Java heap error with RazorSQL on Windows 10

Java_logo

In working with some large table exports with RazorSQL, I ran into some Java heap errors. Here is how to fix it by throwing more memory at Java in the runtime parameters.

  1. Get the latest version on Java. I know, Oracle and all, but just get the latest version. At the time of this post, it was 1.80.91
  2. Go to the “Configura Java” application or the java Control Panel and then into the Java tab to view/edit runtime settings.
  3. Add an entry for the -Xms parameter. In my example, I gave it 3 gb more memory, but YMMV. I ended-up going with 4gbs 0r 4096m.

2016-05-24_10-02-43

 

That gave me a little more room in exporting some large tables from an old Sybase ASE database via RazorSQL since RazorSQL is a java program looking at the runtime for parameters.

Getting Windows 10 and Cisco VPN Client Operational

windows10

Kudos to the various sites that provided some guidance on getting the Cisco IPSec VPN client going again on Windows 10. I finally was able to get it going for me. I’m running Windows 10 64bit and connecting to Cisco IPSec/UDP.

1. Run Winfix.exe before you do anything else. This will nuke all the bad stuff you probably did to try and get it operational. Do this first before you start piling on installs again. Trust me. Believe me. Reboot.

2. Install the Dell Sonic VPN client. Reboot.

3. Install your Cisco VPN client. Reboot

4. Try the VPN connection. It should work.

I know there are various other sequences out there, but this one is the only one that worked for me.

YMMV

Here are some of the other sites I tried prior to going down this route. Any sequence that included the DNE update from Citrix didn’t work for me.

http://itthatshouldjustwork.blogspot.com/2015/07/cisco-64-bit-vpn-client-on-windows-10.html

http://www.gleescape.com/posts/2917

http://community.spiceworks.com/how_to/120150-fix-cisco-vpn-error-27850-on-windows-10

 

Batch Inserting Pages into Multiple, Separate PDFs with Adobe Acrobat

We had a need recently to batch insert a pdf into hundreds of other PDFs prior to distribution. There are a lot of slimy PDF applications out there that seem to be able to help compile merged PDFs, but I wasn’t happy when I tried a bunch of them. The good news is Adobe Acrobat XI has the Action Wizard functionality that can do this pretty easily. Here is how we did it.

1. Put all the PDFs you want to augment into a folder. Put the PDF you want to insert into all the PDFs in that folder outside the folder.

insertPDF1

2. Go into Acrobat Pro (Version X or higher) and go to Tools > Action Wizard

insertPDF2

3. Go ahead and “Create a New action” and change the first area of “Files to be Process” default option to “Add Folder” and under “Pages” add “Insert Pages” and specify settings as desired. You can leave the defaults.

insertPDF4

4. Add “Save” to the action sequence after insert so you won’t have to save each individual PDF after the insert happens.

insertPDF5

5. Inside the “Save” tool, you can decide to tweak the filenames ¬†as well. We left them at default so they save over the existing PDFs.

insertPDF6

6. Save the action.

insertPDF7

and you will see this in your Acrobat Pro > Tools > Action Wizard menu.

7. Click the saved action to start the batch process. Specify the folder for all the PDFs you will be inserting pages into. When you select the folder, it will put a list of the pdfs in the preview.

insertPDF8

insertPDF9

8. Click “Start” to be prompted for the PDF you want to insert.

insertPDF10

9. And then the magic happens. Acrobat should go through the PDFs in the specified folder and play the insert. This is much, much better than having to play the inserts manually to the dozens or hundreds of PDFs.

CPAN Term::ReadKey won’t compile? Get it via apt-get

For some reason in Perl CPAN, I always have issues around getting Term::ReadKey to install/compile on a fresh Linux distro install.

cpan Term:ReadKey compile issue
cpan Term:ReadKey compile issue

There might be a way to correct this. I haven’t found it, but another way to get the package is just via apt-get in your Debian-based linux distro.

libterm-readkey-perl package via apt
libterm-readkey-perl package via apt

The readkey package name on your linux distro of choice may vary.

Term::ReadKey problems in Cygwin? Install the package vs. CPAN compile

I had an issue running Perl in Cygwin. I could install the modules I needed, but was unable to compile Term::ReadKey due to sgtty or some other challenges. I kept getting annoying messages around perl like this with “sgtty not found” and it seems to be an eternal issue. I found bug reports back to 2000!

ReadKeyerrors
Term::ReadKey in cygwin sgtty not found during cpan compile

I tried many different tactics within perl, but nothing worked. Turns out, there is a cygwin package you can install directly for this issue. You can run the setup.exe or setup64.exe for cygwin and select the

perl-Term-ReadKey

package to get the module going in perl under cygwin. You are also better-off long term on getting apt-cyg going in the cygwin environment to query and install packages easily in the environment and without the need to fire-up the setup.exe app each time you want to install a package.

Getting apt-cyg going in cygwin
Getting apt-cyg going in cygwin

Here is the install of Term::ReadKey via the setup apt-cyg:

Installing perl-Term-ReadKey via apt-cyg
Installing perl-Term-ReadKey via apt-cyg