Skip to Content
0
Former Member
May 28, 2015 at 11:07 AM

Problem after SQL restore

317 Views

Hi,

We have restored and ECC system from a backup from another system with the same SID. We are using windows server 2012 using SQL server 2012 as DB .

Restore finished sucessfully and we can connect to the DB from the SQL server studio but SAP is not starting .

We have done the R3trans -x and it's working but when we execute R3trans -d we have this on the trans.log:

4 ETW000 [ dbntab ,00000] ***LOG BZY=>unexpected return code 103 calling NTAB 49 0.076166 4 ETW000 [ dev trc,00000] NTAB: db_ntab(): init_ntab failed, returning 2 52 0.076218 4 ETW000 [ dev trc,00000] NTAB: SELECT COMPCNT, UNICODELG FROM XXXXT WHERE TABNAME = 'SVERS'... 4 ETW000 32 0.076250 4 ETW000 [ dev trc,00000] db_con_test_and_open: 3 open cursors (delta=1) 34 0.076284 4 ETW000 [ dev trc,00000] db_con_check_dirty: 3 open cursors, tx = NO , bc = NO 18 0.076302 4 ETW000 [ dev trc,00000] db_con_check_dirty: db_con_dirty = YES 16 0.076318 4 ETW000 [ dev trc,00000] ERROR: -1 in function StartSelect (execute) [line 14698] 880 0.077198 4 ETW000 [ dev trc,00000] (208) [42S02] [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid object name 'XXXXT'. 4 ETW000 68 0.077266 4 ETW000 [ dev trc,00000] Error 103 (dbcode 208) in StartSelect 33 0.077299 4 ETW000 [ dev trc,00000] StartSelect: stmt of NULL_STMTID 22 0.077321 4 ETW000 [ dev trc,00000] SELECT COMPCNT, UNICODELG FROM "XXXXT" WHERE TABNAME = 'SVERS' 28 0.077349 4 ETW000 /* R3::0 T:XXXXT 4 ETW000 [ dev trc,00000] */ 24 0.077373 4 ETW000 [ dev trc,00000] NTAB: SELECT COMPCNT, UNICODELG FROM XXXXT WHERE TABNAME = 'SVERS' FAILED 4 ETW000 37 0.077410 4 ETW000 [ dev trc,00000] NTAB: SELECT VERSION FROM XXXXT WHERE TABNAME = 'SVERS'... 20 0.077430 4 ETW000 [ dev trc,00000] db_con_test_and_open: 4 open cursors (delta=1) 32 0.077462 4 ETW000 [ dev trc,00000] db_con_check_dirty: 4 open cursors, tx = NO , bc = NO 18 0.077480 4 ETW000 [ dev trc,00000] db_con_check_dirty: db_con_dirty = YES 16 0.077496 4 ETW000 [ dev trc,00000] ERROR: -1 in function StartSelect (execute) [line 14698] 925 0.078421 4 ETW000 [ dev trc,00000] (208) [42S02] [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid object name 'XXXXT'. 4 ETW000 62 0.078483 4 ETW000 [ dev trc,00000] Error 103 (dbcode 208) in StartSelect 58 0.078541 4 ETW000 [ dev trc,00000] StartSelect: stmt of NULL_STMTID 25 0.078566 4 ETW000 [ dev trc,00000] SELECT VERSION FROM "XXXXT" WHERE TABNAME = 'SVERS' 27 0.078593 4 ETW000 /* R3::0 T:XXXXT */ 4 ETW000 [dbntab.c ,00000] *** ERROR => NTAB: SELECT VERSION FROM XXXXT WHERE TABNAME = 'SVERS' FAILED 4 ETW000 55 0.078648 4 ETW000 [ dbntab ,00000] ***LOG BZY=>unexpected return code 103 calling NTAB 34 0.078682 4 ETW000 [ dev trc,00000] NTAB: db_ntab(): init_ntab failed, returning 2 30 0.078712

2EETW000 sap_dext called with msgnr "2":

2EETW000 ---- db call info ----

2EETW000 function: db_ntab

2EETW000 fcode: NT_RDTDESCR 2EETW000 tabname: TADIR

2EETW000 len (char): 5

2EETW000 key: TADIR 2EETW000 retcode: 2 4 ETW000 [ dev trc,00000] db_con_rollback (con_da={R/3,0,0},th_rollback=1,tx=0) 8086 0.086798 4 ETW000 [ dev trc,00000] db_con_check_dirty: db_con_dirty = NO

We have set up these environment variables :

ICM log:

*** ICM up and operational (pid: 2196, HTTP: -, HTTPS: -) ***

Shutdown ICM server ...............

*** ICM shutdown completed (pid: 2196) ***

rslgwr1(21): Searching for overlap point in pre-existing SysLog file...

*** DISPATCHER EMERGENCY SHUTDOWN => DpWpCheck: no more work processes

Created shared memory for profile parameters

Please, could someone help us?

Thanks a lot , sapera

Attachments