Skip to Content
avatar image
Former Member

error DBIF_RSQL_SQL_ERROR after upgrade Oracle DB from 8.1.7 to 9.2.0.

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Sep 24, 2007 at 08:55 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      am using the below:

      Platform - Solaris

      installed patchsets - 9207

      installed one off patches (unix)

      Thanks

  • Sep 24, 2007 at 01:25 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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

  • avatar image
    Former Member
    Sep 28, 2007 at 02:34 AM

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

    Add comment
    10|10000 characters needed characters exceeded