Dispatcher stopping after db restore

[Former Member]

hi all,

i have just restored the production db onto a test system with the same db name but now when i try to start sap, dispatcher is stopping after sometime.

the dev_w0 file reads as below

LOCATION SAP-Server w140_MPR_00 on host w140 (wp 0)

M * ERROR ThInit: db_connect

M *

M * TIME Fri Jul 17 10:28:27 2009

M * RELEASE 700

M * COMPONENT Taskhandler

M * VERSION 1

M * RC 13

M * MODULE thxxhead.c

M * LINE 10486

M * COUNTER 1

thanks ..

Regards

Arvind Kumar

[JPReyes]

Can you post full dev_w0 please ?

Regards

Juan

[Former Member]

Hi Juan,

plz find below full details of the file.

-

---

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

-

---

*

• ACTIVE TRACE LEVEL 1

• ACTIVE TRACE COMPONENTS all, MJ

*

B

B Fri Jul 17 15:13:55 2009

B create_con (con_name=R/3)

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

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

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

B New connection 0 created

M sysno 00

M sid MPR

M systemid 562 (PC with Windows NT)

M relno 7000

M patchlevel 0

M patchno 111

M intno 20050900

M make: multithreaded, Unicode, 64 bit, optimized

M pid 3540

M

M kernel runs with dp version 229000(ext=109000) (@(#) DPLIB-INT-VERSION-229000-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

M Fri Jul 17 15:13:56 2009

M DpShMCreate: sizeof(wp_adm) 19248 (1480)

M DpShMCreate: sizeof(tm_adm) 5584592 (27784)

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: 000000000F160050, size: 6275136)

M DpShMCreate: allocated sys_adm at 000000000F160050

M DpShMCreate: allocated wp_adm at 000000000F162150

M DpShMCreate: allocated tm_adm_list at 000000000F166C80

M DpShMCreate: allocated tm_adm at 000000000F166CE0

M DpShMCreate: allocated wp_ca_adm at 000000000F6BA3B0

M DpShMCreate: allocated appc_ca_adm at 000000000F6C0170

M DpShMCreate: allocated comm_adm at 000000000F6C20B0

M DpShMCreate: system runs without slock table

M DpShMCreate: system runs without file table

M DpShMCreate: allocated vmc_adm_list at 000000000F748D40

M DpShMCreate: allocated gw_adm at 000000000F748DC0

M DpShMCreate: system runs without vmc_adm

M DpShMCreate: allocated ca_info at 000000000F748DF0

M DpShMCreate: allocated wall_adm at 000000000F748E00

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 ThInit: running on host w140

M

M Fri Jul 17 15:13:57 2009

M calling db_connect ...

C Thread ID:3752

C Thank You for using the SLOLEDB-interface

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

C dbmssslib.dll patch info

C patchlevel 0

C patchno 110

C patchcomment MSSQL: Connect error handling (1053754)

C np:(local) connection used on W140

C CopyLocalParameters: dbuser is 'mpr'

C Using Provider SQLNCLI

C OpenOledbConnection: MARS property was set successfully.

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

C sloledb.cpp [ExecuteAndFlush,line 6450]: Error/Message: (err 15157, sev 0), Setuser failed because of one of the following reasons: the database principal 'mpr' 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 'mpr' failed -- connect terminated

C Using Provider SQLNCLI

C OpenOledbConnection: MARS property was set successfully.

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

C sloledb.cpp [ExecuteAndFlush,line 6450]: Error/Message: (err 15157, sev 0), Setuser failed because of one of the following reasons: the database principal 'mpr' 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 'mpr' failed -- connect terminated

C Using Provider SQLNCLI

C OpenOledbConnection: MARS property was set successfully.

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

C sloledb.cpp [ExecuteAndFlush,line 6450]: Error/Message: (err 15157, sev 0), Setuser failed because of one of the following reasons: the database principal 'mpr' 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 'mpr' 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() != 'mpr' setuser 'mpr']

C sloledb.cpp [ExecuteAndFlush,line 6450]: Error/Message: (err 15157, sev 0), Setuser failed because of one of the following reasons: the database principal 'mpr' 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 'mpr' failed -- connect terminated

C Using Provider SQLNCLI

C OpenOledbConnection: MARS property was set successfully.

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

C sloledb.cpp [ExecuteAndFlush,line 6450]: Error/Message: (err 15157, sev 0), Setuser failed because of one of the following reasons: the database principal 'mpr' 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 'mpr' failed -- connect terminated

C Using Provider SQLNCLI

C OpenOledbConnection: MARS property was set successfully.

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

C sloledb.cpp [ExecuteAndFlush,line 6450]: Error/Message: (err 15157, sev 0), Setuser failed because of one of the following reasons: the database principal 'mpr' 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 'mpr' 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 'mpr' 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#3 @ 431] [dblink 0431 ]

