SAP Dispatcher getting stopped after successful DB...

Dear Experts,

I have installed SAP ECC 6.0 with MSS 2005 on Windows 2003 x64. MSS DB and thereafter

SAP installtion was successful. I also logged on the system and checked a few things. Then we

performed a PRD data DB restore using MSS Management Studio and DB restore completed successfully.

Then we take a restart and tried to start SAP. Primarily I found it is starting and then when it come Dispatcher

getting stopped once i restarted the server also I tried with r3trans -d and its not executing please check the developer trace

and my server work directory in zip format attached please check the attachment

please help me to sort out this issue

Best Regards

SURESH .M

SAP BASIS CONSULTANT

SAP Managed Tags:
Windows Server

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Accepted Solutions (0)

Answers (3)

Hi Suresh

1. System kernel level low, you have to upgrade the kernel & DBSL patch

2. Just do the full system restart, try to start the system have you completed the post installation tasks?

3. Could you check this SAP Note

1934023 - Application server startup fail with an ICM connection error

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi Anandan,

It looks to be problem with schema as you perform system copy from PRD to new system.

Please refer to detailed system copy steps in SAP note & Ensure all steps are correctly performed

Note 151603 - Copying an SQL Server database

Also refer to SAP note for Post copy steps.

Note 683447 - SAP Tools for MS SQL Server

Refer to SAP note below for issues related to schema and how to resolve them.

Note 551915 - R/3 won't start after database restore or database copy

Hope this helps.

Regards,

Deepak Kori

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Dear Deepak Kori,

iam Given the all the <SID> and host name all are same like PRD Nothing iam changed

Best Regards

SURESH .M

SAP BASIS CONSULTANT

Hi Suresh,

Please share R3trans -d log

Regards,

Deepak Kori

Hi Deepak,

trans log is nothing is there command also not executing all the services are green color only dispatcher stoped

Regards

suresh .M

hi deepak,

iam refer to SAP

Note 683447 - SAP Tools for MS SQL Server and downloading the SWPM TOOL

PLEASE GUIDE ME how to use the tool

Regards

suresh .M

Hi Suresh,

From the trans.log


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.

This error comes when copying database with same SID. Please use below SAP note and perform post copy steps .

Note 683447 - SAP Tools for MS SQL Server

Hope this helps.

Regards,

Deepak Kori

okay deepak thanks for prompt reply

Hi deepak ,

please check the trans log iam attached

r3trans -d getting return code 0012

please check it

4 ETW000 r3trans version 6.14 (release 700 - 18.09.06 - 09:35:00).

4 ETW000 unicode enabled version

4 ETW000 ===============================================

4 ETW000

4 ETW000 date&time : 19.06.2014 - 16:57:13

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: r3trans -d

4 ETW000 trace at level 2 opened for a given file pointer

4 ETW000 [dev trc ,00000] Thu Jun 19 16:57:15 2014 41662 0.041662

4 ETW000 [dev trc ,00000] db_con_init called 142 0.041804

4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 181 0.041985

4 ETW000 [dev trc ,00000] Loading DB library 'dbmssslib.dll' ... 138 0.042123

4 ETW000 [dev trc ,00000] load shared library (dbmssslib.dll), hdl 0 47141 0.089264

4 ETW000 [dev trc ,00000] using "D:\usr\sap\PRD\SYS\exe\uc\NTAMD64\dbmssslib.dll"

4 ETW000 130 0.089394

4 ETW000 [dev trc ,00000] Library 'dbmssslib.dll' loaded 40 0.089434

4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library dbmssslib.dll

4 ETW000 63 0.089497

4 ETW000 [dev trc ,00000] Version of 'dbmssslib.dll' is "700.08", patchlevel (0.72)

4 ETW000 28593 0.118090

4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library dbmssslib.dll

4 ETW000 75 0.118165

4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library dbmssslib.dll

4 ETW000 70 0.118235

4 ETW000 [dev trc ,00000] New connection 0 created 11925 0.130160

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = -000000001 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 163 0.130323

4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 56 0.130379

4 ETW000 [dev trc ,00000] find_con_by_name found the following connection for reuse:

4 ETW000 60 0.130439

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = 000000000 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 74 0.130513

4 ETW000 [dev trc ,00000] Thread ID:2196 16796 0.147309

4 ETW000 [dev trc ,00000] Thank You for using the SLOLEDB-interface 54 0.147363

4 ETW000 [dev trc ,00000] Using dynamic link library 'D:\usr\sap\PRD\SYS\exe\uc\NTAMD64\dbmssslib.dll'

4 ETW000 76 0.147439

4 ETW000 [dev trc ,00000] dbmssslib.dll patch info 84 0.147523

4 ETW000 [dev trc ,00000] patchlevel 0 37 0.147560

4 ETW000 [dev trc ,00000] patchno 72 30 0.147590

4 ETW000 [dev trc ,00000] patchcomment MSSQL: Thread check in DbSlDisconnect (969143)

4 ETW000 54 0.147644

