Dispatcher - Stopped. - SAP Community

Hi,

I installed Central Instance on Win2K3 Server. SQL 2005.

I kept 3 data files set of 105GB (35 x 3) and log file with default of 1GB.

I restored a backup of one of other server with 80GB of database (26.6 x 3) and log file with size 40GB.

After is restored the database from SQL and start the instance, the dispatcher "disp+work.EXE" is not starting and is stopped. I have uploaded the Developer Trace of it as below.

http://www.yousendit.com/download/dVlxWmd0dENQb0lLSkE9PQ

Can someone guide to solve this problem.

Thanks in advance.

Kalpesh

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 (2)

Apply sap note 610640. In this note download the text file sp_check_sap_login.TXT . Copy all the contents of the sp_check_sap_login.TXT and place in the SQL Query analyzer

Regards

Uday

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

Comment

Hello Uday,

Thanks for the link to SAP Note. SAP Note 610640 is now changed to 1294762. This note has a script to repair the schema and move the schema.

In our scenario, we have installed a new server with different SID (PRT). We restored it from Quality Server with different SID (QAS). When i run the script to repair the schema, it asks for information regarding the instance and SID. I provided the details as as per my existing installation (i.e. SID=PRT). But there is no SID as such in the schema after doing the restore. I can see schema of QAS server and sid of QAS server. Also there is schema called dbo, and SID of it is showing - "???".

Yet, when i executed the repair script, it gave me error since the users were not found, i.e. sidadm and SAPServiceSID. So i created new users manually with "qasadm" and "SAPServiceQAS" and gave rights as per existing ones. Run the script. There were no errors. But the problem still exists.

Can you please guide - can i restore a database from one server to another with different SID ? If i want to do that, do i have to move the schema ? This should be done before restore or after restore ?

Please guide.

Thanks,

Kalpesh.

Hello Kalpesh,

You can do a restore of the backup from one server to another with different SID.

But for tha you require proper planning.Follow the note 151603 and 193816,it tells you in detail the procedure for carrying out this activity.

Also after the restore,you need to run the schema conversion,for that on SQL server SAP has provided SAP tools for schema conversion.Refer to Note 683447 for detailed info

Rohit

Hello Rohit,

Thanks for links. I will go through the steps and try.

Can you clear me - if we install a server with same SID and try to restore the database, does things run fine or would need some planning and tools for that too ?

Please guide. Thanks,

Kalpesh

you can install a server with same SID and restore the database,it should not be any issue and would not require any special planning

Rohit

post the contents of dev_w0 log file

Rohit

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

Comment

HI,

Please find the contents of dev_w0 file

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

ACTIVE TRACE LEVEL 1
ACTIVE TRACE COMPONENTS all, MJ

B Sat Apr 25 18:57:48 2009

B create_con (con_name=R/3)

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

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

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

B New connection 0 created

M sysno 00

M sid PRT

M systemid 560 (PC with Windows NT)

M relno 7000

M patchlevel 0

M patchno 144

M intno 20050900

M make: multithreaded, Unicode, optimized

M pid 4072

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 4072) [dpxxdisp.c 1305]

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) 24416 (1436)

M DpShMCreate: sizeof(tm_adm) 4270848 (21248)

M DpShMCreate: sizeof(wp_ca_adm) 24000 (80)

M DpShMCreate: sizeof(appc_ca_adm) 8000 (80)

M DpCommTableSize: max/headSize/ftSize/tableSize=500/8/528056/528064

M DpShMCreate: sizeof(comm_adm) 528064 (1048)

M DpSlockTableSize: max/headSize/ftSize/fiSize/tableSize=0/0/0/0/0

M DpShMCreate: sizeof(slock_adm) 0 (96)

M DpFileTableSize: max/headSize/ftSize/tableSize=0/0/0/0

M DpShMCreate: sizeof(file_adm) 0 (72)

M DpShMCreate: sizeof(vmc_adm) 0 (1544)

M DpShMCreate: sizeof(wall_adm) (38456/34360/64/184)

M DpShMCreate: sizeof(gw_adm) 48

M DpShMCreate: SHM_DP_ADM_KEY (addr: 06F70040, size: 4936648)

M DpShMCreate: allocated sys_adm at 06F70040

M DpShMCreate: allocated wp_adm at 06F72090

M DpShMCreate: allocated tm_adm_list at 06F77FF0

M DpShMCreate: allocated tm_adm at 06F78020

M DpShMCreate: allocated wp_ca_adm at 0738AB20

M DpShMCreate: allocated appc_ca_adm at 073908E0

M DpShMCreate: allocated comm_adm at 07392820

M DpShMCreate: system runs without slock table

M DpShMCreate: system runs without file table

M DpShMCreate: allocated vmc_adm_list at 074136E0

M DpShMCreate: allocated gw_adm at 07413720

M DpShMCreate: system runs without vmc_adm

M DpShMCreate: allocated ca_info at 07413750

M DpShMCreate: allocated wall_adm at 07413758

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 Sat Apr 25 18:57:50 2009

M ThInit: running on host mtcc-testsvr

M Sat Apr 25 18:57:51 2009

M calling db_connect ...

C Thread ID:1172

C Thank You for using the SLOLEDB-interface

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

C dbmssslib.dll patch info

C patchlevel 0

C patchno 144

C patchcomment MSSQL: ODBC fastload on separate connection (1131805)

C np:(local) connection used on MTCC-TESTSVR

C CopyLocalParameters: dbuser is 'prt'

C Using Provider SQLNCLI

C OpenOledbConnection: MARS property was set successfully.

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

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

C Using Provider SQLNCLI

C OpenOledbConnection: MARS property was set successfully.

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

C Procname: [ExecuteAndFlush - no proc]

C setuser 'prt' failed -- connect terminated

C Using Provider SQLNCLI

C OpenOledbConnection: MARS property was set successfully.

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

C Procname: [ExecuteAndFlush - no proc]

C setuser 'prt' 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() != 'prt' setuser 'prt']

C Procname: [ExecuteAndFlush - no proc]

C setuser 'prt' failed -- connect terminated

C Using Provider SQLNCLI

C OpenOledbConnection: MARS property was set successfully.

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

C Procname: [ExecuteAndFlush - no proc]

C setuser 'prt' failed -- connect terminated

C Using Provider SQLNCLI

C OpenOledbConnection: MARS property was set successfully.

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

C Procname: [ExecuteAndFlush - no proc]

C setuser 'prt' 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 'prt' 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 ]

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 Info for wp 0

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 * LOCATION SAP-Server mtcc-testsvr_PRT_00 on host mtcc-testsvr (wp 0)

M * ERROR ThInit: db_connect

M *

M * TIME Sat Apr 25 18:57:51 2009

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

Hi,

Can anyone please provide some guidelines to the solution ?

Thanks,

Kalpesh.

Ask a Question

Top Q&A Solution Author

User

Count