Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

DISP+Work processe terminated / ECC can't connect to MaxDB

Hello everyone,

it's been two days reading and trying different solutions already posted to ths topic. Now i've reached the end of my knowledge.

The problem is as folows:

I have a server here on which I installed SAP ECC 6.0 with MaxDB two years ago. Since it wasn't used much now, i saw no purpose of maintaining it. Until now. I found out, that i had access to SAP with all the rights i needed, but misplaces the username / password to the database (control, superdba, sap<sid>).

I am not the brightest light on SAP products although i took trainings on MaxDB and SAP ECC installation (2 years ago).

I managed to reset the password for the user CONTROL somewhere through the LiveCache Transaction (i think). Since the CONTROL user was already logged on i could reset the password with a dbmcli command.

Then i was able to reset the passwords for the other users: superdba and sapc01.

You might have noticed that my sid is C01, so i will continue with this term rather than writing sap<sid>

Anyways. i restarted the mashine and now the MMC tells me, that the SAP System cannot connect to the database.

-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


The error diplayed in the MMC is:

SAP-Basis System: Initialization           DB-Connect Failed, Return Code  000256

and

SAP-Basis System: Operating system call           recv failed (error no. 10054)

-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


As i am not the only one with this problem i already read all the other threads and notes concerning this topic (ie 25591). Sadly none of them helped me. I also tried updating the xuser list as told in the Note 39439. STill no success.

-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


In case it might help, i'll post my logs here:

r3trans -d:

D:\usr\sap\C01\SYS\exe\uc\NTAMD64>R3trans.exe -d
This is R3trans.exe version 6.14 (release 700 - 14.02.08 - 14:55:00).
unicode enabled version
2EETW169 no connect possible: "connect failed with DBLI_RC_LOAD_LIB_FAILED."
R3trans.exe finished (0012).

-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


dev_W0:

