Hi Imre,
Did you run the SQL code attached to SAP note 551915?
Regards
From: Imre Nemeth via sap-basis [mailto:sap-basis@Groups.ITtoolbox.com]
Sent: 30 May 2010 20:49
To: D. Caddick
Subject: RE:[sap-basis] SAP not able to start disp+work problem after system copy
Posted by Imre Nemeth
on May 30 at 5:30 PM Mark as helpful
I can only post only trans.log because I had to start restore the original db for tomorrow morning. :-(
One of the error was in work process trace:
event handler db_init for event CREATE_SHM failed -
The Windows server has restarted, but the problem did not solved. (becouse of shared memory)
R3trans -X was 0000, but the R3trans -d was RC 8.
TADIR is missing from DB.
4 ETW000 [dev trc ,00000] ParamStmtExec: line 13241. hr: 0x80040e14 Statement(s) could not be prepared.
4 ETW000 1553 0.200457
4 ETW000 [dev trc ,00000] sloledb.cpp [ParamStmtExec,line 13241]: Error/Message: (err 8180, sev 0), Statement(s) could not be prepared.
4 ETW000 56 0.200513
4 ETW000 [dev trc ,00000] Procname: [##Y4A1_DEVQUa1q00000058400000000005191118]
4 ETW000 27 0.200540
4 ETW000 [dev trc ,00000] sloledb.cpp [ParamStmtExec,line 13241]: Error/Message: (err 208, sev 16), Invalid object name 'TADIR'.
4 ETW000 47 0.200587
4 ETW000 [dev trc ,00000] Procname: [##Y4A1_DEVQUa1q00000058400000000005191118]
4 ETW000 27 0.200614
4 ETW000 [dev trc ,00000] ParamStmtExec failed. HR 80040e14 DBSL retcode 103. stmt:
4 ETW000 38 0.200652
4 ETW000 [dev trc ,00000] SELECT TOP 1 "PGMID" AS c,"OBJECT" AS c,"OBJ_NAME" AS c,"KORRNUM" A
4 ETW000 30 0.200682
4 ETW000 [dev trc ,00000] S c,"SRCSYSTEM" AS c,"AUTHOR" AS c,"SRCDEP" AS c,"DEVCLASS" AS c,"GENFLA
4 ETW000 28 0.200710
4 ETW000 [dev trc ,00000] G" AS c,"EDTFLAG" AS c,"CPROJECT" AS c,"MASTERLANG" AS c,"VERSID" AS c,"
4 ETW000 28 0.200738
4 ETW000 [dev trc ,00000] PAKNOCHECK" AS c,"OBJSTABLTY" AS c,"COMPONENT" AS c,"CRELEASE" AS c,"DEL
4 ETW000 28 0.200766
4 ETW000 [dev trc ,00000] FLAG" AS c,"TRANSLTTXT" AS c FROM "TADIR" WHERE "PGMID" = ? AND "OBJECT"
4 ETW000 28 0.200794
4 ETW000 [dev trc ,00000] = ? AND "OBJ_NAME" = ? 19 0.200813
4 ETW000 /* R3:KRN:0 T:TADIR */
4 ETW000 [dev trc ,00000] Conn_i:1 selection:1 singleton:1 flag_fupd:0 use_cursor:0 chksum: 1113260
4 ETW000 38 0.200851
4 ETW000 [dev trc ,00000] DbSlRead - Error 103 (dbcode 208) on open 23 0.200874
4 ETW000 [dev trc ,00000] DbSlRead - <##Y4A1_DEVQUa1q00000058400000000005191118>
4 ETW000 27 0.200901
4 ETW000 [dev trc ,00000] DbSlRead - Error 103 (dbcode 208) on fetch 20 0.200921
4 ETW000 [dev trc ,00000] DbSlRead - <##Y4A1_DEVQUa1q00000058400000000005191118>
4 ETW000 27 0.200948
4 ETW000 [dbtrtab ,03893] ***LOG BZA=>table TADIR does not exist on database [dbtrtab#7 @ 3893]
4 ETW000 602 0.201550
4 ETW000 [dev trc ,00000] } db_rtab( fcode = 'RT_READ_ONLY', retcode = 2 )
4 ETW000 36 0.201586
4 ETW000
2EETW000 I have some problems during TADIR access.
4 ETW000 Connected to DBMS = MSSQL --- SERVER = 'A1-DEVQUA' DBNAME = 'A1Q' --- SYSTEM = '???'.
3WETW000 The HEAD entry in TADIR is missing.
4 ETW000 [dev trc ,00000] { db_rtab( fcode = 'RT_INSERT', tname = 'PATCHHIST' ) {saprel.c:1258}
4 ETW000 1046 0.202632
4 ETW000 [dev trc ,00000] DbSlBegRead[0]: ##Y4A1_DEVQUa1q00000058400000000003191118
4 ETW000 513 0.203145
4 ETW000 [dev trc ,00000] } db_rtab( fcode = 'RT_INSERT', retcode = 0 ) 1258 0.204403
4 ETW000 [dev trc ,00000] dsql_open (con_da=(0,R/3),stmt="SELECT EXECUTABLE,SAPRELEASE,H ...",#binds=0,name=UNKNOWN,#input=0)
4 ETW000 73 0.204476
4 ETW000 [dev trc ,00000] DbSlBegRead[1]: ##Y4A1_DEVQUa1q00000058400000000007191118
4 ETW000 119 0.204595
4 ETW000 [dev trc ,00000] dsql_fetch (con_da=(0,R/3),cu_id=1,#output=8) 30983 0.235578
4 ETW000 [dev trc ,00000] dsql_close (con_da=(0,R/3),cu_id=1) 127 0.235705
4 ETW000 [dev trc ,00000] { db_rtab( fcode = 'RT_DELETE', tname = 'PATCHHIST' ) {saprel.c:1370}
4 ETW000 64 0.235769
4 ETW000 [dev trc ,00000] } db_rtab( fcode = 'RT_DELETE', retcode = 0 ) 803 0.236572
4 ETW690 COMMIT "0" "0"
4 ETW000 [dev trc ,00000] db_con_commit (con_da={R/3,0,0},th_commit=1,tx=1,hold_cursor=0)
4 ETW000 81 0.236653
4 ETW000 trace to file pointer closed
4 ETW000 trace at level 1 opened for a given file pointer
4 ETW000
4 ETW000 ================== STEP 1 =====================
4 ETW000 date&time : 30.05.2010 - 19:11:18
4 ETW000 function : CONNECT
4 ETW000 buffersync : YES
4 ETW000 clients : default
4 ETW000 l.s.m. : VECTOR
4 ETW000 commit : 100000
4 ETW000 table cache : dynamic
4 ETW000
4 ETW000 [dev trc ,00000] Disconnecting from ALL connections: 205 0.000205
4 ETW000 [dev trc ,00000] Disconnected from connection 0 1682 0.001887
4 ETW000 [dev trc ,00000] statistics db_con_commit (com_total=1, com_tx=1)
4 ETW000 46 0.001933
4 ETW000 [dev trc ,00000] statistics db_con_rollback (roll_total=0, roll_tx=0)
4 ETW000 28 0.001961
4 ETW000 Disconnected from database.
4 ETW000 End of Transport (0008).
4 ETW000 date&time: 30.05.2010 - 19:11:18
4 ETW000 1 warning occured.
4 ETW000 1 error occured.
---------------Original Message---------------
From: Imre Nemeth
Sent: Sunday, May 30, 2010 3:01 PM
Subject: SAP not able to start disp+work problem after system copy
> Hi gurus,
>
> SAP ECC6 with MySQL. After Syscopy the SAP not able to start. The disp+work yellow. Failed to start.
> I was not able to perform the sapinst Target system post activity, becouse in starting system phase the sapinst has stopped.
>
> The schema owner still the old (P) in the restored Q db.
> How can I continue?
> Thanks in advance
| __.____._ Copyright © 2010 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
| |  D. Caddick
SAP Basis Top Contributor
Contributed the most posts in a group for 3 consecutive months to earn a Gold Achievement Related Content White Papers
In the Spotlight  _.____.__ |
Mark as helpful
