ERROR - Connect to user management

[Former Member]

Hey folks,

I have some problems on working with dbstudio.

I use this weird 64bit dbstudio ... kind of thing .

I get this thing to run and it worked fine.

But yesterday the studio began to throw error messages on startup.

Sorry if I seem to be a bit fretful but this is a bit annoying because this software makes it really hard

to get it to work.

The latest issue is that the studio can't connect to the user management.

Im not really adept with this software but why does the studio need some kind of user management ?

I mean i use the studio on my working station and connect to the server to get access to our databases.

Studio is telling me :

ERROR - Connect to user management

ERROR - Recreation default user management

ERROR - Connect to UMDB not possible. Try to use/create local default user management.

Ok but how could it happened that this error appears from one startup to another ?

I tried to connect to the .UMDB instance but it failed. The DB is existing but the user password seems to be wrong

I used "DBADMIN,DBADMIN" for user,pwd i read that this is the default but nothing happened.

Has anybody an idea what could went wrong so that this error appears ?

Thanks for help...

[lbreddemann]

Just a wild guess here, but...

Have you checked the simple stuff?

Is the XSERVER running?

If you also installed MaxDB 7.8 on the machine: are all XSERVERs running? (time to check the SERVICES!)

regards,

Lars

[Former Member]

I encountered the same error (and many others before).

If you want a workaround, I started the Database Studio as root once (I know, I know, this is a bad thing to do) and after this initial setup I was able to use the Studio with my regular domain user withour any restrictions so far.

[Former Member]

Yes, this works, first start as admin, after that it is possible to run with user privileges.

Edited by: Andreas Ernst on Jan 12, 2011 12:35 PM

[hannes_kuehnemund]

moved to MaxDB forum, as it is not related to SAP on Linux but more to MaxDB Tools ...

[former_member189546]

Hello,

can you check if the OS user -with whom DB Studio is started- can

access the path to the .UMDB DBM shared memory files?

(These probably reside here:

C:\Documents and Settings\All Users\Application Data\sdb\data\wrk

and are called '.UMDB.dbm.shi' and '.UMDB.dbm.shm'

regards,

John Feely

[Former Member]

Hey John, I tried this but I get no positive results.

I run the dbstudio as root but I get the same error every time, even in a windows vm.

I never had this error before and now on two different systems ? hmm...

If you or anybody alse have another idea what cause this problem let me know.

The error occurs when I start the dbstudio with the:

MaxDB Database Studio Core UI Plug-in

I don't know if its helpful but here is the log of the first error I get:

:com.sap.sdb.tools.core.ui.CoreUIPlugin.connectUser(CoreUIPlugin.java:467][N:1284647394019:17][DB:null][U:null]

com.sap.sdb.tools.usermanagement.UM_Exception: Connect failed

at com.sap.sdb.tools.usermanagement.UM_Usermanagement.connectUser(UM_Usermanagement.java:621)

at com.sap.sdb.tools.usermanagement.UM_Usermanagement.connectUser(UM_Usermanagement.java:559)

at com.sap.sdb.tools.core.ui.CoreUIPlugin.connectUser(CoreUIPlugin.java:445)

at com.sap.sdb.tools.core.ui.CoreUIPlugin$1.run(CoreUIPlugin.java:91)

at org.eclipse.ui.internal.UILockListener.doPendingWork(UILockListener.java:155)

at org.eclipse.ui.internal.UISynchronizer$2.run(UISynchronizer.java:126)

at org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:35)

at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:123)

at org.eclipse.swt.widgets.Display.runAsyncMessages(Display.java:3296)

at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2974)

at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2389)

at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2353)

at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2219)

at org.eclipse.ui.internal.Workbench$4.run(Workbench.java:466)

at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:289)

at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:461)

at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)

at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:106)

at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:153)

at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:106)

at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:76)

at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:363)

at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:176)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:504)

at org.eclipse.equinox.launcher.Main.basicRun(Main.java:443)

at org.eclipse.equinox.launcher.Main.run(Main.java:1169)

at org.eclipse.equinox.launcher.Main.main(Main.java:1144)

Caused by: com.sap.sdb.tools.usermanagement.UM_Exception: Connect failed

at com.sap.sdb.tools.usermanagement.UM_Usermanagement.connectUser(UM_Usermanagement.java:608)

... 30 more

Caused by: com.sap.sdb.tools.usermanagement.UM_Exception: Connect failed

at com.sap.sdb.tools.usermanagement.UM_Storage.ExceptionHandler(UM_Storage.java:8112)

at com.sap.sdb.tools.usermanagement.UM_Storage.getConnectionUM(UM_Storage.java:8146)

at com.sap.sdb.tools.usermanagement.UM_Storage.connectUser(UM_Storage.java:2754)

at com.sap.sdb.tools.usermanagement.UM_Usermanagement.connectUser(UM_Usermanagement.java:599)

... 30 more

Caused by: com.sap.dbtech.jdbc.exceptions.JDBCDriverException: Cannot connect to jdbc:sapdb://www.myserver.de/.UMDB [Restart required].

at com.sap.dbtech.jdbc.DriverSapDB.connect(DriverSapDB.java:237)

at java.sql.DriverManager.getConnection(Unknown Source)

at java.sql.DriverManager.getConnection(Unknown Source)

at com.sap.sdb.tools.usermanagement.UM_Storage.getConnectionUM(UM_Storage.java:8139)

... 32 more

Thanks for help