cancel
Showing results for 
Search instead for 
Did you mean: 

Disp+Work.exe Stopped after database restore

Former Member
0 Kudos

Dear All,

I have performed a database restore on my testing server with "RESTORE WITH RECOVERY MODE". restore was successful

but after that dispatcher is getting stopped automatically.

OS: windows 2008 64,, DB:- MS SQL SERVER 2005

I have pasted the content of dev_w0 below. pls help

rgs

awnindra

-


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

-


*

  • ACTIVE TRACE LEVEL 1

  • ACTIVE TRACE COMPONENTS all, MJ

*

B

B Tue Jun 29 15:46:32 2010

B create_con (con_name=R/3)

B Loading DB library 'F:\usr\sap\PRD\DVEBMGS00\exe\dbmssslib.dll' ...

B Library 'F:\usr\sap\PRD\DVEBMGS00\exe\dbmssslib.dll' loaded

B Version of 'F:\usr\sap\PRD\DVEBMGS00\exe\dbmssslib.dll' is "700.08", patchlevel (0.131)

B New connection 0 created

M sysno 00

M sid PRD

M systemid 562 (PC with Windows NT)

M relno 7000

M patchlevel 0

M patchno 133

M intno 20050900

M make: multithreaded, Unicode, 64 bit, optimized

M pid 3540

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 3540) [dpxxdisp.c 1301]

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) 22208 (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: 000000000FA00050, size: 6345632)

M DpShMCreate: allocated sys_adm at 000000000FA00050

M DpShMCreate: allocated wp_adm at 000000000FA02150

M DpShMCreate: allocated tm_adm_list at 000000000FA07810

M DpShMCreate: allocated tm_adm at 000000000FA07870

M DpShMCreate: allocated wp_ca_adm at 000000000FF6B710

M DpShMCreate: allocated appc_ca_adm at 000000000FF714D0

M DpShMCreate: allocated comm_adm at 000000000FF73410

M DpShMCreate: system runs without slock table

M DpShMCreate: system runs without file table

M DpShMCreate: allocated vmc_adm_list at 000000000FFFA0A0

M DpShMCreate: allocated gw_adm at 000000000FFFA120

M DpShMCreate: system runs without vmc_adm

M DpShMCreate: allocated ca_info at 000000000FFFA150

M DpShMCreate: allocated wall_adm at 000000000FFFA160

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.

M

M Tue Jun 29 15:46:33 2010

M ThInit: running on host PICLDR

M

M Tue Jun 29 15:46:34 2010

M calling db_connect ...

C Thread ID:3260

C Thank You for using the SLOLEDB-interface

C Using dynamic link library 'F:\usr\sap\PRD\DVEBMGS00\exe\dbmssslib.dll'

C dbmssslib.dll patch info

C patchlevel 0

C patchno 131

C patchcomment MSSQL: BCP failed: Invalid character value (1097943)

C np:(local) connection used on PICLDR

C CopyLocalParameters: dbuser is 'prd'

C Using Provider SQLNCLI

C OpenOledbConnection: MARS property was set successfully.

C ExecuteAndFlush return code: 0x80040e14 Stmt: [if user_name() != 'prd' setuser 'prd']

C sloledb.cpp [ExecuteAndFlush,line 6470]: Error/Message: (err 15157, sev 0), Setuser failed because of one of the following reasons: the database principal 'prd' does not exist, its corresponding server principal does not have server access, this type of database principal cannot be impersonated, or you do not have permission.

C Procname: [ExecuteAndFlush - no proc]

C setuser 'prd' failed -- connect terminated

C Using Provider SQLNCLI

C OpenOledbConnection: MARS property was set successfully.

C ExecuteAndFlush return code: 0x80040e14 Stmt: [if user_name() != 'prd' setuser 'prd']

C sloledb.cpp [ExecuteAndFlush,line 6470]: Error/Message: (err 15157, sev 0), Setuser failed because of one of the following reasons: the database principal 'prd' does not exist, its corresponding server principal does not have server access, this type of database principal cannot be impersonated, or you do not have permission.

C Procname: [ExecuteAndFlush - no proc]

C setuser 'prd' failed -- connect terminated

C Using Provider SQLNCLI

C OpenOledbConnection: MARS property was set successfully.

C ExecuteAndFlush return code: 0x80040e14 Stmt: [if user_name() != 'prd' setuser 'prd']

