on 12-10-2010 6:46 PM
hello all, we have SAP 4.7 SR 200 with SQL 2005 server on windows 2003 server. we did a homogenious system copy successfully and after that we restored the database using sql database restore method. Now we are not able to start SAP DISP+WORK.EXE specifically.
I run command R3TRANS.EXE and it get me below output
C:\Documents and Settings\<sid>adm>cd C:\usr\sap\<SID>\SYS\exe\run
C:\usr\sap\<SID>\SYS\exe\run>r3trans -d
This is r3trans version 6.09 (release 640 - 28.04.04 - 16:14:00).
2EETW169 no connect possible: "DBMS = MSSQL --- SERV
ER = 'sap<sid>\<SID>' DBNAME = '<SID>'"
r3trans finished (0012).
i attached log for trans.log below
4 ETW000 r3trans version 6.09 (release 640 - 28.04.04 - 16:14:00).
4 ETW000 ===============================================
4 ETW000
4 ETW000 date&time : 10.12.2010 - 13:32:34
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 Dec 10 13:32:36 2010 0.000000
4 ETW000 [dev trc ,00000] db_con_init called 0.000000
4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 0.000000
4 ETW000 [dev trc ,00000] Loading DB library 'dbmssslib.dll' ... 0.000000
4 ETW000 [dev trc ,00000] load shared library (dbmssslib.dll), hdl 0 1240 0.001240
4 ETW000 [dev trc ,00000] using "C:\usr\sap\<SID>\SYS\exe\run\dbmssslib.dll"
4 ETW000 14 0.001254
4 ETW000 [dev trc ,00000] Library 'dbmssslib.dll' loaded 6 0.001260
4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library dbmssslib.dll
4 ETW000 11 0.001271
4 ETW000 [dev trc ,00000] Version of 'dbmssslib.dll' is "640.00", patchlevel (0.26)
4 ETW000 106 0.001377
4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library dbmssslib.dll
4 ETW000 11 0.001388
4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library dbmssslib.dll
4 ETW000 17 0.001405
4 ETW000 [dev trc ,00000] New connection 0 created 40 0.001445
4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = -000000001 state = DISCONNECTED, perm = YES, reco = NO , con_max = 255, con_opt = 255, occ = NO
4 ETW000 14 0.001459
4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 43 0.001502
4 ETW000 [dev trc ,00000] find_con_by_name found the following connection for reuse:
4 ETW000 11 0.001513
4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = 000000000 state = DISCONNECTED, perm = YES, reco = NO , con_max = 255, con_opt = 255, occ = NO
4 ETW000 12 0.001525
4 ETW000 [dev trc ,00000] Thank You for using the SLOLEDB-interface 1370 0.002895
4 ETW000 [dev trc ,00000] Using dynamic link library 'C:\usr\sap\<SID>\SYS\exe\run\dbmssslib.dll'
4 ETW000 18 0.002913
4 ETW000 [dev trc ,00000] dbmssslib.dll patch info 9 0.002922
4 ETW000 [dev trc ,00000] patchlevel 0 5 0.002927
4 ETW000 [dev trc ,00000] patchno 26 6 0.002933
4 ETW000 [dev trc ,00000] patchcomment MSSQL: GetNextMsst1 error (754819)
4 ETW000 9 0.002942
4 ETW000 [dev trc ,00000] Local connection used on SAP<SID> to named instance: np:sap<sid>\<SID>
4 ETW000 92 0.003034
4 ETW000 [dev trc ,00000] Using Provider SQLNCLI 13750 0.016784
4 ETW000 [dev trc ,00000] ExecuteAndFlush return code: 0x80040e14 Stmt: [if user_name() != '<sid>' setuser '<sid>']
4 ETW000 73087 0.089871
4 ETW000 [dev trc ,00000] ExecuteAndFlush: line 5658. hr: 0x80040e14 Setuser failed because of one of the following reasons: the database principal '<sid>' 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 117 0.089988
4 ETW000 [dev trc ,00000] sloledb.cpp [ExecuteAndFlush,line 5658]: Error/Message: (err 15157, sev 0), Setuser failed because of one of the following reasons: the database principal '<sid>' 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 39 0.090027
4 ETW000 [dev trc ,00000] Procname: [ExecuteAndFlush - no proc] 6 0.090033
4 ETW000 [dev trc ,00000] setuser '<sid>' failed -- connect terminated 37 0.090070
4 ETW000 [dev trc ,00000] Using Provider SQLNCLI 2461 0.092531
4 ETW000 [dev trc ,00000] ExecuteAndFlush return code: 0x80040e14 Stmt: [if user_name() != '<sid>' setuser '<sid>']
4 ETW000 4318 0.096849
4 ETW000 [dev trc ,00000] ExecuteAndFlush: line 5658. hr: 0x80040e14 Setuser failed because of one of the following reasons: the database principal '<sid>' 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 25 0.096874
4 ETW000 [dev trc ,00000] sloledb.cpp [ExecuteAndFlush,line 5658]: Error/Message: (err 15157, sev 0), Setuser failed because of one of the following reasons: the database principal '<sid>' 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 27 0.096901
4 ETW000 [dev trc ,00000] Procname: [ExecuteAndFlush - no proc] 6 0.096907
4 ETW000 [dev trc ,00000] setuser '<sid>' failed -- connect terminated 9 0.096916
4 ETW000 [dev trc ,00000] Using Provider SQLNCLI 11599 0.108515
4 ETW000 [dev trc ,00000] ExecuteAndFlush return code: 0x80040e14 Stmt: [if user_name() != '<sid>' setuser '<sid>']
4 ETW000 4996 0.113511
4 ETW000 [dev trc ,00000] ExecuteAndFlush: line 5658. hr: 0x80040e14 Setuser failed because of one of the following reasons: the database principal '<sid>' 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 26 0.113537
4 ETW000 [dev trc ,00000] sloledb.cpp [ExecuteAndFlush,line 5658]: Error/Message: (err 15157, sev 0), Setuser failed because of one of the following reasons: the database principal '<sid>' 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 28 0.113565
4 ETW000 [dev trc ,00000] Procname: [ExecuteAndFlush - no proc] 6 0.113571
4 ETW000 [dev trc ,00000] setuser '<sid>' failed -- connect terminated 10 0.113581
4 ETW000 [dev trc ,00000] failed to establish conn to np:sap<sid>\<SID>. 10253 0.123834
4 ETW000 [dev trc ,00000] Retrying without protocol specifier: sap<sid>\<SID> 12 0.123846
4 ETW000 [dev trc ,00000] Using Provider SQLNCLI 31 0.123877
4 ETW000 [dev trc ,00000] ExecuteAndFlush return code: 0x80040e14 Stmt: [if user_name() != '<sid>' setuser '<sid>']
4 ETW000 4569 0.128446
4 ETW000 [dev trc ,00000] ExecuteAndFlush: line 5658. hr: 0x80040e14 Setuser failed because of one of the following reasons: the database principal '<sid>' 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 25 0.128471
4 ETW000 [dev trc ,00000] sloledb.cpp [ExecuteAndFlush,line 5658]: Error/Message: (err 15157, sev 0), Setuser failed because of one of the following reasons: the database principal '<sid>' 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 26 0.128497
4 ETW000 [dev trc ,00000] Procname: [ExecuteAndFlush - no proc] 6 0.128503
4 ETW000 [dev trc ,00000] setuser '<sid>' failed -- connect terminated 9 0.128512
4 ETW000 [dev trc ,00000] Using Provider SQLNCLI 10981 0.139493
4 ETW000 [dev trc ,00000] ExecuteAndFlush return code: 0x80040e14 Stmt: [if user_name() != '<sid>' setuser '<sid>']
4 ETW000 4311 0.143804
4 ETW000 [dev trc ,00000] ExecuteAndFlush: line 5658. hr: 0x80040e14 Setuser failed because of one of the following reasons: the database principal '<sid>' 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 25 0.143829
4 ETW000 [dev trc ,00000] sloledb.cpp [ExecuteAndFlush,line 5658]: Error/Message: (err 15157, sev 0), Setuser failed because of one of the following reasons: the database principal '<sid>' 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 27 0.143856
4 ETW000 [dev trc ,00000] Procname: [ExecuteAndFlush - no proc] 6 0.143862
4 ETW000 [dev trc ,00000] setuser '<sid>' failed -- connect terminated 9 0.143871
4 ETW000 [dev trc ,00000] Using Provider SQLNCLI 11093 0.154964
4 ETW000 [dev trc ,00000] ExecuteAndFlush return code: 0x80040e14 Stmt: [if user_name() != '<sid>' setuser '<sid>']
4 ETW000 4552 0.159516
4 ETW000 [dev trc ,00000] ExecuteAndFlush: line 5658. hr: 0x80040e14 Setuser failed because of one of the following reasons: the database principal '<sid>' 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 26 0.159542
4 ETW000 [dev trc ,00000] sloledb.cpp [ExecuteAndFlush,line 5658]: Error/Message: (err 15157, sev 0), Setuser failed because of one of the following reasons: the database principal '<sid>' 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 28 0.159570
4 ETW000 [dev trc ,00000] Procname: [ExecuteAndFlush - no proc] 6 0.159576
4 ETW000 [dev trc ,00000] setuser '<sid>' failed -- connect terminated 35 0.159611
4 ETW000 [dev trc ,00000] failed to establish conn. 0 11116 0.170727
4 ETW000 [dblink ,00419] ***LOG BY2=>sql error 0 performing CON [dblink#1 @ 419]
4 ETW000 1284 0.172011
4 ETW000 [dblink ,00419] ***LOG BY0=><message text not available> [dblink#1 @ 419]
4 ETW000 22 0.172033
2EETW169 no connect possible: "DBMS = MSSQL --- SERVER = 'sap<sid>\<SID>' DBNAME = '<SID>'"
below is the dev_w0 log
-
trc file: "dev_w0", trc level: 1, release: "640"
-
*
ACTIVE TRACE LEVEL 1
ACTIVE TRACE COMPONENTS all, M
*
B
B Fri Dec 10 13:14:42 2010
B create_con (con_name=R/3)
B Loading DB library 'C:\usr\sap\<SID>\SYS\exe\run\dbmssslib.dll' ...
B Library 'C:\usr\sap\<SID>\SYS\exe\run\dbmssslib.dll' loaded
B Version of 'C:\usr\sap\<SID>\SYS\exe\run\dbmssslib.dll' is "640.00", patchlevel (0.26)
B New connection 0 created
M systemid 560 (PC with Windows NT)
M relno 6400
M patchlevel 0
M patchno 25
M intno 20020600
M make: multithreaded, ASCII
M pid 2548
M
M ***LOG Q0Q=> tskh_init, WPStart (Workproc 0 2548) [dpxxdisp.c 1160]
I MtxInit: -2 0 0
M DpSysAdmExtCreate: ABAP is active
M DpSysAdmExtCreate: JAVA is not active
M DpShMCreate: sizeof(wp_adm) 6624 (828)
M DpShMCreate: sizeof(tm_adm) 2219848 (11044)
M DpShMCreate: sizeof(wp_ca_adm) 18000 (60)
M DpShMCreate: sizeof(appc_ca_adm) 6000 (60)
M DpShMCreate: sizeof(comm_adm) 192000 (384)
M DpShMCreate: sizeof(vmc_adm) 0 (320)
M DpShMCreate: sizeof(wall_adm) (22440/34344/56/100)
M DpShMCreate: SHM_DP_ADM_KEY (addr: 05A00040, size: 2505416)
M DpShMCreate: allocated sys_adm at 05A00040
M DpShMCreate: allocated wp_adm at 05A017A8
M DpShMCreate: allocated tm_adm_list at 05A03188
M DpShMCreate: allocated tm_adm at 05A031B0
M DpShMCreate: allocated wp_ca_adm at 05C210F8
M DpShMCreate: allocated appc_ca_adm at 05C25748
M DpShMCreate: allocated comm_adm_list at 05C26EB8
M DpShMCreate: allocated comm_adm at 05C26ED0
M DpShMCreate: allocated vmc_adm_list at 05C55CD0
M DpShMCreate: system runs without vmc_adm
M DpShMCreate: allocated ca_info at 05C55CF8
M DpShMCreate: allocated wall_adm at 05C55D00
X EmInit: MmSetImplementation( 2 ).
X <ES> client 0 initializing ....
X Using implementation std
M <EsNT> Memory Reset enabled as NT default
X ES initialized.
M
M Fri Dec 10 13:14:43 2010
M calling db_connect ...
C Thank You for using the SLOLEDB-interface
C Using dynamic link library 'C:\usr\sap\<SID>\SYS\exe\run\dbmssslib.dll'
C dbmssslib.dll patch info
C patchlevel 0
C patchno 26
C patchcomment MSSQL: GetNextMsst1 error (754819)
C Local connection used on SAP<SID> to named instance: np:sap<sid>\<SID>
C Using Provider SQLNCLI
C ExecuteAndFlush return code: 0x80040e14 Stmt: [if user_name() != '<sid>' setuser '<sid>']
C sloledb.cpp [ExecuteAndFlush,line 5658]: Error/Message: (err 15157, sev 0), Setuser failed because of one of the following reasons: the database principal '<sid>' 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 '<sid>' failed -- connect terminated
C Using Provider SQLNCLI
C ExecuteAndFlush return code: 0x80040e14 Stmt: [if user_name() != '<sid>' setuser '<sid>']
C sloledb.cpp [ExecuteAndFlush,line 5658]: Error/Message: (err 15157, sev 0), Setuser failed because of one of the following reasons: the database principal '<sid>' 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 '<sid>' failed -- connect terminated
C Using Provider SQLNCLI
C ExecuteAndFlush return code: 0x80040e14 Stmt: [if user_name() != '<sid>' setuser '<sid>']
C sloledb.cpp [ExecuteAndFlush,line 5658]: Error/Message: (err 15157, sev 0), Setuser failed because of one of the following reasons: the database principal '<sid>' 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 '<sid>' failed -- connect terminated
C failed to establish conn to np:sap<sid>\<SID>.
C Retrying without protocol specifier: sap<sid>\<SID>
C Using Provider SQLNCLI
C ExecuteAndFlush return code: 0x80040e14 Stmt: [if user_name() != '<sid>' setuser '<sid>']
C sloledb.cpp [ExecuteAndFlush,line 5658]: Error/Message: (err 15157, sev 0), Setuser failed because of one of the following reasons: the database principal '<sid>' 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 '<sid>' failed -- connect terminated
C Using Provider SQLNCLI
C ExecuteAndFlush return code: 0x80040e14 Stmt: [if user_name() != '<sid>' setuser '<sid>']
C sloledb.cpp [ExecuteAndFlush,line 5658]: Error/Message: (err 15157, sev 0), Setuser failed because of one of the following reasons: the database principal '<sid>' 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 '<sid>' failed -- connect terminated
C Using Provider SQLNCLI
C
C Fri Dec 10 13:14:44 2010
C ExecuteAndFlush return code: 0x80040e14 Stmt: [if user_name() != '<sid>' setuser '<sid>']
C sloledb.cpp [ExecuteAndFlush,line 5658]: Error/Message: (err 15157, sev 0), Setuser failed because of one of the following reasons: the database principal '<sid>' 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 '<sid>' failed -- connect terminated
C failed to establish conn. 0
B ***LOG BY2=> sql error 0 performing CON [dbsh#2 @ 1200] [dbsh 1200 ]
B ***LOG BY0=> <message text not available> [dbsh#2 @ 1200] [dbsh 1200 ]
B ***LOG BY2=> sql error 0 performing CON [dblink#1 @ 419] [dblink 0419 ]
B ***LOG BY0=> <message text not available> [dblink#1 @ 419] [dblink 0419 ]
M ***LOG R19=> tskh_init, db_connect ( DB-Connect 000256) [thxxhead.c 1271]
M in_ThErrHandle: 1
M *** ERROR => tskh_init: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c 9379]
M
M Info for wp 0
M
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 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
M *****************************************************************************
M *
M * LOCATION SAP-Server sap<sid>_<SID>_00 on host sap<sid> (wp 0)
M * ERROR tskh_init: db_connect
M *
M * TIME Fri Dec 10 13:14:44 2010
M * RELEASE 640
M * COMPONENT Taskhandler
M * VERSION 1
M * RC 13
M * MODULE thxxhead.c
M * LINE 9555
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 730]
M *** ERROR => ThCallHooks: event handler ThrSaveSPAFields for event BEFORE_DUMP failed [thxxtool3.c 246]
M Entering ThSetStatError
M Entering ThReadDetachMode
M call ThrShutDown (1)...
M ***LOG Q02=> wp_halt, WPStop (Workproc 0 2548) [dpnttool.c 357]
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
7 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.