C *** ERROR => Connect to database failed, rc = -10709 (Connection failed

[former_member1346695]

Hello Experts,

We had a log fill in our MaxDB database which was used for IDES. As we were taking a backup using MaxDB Database Studio, we recieved an error saying that the database was offline. On inspection we saw that the dispather had stopped. After looking at dev_w0 as well as the dialog files of databse, we found this:

-

---

trc file: "dev_w0", trc level: 1, release: "701"

-

---

*

• ACTIVE TRACE LEVEL 1

• ACTIVE TRACE COMPONENTS all, MJ

*

M sysno 01

M sid OMG

M systemid 562 (PC with Windows NT)

M relno 7010

M patchlevel 0

M patchno 137

M intno 20020600

M make: multithreaded, Unicode, 64 bit, optimized

M pid 4940

M

M

M Mon Nov 28 17:06:47 2011

M kernel runs with dp version 245000(ext=110000) (@(#) DPLIB-INT-VERSION-245000-UC)

M length of sys_adm_ext is 576 bytes

M ***LOG Q0Q=> tskh_init, WPStart (Workproc 0 4940) [dpxxdisp.c 1354]

I MtxInit: 30000 0 0

M DpSysAdmExtCreate: ABAP is active

M DpSysAdmExtCreate: VMC (JAVA VM in WP) is not active

M DpShMCreate: sizeof(wp_adm) 29792 (1752)

M DpShMCreate: sizeof(tm_adm) 5912704 (29416)

M DpShMCreate: sizeof(wp_ca_adm) 24064 (80)

M DpShMCreate: sizeof(appc_ca_adm) 8000 (80)

M DpCommTableSize: max/headSize/ftSize/tableSize=500/16/552064/552080

M DpShMCreate: sizeof(comm_adm) 552080 (1088)

M DpSlockTableSize: max/headSize/ftSize/fiSize/tableSize=0/0/0/0/0

M DpShMCreate: sizeof(slock_adm) 0 (104)

M DpFileTableSize: max/headSize/ftSize/tableSize=0/0/0/0

M DpShMCreate: sizeof(file_adm) 0 (72)

M DpShMCreate: sizeof(vmc_adm) 0 (1864)

M DpShMCreate: sizeof(wall_adm) (41664/36752/64/192)

M DpShMCreate: sizeof(gw_adm) 48

M DpShMCreate: SHM_DP_ADM_KEY (addr: 000000000DD10050, size: 6614192)

M DpShMCreate: allocated sys_adm at 000000000DD10050

M DpShMCreate: allocated wp_adm at 000000000DD122A0

M DpShMCreate: allocated tm_adm_list at 000000000DD19700

M DpShMCreate: allocated tm_adm at 000000000DD19760

M DpShMCreate: allocated wp_ca_adm at 000000000E2BCFE0

M DpShMCreate: allocated appc_ca_adm at 000000000E2C2DE0

M DpShMCreate: allocated comm_adm at 000000000E2C4D20

M DpShMCreate: system runs without slock table

M DpShMCreate: system runs without file table

M DpShMCreate: allocated vmc_adm_list at 000000000E34B9B0

M DpShMCreate: allocated gw_adm at 000000000E34BA30

M DpShMCreate: system runs without vmc_adm

M DpShMCreate: allocated ca_info at 000000000E34BA60

M DpShMCreate: allocated wall_adm at 000000000E34BA70

M DpRqQInit: Parameter rdisp/queue_lock_level = 2

M rdisp/queue_size_check_value : -> on,50,30,40,500,50,500,80

M ThTaskStatus: rdisp/reset_online_during_debug 0

X EmInit: MmSetImplementation( 2 ).

X MM global diagnostic options set: 0

X <ES> client 0 initializing ....

X Using implementation view

X <EsNT> Using memory model view.

M <EsNT> Memory Reset disabled as NT default

X ES initialized.

X mm.dump: set maximum dump mem to 96 MB

M

M Mon Nov 28 17:06:48 2011

M ThInit: rdisp/cleanup_after_crash = 1

M ThInit: running on host Omega1

M calling db_connect ...

B Loading DB library 'E:\usr\sap\OMG\DVEBMGS01\exe\dbsdbslib.dll' ...

B Library 'E:\usr\sap\OMG\DVEBMGS01\exe\dbsdbslib.dll' loaded

B Version of 'E:\usr\sap\OMG\DVEBMGS01\exe\dbsdbslib.dll' is "700.08", patchlevel (0.111)

C

C DBSDBSLIB : version 700.08, patch 0.111 (Make PL 0.137)

C MAXDB shared library (dbsdbslib) patchlevels (last 10)

C (0.111) Empty string handling for NUMC, DATE and TIME (note 1509705)

C (0.101) MSSQL: database fingerprint (note 1405158)

C (0.099) ABAP: Return technical database PPMS information (note 1419552)

C (0.093) Unknown primary key (note 1459400)

C (0.093) Connection table corrected (note 1466271)

C (0.092) Improved overflow error handling (note 1463647)

C (0.084) Use SCHEMANAME instead of OWNER for MaxDB 7.8 (note 1353266)

C (0.082) Support of MaxDB 7.8 (note 1353266)

C (0.047) MVCC support for MaxDB (note 1332203)

C (0.037) NUMC conversion corrected (note 1288313)

C

C

C Loading SQLDBC client runtime ...

C SQLDBC SDK Version : SQLDBC.H 7.6.0 BUILD 007-123-091-175

C SQLDBC Library Version : libSQLDBC 7.6.5 BUILD 015-123-202-938

C SQLDBC client runtime is MaxDB 7.6.5.015 CL 202938

C SQLDBC supports new DECIMAL interface : 0

C SQLDBC supports VARIABLE INPUT data : 1

C SQLDBC supports keepAlive indicator : 0

C INFO : SQLOPT= -I 0 -t 0 -S SAPR3

C Try to connect (DEFAULT) on connection 0 ...

C *** ERROR => Connect to database failed, rc = -10709 (Connection failed (RTE:Database name is missing))

[dbsdbsql.cpp 137]

B ***LOG BV3=> severe db error -10709 ; work process is stopped [dbsh#2 @ 1203] [dbsh 1203 ]

B ***LOG BY2=> sql error -10709 performing CON [dblink#4 @ 433] [dblink 0433 ]

B ***LOG BY0=> Connection failed (RTE:Database name is missing) [dblink#4 @ 433] [dblink 0433 ]

M ***LOG R19=> ThInit, db_connect ( DB-Connect 000256) [thxxhead.c 1505]

M in_ThErrHandle: 1

M *** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c 10652]

M

M Info for wp 0

M

M pid = 4940

M severity = 0

M status = 0

M stat = WP_RUN

M waiting_for = NO_WAITING

M reqtype = DP_RQ_DIAWP

M act_reqtype = NO_REQTYPE

M rq_info = 0

M tid = -1

M mode = 255

M len = -1

M rq_id = 65535

M rq_source =

M last_tid = 0

M last_mode = 0

M semaphore = 0

M act_cs_count = 0

M csTrack = 0

M csTrackRwExcl = 0

M csTrackRwShrd = 0

M mode_cleaned_counter = 0

M control_flag = 0

M int_checked_resource(RFC) = 0

M ext_checked_resource(RFC) = 0

M int_checked_resource(HTTP) = 0

M ext_checked_resource(HTTP) = 0

M report = > <

M action = 0

M tab_name = > <

M attachedVm = no VM

M

M *****************************************************************************

M *

M * LOCATION SAP-Server Omega1_OMG_01 on host Omega1 (wp 0)

M * ERROR ThInit: db_connect

M *

M * TIME Mon Nov 28 17:06:48 2011

M * RELEASE 701

M * COMPONENT Taskhandler

M * VERSION 1

M * RC 13

M * MODULE thxxhead.c

M * LINE 10917

M * COUNTER 1

M *

M *****************************************************************************

M

M PfStatDisconnect: disconnect statistics

M Entering TH_CALLHOOKS

M ThCallHooks: call hook >BtcCallLgCl< for event BEFORE_DUMP

M ThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP

M *** ERROR => ThrSaveSPAFields: no valid thr_wpadm [thxxrun1.c 730]

M *** ERROR => ThCallHooks: event handler ThrSaveSPAFields for event BEFORE_DUMP failed [thxxtool3.c 262]

M Entering ThSetStatError

M ThIErrHandle: do not call ThrCoreInfo (no_core_info=0, in_dynp_env=0)

M Entering ThReadDetachMode

M call ThrShutDown (1)...

M ***LOG Q02=> wp_halt, WPStop (Workproc 0 4940) [dpnttool.c 334]

We have tried to restart the database services via the control panel, but no luck, we received UA exceptions. Could you kindly help us and throw us a light on how we should proceed. And yes, we followed the sap note that talks about XUSER settings and modifying them with the desired values. We did the setting with the Admin user as well as the SUPERDBA user.

Still no luck.

Points would be handsomely rewarded for replies that bear fruits.

Thanks and Regards,

Saurav

[former_member188883 · Accepted solution]

Hi,

1) Can you check whether this command works for you

dbmcli -d <DB name> -u <DBADMIN>,<mypassword> -uSQL <DBM>,<hispassword>

2) Install DBMGUI on you machine and check whether you can connect to your database.

regards,

Deepak Kori

[former_member1346695]

Hello Deepak,

Thanks a lot for replying.

I did try the command where it asked me for the DB name, after which I get the prompt for dbmcli on OMG>

Regarding the DBMGUI, I have installed DBStudio, with this I can connect to the database and look at the data files etc. But, I cannot make it online as I get the error:

Runtime environment error

20099,'OMG' has stopped unexpectedly, (view 'Application Event Log')

com.sap.sdb.tools.databasemanagement.DM_Exception: Runtime environment error

20099,'OMG' has stopped unexpectedly, (view 'Application Event Log').

This is the application log:

at com.sap.sdb.tools.databasemanagement.internal.DM_Session.handleException(DM_Session.java:325)

at com.sap.sdb.tools.databasemanagement.internal.DM_Session.execute(DM_Session.java:285)

at com.sap.sdb.tools.databasemanagement.internal.commands.DM_BaseCommand.doExecute(DM_BaseCommand.java:187)

at com.sap.sdb.tools.databasemanagement.internal.commands.DM_DatabaseCommand.doExecute(DM_DatabaseCommand.java:55)

at com.sap.sdb.tools.databasemanagement.internal.commands.DM_BaseCommand.execute(DM_BaseCommand.java:119)

at com.sap.sdb.tools.databasemanagement.internal.DM_State.setOnline(DM_State.java:385)

at com.sap.sdb.tools.databasemanagement.internal.DM_State.setOnline(DM_State.java:371)

at com.sap.sdb.tools.databasemanagement.internal.DM_State.setOnline(DM_State.java:364)

at com.sap.sdb.tools.ui.dbm.command.handlers.DatabaseStateOnlineHandler$1.run(DatabaseStateOnlineHandler.java:47)

at com.sap.sdb.tools.dbm.jobs.DBMJob$1.run(DBMJob.java:81)

Caused by: com.sap.sdb.tools.usermanagement.UM_Exception: Runtime environment error

20099,'OMG' has stopped unexpectedly, (view 'Application Event Log')

at com.sap.sdb.tools.usermanagement.UM_SessionDBM.execute(UM_SessionDBM.java:72)

at com.sap.sdb.tools.databasemanagement.internal.DM_Session.execute(DM_Session.java:282)

... 8 more

Regards,

Saurav