cancel
Showing results for 
Search instead for 
Did you mean: 

error DBIF_RSQL_SQL_ERROR after upgrade Oracle DB from 8.1.7 to 9.2.0.

Former Member
0 Kudos

Hi, I encounter this error in ST22 after I upgrade our Oracle database from 8.1.7 to 9.2.0.

All my released job are unable to trigger by itself.

Appreciate anyone can advice on this. Thanks

-


ABAP runtime errors DBIF_RSQL_SQL_ERROR

Occurred on 24.09.2007 at 00:00:35

SQL error 600 occurred when accessing table "TBTCS ".

How to correct the error

Database error text........: "ORA-00600: internal error code, arguments:

[12700], [44411], [155358993], [34], [25230726], [25], [], []?"

Internal call code.........: "[RSQL/FTCH/TBTCS ]"

Please check the entries in the system log (Transaction SM21).

If the error occurred in a non-modified SAP program, you may be

able to find a solution in the SAP note system.

If you have access to the note system yourself, use the following

search criteria:

"DBIF_RSQL_SQL_ERROR"

"SAPMSSY2 " or "SAPMSSY2 "

"SELECT_TIME_TRIGGERED_JOBS"

Message was edited by:

J L

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Thanks all, problem solved. I Rebuild the TBTCS indexes.

former_member204746
Active Contributor
0 Kudos

it might be a corrupted table/index:

try to rebuild ALL TBTCS indexes, then:

sqlplus "/ as sysdba"

ANALYZE TABLE SAPR3.TBTCS VALIDATE STRUCTURE CASCADE;

provide results.

Former Member
0 Kudos

please have a look at the following SAP Notes:

365481 - Block corruptions

786645 - Explanations for spontaneous corrections of corrupt blocks

and 23345 - Consistency check of ORACLE database

it looks like corrupted ORACLE blocks.

Best regards

Former Member
0 Kudos

can you please put a little light on the Oracle 9.2 version you are running

- Platform

- installed patchsets

- installed one off patches (unix) minipatches (windows).

peter

Former Member
0 Kudos

am using the below:

Platform - Solaris

installed patchsets - 9207

installed one off patches (unix)

Thanks