Skip to Content
0

Error in Maxdb - unable to connect.

Oct 09, 2017 at 09:23 PM

192

avatar image
Former Member

1st Warning - Database Studio utilities path is not specified. Going to use programs path.

2nd Warning - Going to use utilities path: C:\Program Files\sdb\DatabaseStudio

3rd Error - Could not connect SQL due to: SAP DBTech JDBC: Cannot connect to jdbc:sapdb://GCCSADMS/SDB [Restart required].

4th Error - Could not connect DBM due to: The DBM server must be aborted. -24832,ERR_SHMNOTAVAILABLE: Shared memory not available

This was working with out issue. Server was restart due to power failure. No change made so far. Please help me to solve the issue

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
James Zhang
Oct 10, 2017 at 12:46 AM
1

Hi,

Please refer to SAP note ##1041650, please clear the server shadow memory.
Afterwards please send me the error screenshot if the problem does still occur.

Best regards,
James

Show 4 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi James,

Thanks for your message. As that note is for unix OS. Our maxdb installed on Windows 2008 OS. Also I am very new in MAXDB environment. So please send me the details how to clear the server shadow memory. I attach the current screenshot below.

1screenshot.jpg (215.9 kB)
0

Hi,

You are welcome.

Windows is similar, please find the

dbm.shm

from the windows path, like:

:\sapdb\<dbsid>\data\wrk

Best regards,
James

1
Former Member

Thank you. The database online now. But still I am getting the below error, and could not get the data from ERP system.

Catalog cannot be displayed due to:Cannot connect to jdbc:sapdb://GCCSADMS/SDB [Restart required].

com.sap.dbtech.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: Cannot connect to jdbc:sapdb://GCCSADMS/SDB [Restart required]. at com.sap.dbtech.jdbc.exceptions.SQLExceptionSapDB.createException(SQLExceptionSapDB.java:156) at com.sap.dbtech.jdbc.exceptions.SQLExceptionSapDB.generateDatabaseException(SQLExceptionSapDB.java:146) at com.sap.dbtech.jdbc.DriverSapDB.connect(DriverSapDB.java:242) at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at com.sap.sdb.tools.usermanagement.UM_Storage.getSessionSQLWithConnectionKey(UM_Storage.java:9066) at com.sap.sdb.tools.usermanagement.UM_Storage.getSessionSQL(UM_Storage.java:1523) at com.sap.sdb.tools.usermanagement.UM_DatabaseMaxDB.getSessionSQL(UM_DatabaseMaxDB.java:137) at com.sap.sdb.tools.usermanagement.UM_DatabaseSession.getSessionSQL(UM_DatabaseSession.java:64) at com.sap.sdb.tools.resources.catalog.internal.CatalogFolder.getSQLSession(CatalogFolder.java:151) at com.sap.sdb.tools.resources.catalog.internal.Schemas.validateWithState(Schemas.java:136) at com.sap.sdb.tools.resources.base.internal.extensions.ExtensionManager.loadResourceExtensions(ExtensionManager.java:83) at com.sap.sdb.tools.resources.base.Resource.loadExtensions(Resource.java:618) at com.sap.sdb.tools.ui.dbm.util.ResourceUtil.addConnectionKey(ResourceUtil.java:57) at com.sap.sdb.tools.ui.dbm.command.handlers.AdministrationTaskHandler.prepareDMDatabase(AdministrationTaskHandler.java:298) at com.sap.sdb.tools.ui.dbm.command.handlers.AdministrationTaskHandler.prepare(AdministrationTaskHandler.java:234) at com.sap.sdb.tools.ui.dbm.command.handlers.AdministrationTaskHandler.prepare(AdministrationTaskHandler.java:143) at com.sap.sdb.tools.ui.dbm.command.handlers.DatabaseStateOnlineHandler.execute(DatabaseStateOnlineHandler.java:37) at org.eclipse.ui.internal.handlers.HandlerProxy.execute(HandlerProxy.java:294) at org.eclipse.core.commands.Command.executeWithChecks(Command.java:476) at org.eclipse.core.commands.ParameterizedCommand.executeWithChecks(ParameterizedCommand.java:508) at org.eclipse.ui.internal.handlers.HandlerService.executeCommand(HandlerService.java:169) at org.eclipse.ui.internal.handlers.SlaveHandlerService.executeCommand(SlaveHandlerService.java:241) at org.eclipse.ui.internal.handlers.SlaveHandlerService.executeCommand(SlaveHandlerService.java:241) at org.eclipse.ui.menus.CommandContributionItem.handleWidgetSelection(CommandContributionItem.java:770) at org.eclipse.ui.menus.CommandContributionItem.access$10(CommandContributionItem.java:756) at org.eclipse.ui.menus.CommandContributionItem$5.handleEvent(CommandContributionItem.java:746) at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84) at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1003) at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3910) at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3503) at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2405) at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2369) at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2221) at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:500) at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332) at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:493) at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149) at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:113) at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:194) at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110) at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:368) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179) 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:559) at org.eclipse.equinox.launcher.Main.basicRun(Main.java:514) at org.eclipse.equinox.launcher.Main.run(Main.java:1311) at org.eclipse.equinox.launcher.Main.main(Main.java:1287)

Thanks and Best Regards

Abdul Majeed

2.jpg (136.8 kB)
0

Hi,

looks that only database studio has this issue? then please reinstall database studio.

You need to use "installation manager" to uninstall it, Also please manually the remaining files from os level, afterwards please perform a complete new database studio install.

Also please not to remove database in "installation manager", only database studio which is a client tool needs to be selected.


Best regards,
James

0