B ***LOG BY0=> Setuser failed because of one of the following reasons: the database principal 'mpr' 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#3 @ 431] [dblink 0431 ]

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

M in_ThErrHandle: 1

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

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 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 w140_MPR_00 on host w140 (wp 0)

M * ERROR ThInit: db_connect

M *

M * TIME Fri Jul 17 15:13:57 2009

M * RELEASE 700

M * COMPONENT Taskhandler

M * VERSION 1

M * RC 13

M * MODULE thxxhead.c

M * LINE 10486

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

[JPReyes]

the database principal 'mpr' does not exist,

Read,

http://support.microsoft.com/kb/913423

That should help.

Regards

Juan

[former_member235680]

Hi Arvind,

Did you make any change in the existing kernel as well? I mean is there any difference between source and target kernels?

Thanks

Abhi

[Former Member]

Hi

After setting evn did you log off and log in ?

Regards

Uday

[Former Member]

yes uday..the system was restarted after setting the environment variables...

[Former Member]

Hi Arvind

4 ETW000 http://dbcon.c ,00000 *** ERROR => Invalid profile parameter dbms/type (or environment variable dbms_type) = <undef>, cannot load DB library
4 ETW000 131 0.001799
2EETW169 no connect possible: "connect failed with DBLI_RC_LOAD_LIB_FAILED."

You did not tell us your DB release!!

whatever, ORA/MSS/DB2/DB4...

dbms/type need sto be setup as an OS environment variable: "DBMS_TYPE = ORA"

Check this blog for more clarity

Regards

Uday

[Former Member]

hi uday,

my db is ms sql.

the link you provided mentions that the dbms type needs to be mentioned in sapsid environment. i am not very clear what it means.

does it mean that i have to login as sidadm in windows and set the variable name as dbms_type and the value as mss

[Former Member]

Hi Arabind,

Yes,You are right.

You have to login as sidadm and set the env variable.You can even set under the user administrator also.

Regards

Ashok Dalai

[Former Member]

hi,

i have set the environment variable name as dbms_type and value as mss, but still am facing the same issue.

work process stops and the dispatcher also stops.

i also tried to restart the server after setting the environment variables.

i am a little clueless as to why this happend after the db restore and why sap is not starting.

[Former Member]

Check your database is up and try to connect manually.

[Former Member]

yes, the db is up ad im able to login to sql.

[Former Member]

Hi Arabind,

You have missed post resore steps.Perform all this before starting sap.Below note will guide you.

Check below notes

Note 151603 - Copying an SQL Server database,here check the folowup steps.

Note 683447 - SAP Tools for MS SQL Server

Regards

Ashok Dalai

[Former Member]

Hi Aravind Kumar,

Your db names are same but what about your sap SID?

You have to create the users after db restore.

At command prompt execute command r3trans -d and paste the trans.log here.

Regards

Ashok Dalai

[Former Member]

thanks for the quick reply..

i tried to enter the command r3trans -d in cmd but the command is not getting recognised by the system..

SAP sid is also same..the only thing different is the hostname.

i did have to create a new .ndf file to restore the db onto the test server.

also im not clear what you mean by create the users..please explain

regards

Arvind Kumar

[Former Member]

Hi Arvind Kumar,

The system is not able recognise the command because the path to the kernel directory is not set in the env variable.

C:\Documents and Settings\sidadm>path=<path to kernel directory>

Then command r3trans -d

If you will login to o/s level as user sidadm then above step not required you can directly execute r3trans -d

Then check the file for connection error.

the host name changed so you have to cteate the users again.

Read below note

sap note - 400241

Regards

Ashok Dalai

[Former Member]

Hi,

please find below the trans log.

4 ETW000 r3trans version 6.14 (release 700 - 15.06.07 - 15:50:00).

4 ETW000 unicode enabled version

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

4 ETW000

4 ETW000 date&time : 17.07.2009 - 11:24:43

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] Fri Jul 17 11:24:45 2009 1571 0.001571

4 ETW000 [dev trc ,00000] db_con_init called 44 0.001615

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

4 ETW000 [dbcon.c ,00000] *** ERROR => Invalid profile parameter dbms/type (or environment variable dbms_type) = <undef>, cannot load DB library

4 ETW000 131 0.001799

2EETW169 no connect possible: "connect failed with DBLI_RC_LOAD_LIB_FAILED."

[Former Member]

Hi Arvind Kumar,

ERROR => Invalid profile parameter dbms/type (or environment variable dbms_type) = <undef>, cannot load DB library

Set the env variable dbms_type to correct value.

if oracle then to ora

if mssql then mss

Regards

Ashok Dalai