dbisql.exe fails to load

[Former Member]

Hi,

I have a setup where dbisql.exe fails to load. No GUI can be seen. Also, am not getting any error while running through double clicking or through command line.

1. procmon dump (process monitor) from the system don't show any specific error.
2. Event viewer logs also don't have any specific error for this.

The sybase version we are using is pretty old (9.0) and can't be upgraded. Is there anything I can do more to troubleshoot here?

Many thanks in advance.

Vineet link text

[Former Member]

attached procmon result from the problematic system.

[Breck_Carter]

Did it ever load properly? What changed since then?

Are you loading stuff from the network? Is there a security issue, or a firewall getting in the way?

FWIW there are a bunch of BUFFER OVERFLOW errors on the Java components including dbisqlg.exe.

Maybe there is a problem with the CLASSPATH. Version 9 was "early days" for the Java version of ISQL, and it pretty much sucked.

Look around for a crash dump file... although it looks like dbisql.exe ended "normally".

Workaround 1: Use the "C" version of ISQL: dbisqlc.exe

Workaround 2: Try executing dbisqlg.exe directly.

Workaround 3: Use the ISQL delivered with a later version of SQL Anywhere...

"%SQLANY10%\\win32\\dbisql.exe"^
  -c "ENG=ddd9;DBN=ddd9;UID=dba;PWD=sql;CON=ddd9-2"

[Breck_Carter]

To All: Can anyone remember where V9 put its dumps and error logs and such like?

[Former Member]

This problem is occurring on only one setup having OS 2003 server. This works on all other setups with same OS version. Every thing is on the local machine.

We are calling dbisql.exe through scripts which are failing and no manual interference is there. This is happening on one setup.

I tried making one procmon dump from one of my working setup and tried comparing with the problematic one but no luck. I will attach the correct one for your reference.

At the time of problem, I tried opening dbisqlc.exe but got the same problem. Though, i was able to open ISQL through dbisqlg.exe

Thanks

[Former Member]

link text

[former_SQLA_member1694878]

I believe 9 writes error reports to the temporary directory (%SADIAGDIR%,%SATMP%,%TMP%,%TMPDIR%,%TEMP%, Current Directory). You could try running "dbisql -batch" which will save the java start line in a .bat file in the working directory. Sometimes you can see more detailed error messages by running this batch file instead of the executable.

[Former Member]

Running dbisql.exe -batch command gives me isqlj.bat and asasrv.ini file. but running isqlj.bat file doesn't show anything. I tried running this on my working setup. Running through double click does nothing. Running through command prompt just print the command.

If I copy paste the command on the command prompt, its gives NoClassDefFoundError. All this happening on my working setup.

kindly let me know how to proceed fro here.

[Breck_Carter]

The fact dbisqlc.exe does not work indicates the problem is much larger than just dbisql.exe not working, since dbisqlc.exe is a completely different animal.

If you haven't already, reboot. Try turning off all firewall and virus checkers on the local computer. If that doesn't help, reinstall ASA 9 ...those are just prerequisites to proceeding with other heroic measures 🙂

[Breck_Carter]

"Every thing is on the local machine" ...is that true? is the E: drive local, or a network drive?

Anyway, both procmon files show that dbisql.exe successfully launched dbisqlg.exe and then shut down, and that may be normal... you may be watching the wrong process; the problem may lie with dbisqlg.exe.

The procmon lines for dbisqlg.exe refer to different folders; is that a clue?

dbisql_procmon.PML

2:56:54.4754693 PM  dbisql.exe  3052    Process Create  
E:\\NIC\\4100\\SIEM01~1\\BIN\\ASA\\WIN32\\DBISQLG.EXE  SUCCESS PID: 5672, 
Command line: E:\\NIC\\4100\\SIEM01~1\\BIN\\ASA\\WIN32\\DBISQLG.EXE

Logfile_correct.PML

2:06:36.4104186 PM  dbisql.exe  1112    Process Create  
E:\\NIC\\4100\\MYSITE~1\\BIN\\ASA\\WIN32\\DBISQLG.EXE  SUCCESS PID: 308, 
Command line: E:\\NIC\\4100\\MYSITE~1\\BIN\\ASA\\WIN32\\DBISQLG.EXE

[Former Member]

dbisql_procmon.PML file i got from the problematic system. Logfile_correct.PML file i got from the working system. This i did to compare with dbisql_procmon.PML file.

[Breck_Carter]

Yes, that was clear yesterday... did you read my comment above?