disp+work not able to start after MAXDB Dbrefresh

[Former Member]

Hi experts,

I was performing DBrefresh following note on OS:windows 2003 and Database: maxdb 7.7 ,SAP: Ecc6.0 EHP4

i was following the Note SAP Note No. 129352

now i am able to start the database but disp_work is getting stopped due to following reason

dev_w0 log

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

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

[dbsdbsql.cpp 139]

B  ***LOG BV3=> severe db error -10709    ; work process is stopped [dbsh         1241]

B  ***LOG BY2=> sql error -10709 performing CON [dblink 540]

B  ***LOG BY0=> Connection failed (RTE:Database name is missing) [dblink       540]

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

M  in_ThErrHandle: 1

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

PfStatDisconnect: disconnect statistics

M  Entering TH_CALLHOOKS

M  ThCallHooks: call hook >ThrBtcCallLgCl< for event BEFORE_DUMP

M  ThCallHooks: hook >ThrBtcCallLgCl< o.k.

M  ThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP

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

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

M  ThIErrHandle: 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 (Workp. 12 2808) [dpnttool.c   339]

please help me to solve the issue

thanks & regrads

krishna

[former_member188883 · Accepted solution]

Hi Krishna,

Read,

SAP Note 39439 - XUSER entries for SAP DB and MaxDB

Regards,

Deepak Kori

[Former Member · Accepted solution]

Hi deepak,

I have followed the SAP Note 39439 - XUSER entries for SAP DB and MaxDB 

                                   but still facing the same problem

thanks

krishna

[former_member188883 · Accepted solution]

Hi Krishna,

You may try the following

xuser -U DEFAULT -u SAPS01,admin -d S01 -n SANDBOX set

Post this check the results with R3trans -d

Regards,

Deepak Kori

[Former Member · Accepted solution]

hi Deepak,

I have done the same but no use disp+work is stopped

*** ERROR => Connect to database failed, rc = -10757 (XUSER error (the USERKEY is unknown))

[dbsdbsql.cpp 115]

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

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

[dbsdbsql.cpp 139]

B  ***LOG BV3=> severe db error -10709    ; work process is stopped [dbsh         1241]

B  ***LOG BY2=> sql error -10709 performing CON [dblink       540]

B  ***LOG BY0=> Connection failed (RTE:Database name is missing) [dblink       540]

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

M  in_ThErrHandle: 1

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

M 

check the below image for xuser lis and  r3trans -d

[Former Member · Accepted solution]

Hi

I have one more doubt which user should maintain the xuser entries sidadm,administrator,sapservice<sid>

regrads,

krishna

[former_member188883 · Accepted solution]

Hi Krishna,

You need to have entries for sidadm in xuser

Please check xuser list for detailed existing configuration.

Regards,

Deepak Kori

[former_member188883 · Accepted solution]

Hi Krishna,

Refer link http://scn.sap.com/thread/1248620 . for XUSER error (the USERKEY is unknown))

Regards,

Deepak Kori

[Former Member · Accepted solution]

Hi deepak ,

Issue was solved . by logging to SAPserviceSid and created xuser entries for that user.

now db restore was done succesfully.

thanks evryone

[Former Member]

Hi Krishna,

Please check the below link and see whether it helps.

http://scn.sap.com/thread/1955800

Thanks and Regards,

Vimal

[Former Member]

As well as please login as sidadm and execute R3trans -d and share the trans.log for more analysis.

[Former Member]

Hi Vimal ,

I have check the thread but no use but yes the problem iam facing is somewhat similar . r3trans -d is finished with 0000

i found the following log in dbmsrv_sandbox.prt

ERR     -24811 DBMSrv   ERR_CONNLOST: connection to client lost (error code 10)

2013-03-08 17:53:57 0x00000ba0 INF          2 DBMSrvCo A DBM Server client connection was released (client process has process ID 2152 on computer sandbox).

2013-03-08 17:53:58 0x00000970 INF          1 DBMSrvCo A DBM Server client connection was established at 2013-03-08 17:53:58 (client process has process ID 1184 on computer sandbox).

2013-03-08 17:53:58 0x00000970 INF          4 DBMSrvLo This DBM Server does not switch its log file to file dbm.prt in the run directory.

                    0x00000970 INF        416 DBMSrv   Rundirectory E:\sapdb\data\wrk\S01 does not exist.

2013-03-08 17:53:58 0x00000970 INF        283 DBMSrv   Command 'param_checkall' is being executed.

2013-03-08 17:53:58 0x00000970 INF        419 DBMSrv   Command 'param_checkall' has ended with return code 0.

2013-03-08 17:53:58 0x00000970 INF          2 DBMSrvCo A DBM Server client connection was released (client process has process ID 1184 on computer sandbox).

2013-03-08 17:53:59 0x00000718 INF          1 DBMSrvCo A DBM Server client connection was established at 2013-03-08 17:53:59 (client process has process ID 2828 on computer sandbox).

2013-03-08 17:53:59 0x00000718 INF          4 DBMSrvLo This DBM Server does not switch its log file to file dbm.prt in the run directory.

                    0x00000718 INF        416 DBMSrv   Rundirectory E:\sapdb\data\wrk\S01 does not exist.

2013-03-08 17:53:59 0x00000718 INF        283 DBMSrv   Command 'db_admin' is being executed.

regards,

krishna