---------------------------------------------------
trc file: "dev_w0", trc level: 1, release: "700"
---------------------------------------------------
*
*  ACTIVE TRACE LEVEL           1
*  ACTIVE TRACE COMPONENTS      all, MJ
*
B  
B Thu May 12 16:22:35 2011
B  create_con (con_name=R/3)
B  Loading DB library 'D:\usr\sap\C01\DVEBMGS02\exe\dbsdbslib.dll' ...
B  Library 'D:\usr\sap\C01\DVEBMGS02\exe\dbsdbslib.dll' loaded
B  Version of 'D:\usr\sap\C01\DVEBMGS02\exe\dbsdbslib.dll' is "700.08", patchlevel (0.144)
B  New connection 0 created
M sysno      02
M sid        C01
M systemid   562 (PC with Windows NT)
M relno      7000
M patchlevel 0
M patchno    144
M intno      20050900
M make:      multithreaded, Unicode, 64 bit, optimized
M pid        2648
M 
M  kernel runs with dp version 232000(ext=109000) (@(#) DPLIB-INT-VERSION-232000-UC)
M  length of sys_adm_ext is 576 bytes
M  ***LOG Q0Q=> tskh_init, WPStart (Workproc 0 2648) [dpxxdisp.c   1305]
I  
I Thu May 12 16:22:36 2011
I  MtxInit: 30000 0 0
M  
M Thu May 12 16:22:37 2011
M  DpSysAdmExtCreate: ABAP is active
M  DpSysAdmExtCreate: VMC (JAVA VM in WP) is not active
M  DpShMCreate: sizeof(wp_adm)		25168	(1480)
M  DpShMCreate: sizeof(tm_adm)		5652128	(28120)
M  DpShMCreate: sizeof(wp_ca_adm)		24000	(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: 000000000EE70050, size: 6348592)
M  DpShMCreate: allocated sys_adm at 000000000EE70050
M  DpShMCreate: allocated wp_adm at 000000000EE72150
M  DpShMCreate: allocated tm_adm_list at 000000000EE783A0
M  DpShMCreate: allocated tm_adm at 000000000EE78400
M  DpShMCreate: allocated wp_ca_adm at 000000000F3DC2A0
M  DpShMCreate: allocated appc_ca_adm at 000000000F3E2060
M  DpShMCreate: allocated comm_adm at 000000000F3E3FA0
M  DpShMCreate: system runs without slock table
M  DpShMCreate: system runs without file table
M  DpShMCreate: allocated vmc_adm_list at 000000000F46AC30
M  DpShMCreate: allocated gw_adm at 000000000F46ACB0
M  DpShMCreate: system runs without vmc_adm
M  DpShMCreate: allocated ca_info at 000000000F46ACE0
M  DpShMCreate: allocated wall_adm at 000000000F46ACF0
M  
M Thu May 12 16:22:40 2011
M  ThTaskStatus: rdisp/reset_online_during_debug 0
X  EmInit: MmSetImplementation( 2 ).
X  MM global diagnostic options set: 0
X  
X Thu May 12 16:22:43 2011
X  <ES> client 0 initializing ....
X  
X Thu May 12 16:22:44 2011
X  Using implementation view
X  <EsNT> Using memory model view.
M  <EsNT> Memory Reset disabled as NT default
X  ES initialized.
M  
M Thu May 12 16:22:46 2011
M  ThInit: running on host saptest
M  
M Thu May 12 16:22:48 2011
M  calling db_connect ...
C  
C  DBSDBSLIB : version 700.08, patch 0.144 (Make PL 0.144)
C  MAXDB shared library (dbsdbslib) patchlevels (last 10)
C    (0.144) MSSQL: ODBC fastload on separate connection (note 1131805)
C    (0.144) I5/OS ldappasswd support for 5250 terminal. (note 1129573)
C    (0.139) Return DS_SQLERR instead of DS_CONNECTERR (note 1121076)
C    (0.131) Do not trace password of SQLOPT into dev trace (note 1097930)
C    (0.130) Performance optimization for UPDSTAT PREPARE (note 1096387)
C    (0.125) Update statistic prepare on row level (note 1086430)
C    (0.104) Update statistic with empty schemas (note 1041547)
C    (0.095) MaxDB DBSL patch collection 1 2007 (note 1014270)
C    (0.082) MaxDB DBSL patch collection 3 2006 (note 991258)
C    (0.079) MaxDB DBSL patch collection 2 2006 (note 984406)
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.3    BUILD 009-123-163-622
C  SQLDBC client runtime is MaxDB 7.6.3.009 CL 163622
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 @ 1199] [dbsh    1199 ]
B  ***LOG BY2=> sql error -10709 performing CON [dblink#5 @ 431] [dblink  0431 ]
B  ***LOG BY0=> Connection failed (RTE:Database name is missing) [dblink#5 @ 431] [dblink  0431 ]
M  ***LOG R19=> ThInit, db_connect ( DB-Connect 000256) [thxxhead.c   1440]
M  in_ThErrHandle: 1
M  *** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c   10468]
M  
M  Info for wp 0
M  
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 saptest_C01_02 on host saptest (wp 0)
M  *  ERROR       ThInit: db_connect
M  *
M  *  TIME        Thu May 12 16:22:48 2011
M  *  RELEASE     700
M  *  COMPONENT   Taskhandler
M  *  VERSION     1
M  *  RC          13
M  *  MODULE      thxxhead.c
M  *  LINE        10688
M  *  COUNTER     1
M  *
M  *****************************************************************************
M  
M  PfStatDisconnect: disconnect statistics
M  Entering TH_CALLHOOKS
M  ThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP
M  *** ERROR => ThrSaveSPAFields: no valid thr_wpadm [thxxrun1.c   724]
M  *** ERROR => ThCallHooks: event handler ThrSaveSPAFields for event BEFORE_DUMP failed [thxxtool3.c  261]
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 2648) [dpnttool.c   327]

-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


xuser list:

-----------------------------------------------------------------
XUSER Entry  1
--------------
Key         :DEFAULT           
Username    :SAPC01                                                          
UsernameUCS2:S.A.P.C.0.1. . . . . . . . . . . . . . . . . . . . . . . . . . .
Password    :?????????
PasswordUCS2:?????????
Dbname      :DB2               
Nodename    :saptest                                                         
Sqlmode     :<unspecified>
Cachelimit  :-1
Timeout     :0
Isolation   :0
Charset     :<unspecified>     
-----------------------------------------------------------------
XUSER Entry  2
--------------
Key         :c                 
Username    :CONTROL                                                         
UsernameUCS2:C.O.N.T.R.O.L. . . . . . . . . . . . . . . . . . . . . . . . . .
Password    :?????????
PasswordUCS2:?????????
Dbname      :DB2               
Nodename    :SAPTEST                                                         
Sqlmode     :INTERNAL
Cachelimit  :-1
Timeout     :-1
Isolation   :-1
Charset     :<unspecified>     
-----------------------------------------------------------------
XUSER Entry  3
--------------
Key         :w                 
Username    :SUPERDBA                                                        
UsernameUCS2:S.U.P.E.R.D.B.A. . . . . . . . . . . . . . . . . . . . . . . . .
Password    :?????????
PasswordUCS2:?????????
Dbname      :DB2               
Nodename    :SAPTEST                                                         
Sqlmode     :INTERNAL
Cachelimit  :-1
Timeout     :-1
Isolation   :-1
Charset     :<unspecified>

-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


-


I also changed the password for the SAPServceC01 user.

Let's assume the i choose the password "fortknox", all my users (superdba, control, sapc01, SAPservicec01, etc) have the same password. that makes it a bit easier.

Any help will be greathly appreciated! Thank you in advance.

Edited by: Jan Selucky on May 12, 2011 4:47 PM

Edited by: Jan Selucky on May 12, 2011 4:48 PM

Former Member
Not what you were looking for? View more on this topic or Ask a question