Question from Tapas on Oct 2 at 9:20 AM Dear experts, I am not able to bring my SAP server online after doing a database restore. Environment:- SAP ECC 6.0 EHP4 DB:- MSSQL 2008 We have a PRD LIVE database which is working fine. I also have a PRD dummy which was a copy of PRD live. But our Dummy PRD was not uptodate as the copy was done a long back. Hence we restored our most recent PRD-LIVE Back up to make it upto date. Before restoring it, I increased and made the size equal to our PRD-LIVE server. Restore completed successfulley, but when I try to start SAP through SAP MMC, the Dispatcher gives and error and stops immidiately. Below is the Developer trace for DIspatcher:- ------------------- trc file: "dev_disp", trc level: 1, release: "701" ------------------- sysno 01 sid PRD systemid 562 (PC with Windows NT) relno 7010 patchlevel 0 patchno 194 intno 20020600 make: multithreaded, Unicode, 64 bit, optimized pid 3948 kernel runs with dp version 246000(ext=110000) (@(#) DPLIB-INT-VERSION-246000-UC) length of sys_adm_ext is 576 bytes *** SWITCH TRC-HIDE on *** ***LOG Q00=> DpSapEnvInit, DPStart (01 3948) [dpxxdisp.c 1361] shared lib "dw_xml.dll" version 194 successfully loaded shared lib "dw_xtc.dll" version 194 successfully loaded shared lib "dw_stl.dll" version 194 successfully loaded shared lib "dw_gui.dll" version 194 successfully loaded shared lib "dw_mdm.dll" version 194 successfully loaded rdisp/softcancel_sequence : -> 0,5,-1 use internal message server connection to port 3901 Thu Feb 10 12:16:41 2005 *** WARNING => DpNetCheck: NiAddrToHost(1.0.0.0) took 4 seconds ***LOG GZZ=> 1 possible network problems detected - check tracefile and adjust the DNS settings [dpxxtool2.c 5551] MtxInit: 30000 0 0 DpSysAdmExtInit: ABAP is active DpSysAdmExtInit: VMC (JAVA VM in WP) is not active DpIPCInit2: start server >FILSAPDR1_PRD_01 < DpShMCreate: sizeof(wp_adm) 24528 (1752) DpShMCreate: sizeof(tm_adm) 5912704 (29416) DpShMCreate: sizeof(wp_ca_adm) 24064 (80) DpShMCreate: sizeof(appc_ca_adm) 8000 (80) DpCommTableSize: max/headSize/ftSize/tableSize=500/16/552064/552080 DpShMCreate: sizeof(comm_adm) 552080 (1088) DpSlockTableSize: max/headSize/ftSize/fiSize/tableSize=0/0/0/0/0 DpShMCreate: sizeof(slock_adm) 0 (104) DpFileTableSize: max/headSize/ftSize/tableSize=0/0/0/0 DpShMCreate: sizeof(file_adm) 0 (72) DpShMCreate: sizeof(vmc_adm) 0 (1864) DpShMCreate: sizeof(wall_adm) (41664/36752/64/192) DpShMCreate: sizeof(gw_adm) 48 DpShMCreate: SHM_DP_ADM_KEY (addr: 0000000008A00050, size: 6609024) DpShMCreate: allocated sys_adm at 0000000008A00050 DpShMCreate: allocated wp_adm at 0000000008A022A0 DpShMCreate: allocated tm_adm_list at 0000000008A08270 DpShMCreate: allocated tm_adm at 0000000008A082D0 DpShMCreate: allocated wp_ca_adm at 0000000008FABB50 DpShMCreate: allocated appc_ca_adm at 0000000008FB1950 DpShMCreate: allocated comm_adm at 0000000008FB3890 DpShMCreate: system runs without slock table DpShMCreate: system runs without file table DpShMCreate: allocated vmc_adm_list at 000000000903A520 DpShMCreate: allocated gw_adm at 000000000903A5A0 DpShMCreate: system runs without vmc_adm DpShMCreate: allocated ca_info at 000000000903A5D0 DpShMCreate: allocated wall_adm at 000000000903A640 MBUF state OFF DpCommInitTable: init table for 500 entries DpRqQInit: Parameter rdisp/queue_lock_level = 2 rdisp/queue_size_check_value : -> on,50,30,40,500,50,500,80 ThTaskStatus: rdisp/reset_online_during_debug 0 EmInit: MmSetImplementation( 2 ). MM global diagnostic options set: 0 <ES> client 0 initializing .... <ES> EsILock: use spinlock for locking <ES> InitFreeList <ES> block size is 4096 kByte. <ES> Info: em/initial_size_MB( 3999MB) not multiple of em/blocksize_KB( 4096KB) <ES> Info: em/initial_size_MB rounded up to 4000MB Using implementation view <EsNT> Using memory model view. <EsNT> Memory Reset disabled as NT default <ES> 999 blocks reserved for free list. ES initialized. mm.dump: set maximum dump mem to 96 MB rdisp/http_min_wait_dia_wp : 1 -> 1 ***LOG CPS=> DpLoopInit, ICU ( 3.0 3.0 4.0.1) [dpxxdisp.c 1756] ***LOG Q0K=> DpMsAttach, mscon ( FILSAPDR1) [dpxxdisp.c 12872] DpStartStopMsg: send start message (myname is >FILSAPDR1_PRD_01 <) DpStartStopMsg: start msg sent CCMS: Initalizing shared memory of size 60000000 for monitoring segment. CCMS: Checking Downtime Configuration of Monitoring Segment. CCMS: start to initalize 3.X shared alert area (first segment). DpMsgAdmin: Set release to 7010, patchlevel 0 MBUF state PREPARED MBUF component UP DpMBufHwIdSet: set Hardware-ID ***LOG Q1C=> DpMBufHwIdSet [dpxxmbuf.c 1048] DpMsgAdmin: Set patchno for this platform to 194 Release check o.K. Thu Feb 10 12:17:21 2005 my types changed after wp death/restart 0xb7 --> 0xb6 my types changed after wp death/restart 0xb6 --> 0xb4 my types changed after wp death/restart 0xb4 --> 0xb0 my types changed after wp death/restart 0xb0 --> 0xa0 my types changed after wp death/restart 0xa0 --> 0x80 *** DP_FATAL_ERROR => DpWPCheck: no more work processes *** DISPATCHER EMERGENCY SHUTDOWN *** increase tracelevel of WPs NiWait: sleep (10000ms) ... NiISelect: timeout 10000ms NiISelect: maximum fd=1049 NiISelect: read-mask is NULL NiISelect: write-mask is NULL Thu Feb 10 12:17:31 2005 NiISelect: TIMEOUT occured (10000ms) dump system status Workprocess Table (long) Thu Feb 10 08:17:31 2005 ======================== No Ty. Pid Status Cause Start Err Sem CPU Time Program Cl User Action Table ------------------------------------------------------------------------------------------------------------------------------- 0 DIA 4168 Ended no 1 0 0 1 DIA 1880 Ended no 1 0 0 2 DIA 4884 Ended no 1 0 0 3 DIA 3408 Ended no 1 0 0 4 DIA 3592 Ended no 1 0 0 5 DIA 4420 Ended no 1 0 0 6 DIA 2152 Ended no 1 0 0 7 DIA 2884 Ended no 1 0 0 8 DIA 4980 Ended no 1 0 0 9 DIA 440 Ended no 1 0 0 10 UPD 3400 Ended no 1 0 0 11 ENQ 544 Ended no 1 0 0 12 SPO 4356 Ended no 1 0 0 13 UP2 2992 Ended no 1 0 0 Dispatcher Queue Statistics Thu Feb 10 08:17:31 2005 =========================== +------+--------+--------+--------+--------+--------+ | Typ | now | high | max | writes | reads | +------+--------+--------+--------+--------+--------+ | NOWP | 0 | 2 | 2000 | 5 | 5 | +------+--------+--------+--------+--------+--------+ | DIA | 5 | 5 | 2000 | 5 | 0 | +------+--------+--------+--------+--------+--------+ | UPD | 0 | 0 | 2000 | 0 | 0 | +------+--------+--------+--------+--------+--------+ | ENQ | 0 | 0 | 2000 | 0 | 0 | +------+--------+--------+--------+--------+--------+ | BTC | 0 | 0 | 2000 | 0 | 0 | +------+--------+--------+--------+--------+--------+ | SPO | 0 | 0 | 2000 | 0 | 0 | +------+--------+--------+--------+--------+--------+ | UP2 | 0 | 0 | 2000 | 0 | 0 | +------+--------+--------+--------+--------+--------+ max_rq_id 12 wake_evt_udp_now 0 wake events total 8, udp 6 ( 75%), shm 2 ( 25%) since last update total 8, udp 6 ( 75%), shm 2 ( 25%) Dump of tm_adm structure: Thu Feb 10 08:17:31 2005 ========================= Term uid man user term lastop mod wp ta a/i (modes) Workprocess Comm. Area Blocks Thu Feb 10 08:17:31 2005 ============================= Slots: 300, Used: 1, Max: 1 +------+--------------+----------+-------------+ | id | owner | pid | eyecatcher | +------+--------------+----------+-------------+ | 0 | DISPATCHER | -1 | *WPCAAD000* | NiWait: sleep (5000ms) ... NiISelect: timeout 5000ms NiISelect: maximum fd=1049 NiISelect: read-mask is NULL NiISelect: write-mask is NULL Thu Feb 10 12:17:36 2005 NiISelect: TIMEOUT occured (5000ms) DpHalt: shutdown server >FILSAPDR1_PRD_01 < (normal) DpJ2eeDisableRestart DpModState: buffer in state MBUF_PREPARED NiBufSend starting NiIWrite: hdl 2 sent data (wrt=110,pac=1,MESG_IO) MsINiWrite: sent 110 bytes MsIModState: change state to SHUTDOWN DpModState: change server state from STARTING to SHUTDOWN Switch off Shared memory profiling ShmProtect( 57, 3 ) ShmProtect(SHM_PROFILE, SHM_PROT_RW ShmProtect( 57, 1 ) ShmProtect(SHM_PROFILE, SHM_PROT_RD DpWakeUpWps: wake up all wp's Stop work processes Stop gateway killing process (4248) (SOFT_KILL) Stop icman killing process (3084) (SOFT_KILL) Terminate gui connections wait for end of work processes wait for end of gateway [DpProcDied] Process lives (PID:4248 HANDLE:780) waiting for termination of gateway ... NiWait: sleep (1000ms) ... NiISelect: timeout 1000ms NiISelect: maximum fd=1049 NiISelect: read-mask is NULL NiISelect: write-mask is NULL Thu Feb 10 12:17:37 2005 NiISelect: TIMEOUT occured (1000ms) [DpProcDied] Process died (PID:4248 HANDLE:780) wait for end of icman [DpProcDied] Process lives (PID:3084 HANDLE:808) waiting for termination of icman ... NiWait: sleep (1000ms) ... NiISelect: timeout 1000ms NiISelect: maximum fd=1049 NiISelect: read-mask is NULL NiISelect: write-mask is NULL Thu Feb 10 12:17:38 2005 NiISelect: TIMEOUT occured (1000ms) [DpProcDied] Process lives (PID:3084 HANDLE:808) waiting for termination of icman ... NiWait: sleep (1000ms) ... NiISelect: timeout 1000ms NiISelect: maximum fd=1049 NiISelect: read-mask is NULL NiISelect: write-mask is NULL Thu Feb 10 12:17:39 2005 NiISelect: TIMEOUT occured (1000ms) [DpProcDied] Process lives (PID:3084 HANDLE:808) waiting for termination of icman ... NiWait: sleep (1000ms) ... NiISelect: timeout 1000ms NiISelect: maximum fd=1049 NiISelect: read-mask is NULL NiISelect: write-mask is NULL Thu Feb 10 12:17:40 2005 NiISelect: TIMEOUT occured (1000ms) [DpProcDied] Process lives (PID:3084 HANDLE:808) waiting for termination of icman ... NiWait: sleep (1000ms) ... NiISelect: timeout 1000ms NiISelect: maximum fd=1049 NiISelect: read-mask is NULL NiISelect: write-mask is NULL Thu Feb 10 12:17:41 2005 NiISelect: TIMEOUT occured (1000ms) [DpProcDied] Process lives (PID:3084 HANDLE:808) waiting for termination of icman ... NiWait: sleep (1000ms) ... NiISelect: timeout 1000ms NiISelect: maximum fd=1049 NiISelect: read-mask is NULL NiISelect: write-mask is NULL Thu Feb 10 12:17:42 2005 NiISelect: TIMEOUT occured (1000ms) [DpProcDied] Process lives (PID:3084 HANDLE:808) waiting for termination of icman ... NiWait: sleep (1000ms) ... NiISelect: timeout 1000ms NiISelect: maximum fd=1049 NiISelect: read-mask is NULL NiISelect: write-mask is NULL Thu Feb 10 12:17:43 2005 NiISelect: TIMEOUT occured (1000ms) [DpProcDied] Process lives (PID:3084 HANDLE:808) waiting for termination of icman ... NiWait: sleep (1000ms) ... NiISelect: timeout 1000ms NiISelect: maximum fd=1049 NiISelect: read-mask is NULL NiISelect: write-mask is NULL Thu Feb 10 12:17:44 2005 NiISelect: TIMEOUT occured (1000ms) [DpProcDied] Process lives (PID:3084 HANDLE:808) waiting for termination of icman ... NiWait: sleep (1000ms) ... NiISelect: timeout 1000ms NiISelect: maximum fd=1049 NiISelect: read-mask is NULL NiISelect: write-mask is NULL Thu Feb 10 12:17:45 2005 NiISelect: TIMEOUT occured (1000ms) [DpProcDied] Process lives (PID:3084 HANDLE:808) waiting for termination of icman ... NiWait: sleep (1000ms) ... NiISelect: timeout 1000ms NiISelect: maximum fd=1049 NiISelect: read-mask is NULL NiISelect: write-mask is NULL Thu Feb 10 12:17:46 2005 NiISelect: TIMEOUT occured (1000ms) [DpProcDied] Process lives (PID:3084 HANDLE:808) waiting for termination of icman ... NiWait: sleep (1000ms) ... NiISelect: timeout 1000ms NiISelect: maximum fd=1049 NiISelect: read-mask is NULL NiISelect: write-mask is NULL Thu Feb 10 12:17:47 2005 NiISelect: TIMEOUT occured (1000ms) [DpProcDied] Process lives (PID:3084 HANDLE:808) waiting for termination of icman ... NiWait: sleep (1000ms) ... NiISelect: timeout 1000ms NiISelect: maximum fd=1049 NiISelect: read-mask is NULL NiISelect: write-mask is NULL Thu Feb 10 12:17:48 2005 NiISelect: TIMEOUT occured (1000ms) [DpProcDied] Process died (PID:3084 HANDLE:808) DpStartStopMsg: send stop message (myname is >FILSAPDR1_PRD_01 <) DpStartStopMsg: Write AD_STARTSTOP message with type= 0, name=FILSAPDR1_PRD_01 , sapsysnr= 1, hostname=FILSAPDR1 AdGetSelfIdentRecord: > < AdCvtRecToExt: opcode 60 (AD_SELFIDENT), ser 0, ex 0, errno 0 AdCvtRecToExt: opcode 4 (AD_STARTSTOP), ser 0, ex 0, errno 0 DpConvertRequest: net size = 189 bytes NiBufSend starting NiIWrite: hdl 2 sent data (wrt=562,pac=1,MESG_IO) MsINiWrite: sent 562 bytes send msg (len 110+452) to name -, type 4, key - DpStartStopMsg: stop msg sent NiIRead: hdl 2 received data (rcd=274,pac=1,MESG_IO) NiBufIIn: NIBUF len=274 NiBufIIn: packet complete for hdl 2 NiBufReceive starting MsINiRead: received 274 bytes MSG received, len 110+164, flag 1, from MSG_SERVER , typ 0, key - DpHalt: received 164 bytes from message server NiIRead: hdl 2 received data (rcd=274,pac=1,MESG_IO) NiBufIIn: NIBUF len=274 NiBufIIn: packet complete for hdl 2 NiBufReceive starting MsINiRead: received 274 bytes MSG received, len 110+164, flag 1, from MSG_SERVER , typ 0, key - DpHalt: received 164 bytes from message server NiIRead: hdl 2 received data (rcd=274,pac=1,MESG_IO) NiBufIIn: NIBUF len=274 NiBufIIn: packet complete for hdl 2 NiBufReceive starting MsINiRead: received 274 bytes MSG received, len 110+164, flag 1, from MSG_SERVER , typ 0, key - DpHalt: received 164 bytes from message server NiIRead: hdl 2 received data (rcd=274,pac=1,MESG_IO) NiBufIIn: NIBUF len=274 NiBufIIn: packet complete for hdl 2 NiBufReceive starting MsINiRead: received 274 bytes MSG received, len 110+164, flag 1, from MSG_SERVER , typ 0, key - DpHalt: received 164 bytes from message server NiIRead: hdl 2 received data (rcd=274,pac=1,MESG_IO) NiBufIIn: NIBUF len=274 NiBufIIn: packet complete for hdl 2 NiBufReceive starting MsINiRead: received 274 bytes MSG received, len 110+164, flag 1, from MSG_SERVER , typ 0, key - DpHalt: received 164 bytes from message server NiIRead: hdl 2 received data (rcd=274,pac=1,MESG_IO) NiBufIIn: NIBUF len=274 NiBufIIn: packet complete for hdl 2 NiBufReceive starting MsINiRead: received 274 bytes MSG received, len 110+164, flag 1, from MSG_SERVER , typ 0, key - DpHalt: received 164 bytes from message server NiIRead: hdl 2 recv would block (errno=EAGAIN) NiIRead: read for hdl 2 timed out (0ms) DpHalt: no more messages from the message server DpHalt: send keepalive to synchronize with the message server NiBufSend starting NiIWrite: hdl 2 sent data (wrt=114,pac=1,MESG_IO) MsINiWrite: sent 114 bytes send msg (len 110+4) to name MSG_SERVER, type 0, key - MsSndName: MS_NOOP ok Send 4 bytes to MSG_SERVER NiIRead: hdl 2 recv would block (errno=EAGAIN) NiIPeek: peek successful for hdl 2 (r) NiIRead: hdl 2 received data (rcd=114,pac=1,MESG_IO) NiBufIIn: NIBUF len=114 NiBufIIn: packet complete for hdl 2 NiBufReceive starting MsINiRead: received 114 bytes MSG received, len 110+4, flag 3, from MSG_SERVER , typ 0, key - Received 4 bytes from MSG_SERVER Received opcode MS_NOOP from msg_server, reply MSOP_OK MsOpReceive: ok MsSendKeepalive : keepalive sent to message server NiIRead: hdl 2 recv would block (errno=EAGAIN) Thu Feb 10 12:17:49 2005 NiIPeek: peek for hdl 2 timed out (r; 1000ms) NiIRead: read for hdl 2 timed out (1000ms) DpHalt: no more messages from the message server DpHalt: sync with message server o.k. detach from message server ***LOG Q0M=> DpMsDetach, ms_detach () [dpxxdisp.c 13218] NiBufSend starting NiIWrite: hdl 2 sent data (wrt=110,pac=1,MESG_IO) MsINiWrite: sent 110 bytes MsIDetach: send logout to msg_server MsIDetach: call exit function DpMsShutdownHook called NiBufISelUpdate: new MODE -- (r-) for hdl 2 in set0 SiSelNSet: set events of sock 776 to: --- NiBufISelRemove: remove hdl 2 from set0 SiSelNRemove: removed sock 776 (pos=2) SiSelNRemove: removed sock 776 NiSelIRemove: removed hdl 2 MBUF state OFF AdGetSelfIdentRecord: > < AdCvtRecToExt: opcode 60 (AD_SELFIDENT), ser 0, ex 0, errno 0 AdCvtRecToExt: opcode 40 (AD_MSBUF), ser 0, ex 0, errno 0 AdCvtRecToExt: opcode 40 (AD_MSBUF), ser 0, ex 0, errno 0 blks_in_queue/wp_ca_blk_no/wp_max_no = 1/300/14 LOCK WP ca_blk 1 make DISP owner of wp_ca_blk 1 DpSemRq: key: 2, units: 1, timeout: -1 DpSemRel: key: 2, units: 1 DpRqPutIntoQueue: put request into queue (reqtype 1, prio LOW, rq_id 15) MBUF component DOWN NiICloseHandle: shutdown and close hdl 2 / sock 776 NiBufIClose: clear extension for hdl 2 MsIDetach: detach MS-system cleanup EM EsCleanup .... EmCleanup() -> 0 Es2Cleanup: Cleanup ES2 ***LOG Q05=> DpHalt, DPStop ( 3948) [dpxxdisp.c 11392] Good Bye ..... And also here is the DEV_W0 trace file:- --------------------------------------------------- trc file: "dev_w0", trc level: 1, release: "701" --------------------------------------------------- * * ACTIVE TRACE LEVEL 1 * ACTIVE TRACE COMPONENTS all, MJ * M sysno 01 M sid PRD M systemid 562 (PC with Windows NT) M relno 7010 M patchlevel 0 M patchno 194 M intno 20020600 M make: multithreaded, Unicode, 64 bit, optimized M pid 2840 M M kernel runs with dp version 246000(ext=110000) (@(#) DPLIB-INT-VERSION-246000-UC) M length of sys_adm_ext is 576 bytes M ***LOG Q0Q=> tskh_init, WPStart (Workproc 0 2840) [dpxxdisp.c 1423] 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) 24528 (1752) M DpShMCreate: sizeof(tm_adm) 5912704 (29416) M DpShMCreate: sizeof(wp_ca_adm) 24064 (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: 000000000AA00050, size: 6609024) M DpShMCreate: allocated sys_adm at 000000000AA00050 M DpShMCreate: allocated wp_adm at 000000000AA022A0 M DpShMCreate: allocated tm_adm_list at 000000000AA08270 M DpShMCreate: allocated tm_adm at 000000000AA082D0 M DpShMCreate: allocated wp_ca_adm at 000000000AFABB50 M DpShMCreate: allocated appc_ca_adm at 000000000AFB1950 M DpShMCreate: allocated comm_adm at 000000000AFB3890 M DpShMCreate: system runs without slock table M DpShMCreate: system runs without file table M DpShMCreate: allocated vmc_adm_list at 000000000B03A520 M DpShMCreate: allocated gw_adm at 000000000B03A5A0 M DpShMCreate: system runs without vmc_adm M DpShMCreate: allocated ca_info at 000000000B03A5D0 M DpShMCreate: allocated wall_adm at 000000000B03A640 M DpRqQInit: Parameter rdisp/queue_lock_level = 2 M rdisp/queue_size_check_value : -> on,50,30,40,500,50,500,80 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 <ES> EsILock: use spinlock for locking X Using implementation view X <EsNT> Using memory model view. M <EsNT> Memory Reset disabled as NT default X ES initialized. X mm.dump: set maximum dump mem to 96 MB M ThStart: taskhandler started M ThInit: initializing DIA work process W0 M ThInit: rdisp/cleanup_after_crash = 1 M ThInit: running on host FILSAPDR1 M calling db_connect ... B Loading DB library 'D:\usr\sap\PRD\DVEBMGS01\exe\dbmssslib.dll' ... B Library 'D:\usr\sap\PRD\DVEBMGS01\exe\dbmssslib.dll' loaded B Version of 'D:\usr\sap\PRD\DVEBMGS01\exe\dbmssslib.dll' is "700.08", patchlevel (0.194) C Callback functions for dynamic profile parameter registered C Profile parameter SWITCH dbs/mss/dbsl_profile=1 C dbsl profile written to dbsl_w0 C Thread ID:3156 C Thank You for using the SLODBC-interface C Using dynamic link library 'D:\usr\sap\PRD\DVEBMGS01\exe\dbmssslib.dll' C dbmssslib.dll patch info C SAP patchlevel 0 C SAP patchno 194 C Last MSSQL DBSL patchlevel 0 C Last MSSQL DBSL patchno 194 C Last MSSQL DBSL patchcomment Work process can not be cancelled (1740162) C lpc:(local) connection used on FILSAPDR1 C ERROR: -1 in function ExecuteAndFlush (SQLExecDirect) [line 5520] C (15157) [42000] [Microsoft][SQL Server Native Client 10.0][SQL Server]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 <if user_name() != 'prd' setuser 'prd'> failed -- connect terminated B ***LOG BY2=> sql error 15157 performing CON [dbsh#2 @ 1208] [dbsh 1208 ] 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 @ 1208] [dbsh 1208 ] B ***LOG BY2=> sql error 15157 performing CON [dblink#4 @ 433] [dblink 0433 ] 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#4 @ 433] [dblink 0433 ] M ***LOG R19=> ThInit, db_connect ( DB-Connect 000256) [thxxhead.c 1503] M in_ThErrHandle: 1 M *** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c 10806] M M Info for wp 0 M M pid = 2840 M severity = 0 M status = 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 * M * LOCATION SAP-Server FILSAPDR1_PRD_01 on host FILSAPDR1 (wp 0) M * ERROR ThInit: db_connect M * M * TIME Thu Feb 10 08:39:04 2005 M * RELEASE 701 M * COMPONENT Taskhandler M * VERSION 1 M * RC 13 M * MODULE thxxhead.c M * LINE 11075 M * COUNTER 1 M * M ***************************************************************************** M M PfStatDisconnect: disconnect statistics M Entering TH_CALLHOOKS M ThCallHooks: call hook >BtcCallLgCl< for event BEFORE_DUMP M ThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP M *** ERROR => ThrSaveSPAFields: no valid thr_wpadm [thxxrun1.c 796] M *** ERROR => ThCallHooks: event handler ThrSaveSPAFields for event BEFORE_DUMP failed [thxxtool3.c 262] 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 2840) [dpnttool.c 334] Your Immediate Help will be highly appreciable. Best Regards, Tapas | Reply to this email to post your response. __.____._ | _.____.__ |