on 12-04-2007 1:59 PM
Dear People,
I have successfully upgraded sql from 2000 to 2005 and im doing the post processing steps for upgrade using the sql tool and im getting error at the step " creare sap stored procedure" .im pasting the error messages below.
<b>dev_w0</b>
RROR: schema user dcb has administrator fixed server role (user_name() is 'dbo').
C This is not allowed. Please check the Server Roles of user dcb.
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
sapinst_dev.log<b></b>
ERROR 2007-12-04 10:54:48.62 [iaxxgenimp.cpp:731]
showDialog()
FCO-00011 The step ExeProcs with step key |SAPMSSTOOLS|ind|ind|ind|ind|0|0|MssSysCopy|ind|ind|ind|ind|4|0|MssProcs|ind|ind|ind|ind|4|0|ExeProcs was executed with status ERROR .
ERROR 2007-12-04 10:54:48.62
lib=iamodmssql module=CIaNtMssDmo
MDB-05053 Errors when executing sql command: [Microsoft][ODBC SQL Server Driver][SQL Server]SELECT permission denied on object 'MSSSOURCE', database 'DCB', schema 'dcb'.
<p> SOLUTION: If this message is displayed as a warning, you can ignore it. If this is an error, contact SAP support.</p>
regards
raj
Hi raj,
The SQL Server upgrade must have (in some ways) changed the user profile of the schema user.
I saw the following text in your post:
<i>dev_w0 RROR: schema user dcb has administrator fixed server role (user_name() is 'dbo'). C This is not allowed. Please check the Server Roles of user dcb. </i>
Please check the following SAP Note and set your schema user role accordingly.
Note 592514 - MSSQL: internal database users, permissions and security
Regards,
Siddhesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Siddesh,
Thank you for the input, it is little bit helpful,but it did not resolve my problem,following by the note ..there is not dcb=sid user in my tempdb.
and the dcb is existing in all other databases and all database and server roles are there as per note...any help
I now remember that when im upgrading i have come across a screen where i need to pick up the service user, there i guess i did not pick up SAPServiceSID, i have just used default,windows login. does this have any relation with this particular error
points awarded...
regarads
raj
hi siddesh,
i also get the following errors in sql,this could be the main reason
1.Msg 15157, Level 16, State 1, Line 1
Setuser failed because of one of the following reasons: the database principal 'dcb' 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.
Msg 229, Level 14, State 5, Procedure sap_droproc, Line 56
SELECT permission denied on object 'sysobjects', database 'mssqlsystemresource', schema 'sys'.
Msg 229, Level 14, State 5, Procedure sap_droproc, Line 60
SELECT permission denied on object 'sysobjects', database 'mssqlsystemresource', schema 'sys'.
Msg 208, Level 16, State 0, Procedure sap_droproc, Line 65
Invalid object name '#allnames
-
trc file: "dev_disp", trc level: 1, release: "700"
-
sysno 00
sid DCB
systemid 560 (PC with Windows NT)
relno 7000
patchlevel 0
patchno 111
intno 20050900
make: multithreaded, ASCII, optimized
pid 3236
Wed Dec 05 12:07:00 2007
kernel runs with dp version 229(ext=109) (@(#) DPLIB-INT-VERSION-229)
length of sys_adm_ext is 364 bytes
SWITCH TRC-HIDE on ***
***LOG Q00=> DpSapEnvInit, DPStart (00 3236) [dpxxdisp.c 1239]
shared lib "dw_xml.dll" version 111 successfully loaded
shared lib "dw_xtc.dll" version 111 successfully loaded
shared lib "dw_stl.dll" version 111 successfully loaded
shared lib "dw_gui.dll" version 111 successfully loaded
shared lib "dw_mdm.dll" version 111 successfully loaded
rdisp/softcancel_sequence : -> 0,5,-1
use internal message server connection to port 3900
Wed Dec 05 12:07:04 2007
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 5361]
MtxInit: 30000 0 0
DpSysAdmExtInit: ABAP is active
DpSysAdmExtInit: VMC (JAVA VM in WP) is not active
DpIPCInit2: start server >voyager_DCB_00 <
DpShMCreate: sizeof(wp_adm) 11808 (908)
DpShMCreate: sizeof(tm_adm) 3605136 (17936)
DpShMCreate: sizeof(wp_ca_adm) 18000 (60)
DpShMCreate: sizeof(appc_ca_adm) 6000 (60)
DpCommTableSize: max/headSize/ftSize/tableSize=500/8/528040/528048
DpShMCreate: sizeof(comm_adm) 528048 (1048)
DpSlockTableSize: max/headSize/ftSize/fiSize/tableSize=0/0/0/0/0
DpShMCreate: sizeof(slock_adm) 0 (96)
DpFileTableSize: max/headSize/ftSize/tableSize=0/0/0/0
DpShMCreate: sizeof(file_adm) 0 (72)
DpShMCreate: sizeof(vmc_adm) 0 (1296)
DpShMCreate: sizeof(wall_adm) (22440/34344/56/100)
DpShMCreate: sizeof(gw_adm) 48
DpShMCreate: SHM_DP_ADM_KEY (addr: 05CB0040, size: 4232896)
DpShMCreate: allocated sys_adm at 05CB0040
DpShMCreate: allocated wp_adm at 05CB1B30
DpShMCreate: allocated tm_adm_list at 05CB4950
DpShMCreate: allocated tm_adm at 05CB4980
DpShMCreate: allocated wp_ca_adm at 06024C10
DpShMCreate: allocated appc_ca_adm at 06029260
DpShMCreate: allocated comm_adm at 0602A9D0
DpShMCreate: system runs without slock table
DpShMCreate: system runs without file table
DpShMCreate: allocated vmc_adm_list at 060AB880
DpShMCreate: allocated gw_adm at 060AB8C0
DpShMCreate: system runs without vmc_adm
DpShMCreate: allocated ca_info at 060AB8F0
DpShMCreate: allocated wall_adm at 060AB8F8
Wed Dec 05 12:07:05 2007
MBUF state OFF
DpCommInitTable: init table for 500 entries
EmInit: MmSetImplementation( 2 ).
MM global diagnostic options set: 0
<ES> client 0 initializing ....
<ES> InitFreeList
<ES> block size is 1024 kByte.
Using implementation view
<EsNT> Using memory model view.
<EsNT> Memory Reset disabled as NT default
<ES> 511 blocks reserved for free list.
ES initialized.
rdisp/http_min_wait_dia_wp : 1 -> 1
***LOG Q0K=> DpMsAttach, mscon ( voyager) [dpxxdisp.c 11753]
DpStartStopMsg: send start message (myname is >voyager_DCB_00 <)
DpStartStopMsg: start msg sent
CCMS: AlInitGlobals : alert/use_sema_lock = TRUE.
CCMS: Initalizing shared memory of size 40000000 for monitoring segment.
CCMS: start to initalize 3.X shared alert area (first segment).
DpMsgAdmin: Set release to 7000, patchlevel 0
MBUF state PREPARED
MBUF component UP
DpMBufHwIdSet: set Hardware-ID
***LOG Q1C=> DpMBufHwIdSet [dpxxmbuf.c 1050]
DpMsgAdmin: Set patchno for this platform to 111
Release check o.K.
Wed Dec 05 12:07:45 2007
ERROR => W0 (pid 2840) died [dpxxdisp.c 14441]
ERROR => W1 (pid 2844) died [dpxxdisp.c 14441]
ERROR => W2 (pid 1904) died [dpxxdisp.c 14441]
ERROR => W3 (pid 3308) died [dpxxdisp.c 14441]
ERROR => W4 (pid 4056) died [dpxxdisp.c 14441]
ERROR => W5 (pid 4088) died [dpxxdisp.c 14441]
my types changed after wp death/restart 0xbf --> 0xbe
ERROR => W6 (pid 1244) died [dpxxdisp.c 14441]
my types changed after wp death/restart 0xbe --> 0xbc
ERROR => W7 (pid 2888) died [dpxxdisp.c 14441]
my types changed after wp death/restart 0xbc --> 0xb8
ERROR => W8 (pid 2932) died [dpxxdisp.c 14441]
ERROR => W9 (pid 2892) died [dpxxdisp.c 14441]
ERROR => W10 (pid 3116) died [dpxxdisp.c 14441]
my types changed after wp death/restart 0xb8 --> 0xb0
ERROR => W11 (pid 2096) died [dpxxdisp.c 14441]
my types changed after wp death/restart 0xb0 --> 0xa0
ERROR => W12 (pid 2480) died [dpxxdisp.c 14441]
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=1637
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Wed Dec 05 12:07:55 2007
NiISelect: TIMEOUT occured (10000ms)
dump system status
Workprocess Table (long) Wed Dec 05 12:07:55 2007
========================
No Ty. Pid Status Cause Start Err Sem CPU Time Program Cl User Action Table
-
0 DIA 2840 Ended no 1 0 0
1 DIA 2844 Ended no 1 0 0
2 DIA 1904 Ended no 1 0 0
3 DIA 3308 Ended no 1 0 0
4 DIA 4056 Ended no 1 0 0
5 DIA 4088 Ended no 1 0 0
6 UPD 1244 Ended no 1 0 0
7 ENQ 2888 Ended no 1 0 0
8 BTC 2932 Ended no 1 0 0
9 BTC 2892 Ended no 1 0 0
10 BTC 3116 Ended no 1 0 0
11 SPO 2096 Ended no 1 0 0
12 UP2 2480 Ended no 1 0 0
Dispatcher Queue Statistics Wed Dec 05 12:07:55 2007
===========================
--------
+
Typ | now | high | max | writes | reads |
--------
+
NOWP | 0 | 2 | 2000 | 6 | 6 |
--------
+
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 7 ( 87%), shm 1 ( 12%)
since last update total 8, udp 7 ( 87%), shm 1 ( 12%)
Dump of tm_adm structure: Wed Dec 05 12:07:55 2007
=========================
Term uid man user term lastop mod wp ta a/i (modes)
Workprocess Comm. Area Blocks Wed Dec 05 12:07:55 2007
=============================
Slots: 300, Used: 1, Max: 0
--------
+
id | owner | pid | eyecatcher |
--------
+
0 | DISPATCHER | -1 | WPCAAD000 |
NiWait: sleep (5000ms) ...
NiISelect: timeout 5000ms
NiISelect: maximum fd=1637
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Wed Dec 05 12:08:00 2007
NiISelect: TIMEOUT occured (5000ms)
DpHalt: shutdown server >voyager_DCB_00 < (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 (1680) (SOFT_KILL)
Stop icman
killing process (2612) (SOFT_KILL)
Terminate gui connections
wait for end of work processes
wait for end of gateway
[DpProcDied] Process lives (PID:1680 HANDLE:1608)
waiting for termination of gateway ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=1637
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Wed Dec 05 12:08:01 2007
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process died (PID:1680 HANDLE:1608)
wait for end of icman
[DpProcDied] Process lives (PID:2612 HANDLE:1612)
waiting for termination of icman ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=1637
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Wed Dec 05 12:08:02 2007
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process lives (PID:2612 HANDLE:1612)
waiting for termination of icman ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=1637
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Wed Dec 05 12:08:03 2007
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process lives (PID:2612 HANDLE:1612)
waiting for termination of icman ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=1637
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Wed Dec 05 12:08:04 2007
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process lives (PID:2612 HANDLE:1612)
waiting for termination of icman ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=1637
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Wed Dec 05 12:08:05 2007
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process lives (PID:2612 HANDLE:1612)
waiting for termination of icman ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=1637
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Wed Dec 05 12:08:06 2007
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process lives (PID:2612 HANDLE:1612)
waiting for termination of icman ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=1637
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Wed Dec 05 12:08:07 2007
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process lives (PID:2612 HANDLE:1612)
waiting for termination of icman ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=1637
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Wed Dec 05 12:08:08 2007
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process lives (PID:2612 HANDLE:1612)
waiting for termination of icman ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=1637
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Wed Dec 05 12:08:09 2007
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process lives (PID:2612 HANDLE:1612)
waiting for termination of icman ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=1637
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Wed Dec 05 12:08:10 2007
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process lives (PID:2612 HANDLE:1612)
waiting for termination of icman ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=1637
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Wed Dec 05 12:08:11 2007
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process lives (PID:2612 HANDLE:1612)
waiting for termination of icman ...
NiWait: sleep (1000ms) ...
NiISelect: timeout 1000ms
NiISelect: maximum fd=1637
NiISelect: read-mask is NULL
NiISelect: write-mask is NULL
Wed Dec 05 12:08:12 2007
NiISelect: TIMEOUT occured (1000ms)
[DpProcDied] Process died (PID:2612 HANDLE:1612)
DpStartStopMsg: send stop message (myname is >voyager_DCB_00 <)
NiIMyHostName: hostname = 'voyager'
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 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 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)
Wed Dec 05 12:08:13 2007
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 12099]
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 1548 to: ---
NiBufISelRemove: remove hdl 2 from set0
SiSelNRemove: removed sock 1548 (pos=2)
SiSelNRemove: removed sock 1548
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/13
LOCK WP ca_blk 1
make DISP owner of wp_ca_blk 1
DpRqPutIntoQueue: put request into queue (reqtype 1, prio LOW, rq_id 15)
MBUF component DOWN
NiICloseHandle: shutdown and close hdl 2 / sock 1548
NiBufIClose: clear extension for hdl 2
MsIDetach: detach MS-system
cleanup EM
EsCleanup ....
EmCleanup() -> 0
Es2Cleanup: Cleanup ES2
***LOG Q05=> DpHalt, DPStop ( 3236) [dpxxdisp.c 10371]
Good Bye .....
Hi Siddesh,
below is the dev_w0
-
trc file: "dev_w0", trc level: 1, release: "700"
-
*
ACTIVE TRACE LEVEL 1
ACTIVE TRACE COMPONENTS all, MJ
*
B
B Wed Dec 05 17:04:40 2007
B create_con (con_name=R/3)
B Loading DB library 'F:\usr\sap\DCB\DVEBMGS00\exe\dbmssslib.dll' ...
B Library 'F:\usr\sap\DCB\DVEBMGS00\exe\dbmssslib.dll' loaded
B Version of 'F:\usr\sap\DCB\DVEBMGS00\exe\dbmssslib.dll' is "700.08", patchlevel (0.109)
B New connection 0 created
M sysno 00
M sid DCB
M systemid 560 (PC with Windows NT)
M relno 7000
M patchlevel 0
M patchno 111
M intno 20050900
M make: multithreaded, ASCII, optimized
M pid 2716
M
M kernel runs with dp version 229(ext=109) (@(#) DPLIB-INT-VERSION-229)
M length of sys_adm_ext is 364 bytes
M ***LOG Q0Q=> tskh_init, WPStart (Workproc 0 2716) [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) 14528 (908)
M DpShMCreate: sizeof(tm_adm) 3605136 (17936)
M DpShMCreate: sizeof(wp_ca_adm) 18000 (60)
M DpShMCreate: sizeof(appc_ca_adm) 6000 (60)
M DpCommTableSize: max/headSize/ftSize/tableSize=500/8/528040/528048
M DpShMCreate: sizeof(comm_adm) 528048 (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 (1296)
M DpShMCreate: sizeof(wall_adm) (22440/34344/56/100)
M DpShMCreate: sizeof(gw_adm) 48
M DpShMCreate: SHM_DP_ADM_KEY (addr: 064B0040, size: 4235616)
M DpShMCreate: allocated sys_adm at 064B0040
M DpShMCreate: allocated wp_adm at 064B1B30
M DpShMCreate: allocated tm_adm_list at 064B53F0
M DpShMCreate: allocated tm_adm at 064B5420
M DpShMCreate: allocated wp_ca_adm at 068256B0
M DpShMCreate: allocated appc_ca_adm at 06829D00
M DpShMCreate: allocated comm_adm at 0682B470
M DpShMCreate: system runs without slock table
M DpShMCreate: system runs without file table
M DpShMCreate: allocated vmc_adm_list at 068AC320
M DpShMCreate: allocated gw_adm at 068AC360
M DpShMCreate: system runs without vmc_adm
M DpShMCreate: allocated ca_info at 068AC390
M DpShMCreate: allocated wall_adm at 068AC398
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 Wed Dec 05 17:04:41 2007
M ThInit: running on host voyager
M
M Wed Dec 05 17:04:42 2007
M calling db_connect ...
C Thread ID:3924
C Thank You for using the SLOLEDB-interface
C Using dynamic link library 'F:\usr\sap\DCB\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 VOYAGER
C CopyLocalParameters: dbuser is 'dcb'
C Using Provider SQLNCLI
C OpenOledbConnection: MARS property was set successfully.
C Provider Release:9.00.3042.00
C Using Provider SQLNCLI
C OpenOledbConnection: MARS property was set successfully.
C CheckCodepageType: line 24375. hr: 0x80040e09 SELECT permission denied on object 'DBPROPERTIES', database 'DCB', schema 'dcb'.
C sloledb.cpp [CheckCodepageType,line 24375]: Error/Message: (err 229, sev 0), SELECT permission denied on object 'DBPROPERTIES', database 'DCB', schema 'dcb'.
C Procname: [CheckCodepageType -- no proc]
C Cache sizes: header 52 bytes, 20000 names (26880000 bytes), 500 dynamic statements (2728000 bytes), total 29608052 bytes
C Using shared procedure name cache VOYAGER_DCBDCB_DCB_MEM initialized by another process.
C PnSetup: line 330. hr: 0x80040e09 SELECT permission denied on object 'objects', database 'mssqlsystemresource', schema 'sys'.
C sloledb.cpp [PnSetup,line 330]: Error/Message: (err 229, sev 0), SELECT permission denied on object 'objects', database 'mssqlsystemresource', schema 'sys'.
C Procname: [PnSetup - no proc]
C Connected to db server : [VOYAGER] server_used : [np:(local)], dbname: DCB, dbuser: dcb
C pn_id:VOYAGER_DCBDCB_DCB
C Using MARS (on sql 9.0)
B Connection 0 opened (DBSL handle 0)
B Wp Hdl ConName ConId ConState TX PRM RCT TIM MAX OPT Date Time DBHost
B 000 000 R/3 000000000 ACTIVE NO YES NO 000 255 255 20071205 170442 VOYAGER
C The IRow interface is supported by this OLEDB provider
C ParamStmtExec: line 13027. hr: 0x80040e09 SELECT permission denied on object 'SVERS', database 'DCB', schema 'dcb'.
C sloledb.cpp [ParamStmtExec,line 13027]: Error/Message: (err 229, sev 0), SELECT permission denied on object 'SVERS', database 'DCB', schema 'dcb'.
C Procname: [##Y4VOYAGERdcb00000022000000000001170442]
C ParamStmtExec failed. HR 80040e09 DBSL retcode 99. stmt: [SELECT TOP 1 VERSION FROM SVERS ]
C Conn_i:1 selection:1 singleton:1 flag_fupd:0 use_cursor:0 chksum: 1112156
C DbSlRead - Error 99 (dbcode 229) on open
C DbSlRead - <##Y4VOYAGERdcb00000022000000000001170442>
C DbSlRead - Error 99 (dbcode 229) on fetch
C DbSlRead - <##Y4VOYAGERdcb00000022000000000001170442>
B ***LOG BZA=> table SVERS does not exist on database [dblink#3 @ 1299] [dblink 1299 ]
M ***LOG R19=> ThInit, db_connect ( DB-Connect 004096) [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 voyager_DCB_00 on host voyager (wp 0)
M * ERROR ThInit: db_connect
M *
M * TIME Wed Dec 05 17:04:42 2007
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 2716) [dpnttool.c 327]
regards
raj
Attach the trace file and our conversation in the OSS Message and ask them if its safe to apply the SAP Note I gave u and see what they say.
Your developer trace has the error message the note is pretty straightforward but I can understand your tension, better ask SAP and take a backup first always, good luck !
Regards,
Siddhesh
User | Count |
---|---|
91 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.