on 05-18-2010 10:36 PM
Dear Guru's,
We are using SAP MaxDB Database Studio Version: 7.7.06.09 on our Windows 2003 X86 server.
We are executing the studio using the following command:
cd C:\sapdb\programs\DatabaseStudio
dbstudio.exe -vm "C:\Program Files (x86)\Java\jre1.5.0_22\bin\java.exe"
We are able to connect to the local SDB database as superdba. When we connect to Administration mode, the system is refreshing in an infinite loop without displaying any of the database information.
Please let me know on how to correct this issue...
Thank you,
Nikee
hi Nikee, dear community,
The issue was neither caused by an infinite refresh nor by the underlying 'dban_state' command hanging. It only seemed to be hanging because of DB Studio suppressed an error message that a certain DLL couldn't be found.
Calling the dbanalyzer.exe executable from the commandline DID showed the actual error.
The dll in question was: SDBODBCW.dll
Background info: the name of SAP MaxDB ODBC dlls changed from version 7.6 to 7.7.
In this case, you only had ODBC 7.6 on your system and the DB kernel and DB Analyzer are of 7.7. The DB Analzyer couldn't find the needed (new) dll, because you previously went back (manually) to ODBC 7.6
The workaround was to extract the two files from the same 7.7 SDBODBC.TGZ package and place them in the IndepProgPath/bin (/sapdb/programs/pgm):
SDBODBCW.dll
SDBODBC.dll
take care,
Junco
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Nikee,
you seem to be a SAP customer. If you have trouble with Database Studio, you might want to open a support message that we can analyze and fix this problem. A remote connection to the server where Database Studio is running might be needed.
Best regards,
Melanie
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Nikee,
are you able to post some logs and traces informations?
I don't use Database Studio currently so I don't remember where it stores the log and traces informations, but I hope that something is traced somewhere.
In my very very personal opinion, Database Studio is not a mature tool up to now, I tried some time ago and I was disappointed because it seems too complex and not stable, I would not use it in a production environment
Valerio
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
I have always used Database Manager GUI, you can download from http://service.sap.com
It's older than Database Studio and is available for Windows only, but it is stable and reliable, and offers the same functionality than Database Studio
Warning: you must be sure that it is supported for the release you are using, I think it is ok for release 7.7, I am not sure for the brand new MaxDB 7.8 release. This happens because SAP wants to drop this tool in the future and continue to develop and support Database Studio only
Regards,
Valerio
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.