C sloledb.cpp [ExecuteAndFlush,line 6470]: Error/Message: (err 15157, sev 0), Setuser failed because of one of the following reasons: the database principal 'prd' does not exist, its corresponding server principal does not have server access, this type of database principal cannot be impersonated, or you do not have permission.

C Procname: [ExecuteAndFlush - no proc]

C setuser 'prd' failed -- connect terminated

C failed to establish conn to np:(local).

C Retrying without protocol specifier: (local)

C Using Provider SQLNCLI

C OpenOledbConnection: MARS property was set successfully.

C ExecuteAndFlush return code: 0x80040e14 Stmt: [if user_name() != 'prd' setuser 'prd']

C sloledb.cpp [ExecuteAndFlush,line 6470]: Error/Message: (err 15157, sev 0), Setuser failed because of one of the following reasons: the database principal 'prd' does not exist, its corresponding server principal does not have server access, this type of database principal cannot be impersonated, or you do not have permission.

C Procname: [ExecuteAndFlush - no proc]

C setuser 'prd' failed -- connect terminated

C Using Provider SQLNCLI

C OpenOledbConnection: MARS property was set successfully.

C ExecuteAndFlush return code: 0x80040e14 Stmt: [if user_name() != 'prd' setuser 'prd']

C sloledb.cpp [ExecuteAndFlush,line 6470]: Error/Message: (err 15157, sev 0), Setuser failed because of one of the following reasons: the database principal 'prd' does not exist, its corresponding server principal does not have server access, this type of database principal cannot be impersonated, or you do not have permission.

C Procname: [ExecuteAndFlush - no proc]

C setuser 'prd' failed -- connect terminated

C Using Provider SQLNCLI

C OpenOledbConnection: MARS property was set successfully.

C ExecuteAndFlush return code: 0x80040e14 Stmt: [if user_name() != 'prd' setuser 'prd']

C sloledb.cpp [ExecuteAndFlush,line 6470]: Error/Message: (err 15157, sev 0), Setuser failed because of one of the following reasons: the database principal 'prd' does not exist, its corresponding server principal does not have server access, this type of database principal cannot be impersonated, or you do not have permission.

C Procname: [ExecuteAndFlush - no proc]

C setuser 'prd' failed -- connect terminated

C failed to establish conn. 0

B ***LOG BY2=> sql error -1 performing CON [dbsh#2 @ 1204] [dbsh 1204 ]

B ***LOG BY0=> Setuser failed because of one of the following reasons: the database principal 'prd' does not exist, its corresponding server principal does not have server access, this type of database principal cannot be impersonated, or you do not have permission. [dbsh#2 @ 1204] [dbsh 1204 ]

B ***LOG BY2=> sql error -1 performing CON [dblink#5 @ 431] [dblink 0431 ]

B ***LOG BY0=> Setuser failed because of one of the following reasons: the database principal 'prd' does not exist, its corresponding server principal does not have server access, this type of database principal cannot be impersonated, or you do not have permission. [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 10380]

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 req.vm = no VM

M attachedVm = no VM

M

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

M *

M * LOCATION SAP-Server PICLDR_PRD_00 on host PICLDR (wp 0)

M * ERROR ThInit: db_connect

M *

M * TIME Tue Jun 29 15:46:34 2010

M * RELEASE 700

M * COMPONENT Taskhandler

M * VERSION 1

M * RC 13

M * MODULE thxxhead.c

M * LINE 10585

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 3540) [dpnttool.c 327]

Accepted Solutions (1)

Accepted Solutions (1)

former_member227600
Contributor
0 Kudos
Error/Message: (err 15157, sev 0), Setuser failed because of one of the following reasons: the database principal 'prd' does not exist, its corresponding server principal does not have server access, this type of database principal cannot be impersonated, or you do not have permission. C Procname: [ExecuteAndFlush - no proc] C setuser 'prd' failed -- connect terminated C Using Provider SQLNCLI C

From the above error is seems that there is some thing wrong with schema. Please go through the below SAP note .

[Note 551915 - R/3 won't start after database restore or database copy|https://websmp230.sap-ag.de/sap%28bD1lbiZjPTAwMQ==%29/bc/bsp/spn/sapnotes/index2.htm?numm=551915]

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

Could you tell me your OS and SQL Version ?

If its windows with SQL, Note 551915 is the solution for your issue.

Down load the attachments (scripts) from note first.

Here two cases,You can restore SQL on same SID or on different SID.

If you restore on same SID, you have to use "user restore" script

If you restore on different SID, you have to use "user change" script.

Edit the script as per the instructions.

Thanks & Regards,

Nagendra.