DBIF_RSQL_SQL_ERROR" "CX_SY_OPEN_SQL_DB error after Restore

[Former Member]

We are facing the above ABAP short dumbs after performing a restore from a backup ,it appears we have some missing data-files from our backup.We have tried recommendation from "SAP Note 328785 -ORA-00376" but it has also failed to help us perform a restore.I have pasted the short dumb below and attached the error text file.

Category Installation Errors
Runtime Errors DBIF_RSQL_SQL_ERROR
Except. CX_SY_OPEN_SQL_DB
Date and Time 17.08.2013 08:41:40
----------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------
|Short text |
| SQL error 376 when accessing table "TBTCO". |
----------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------
|What happened? |
| Error Text of the Database: "ORA-00376: file 8 cannot be read at this |
| time
ORA-01110: data file 8: 'E:\ORACLE\BID\SAPDATA1\SR3_5\SR3.DATA5'" |
----------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------
|What can you do? |
| Note which actions and input led to the error. |
| |
| For further help in handling the problem, contact your SAP administrator |
| . |
| |
| You can use the ABAP dump analysis transaction ST22 to view and manage |
| termination messages, in particular for long term reference. |
| |
| Note which actions and input led to the error. |
| |
| For further help in handling the problem, contact your SAP administrator |
| . |
| |
| You can use the ABAP dump analysis transaction ST22 to view and manage |
| termination messages, in particular for long term reference. |
| |
----------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------
|Error analysis |
| An exception occurred that is explained in detail below. |
| The exception, which is assigned to class 'CX_SY_OPEN_SQL_DB', was not caught |
| in |
| procedure "INITIATE_JOB_START" "(FORM)", nor was it propagated by a RAISING |
| clause. |
| Since the caller of the procedure could not have anticipated that the |
| exception would occur, the current program is terminated. |
| The reason for the exception is: |
| Error Text of the Database: "ORA-00376: file 8 cannot be read at this |
| time
ORA-01110: data file 8: 'E:\ORACLE\BID\SAPDATA1\SR3_5\SR3.DATA5'" |
----------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------
|How to correct the error |
| Internal call code.........: "[RSQL/READ/TBTCO ]" |
| Please check the entries in the system log (Transaction SM21). |
| |
| If the error occures in a non-modified SAP program, you may be able to |
| find an interim solution in an SAP Note. |
| If you have access to SAP Notes, carry out a search with the following |
| keywords: |
| |
| "DBIF_RSQL_SQL_ERROR" "CX_SY_OPEN_SQL_DB" |
| "SAPMSSY2" or "SAPMSSY2" |
| "INITIATE_JOB_START" |
| |
| If you cannot solve the problem yourself and want to send an error |
| notification to SAP, include the following information: |
| |
| 1. The description of the current problem (short dump) |
| |
| To save the description, choose "System->List->Save->Local File |
| (Unconverted)". |
| |
| 2. Corresponding system log |
| |
| Display the system log by calling transaction SM21. |
| Restrict the time interval to 10 minutes before and five minutes |
| after the short dump. Then choose "System->List->Save->Local File |
| (Unconverted)". |
| |
| 3. If the problem occurs in a problem of your own or a modified SAP |
| program: The source code of the program |
| In the editor, choose "Utilities->More |
| Utilities->Upload/Download->Download". |
| |
| 4. Details about the conditions under which the error occurred or which |
| actions and input led to the error. |
| |
| |
| If the error occures in a non-modified SAP program, you may be able to |
| find an interim solution in an SAP Note. |
| If you have access to SAP Notes, carry out a search with the following |
| keywords: |
| |
| "DBIF_RSQL_SQL_ERROR" "CX_SY_OPEN_SQL_DB" |
| "SAPMSSY2" or "SAPMSSY2" |
| "INITIATE_JOB_START" |
| |
| If you cannot solve the problem yourself and want to send an error |
| notification to SAP, include the following information: |
| |
| 1. The description of the current problem (short dump) |
| |
| To save the description, choose "System->List->Save->Local File |
| (Unconverted)". |
| |
| 2. Corresponding system log |
| |
| Display the system log by calling transaction SM21. |
| Restrict the time interval to 10 minutes before and five minutes |
| after the short dump. Then choose "System->List->Save->Local File |
| (Unconverted)". |
| |
| 3. If the problem occurs in a problem of your own or a modified SAP |
| program: The source code of the program |
| In the editor, choose "Utilities->More |
| Utilities->Upload/Download->Download". |
| |
| 4. Details about the conditions under which the error occurred or which |
| actions and input led to the error. |
| |
| The exception must either be prevented, caught within proedure |
| "INITIATE_JOB_START" "(FORM)", or its possible occurrence must be declared in |
| the |
| RAISING clause of the procedure. |
| To prevent the exception, note the following: |
----------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------
|System environment |
| SAP Release..... 702 |
| SAP Basis Level. 0006 |
| |
| Application server... "demoserver" |
| Network address...... "192.168.1.10" |
| Operating system..... "Windows NT" |
| Release.............. "6.1" |
| Hardware type........ "8x AMD64 Level" |
| Character length.... 16 Bits |
| Pointer length....... 64 Bits |
| Work process number.. 8 |
| Shortdump setting.... "full" |
| |
| Database server... "DEMOSERVER" |
| Database type..... "ORACLE" |
| Database name..... "BID" |
| Database user ID.. "SAPSR3" |
| |
| Terminal.......... " " |
| |
| Char.set.... "C" |
| |
| SAP kernel....... 720 |
| created (date)... "May 7 2010 02:47:09" |
| create on........ "NT 5.2 3790 S x86 MS VC++ 14.00" |
| Database version. "OCI_10201_SHARE, 10.2.0.5.0 " |
| |
| Patch level. 46 |
| Patch text.. " " |
| |
| Database............. "ORACLE 10.1.0.*.*, ORACLE 10.2.0.*.*, ORACLE 11.2.*.*.*" |
| SAP database version. 720 |
| Operating system..... "Windows NT 5.0, Windows NT 5.1, Windows NT 5.2, Windows |
| NT 6.0, Windows NT 6.1" |
| |
| Memory consumption |
| Roll.... 0 |
| EM...... 4189792 |
| Heap.... 0 |
| Page.... 0 |
| MM Used. 1841568 |
| MM Free. 2345552 |
----------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------
|User and Transaction |
| Client.............. 000 |
| User................ "SAPSYS" |
| Language key........ "E" |
| Transaction......... " " |
| Transaction ID...... "120807E35929F1C0A30D18A9056E62C3" |
| |
| EPP Whole Context ID.... " " |
| EPP Connection ID....... " " |
| EPP Caller Counter...... 0 |
| |
| Program............. "SAPMSSY2" |
| Screen.............. "SAPMSSY2 4004" |
| Screen Line......... 4 |
| Debugger Active..... "none" |
----------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------
|Information on where terminated |
| Termination occurred in the ABAP program "SAPMSSY2" - in "INITIATE_JOB_START". |
| The main program was "SAPMSSY2 ". |
| |
| In the source code you have the termination point in line 3435 |
| of the (Include) program "SAPMSSY2". |
| The program "SAPMSSY2" was started as a background job. |
| Job Name....... " " |
| Job Initiator.. " " |
| Job Number..... " " |
| The termination is caused because exception "CX_SY_OPEN_SQL_DB" occurred in |
| procedure "INITIATE_JOB_START" "(FORM)", but it was neither handled locally nor |
| declared |
| in the RAISING clause of its signature. |
| |
| The procedure is in program "SAPMSSY2 "; its source code begins in line |
| 3388 of the (Include program "SAPMSSY2 ". |
----------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------
|Source Code Extract |
----------------------------------------------------------------------------------------------------
|Line |SourceCde |
----------------------------------------------------------------------------------------------------
| 3405|* Damit es konsistent ist: ein aktueller Abzug von tbtcs. |
| 3406|* Am Ende stehen nur noch die Jobs drin, |
| 3407|* die aus tbtcs raus koennen, weil hier abgehandelt! |
| 3408|* # read name as 'exec_jobs completely here' |
| 3409|* |
| 3410|* tbtcs enthaelt die Job-Info fuer Jobs, die fuer diesen |
| 3411|* speziellen Scheduler von Belang sind. |
| 3412|* Solange etwas hier drin ist, wird es vom Scheduler |
| 3413|* immer wieder angelangt. |
| 3414|* # read name as 'table for batch jobs of this scheduler' |
| 3415|* |
| 3416|* tbtco enthaelt die globale Info zu einem Job: z.B. Status |
| 3417|* # read name as 'table for batch jobs - overview' |
| 3418|* |
| 3419|* ajk-/10.06.96 |
| 3420| |
| 3421| IF trace_level > btc_trace_level0. |
| 3422| PERFORM trc_func_begin |
| 3423| USING |
| 3424| current_scheduler |
| 3425| 'FORM' 'INITIATE_JOB_START' |
| 3426| space space space space space. |
| 3427| ENDIF. |
| 3428| |
| 3429| job_started = 0. |
| 3430| |
| 3431|* 23.6.2008 d023157 note 1223502 |
| 3432|* if the job has status 'suspended', we don't need to enqueue |
| 3433|* the job. Therefore we make this check already here |
| 3434| |
|>>>>>| SELECT SINGLE * FROM tbtco INTO p_tbtco |
| 3436| WHERE jobname = exec_jobs-jobname |
| 3437| AND jobcount = exec_jobs-jobcount. |
| 3438| |
| 3439| if sy-subrc = 0 and p_tbtco-status = btc_put_active. |
| 3440| DELETE exec_jobs. |
| 3441| jobs_to_process = jobs_to_process - 1. |
| 3442| |
| 3443| IF trace_level > btc_trace_level1. |
| 3444| PERFORM trc_message |
| 3445| USING |
| 3446| current_scheduler |
| 3447| 'Job has status SUSPENDED' |
| 3448| 'Job will be skipped' |
| 3449| space space space. "#EC NOTEXT |
| 3450| |
| 3451| PERFORM trc_func_end |
| 3452| USING |
| 3453| current_scheduler 'FORM' 'INITIATE_JOB_START'. |
| 3454| ENDIF. |
----------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------
|Contents of system fields |
----------------------------------------------------------------------------------------------------
|Name |Val. |
----------------------------------------------------------------------------------------------------
|SY-SUBRC|4 |
|SY-INDEX|0 |
|SY-TABIX|2 |
|SY-DBCNT|1 |
|SY-FDPOS|0 |
|SY-LSIND|0 |
|SY-PAGNO|0 |
|SY-LINNO|1 |
|SY-COLNO|1 |
|SY-PFKEY| |
|SY-UCOMM| |
|SY-TITLE|ABAP Job Control, ABAP Job Runtime Environment |
|SY-MSGTY| |
|SY-MSGID| |
|SY-MSGNO|000 |
|SY-MSGV1|INTERC |
|SY-MSGV2| |
|SY-MSGV3| |
|SY-MSGV4| |
|SY-MODNO|0 |
|SY-DATUM|20130817 |
|SY-UZEIT|084140 |
|SY-XPROG|SAPLSCSMROUTE |
|SY-XFORM| |
----------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------
|Active Calls/Events |
----------------------------------------------------------------------------------------------------
|No. Ty. Program Include Line |
| Name |
----------------------------------------------------------------------------------------------------
| 6 FORM SAPMSSY2 SAPMSSY2 3435 |
| INITIATE_JOB_START |
| 5 FORM SAPMSSY2 SAPMSSY2 3347 |
| DISPATCH_JOBS_ON_HOST |
| 4 FORM SAPMSSY2 SAPMSSY2 3271 |
| DISPATCH_JOBS |
| 3 FORM SAPMSSY2 SAPMSSY2 491 |
| PROCESS_TIME_TRIGGERED_JOBS |
| 2 FORM SAPMSSY2 SAPMSSY2 421 |
| TIME_HANDLER_START |
| 1 MODULE (PAI) SAPMSSY2 SAPMSSY2 348 |
| %_TIME_HANDLER |
----------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------
|Chosen variables |
----------------------------------------------------------------------------------------------------
|Name |
| Val. |
----------------------------------------------------------------------------------------------------
|No. 6 Ty. FORM |
|Name INITIATE_JOB_START |
----------------------------------------------------------------------------------------------------
|JOB_STARTED |
| 0 |
| 0000 |
| 0000 |
| 00000000 |
|AD_WPSTAT_STAT_KILLED |
| 16 |
| 1000 |
| 0000 |
| 10000000 |
|<%_TABLE_TBTCO> |
| ??? |
| ?????? |
| ?????? |
| ???????????? |
|SYST-REPID |
| SAPMSSY2 |
| 5454555322222222222222222222222222222222 |
| 310D339200000000000000000000000000000000 |
| 0000000000000000000000000000000000000000 |
| 0000000000000000000000000000000000000000 |
| 5300410050004D00530053005900320020002000200020002000200020002000200020002000200020002000200020|
|BTC_SHOW_USER_EVENTIDS |
| 4 |
| 0000 |
| 4000 |
| 04000000 |
|SY-REPID |
| SAPMSSY2 |
| 5454555322222222222222222222222222222222 |
| 310D339200000000000000000000000000000000 |
| 0000000000000000000000000000000000000000 |
| 0000000000000000000000000000000000000000 |
| 5300410050004D00530053005900320020002000200020002000200020002000200020002000200020002000200020|
|TH_ADM_LEVEL_WP |
| 1 |
| 0000 |
| 1000 |
| 01000000 |
|EXEC_JOBS-JOBNAME |
| ARFC:C0A8010A12EC517A94140FDE |
| 45443434333343344333433333444222 |
| 1263A301801011253517194140645000 |
| 00000000000000000000000000000000 |
| 00000000000000000000000000000000 |
| 41005200460043003A0043003000410038003000310030004100310032004500430035003100370041003900340031|
|TH_ADM_LEVEL_DP |
| 2 |
| 0000 |
| 2000 |
| 02000000 |
|EXEC_JOBS-JOBCOUNT |
| 18005501 |
| 33333333 |
| 18005501 |
| 00000000 |
| 00000000 |
| 31003800300030003500350030003100 |
|C_INT_UNKNOWN |
| -1 |
| FFFF |
| FFFF |
| FFFFFFFF |
|P_TBTCO |
| ##|
| 2222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222200|
| 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000|
| 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000|
| 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000|
| 2000200020002000200020002000200020002000200020002000200020002000200020002000200020002000200020|
|AD_GENERAL2_REC |
| |
| 2222222222222222222222222222222222222222222 |
| 0000000000000000000000000000000000000000000 |
| 0000000000000000000000000000000000000000000 |
| 0000000000000000000000000000000000000000000 |
| 2000200020002000200020002000200020002000200020002000200020002000200020002000200020002000200020|
|SY-SUBRC |
| 4 |
| 0000 |
| 4000 |
| 04000000 |
|AGE_OF_JOB |
| 0 |
| 0000 |
| 0000 |
| 00000000 |
|P_TBTCO-STATUS |
| |
| 2 |
| 0 |
| 0 |
| 0 |
| 2000 |
|BTC_PUT_ACTIVE |
| Z |
| 5 |
| A |
| 0 |
| 0 |
| 5A00 |
|TBTCO |
| SWWDHEX 11131400 %NEWSTEP ##|
| 5554445222222222222222222222222233333333222222222222244555452222222222222222222222222222222200|
| 37748580000000000000000000000000111314000000000000005E5734500000000000000000000000000000000010|
| 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000|
| 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000|
| 5300570057004400480045005800200020002000200020002000200020002000200020002000200020002000200020|
|EXEC_JOBS[] |
| Table IT_6[19x500] |
| \PROGRAM=SAPMSSY2\DATA=EXEC_JOBS[] |
| Table reference: 0 |
| TABH+ 0(20) = A04D0600FF070000000000000000000000000000 |
| TABH+ 20(20) = 000000000600000013000000F401000000000000 |
| TABH+ 40(16) = 0400000000B8040020000000C110C000 |
| store = 0xA04D0600FF070000 |
| ext1 = 0x0000000000000000 |
| shmId = 0 (0x00000000) |
| id = 0 (0x00000000) |
| label = 6 (0x06000000) |
| fill = 19 (0x13000000) |
| leng = 500 (0xF4010000) |
| loop = 0 (0x00000000) |
| xtyp = TYPE#000122 |
| occu = 32 (0x20000000) |
| accKind = 1 (ItAccessStandard) |
| idxKind = 0 (ItIndexNone) |
| uniKind = 2 (ItUniNo) |
| keyKind = 1 (default) |
| cmpMode = 8 (cmpManyEq) |
| occu0 = 0 |
| stMode = 0 |
| groupCntl = 0 |
| rfc = 0 |
| unShareable = 0 |
| mightBeShared = 0 |
| sharedWithShmTab = 0 |
| isShmLockId = 0 |
| isUsed = 1 |
| isCtfyAble = 1 |
| hasScndKeys = 0 |
| hasRowId = 0 |
| scndKeysOutdated = 0 |
| scndUniKeysOutdated = 0 |
| ----- Shareable Table Header Data ----- |
| tabi = 0x608D0F00FF070000 |
| pgHook = 0x0000000000000000 |
| idxPtr = 0x0000000000000000 |
| id = 8 (0x08000000) |
| shmTabhSet = 0x0000000000000000 |
| refCount = 0 (0x00000000) |
| tstRefCount = 0 (0x00000000) |
| lineAdmin = 32 (0x20000000) |
| lineAlloc = 32 (0x20000000) |
| shmVersId = 0 (0x00000000) |
| shmRefCount = 1 (0x01000000) |
| rowId = 18446744073709551615 |
| scndKeyAdmin = 0x0000000000000000 |
| |
| SWWDHEX 11131400 %_RETRY %NEWSTEP |
| 5554445222222222222222222222222233333333222222222222222222222222222222222554555222222445554522|
| 3774858000000000000000000000000011131400000000000000000000000000000000005F25429000005E57345000|
| 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000|
| 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000|
| 5300570057004400480045005800200020002000200020002000200020002000200020002000200020002000200020|
| |
| ARFC:C0A8010A12EC517A94140FDE 18005501 %NEWSTEP |
| 4544343433334334433343333344422233333333222222222222222222222222222222222222222222222445554522|
| 1263A30180101125351719414064500018005501000000000000000000000000000000000000000000005E57345000|
| 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000|
| 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000|
| 41005200460043003A0043003000410038003000310030004100310032004500430035003100370041003900340031|
| |
| ARFC:C0A8010A178C517A98580156 18005500 %NEWSTEP |
| 4544343433334333433343333333322233333333222222222222222222222222222222222222222222222445554522|
| 1263A30180101178351719858015600018005500000000000000000000000000000000000000000000005E57345000|
| 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000|
| 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000|
| 41005200460043003A0043003000410038003000310030004100310037003800430035003100370041003900380035|
| |
| ARFC:C0A8010A12EC517920620066 18005600 %NEWSTEP |
| 4544343433334334433333333333322233333333222222222222222222222222222222222222222222222445554522|
| 1263A30180101125351792062006600018005600000000000000000000000000000000000000000000005E57345000|
| 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000|
| 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000|
| 41005200460043003A0043003000410038003000310030004100310032004500430035003100370039003200300036|
| |
| ARFC:C0A8010A09E45163DA4004AD 18005600 %NEWSTEP |
| 4544343433334334333334433334422233333333222222222222222222222222222222222222222222222445554522|
| 1263A30180101095451634140041400018005600000000000000000000000000000000000000000000005E57345000|
| 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000|
| 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000|
| 41005200460043003A0043003000410038003000310030004100300039004500340035003100360033004400410034|
|JOBS_TO_PROCESS |
| 19 |
| 1000 |
| 3000 |
| 13000000 |
----------------------------------------------------------------------------------------------------
|No. 5 Ty. FORM |
|Name DISPATCH_JOBS_ON_HOST |
----------------------------------------------------------------------------------------------------
|EXEC_JOBS[] |
| Table IT_6[19x500] |
|SPACE |
| |
| 2 |
| 0 |
| 0 |
| 0 |
| 2000 |
|BTC_MODE_SIMULATION |
| S |
| 5 |
| 3 |
| 0 |
| 0 |
| 5300 |
|TRACE_LEVEL |
| 0 |
| 0000 |
| 0000 |
| 00000000 |
|BTC_TRACE_LEVEL1 |
| 1 |
| 0000 |
| 1000 |
| 01000000 |
|*BTCOMSDL |
| 00000000000000 00000000000000 |
| 3333333333333322222222222222222222222222222222233333333333333 |
| 0000000000000000000000000000000000000000000000000000000000000 |
| 0000000000000000000000000000000000000000000000000000000000000 |
| 0000000000000000000000000000000000000000000000000000000000000 |
| 3000300030003000300030003000300030003000300030003000300020002000200020002000200020002000200020|
|BTC_A2C_WRITE_TRACE |
| 6 |
| 0000 |
| 6000 |
| 06000000 |
|CURRENT_SCHEDULER |
| TIMESDL |
| 54445442222222222222222222222222 |
| 49D534C0000000000000000000000000 |
| 00000000000000000000000000000000 |
| 00000000000000000000000000000000 |
| 540049004D004500530044004C00200020002000200020002000200020002000200020002000200020002000200020|
|EXEC_JOBS-JOBNAME |
| ARFC:C0A8010A12EC517A94140FDE |
| 45443434333343344333433333444222 |
| 1263A301801011253517194140645000 |
| 00000000000000000000000000000000 |
| 00000000000000000000000000000000 |
| 41005200460043003A0043003000410038003000310030004100310032004500430035003100370041003900340031|
|EXEC_JOBS-JOBCOUNT |
| 18005501 |
| 33333333 |
| 18005501 |
| 00000000 |
| 00000000 |
| 31003800300030003500350030003100 |
|BTCDELAY |
| |
| 2222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222|
| 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000|
| 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000|
| 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000|
| 2000200020002000200020002000200020002000200020002000200020002000200020002000200020002000200020|
|%_SPACE |
| |
| 2 |
| 0 |
| 0 |
| 0 |
| 2000 |
|EXEC_JOBS |
| ARFC:C0A8010A12EC517A94140FDE 18005501 %NEWSTEP |
| 4544343433334334433343333344422233333333222222222222222222222222222222222222222222222445554522|
| 1263A30180101125351719414064500018005501000000000000000000000000000000000000000000005E57345000|
| 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000|
| 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000|
| 41005200460043003A0043003000410038003000310030004100310032004500430035003100370041003900340031|
|JOBS_TO_EXECUTE |
| 19 |
| 1000 |
| 3000 |
| 13000000 |
|JOB_STARTED |
| 0 |
| 0000 |
| 0000 |
| 00000000 |
|SY |
| ######################################Ǵ#######################################T######### ####|
| 00000010000000000000000000000000000000F0000000000000000000000000000000000000105000000020220000|
| 0000203000001000000010001000100000000040000000400000000000000000000000000000604000000000000600|
| 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000|
| 00000000000000000000000000000000000000100000000000000000000000000000000000000000000000C000000C|
| 0000000000000000020000001300000000000000000000000100000000000000000000000000000001000000000000|
|BTC_EDIT_BTCCTL_TBL |
| 1 |
| 0000 |
| 1000 |
| 01000000 |
----------------------------------------------------------------------------------------------------
|No. 4 Ty. FORM |
|Name DISPATCH_JOBS |
----------------------------------------------------------------------------------------------------
|NUM_SEL_JOBS |
| 19 |
| 1000 |
| 3000 |
| 13000000 |
|BTC_TRACE_LEVEL0 |
| 0 |
| 0000 |
| 0000 |
| 00000000 |
|*TBTCO |
| ##|
| 2222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222200|
| 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000|
| 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000|
| 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000|
| 2000200020002000200020002000200020002000200020002000200020002000200020002000200020002000200020|
|EXEC_JOBS[] |
| Table IT_6[19x500] |
|EXEC_JOBS |
| ARFC:C0A8010A12EC517A94140FDE 18005501 %NEWSTEP |
| 4544343433334334433343333344422233333333222222222222222222222222222222222222222222222445554522|
| 1263A30180101125351719414064500018005501000000000000000000000000000000000000000000005E57345000|
| 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000|
| 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000|
| 41005200460043003A0043003000410038003000310030004100310032004500430035003100370041003900340031|
|BTC_JOBCLASS_C |
| C |
| 4 |
| 3 |
| 0 |
| 0 |
| 4300 |
|FREE_BTCWP |
| 3 |
| 0000 |
| 3000 |
| 03000000 |
----------------------------------------------------------------------------------------------------
|No. 3 Ty. FORM |
|Name PROCESS_TIME_TRIGGERED_JOBS |
----------------------------------------------------------------------------------------------------
|BTC_BEGINNING_OF_MONTH |
| 01 |
| 33 |
| 01 |
| 00 |
| 00 |
| 30003100 |
|EXEC_JOBS[] |
| Table IT_6[19x500] |
|EXEC_JOBS |
| ARFC:C0A8010A12EC517A94140FDE 18005501 %NEWSTEP |
| 4544343433334334433343333344422233333333222222222222222222222222222222222222222222222445554522|
| 1263A30180101125351719414064500018005501000000000000000000000000000000000000000000005E57345000|
| 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000|
| 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000|
| 41005200460043003A0043003000410038003000310030004100310032004500430035003100370041003900340031|
|SCREEN |
| |
| 2222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222|
| 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000|
| 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000|
| 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000|
| 2000200020002000200020002000200020002000200020002000200020002000200020002000200020002000200020|
|NUM_SEL_JOBS |
| 19 |
| 1000 |
| 3000 |
| 13000000 |
|JOBS_TO_DELETE |
| 0 |
| 0000 |
| 0000 |
| 00000000 |
|EXECUTED_JOBS |
| Table[initial] |
| |
|INTERCEPTED_JOBS |
| Table[initial] |
| |
|%_VIASELSCR |
| # |
| 0 |
| 4 |
| 04 |
----------------------------------------------------------------------------------------------------
|No. 2 Ty. FORM |
|Name TIME_HANDLER_START |
----------------------------------------------------------------------------------------------------
|ERROR_CORRECTED |
| 0 |
| 0000 |
| 0000 |
| 00000000 |
|UNDO_DATA |
| |
| 22222222222222222222222222222222 |
| 00000000000000000000000000000000 |
| 00000000000000000000000000000000 |
| 00000000000000000000000000000000 |
| 2000200020002000200020002000200020002000200020002000200020002000200020002000200020002000200020|
|BTC_SHOW_BTCCTL_TBL |
| 2 |
| 0000 |
| 2000 |
| 02000000 |
|BTC_STDT_MODIFIED |
| 1 |
| 0000 |
| 1000 |
| 01000000 |
|SCHEDULER_ACTIVATED |
| ECZ |
| 445 |
| 53A |
| 000 |
| 000 |
| 450043005A00 |
|TEXT-008 |
| Time |
| 5666 |
| 49D5 |
| 0000 |
| 0000 |
| 540069006D006500 |
|BTC_OBJ_OPMODE_TEXT |
| Betriebsartenumschaltung |
| 46776667677667676666776622222222 |
| 254295231245E5D3381C45E700000000 |
| 00000000000000000000000000000000 |
| 00000000000000000000000000000000 |
| 4200650074007200690065006200730061007200740065006E0075006D0073006300680061006C00740075006E0067|
|SWITCH_DONE |
| 0 |
| 0000 |
| 0000 |
| 00000000 |
|%_PRINT |
| 000 0###|
| 2222333222222222222222222222222222222222222222222222222222222222222222222222222222222222223000|
| 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000|
| 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000|
| 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000|
| 2000200020002000300030003000200020002000200020002000200020002000200020002000200020002000200020|
|SY-ONCOM |
| X |
| 5 |
| 8 |
| 0 |
| 0 |
| 5800 |
----------------------------------------------------------------------------------------------------
|No. 1 Ty. MODULE (PAI) |
|Name %_TIME_HANDLER |
----------------------------------------------------------------------------------------------------
|BTC_JOB_NOT_MODIFIED |
| 1 |
| 0000 |
| 1000 |
| 01000000 |
|TIME_JOBS_STARTED |
| 0 |
| 0000 |
| 0000 |
| 00000000 |
|TIME_JOBS_FOUND |
| 19 |
| 1000 |
| 3000 |
| 13000000 |
----------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------
|Internal notes |
| The termination was triggered in function "ab_HandleRsqlErrors" |
| of the SAP kernel, in line 716 of the module |
| "//bas/720_REL/src/krn/runt/absapsql.c#9". |
| The internal operation just processed is "SQLS". |
| Internal mode was started at 20130817084140. |
| Internal call code.........: "[RSQL/READ/TBTCO ]" |
| Internal call code.........: "[RSQL/READ/TBTCO ]" |
----------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------
|Active Calls in SAP Kernel |
----------------------------------------------------------------------------------------------------
|Lines of C Stack in Kernel (Structure Differs on Each Platform) |
----------------------------------------------------------------------------------------------------
|SAP (R) - R/3(TM) Callstack, Version 1.0 |
|Copyright (C) SAP AG. All rights reserved. |
|Callstack without Exception: |
|App : disp+work.EXE (pid=4348) |
|When : 8/17/2013 8:41:40.939 |
|Threads : 2 |
|Computer Name : DEMOSERVER |
|User Name : SAPServiceBID |
|Number of Processors: 8 |
|Processor Type: Intel64 Family 6 Model 26 Stepping 5 |
|Windows Version : 6.1 Current Build: 7600 |
|State Dump for Thread Id f90 |
|0000000002027D30 0000000141830386 00000000024BD1B0 disp+work!DumpStacks [ntstcdbg.c (508)] |
|0000000002027E30 000000014026A174 0000000074A7A000 disp+work!NTDebugProcess [ntstcdbg.c (369)] |
|0000000002027E60 000000014049DE2A 0000000074A7A000 disp+work!CTrcStack [dptstack.c (183)] |
|0000000002027EB0 00000001404A389D 000000000245F1C8 disp+work!rabax_CStackSave [abrabax.c (8573)] |
|00000000020287C0 00000001405BB5B6 00000000000002CC disp+work!ab_rabax [abrabax.c (1410)] |
|0000000002028870 000000014062C482 0000000000000096 disp+work!ab_rsqlerr [abdberr.c (953)] |
|0000000002028A10 00000001406348FC 0000000000000000 disp+work!SqlsExecuteCall [absapsql.c (7041)] |
|0000000002028BB0 000000014048D491 0000000140000000 disp+work!ab_jsqls [absapsql.c (11956)] |
|0000000002028D30 0000000140504652 000007FF000BA600 disp+work!ab_extri [abextri.c (729)] |
|0000000002028D80 00000001404513D8 000007FF000BA600 disp+work!ab_xevent [abrunt1.c (278)] |
|0000000002028E10 00000001402D9586 000007FF000BA600 disp+work!ab_dstep [abdynpro.c (628)] |
|0000000002028FC0 00000001402DDC80 000007FF000BA600 disp+work!dynpmcal [dymainstp.c (2868)] |
|0000000002029050 00000001402DD27B 000000000000000C disp+work!dynppai0 [dymainstp.c (1215)] |
|0000000002029120 0000000140293DF2 0020002000200020 disp+work!dynprctl [dymainstp.c (470)] |
|000000000202F380 000000014010C9B7 0000000000000000 disp+work!dynpen00 [dymain.c (1973)] |
|000000000202FE50 000000014010D1BC FFFFFFFFFFFFFFFE disp+work!TskhLoop [thxxhead.c (4827)] |
|000000000202FEB0 000000014002DB7C 00000000024BD118 disp+work!ThStart [thxxhead.c (1166)] |
|000000000202FEF0 00000001400010B1 FFFFFFFF00000003 disp+work!DpMain [dpxxdisp.c (1133)] |
|000000000202FF20 0000000141B32150 0000000002030000 disp+work!nlsui_main [thxxanf.c (80)] |
|000000000202FF50 0000000076B5F56D 0000000000000000 disp+work!__tmainCRTStartup [crtexe.c (594)] |
|000000000202FF80 0000000076D93281 0000000000000000 kernel32!BaseThreadInitThunk |
|000000000202FFD0 0000000000000000 0000000000000000 ntdll!RtlUserThreadStart |
|State Dump for Thread Id 868 |
|000000000BE4FDE0 000007FEFD0320EF 000000007C8B1270 ntdll!NtFsControlFile |
|000000000BE4FE50 0000000141A0FD2F FFFFFFFFFFFFFFFE KERNELBASE!ConnectNamedPipe |
|000000000BE4FEF0 00000000749C37D7 0000000007D8E460 disp+work!SigIMsgFunc [signt.c (717)] |
|000000000BE4FF20 00000000749C3894 0000000074A795C0 MSVCR80!endthreadex |
|000000000BE4FF50 0000000076B5F56D 0000000000000000 MSVCR80!endthreadex |
|000000000BE4FF80 0000000076D93281 0000000000000000 kernel32!BaseThreadInitThunk |
|000000000BE4FFD0 0000000000000000 0000000000000000 ntdll!RtlUserThreadStart |
----------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------
|Database Interface Information |
----------------------------------------------------------------------------------------------------
|C|1| OCIStmtExecute() failed with -1=OCI_ERROR [dboci.c#4474] |
|C|1| SQL error 376: [dboci.c#4475] |
|C|E|Error 376 in stmt_fetch() from oci_execute_stmt(), orpc=0 [dbsloci.c#16278] |
|C|E|ORA-00376 occurred when executing SQL stmt (parse error offset=0) [dbsloci.c#16296] |
|C|1|sc_p=0000000012EBF540,no=18,idc_p=0000000012ED6330,con=0,act=1,slen=61,smax=256,#vars=2,stmt=0|
|C|1|SELECT * FROM "TBTCO" WHERE "JOBNAME"=:A0 AND "JOBCOUNT"=:A1 ; [dbsc.c#2318] |
|C|1|sc_p=0000000012EBF540,no=18,idc_p=0000000012ED6330,con=0,act=1,slen=61,smax=256,#vars=2,stmt=0|
|C|1|Statement cache: sc=0000000012EBF540, upsert_sc=0000000000000000, oci_stp=000000003186F818 [db|
|C|1|prepared=0, literal_cnt=0, native_sql=0, lob_ret_cnt=0, fae_cnt=0, xop=3, dbcount=0 [dbsloci.c|
|C|1|IN : col_cnt=2, row_max=1, row_xcnt=0, row_pcnt=0, row_i=0, row_total=0, [dbsloci.c#15575] |
|C|1| row_upto=-1, row_size=80, vda_max=32, bound=1, itp=00000000131EFA70, vda_arr=000000003184|
|C|1| lob_cnt=0, lob_max=0, lob_pw_cnt=0, lob_arr=0000000000000000, rows_ret=0 [dbsloci.c#1558|
|C|1|OUT: col_cnt=58, row_max=1, row_xcnt=1, row_pcnt=0, row_i=0, row_total=0, [dbsloci.c#15575] |
|C|1| row_upto=-1, row_size=1292, vda_max=64, bound=1, itp=0000000002456F50, vda_arr=0000000031|
|C|1| lob_cnt=0, lob_max=0, lob_pw_cnt=0, lob_arr=0000000000000000, rows_ret=0 [dbsloci.c#1558|
|C|1|SELECT * FROM "TBTCO" WHERE "JOBNAME"=:A0 AND "JOBCOUNT"=:A1 ; [dbsc.c#2318] |
|B|E|***LOG BYL=> DBQ action required because of database error 376 [dbsh#1151] |
|B|1|SQL code: 376, SQL text: ORA-00376: file 8 cannot be read at this time [dbsh.c#1159] |
|B|1|ORA-01110: data file 8: 'E:\ORACLE\BID\SAPDATA1\SR3_5\SR3.DATA5' [dbsh.c#1159] |
|B|E|***LOG BY4=> sql error 376 performing SEL on table TBTCO [dbtran#7|
|B|E|***LOG BY0=> ORA-00376: file 8 cannot be read at this time [dbtran#7550] |
|B|E|ORA-01110: data file 8: 'E:\ORACLE\BID\SAPDATA1\SR3_5\SR3.DATA5' [dbtran#7550] |
|B|1|dbtran ERROR LOG (hdl_dbsl_error): DbSl 'SEL' [dbtran.c#7614] |
|B|1| RSLT: {dbsl=99, tran=1} [dbtran.c#7614] |
|B|1| FHDR: {tab='TBTCO', fcode=17, mode=2, bpb=0, dbcnt=0, crsr=1, [dbtran.c#7614] |
|B|1| hold=0, keep=1, xfer=0, pkg=0, upto=0, init:b=0, [dbtran.c#7614] |
|B|1| init:p=0000000000000000, init:#=1296, wa:p=0X000007FF000A0210, wa:#=1296} [dbtran.c#76|
|B|1|dbtran ERROR LOG (hdl_dbsl_error): DbSl 'SEL' [dbtran.c#7645] |
|B|1| STMT: {stmt:#=1, bndfld:#=2, prop=0x21, distinct=0, [dbtran.c#7645] |
|B|1| fld:#=58, alias:p=0000000000000000, fupd:#=0, tab:#=1, where:#=3, [dbtran.c#7645] |
|B|1| groupby:#=0, having:#=0, order:#=0, primary=0, hint:#=0} [dbtran.c#7645] |
|B|1| CRSR: {tab='', id=0, hold=0, prop=0x10000, max.in@0=1, fae:blk=0, [dbtran.c#7645] |
|B|1| con:id=0, con:vndr=5, val=2, [dbtran.c#7645] |
|B|1| key:#=2, xfer=0, xin:#=0, row:#=0, upto=1, wa:p=0X000007FF000A0210} [dbtran.c#7645] |
----------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------
|List of ABAP programs affected |
----------------------------------------------------------------------------------------------------
|Index |Typ|Program |Group |Date |Time |Size |Lang. |
----------------------------------------------------------------------------------------------------
| 0|Prg|SAPMSSY2 | 0|27.12.2010|19:58:42| 343040|E |
| 1|Prg|SAPMSSYD | 0|07.11.2006|07:31:42| 23552|E |
| 2|Prg|SAPFSYSCALLS | 0|09.09.2004|14:18:32| 8192|E |
| 3|Prg|SAPLSTUP | 3|14.07.2010|16:19:03| 86016|E |
| 4|Prg|SAPLCNDP | 4|27.12.2010|21:20:29| 231424|E |
| 5|Prg|SAPLSCNT | 5|18.02.2005|14:16:06| 34816|E |
| 6|Prg|SAPSHDTV | 5|05.01.2005|16:26:16| 38912|E |
| 7|Prg|SAPFGUICNTL | 0|18.02.2005|14:15:08| 27648|E |
| 8|Prg|SAPLOLEA | 8|16.08.2013|16:12:31| 110592|E |
| 9|Prg|SAPLSGUI | 9|27.12.2010|19:50:07| 105472|E |
| 10|Prg|SAPLSTTM | 10|14.07.2010|17:39:47| 79872|E |
| 11|Prg|SAPLSBDC | 11|14.07.2010|17:39:46| 49152|E |
| 12|Prg|SAPLSFES | 12|27.12.2010|21:20:35| 314368|E |
| 13|Prg|SAPLTHFB | 13|27.12.2010|20:00:32| 471040|E |
| 14|Typ|WPINFO | 0|26.02.1999|14:49:01| 6144| |
| 15|Prg|SAPLURFC | 15|14.07.2010|17:39:48| 25600|E |
| 16|Prg|SAPLSPLUGIN | 16|14.07.2010|23:11:12| 9216|E |
| 17|Typ|SWCBCONT | 0|15.11.2000|17:55:11| 3072| |
| 18|Typ|OLE_VERBS | 0|04.04.1995|16:02:20| 2048| |
| 19|Typ|OLE_PA | 0|04.04.1995|16:02:19| 2048| |
| 20|Prg|SAPLBTCH | 20|16.08.2013|16:12:31| 2176000|E |
| 21|Typ|BTCOPTIONS | 0|20.01.2003|16:27:18| 2048| |
| 22|Typ|MSXXLIST_V6 | 0|13.02.2005|18:20:27| 4096| |
| 23|Prg|/1BCDWBEN/SAPLSEN0 | 23|14.07.2010|17:35:13| 106496|E |
| 24|Prg|SAPLSENA | 24|14.07.2010|13:34:50| 39936|E |
| 25|Prg|/1BCDWBEN/SAPLSEN0002 | 25|27.12.2010|21:54:49| 316416|E |
| 26|Typ|BTCCTL | 0|14.02.1998|05:19:27| 4096| |
| 27|Prg|SAPMSSY0 | 27|27.12.2010|19:50:07| 111616|E |
| 28|Prg|SAPLSPIAGENTCW | 28|27.12.2010|20:16:19| 14336|E |
| 29|Prg|SAPLSPILS | 29|27.12.2010|20:16:19| 80896|E |
| 30|Prg|CL_OS_TRANSACTION_END_NOTIFIERCP | 30|14.07.2010|16:28:02| 10240|E |
| 31|Prg|CL_SYSTEM_TRANSACTION_STATE===CP | 31|27.12.2010|19:50:07| 146432|E |
| 32|Prg|%_CTHFB | 13|18.02.2005|14:16:06| 12288|E |
| 33|Typ|BTCDELAY | 0|09.07.1993|20:57:12| 3072| |
| 34|Typ|TBTCS | 0|04.12.2000|14:59:57| 6144| |
| 35|Prg|CL_SBTI_CRITERIA_MANAGER======CP | 35|14.07.2010|22:05:33| 34816|E |
| 36|Prg|CL_SBTI_CRITERIA_TYPE=========CP | 36|14.07.2010|22:05:33| 27648|E |
| 37|Prg|IF_SBTI_CRITERIA_TYPE=========IP | 0|14.07.2010|22:05:33| 8192|E |
| 38|Prg|CX_SBTI_CRITTYPE_EX===========CP | 38|14.07.2010|17:38:09| 21504|E |
| 39|Prg|CX_SBTI_EXCEPTION=============CP | 39|14.07.2010|17:38:09| 16384|E |
| 40|Prg|CX_STATIC_CHECK===============CP | 40|14.07.2010|17:38:10| 11264|E |
| 41|Prg|CX_ROOT=======================CP | 41|16.07.2010|06:44:48| 13312|E |
| 42|Prg|CX_NO_CHECK===================CP | 42|14.07.2010|17:38:08| 11264|E |
| 43|Typ|SCX_T100KEY | 0|06.11.2003|20:31:00| 3072| |
| 44|Prg|IF_T100_MESSAGE===============IP | 39|14.07.2010|17:39:09| 6144|E |
| 45|Prg|CL_MESSAGE_HELPER=============CP | 45|14.07.2010|22:37:35| 36864|E |
| 46|Prg|SAPLSALI | 46|14.07.2010|13:09:03| 224256|E |
| 47|Prg|SAPLSALC | 47|14.07.2010|17:39:46| 795648|E |
| 48|Prg|SAPLSRFC | 48|14.07.2010|17:39:46| 48128|E |
| 49|Prg|SAPLSCSMROUTE | 49|27.12.2010|19:41:44| 445440|E |
| 50|Prg|SAPLSALS | 50|14.07.2010|17:39:46| 181248|E |
| 51|Typ|ALMONSE40B | 0|09.11.2000|14:03:52| 10240| |
| 52|Typ|ALMTNAME_L | 0|07.05.1997|12:39:59| 2048| |
| 53|Typ|ALNAMESPLT | 0|04.06.1997|19:14:50| 3072| |
| 54|Typ|CSMSEGM | 0|18.05.2004|14:07:28| 5120| |
| 55|Prg|SAPLSCSM_UTILITIES | 55|29.11.2008|05:47:57| 10240|E |
| 56|Typ|CSM_UPD_C | 0|14.07.2010|08:28:13| 6144| |
| 57|Typ|ALCONSEG | 0|18.05.2004|14:07:05| 7168| |
| 58|Typ|ALGTIDLNRC | 0|04.06.1997|19:14:45| 4096| |
| 59|Typ|ALRFCLNAME | 0|18.05.2004|14:07:26| 8192| |
| 60|Prg|SAPLSALJ | 60|14.07.2010|12:13:26| 165888|E |
| 61|Typ|ALMTCREATE | 0|13.08.1997|12:16:37| 4096| |
| 62|Typ|ALMTCRERES | 0|09.11.2000|14:03:54| 5120| |
| 63|Typ|ALRFCMTCRE | 0|18.05.2004|14:07:26| 10240| |
| 64|Typ|ALMTCUSTWR | 0|09.11.2000|14:03:54| 5120| |
| 65|Typ|ALGTIDRC | 0|04.06.1997|19:14:45| 3072| |
| 66|Typ|ALRFCMTCUS | 0|18.05.2004|14:07:26| 11264| |
| 67|Typ|ALPERFCUSW | 0|04.06.1997|19:14:51| 5120| |
| 68|Typ|ALRFCPCUSW | 0|18.05.2004|14:07:26| 11264| |
| 69|Typ|ALTOOLASSG | 0|13.08.1997|12:16:47| 4096| |
| 70|Typ|ALGLOBTID | 0|04.06.1997|19:14:45| 3072| |
| 71|Typ|ALTIDSTATS | 0|29.11.2008|01:21:47| 4096| |
| 72|Typ|ALTDEFRC | 0|09.11.2000|14:04:02| 16384| |
| 73|Typ|ALRFCTID | 0|18.05.2004|14:07:26| 9216| |
| 74|Typ|ALGTIDTLRC | 0|05.06.1997|12:32:48| 3072| |
| 75|Typ|ALRFCTOOLA | 0|18.05.2004|14:07:26| 10240| |
| 76|Typ|ALPERFRVAL | 0|04.06.1997|19:14:51| 3072| |
| 77|Typ|ALRFCPRVAL | 0|18.05.2004|14:07:26| 10240| |
| 78|Prg|SAPLSAL2 | 78|14.07.2010|17:39:46| 101376|E |
| 79|Typ|ALMCCREAT2 | 0|02.11.1998|09:42:47| 3072| |
| 80|Typ|ALMCCREATE | 0|13.05.1997|12:48:19| 3072| |
| 81|Typ|ALMCRESULT | 0|13.05.1997|12:48:22| 4096| |
| 82|Typ|ALRFCMCCRE | 0|14.12.1998|23:09:21| 4096| |
| 83|Prg|CL_BP_GROUP_FACTORY===========CP | 83|14.07.2010|17:36:07| 19456|E |
| 84|Prg|CL_BP_CONST===================CP | 84|18.02.2005|14:12:50| 12288|E |
| 85|Prg|/1BCDWBEN/SAPLSENQ10 | 85|09.09.2004|14:18:14| 13312|E |
| 86|Typ|TBTCO | 0|04.12.2000|14:59:56| 12288| |
| 87|Prg|CX_SY_OPEN_SQL_DB=============CP | 87|14.07.2010|17:38:10| 13312|E |
| 88|Prg|CX_SY_OPEN_SQL_ERROR==========CP | 88|14.07.2010|17:38:10| 11264|E |
| 89|Prg|CX_SY_SQL_ERROR===============CP | 89|14.07.2010|17:38:10| 11264|E |
| 90|Prg|CX_DYNAMIC_CHECK==============CP | 90|14.07.2010|17:38:07| 11264|E |
| 91|Prg|CX_SY_NO_HANDLER==============CP | 91|14.07.2010|17:38:10| 11264|E |
| 92|Typ|SYST | 0|09.09.2004|14:18:12| 30720| |
| 93|Typ|ALRLRSNODE | 0|04.12.2000|13:12:25| 7168| |
| 94|Typ|BTCOMSDL | 0|16.03.1994|18:26:05| 3072| |
----------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------
|Directory of Application Tables |
----------------------------------------------------------------------------------------------------
|Name Date Time Lngth |
| Val. |
----------------------------------------------------------------------------------------------------
|Program SAPMSSY2 |
----------------------------------------------------------------------------------------------------
|SYST . . : : 00004612 |
| \0\0\0\0\x0002\0\x0013\0\0\0\0\0\x0001\0\0\0\0\0\0\0\x0001 |
|SY . . : : 00004612 |
| \0\0\0\0\x0002\0\x0013\0\0\0\0\0\x0001\0\0\0\0\0\0\0\x0001 |
|TBTCS . . : : 00000500 |
| SWWDHEX 11131400 |
|BTCCTL . . : : 00000308 |
| demoserver_BID_90 TIMESDL demose |
|TBTCO . . : : 00001296 |
| SWWDHEX 11131400 %NEWST |
|*TBTCO . . : : 00001296 |
| |
|BTCDELAY . . : : 00000268 |
| |
|*BTCOMSDL . . : : 00000122 |
| 00000000000000 00000000000 |
----------------------------------------------------------------------------------------------------
|Program SAPLBTCH |
----------------------------------------------------------------------------------------------------
|BTCOPTIONS . . : : 00000208 |
| |
----------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------
|ABAP Control Blocks (CONT) |
----------------------------------------------------------------------------------------------------
|Index|Name|Fl|PAR0|PAR1|PAR2|PAR3|PAR4|PAR5|PAR6|Source Code |Line |
----------------------------------------------------------------------------------------------------
|20101|9584| | | | | | | | | | |
| 5300|PAR1|10|0000| | | | | | |SAPMSSY2 | 3435|
| 5301|SQLS|24|0005| | | | | | |SAPMSSY2 | 3435|
| 5302|PAR1|00|0003| | | | | | |SAPMSSY2 | 3435|
| 5303|PAR1|00|0056| | | | | | |SAPMSSY2 | 3435|
| 5304|WHER|28|0002|0000|0000| | | | |SAPMSSY2 | 3435|
| 5306|WHER|20|0000|0000|00D9| | | | |SAPMSSY2 | 3435|
| 5308|PAR1|80|C005| | | | | | |SAPMSSY2 | 3435|
| 5309|WHER|20|0000|0001|00DA| | | | |SAPMSSY2 | 3435|
| 5311|PAR1|80|C006| | | | | | |SAPMSSY2 | 3435|
| 5312|SQLS|39|00A9| | | | | | |SAPMSSY2 | 3435|
| 5313|SQLS|3B|0000| | | | | | |SAPMSSY2 | 3435|
|>>>>>|SQLS|03|C000| | | | | | |SAPMSSY2 | 3435|
| 5315|cmpr|00|00E2|02C6|0000| | | | |SAPMSSY2 | 3439|
| 5317|BRAF|02|0003| | | | | | |SAPMSSY2 | 3439|
| 5318|comp|00|02DB|C007|0082| | | | |SAPMSSY2 | 3439|
| 5320|BRAF|02|001D| | | | | | |SAPMSSY2 | 3439|
| 5321|BREL|80|0000| | | | | | |SAPMSSY2 | 3439|
| 5322|TDEL|00|0000|8000|0000|0000|0000|0000|0000|SAPMSSY2 | 3440|
| 5326|CALC|00|8002| | | | | | |SAPMSSY2 | 3441|
----------------------------------------------------------------------------------------------------

Error.txt.zip

[Former Member]

Issue resolved did a fresh install!!

Regards

[Reagan]

Hello

SELECT TABLESPACE_NAME, STATUS FROM DBA_TABLESPACES;

SELECT NAME, FILE#, STATUS FROM V$DATAFILE;

Provide the output please

Regards

RB

[Former Member]

Hi Roy,

The datafile or tablespace the datafile belongs to is either offline or the datafile is corrupted.

Please use the below statement to find out the offline datafile.

SQL> select name, status from v$datafile where status not in ('ONLINE', 'SYSTEM') ;

Please paste the results.

Thanks and Regards,

Kunal Gahlot

[Former Member]

Kunal

The result of the select statement is below

SQL> select name, status from v$datafile where status not in ('ONLINE', 'SYSTEM') ;

NAME
-------------------------------------------

STATUS
-------
E:\ORACLE\BID\SAPDATA1\SR3_5\SR3.DATA5
OFFLINE

E:\ORACLE\BID\SAPDATA6\SR3_52\SR3.DATA52
OFFLINE

[Former Member]

Hi Roy,

Perform below steps:

SQL> recover datafile 'path to datafile';
SQL> alter database datafile 'path to datafile' online;

Hope it works.

Thanks and Regards,

Kunal Gahlot

[Reagan]

Hello

You have datafiles in offline mode.

You need to bring them online.

Note 328785 - ORA-00376: File cannot be read at this time

Regards

RB

[Former Member]

After bringing the files online the database wont open with the following error at startup:

SQL> startup
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS
ORACLE instance started.

Total System Global Area 2639106048 bytes
Fixed Size 2256016 bytes
Variable Size 1325400944 bytes
Database Buffers 1291845632 bytes
Redo Buffers 19603456 bytes
Database mounted.
ORA-01122: database file 8 failed verification check
ORA-01110: data file 8: 'E:\ORACLE\BID\SAPDATA1\SR3_5\SR3.DATA5'
ORA-01203: wrong incarnation of this file - wrong creation SCN

[Former Member]

After bringing the files online the database wont open due to the following error at startup:

SQL> startup
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS
ORACLE instance started.

Total System Global Area 2639106048 bytes
Fixed Size 2256016 bytes
Variable Size 1325400944 bytes
Database Buffers 1291845632 bytes
Redo Buffers 19603456 bytes
Database mounted.
ORA-01122: database file 8 failed verification check
ORA-01110: data file 8: 'E:\ORACLE\BID\SAPDATA1\SR3_5\SR3.DATA5'
ORA-01203: wrong incarnation of this file - wrong creation SCN

[Former Member]

What were you doing before you run into this problem? ORA-01203 mean creation SCN mismatch in the file header and in the control file. Please read about automatic data file verification and ORA-01122 in Note 696141 - Composite SAP Note: ORA-01122 (Reason and Prerequisites). You need to restore and recover the affected file. But before doing this carefully check all conditions that could cause this error.

[Former Member]

Hi,

Can you please check the below log.

Note 553854 - Oracle: Problems with file size limit

After the database was restored did you try and give below command.

sql> recover database;

What is the brtools version that you are using.

Thanks

Rishi Abrol

[Former Member]

We are using Brtools 720, we only restored the database with brtools without executing the command:

sql>recover database;

Instead we tried the command below for the missing datafiles

sql>recover datafile 'path to datafile' ;

[former_member185239]

Hi Roy,

Activity to perform.

1. stop the database.

2. start the database again.

checked if any issue you are facing. If yes , paste the screen shot

3. You need to check , whether the data file exist or not

E:\ORACLE\BID\SAPDATA1\SR3_5\SR3.DATA5 and also checked the permission.

4. Run sql command

Alter database backup controlfile to trace ;

on running this, you will get a trace file in usertarce directory and paste out here.

With Regards

Ashutosh Chaturvedi

[Former Member]

Hi,

The only thing that i am thing that the database came up and is running as sap system can connect it.

Can you see any alert in the alert log of the database. If yes please post it.

If not issues in the db alert log So database is not an issues

Can you please check this note . I know that the version of the note is quite old. Can you try to set the below parameter.

for the below code returned

Note 81499 - No reconnect after offline backup

Just some suggestions...

Thanks

Rishi Abrol

[former_member188883]

Hi Roy,

1) Check whether this file is physically available and it has the similar timestamp like other datafiles

'E:\ORACLE\BID\SAPDATA1\SR3_5\SR3.DATA5'

2) Please check whether do you have any files still to be recovered using

SQL> select * from v$recover_file;

3) Check alert_SID.log for more details of the error. For eg: If there is any corruption with the datafile.

Hope this helps.

Regards,

Deepak Kori

[priyaranjan_gupta]

Hi,

see if below thread can help you.

http://scn.sap.com/thread/1225661

~Priyaranjan