4 ETW000 [dev trc ,00000] np:(local) connection used on PSPRD1 195 0.147839

4 ETW000 [dev trc ,00000] CopyLocalParameters: dbuser is 'prd' 44 0.147883

4 ETW000 [dev trc ,00000] Using Provider SQLNCLI 46841 0.194724

4 ETW000 [dev trc ,00000] OpenOledbConnection: MARS property was set successfully.

4 ETW000 419 0.195143

4 ETW000 [dev trc ,00000] ExecuteAndFlush return code: 0x80040e14 Stmt: [if user_name() != 'prd' setuser 'prd']

4 ETW000 121982 0.317125

4 ETW000 [dev trc ,00000] ExecuteAndFlush: line 6324. hr: 0x80040e14 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.

4 ETW000 211 0.317336

4 ETW000 [dev trc ,00000] sloledb.cpp [ExecuteAndFlush,line 6324]: 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.

4 ETW000 168 0.317504

4 ETW000 [dev trc ,00000] Procname: [ExecuteAndFlush - no proc] 38 0.317542

4 ETW000 [dev trc ,00000] setuser 'prd' failed -- connect terminated 68 0.317610

4 ETW000 [dev trc ,00000] Using Provider SQLNCLI 6271 0.323881

4 ETW000 [dev trc ,00000] OpenOledbConnection: MARS property was set successfully.

4 ETW000 215 0.324096

4 ETW000 [dev trc ,00000] ExecuteAndFlush return code: 0x80040e14 Stmt: [if user_name() != 'prd' setuser 'prd']

4 ETW000 8723 0.332819

4 ETW000 122 0.332941

4 ETW000 141 0.333082

4 ETW000 [dev trc ,00000] Procname: [ExecuteAndFlush - no proc] 37 0.333119

4 ETW000 [dev trc ,00000] setuser 'prd' failed -- connect terminated 53 0.333172

4 ETW000 [dev trc ,00000] Using Provider SQLNCLI 6308 0.339480

4 ETW000 [dev trc ,00000] OpenOledbConnection: MARS property was set successfully.

4 ETW000 209 0.339689

4 ETW000 [dev trc ,00000] ExecuteAndFlush return code: 0x80040e14 Stmt: [if user_name() != 'prd' setuser 'prd']

4 ETW000 8393 0.348082

4 ETW000 122 0.348204

4 ETW000 286 0.348490

4 ETW000 [dev trc ,00000] Procname: [ExecuteAndFlush - no proc] 42 0.348532

4 ETW000 [dev trc ,00000] setuser 'prd' failed -- connect terminated 55 0.348587

4 ETW000 [dev trc ,00000] failed to establish conn to np:(local). 6478 0.355065

4 ETW000 [dev trc ,00000] Retrying without protocol specifier: (local) 49 0.355114

4 ETW000 [dev trc ,00000] Using Provider SQLNCLI 123 0.355237

4 ETW000 [dev trc ,00000] OpenOledbConnection: MARS property was set successfully.

4 ETW000 214 0.355451

4 ETW000 [dev trc ,00000] ExecuteAndFlush return code: 0x80040e14 Stmt: [if user_name() != 'prd' setuser 'prd']

4 ETW000 14045 0.369496

4 ETW000 128 0.369624

4 ETW000 141 0.369765

4 ETW000 [dev trc ,00000] Procname: [ExecuteAndFlush - no proc] 38 0.369803

4 ETW000 [dev trc ,00000] setuser 'prd' failed -- connect terminated 53 0.369856

4 ETW000 [dev trc ,00000] Using Provider SQLNCLI 886 0.370742

4 ETW000 [dev trc ,00000] OpenOledbConnection: MARS property was set successfully.

4 ETW000 226 0.370968

4 ETW000 [dev trc ,00000] ExecuteAndFlush return code: 0x80040e14 Stmt: [if user_name() != 'prd' setuser 'prd']

4 ETW000 8706 0.379674

4 ETW000 122 0.379796

4 ETW000 145 0.379941

4 ETW000 [dev trc ,00000] Procname: [ExecuteAndFlush - no proc] 37 0.379978

4 ETW000 [dev trc ,00000] setuser 'prd' failed -- connect terminated 53 0.380031

4 ETW000 [dev trc ,00000] Using Provider SQLNCLI 6315 0.386346

4 ETW000 [dev trc ,00000] OpenOledbConnection: MARS property was set successfully.

4 ETW000 229 0.386575

4 ETW000 [dev trc ,00000] ExecuteAndFlush return code: 0x80040e14 Stmt: [if user_name() != 'prd' setuser 'prd']

4 ETW000 8701 0.395276

4 ETW000 122 0.395398

4 ETW000 144 0.395542

4 ETW000 [dev trc ,00000] Procname: [ExecuteAndFlush - no proc] 34 0.395576

4 ETW000 [dev trc ,00000] setuser 'prd' failed -- connect terminated 53 0.395629

4 ETW000 [dev trc ,00000] failed to establish conn. 0 6497 0.402126

