|
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.
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 |
Please be aware that the SAP SQL Anywhere Forum will be shut down on August 29th, 2024 when all it's content will be migrated to the SAP Community.
Follow this question
By Email:Once you sign in you will be able to subscribe for any updates here
By RSS:Markdown Basics
- *italic* or _italic_
- **bold** or __bold__
- link:[text](http://url.com/ "title")
- image?
- numbered list: 1. Foo 2. Bar
- to add a line break simply add two spaces to where you would like the new line to be.
- basic HTML tags are also supported
Question tags:
question asked: 13 Mar '14, 04:50
question was seen: 5,815 times
last updated: 14 Mar '14, 08:14
attached procmon result from the problematic system.
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...
To All: Can anyone remember where V9 put its dumps and error logs and such like?
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
link text
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.
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.
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 :)
"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 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.
Yes, that was clear yesterday... did you read my comment above?