Troubleshooting Guide

Troubleshooting Guide helps you to find common problems and resolve issues immediately.

1. Product does not Start when executing the runSybaseToSQLServer.bat
2. JDBC Driver path set in environmental variable sqlserver jdbc in setenv.bat may contain space in directory path
3. Getting the 'Product already running !!' Message
4. Getting the 'java.lang.InstantiationException' Message

1. Product does not Start when executing the runSybaseToSQLServer.bat :

JDK may not be installed.

 

Please ensure your machine has JDK / JRE installed. If your machine does not have a JDK, Install JDK and set the javahome variable to your JAVA_HOME Path in setenv.bat file present in the <InstallDir>\SwisSQL\SybaseToSQLServer(Version_Number)\bin directory. If you have installed the product version with JRE (SybaseToSQLServer_JRE.exe ), you need not set the javahome variable explicitly.

 

Eg: If you have your JAVA is installed in C:\JAVA\J2SDK1.4.1 change the javahome variable in the file as shown below:
set javahome=C:\JAVA\J2SDK1.4.1

 

Alternatively, you can also replace javahome with the JAVA INSTALLATION location. For example in the file runSybaseToSQLServer.bat present in the <InstallDir>\SwisSQL\SybaseToSQLServer(Version_Number)\bin directory, you can replace the javahome variable as shown below:
"%javahome%\bin\java" can be replaced with "C:\Program Files\JAVA\J2SDK1.4.1\bin\java"

 

Users could use JDK (Java Standard Development Kit) 1.4.1 or above version with the product. The product also works with JRE (Java RunTime Environment) 1.4.1 or above

2. JDBC Driver path set in environmental variable sqlserver jdbc in setenv.bat may contain space in directory path.

For eg: The following statement contains space between "Program" and "Files".
set sqlserverjdbc=C:\Program Files\mssqlserver.jar

In such case the directory path in the statement should be between double quotes.
set sqlserverjdbc="C:\Program Files\mssqlserver.jar"

 

3. Getting the 'Product already running !!' Message :

If you are getting this message, this may be either because product is already running and you must close it first or the Product might not have closed properly. If the product is already running, Please close the application and restart once again or use the application which is already running.

4. Getting the 'java.lang.InstantiationException' Message :

    

   If you are getting this message, you might have deleted some files existing in your Installation. Please reinstall the product and restart the tool.