4 ETW000 [dblink ,00431] ***LOG BY2=>sql error 0 performing CON [dblink#3 @ 431]

4 ETW000 11973 0.414099

4 ETW000 [dblink ,00431] ***LOG BY0=><message text not available> [dblink#3 @ 431]

4 ETW000 55 0.414154

2EETW169 no connect possible: "DBMS = MSSQL --- SERVER = 'PSPRD1' DBNAME = 'PRD'"

Best regards

suresh

Hi Suresh,

Please check the SAP note which I shared earlier in my response for usage of MSSQL tools.

Regards,

Deepak Kori

Run R3trans -d and provide the output from the trans.log file

Supply the dev_w0 trace file

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi Reagan,

trans log file also nothing is there please check the below dev_w0 trace file

---------------------------------------------------

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

---------------------------------------------------

* ACTIVE TRACE LEVEL 1

* ACTIVE TRACE COMPONENTS all, MJ

B Thu Jun 19 11:59:28 2014

B create_con (con_name=R/3)

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

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

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

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 75

M intno 20050900

M make: multithreaded, Unicode, 64 bit, optimized

M pid 2160

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

M length of sys_adm_ext is 572 bytes

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

I MtxInit: 30000 0 0

M DpSysAdmExtCreate: ABAP is active

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

M Thu Jun 19 11:59:29 2014

M DpShMCreate: sizeof(wp_adm) 18512 (1424)

M DpShMCreate: sizeof(tm_adm) 5258160 (26160)

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 DpFileTableSize: max/headSize/ftSize/tableSize=0/0/0/0

M DpShMCreate: sizeof(file_adm) 0 (72)

M DpShMCreate: sizeof(vmc_adm) 0 (1744)

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

M DpShMCreate: sizeof(gw_adm) 48

M DpShMCreate: SHM_DP_ADM_KEY (addr: 000000000EE50050, size: 5947376)

M DpShMCreate: allocated sys_adm at 000000000EE50050

M DpShMCreate: allocated wp_adm at 000000000EE51F00

M DpShMCreate: allocated tm_adm_list at 000000000EE56750

M DpShMCreate: allocated tm_adm at 000000000EE567B0

M DpShMCreate: allocated wp_ca_adm at 000000000F35A360

M DpShMCreate: allocated appc_ca_adm at 000000000F360120

M DpShMCreate: allocated comm_adm at 000000000F362060

M DpShMCreate: system runs without file table

M DpShMCreate: allocated vmc_adm_list at 000000000F3E8CF0

M DpShMCreate: allocated gw_adm at 000000000F3E8D70

M DpShMCreate: system runs without vmc_adm

M DpShMCreate: allocated ca_info at 000000000F3E8DA0

M DpShMCreate: allocated wall_adm at 000000000F3E8DB0

X EmInit: MmSetImplementation( 2 ).

X MM global diagnostic options set: 0

X <ES> client 0 initializing ....

X Using implementation flat

M <EsNT> Memory Reset disabled as NT default

X ES initialized.

M Thu Jun 19 11:59:30 2014

M ThInit: running on host psprd1

M Thu Jun 19 11:59:31 2014

M calling db_connect ...

C Thread ID:2964

C Thank You for using the SLOLEDB-interface

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

C dbmssslib.dll patch info

C patchlevel 0

C patchno 72

C patchcomment MSSQL: Thread check in DbSlDisconnect (969143)

C np:(local) connection used on PSPRD1

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 6324]: 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 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 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 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 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 Procname: [ExecuteAndFlush - no proc]

C setuser 'prd' failed -- connect terminated

C failed to establish conn. 0

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

B ***LOG BY0=> <message text not available> [dbsh#2 @ 1204] [dbsh 1204 ]

B ***LOG BY2=> sql error 0 performing CON [dblink#3 @ 431] [dblink 0431 ]

B ***LOG BY0=> <message text not available> [dblink#3 @ 431] [dblink 0431 ]

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

M in_ThErrHandle: 1

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

M Info for wp 0

M stat = 4

M reqtype = 1

M act_reqtype = -1

M rq_info = 0

M tid = -1

M mode = 255

M len = -1

M rq_id = 65535

M rq_source = 255

M last_tid = 0

M last_mode = 0

M semaphore = 0

M act_cs_count = 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 vm = V-1

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

M *

M * LOCATION SAP-Server psprd1_PRD_00 on host psprd1 (wp 0)

M * ERROR ThInit: db_connect

M *

M * TIME Thu Jun 19 11:59:31 2014

M * RELEASE 700

M * COMPONENT Taskhandler

M * VERSION 1

M * RC 13

M * MODULE thxxhead.c

M * LINE 10354

M * COUNTER 1

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 720]

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

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

Best Regards

SURESH .M

SAP BASIS CONSULTANT

Hello Suresh

Check whether the solution suggested in this SAP note can help you. It is not exactly to the error but I believe the error is due to insufficient permissions.

1414121 - Cannot execute as the server principal

Regards

Ask a Question

Top Q&A Solution Author

User

Count