Skip to Content

BW load DBIF_RSQL_SQL_ERROR - ORA-01502

Dears

One of our customers has issues with a BW load throwing short dumps errors accompanied by Oracle errors as described below:

Shortdump

DBIF_RSQL_SQL_ERROR CX_SY_OPEN_SQL_DB

Description

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

[kdtdelrow-2], [34], [34], [], [], [], [], []#ORA-01502: index

'SAPSR3./BIC/B0000799000~0' or partition of such index is in unusable state"

Internal call code.........: "[RSQL/INSR//BIC/B0000799000 ]"

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

"DBIF_RSQL_SQL_ERROR" "CX_SY_OPEN_SQL_DB"

"GP4J7OV5C6IRCY04EBZ697IV37Y" or "GP4J7OV5C6IRCY04EBZ697IV37Y"

"INSERT_ODS"

I have checked on SCN and on Marketplace and found several references and notes.

1. 0.390 BW-SYS-DB-ORA 1558849 * ORA-1502 or ORA-900: index or partition of index is in unusa 24.02.2011

2. 0.380 BI-BIP-ADM 1387765 * Error: "ORA-01502: Index or partition of such index is in un 26.09.2009

I have ran the reports RSAR_PSA_PARTITION_CHECK and the Z program that is available through SAP Note 1558849 -> related SAP note 515711 but there are come back without any issues detected.

I also performed some database checks and they don't discover broken indexes.

The issue only seems to appear on /BIC/B tables. Can anyone provide me with information or give me more ideas where the issue could be situated or where I can discover the affected /BIC/B table indexes that seem to cause this issue?

Kind regards

Tom

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Apr 07, 2011 at 05:54 AM

    check note 1455000. there is a new version of program RSAR_PSA_PARTITION_CHECK (note 1338941).

    we recently encountered the same problem and it was solved by using the new program.

    M.

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 06, 2011 at 08:36 PM

    Hi Tom

    From SE11 first check /BIC/B0000799000 which table is this. This could be a Change Log, PSA or Transfer Strucre.

    Then from SE14 , activate and Adjust the Index for this particular table.

    SE14>Table Name>Index--->Select `0 index and Press "Adjust and Activate"

    Try to load now

    Regards

    Anindya

    Add comment
    10|10000 characters needed characters exceeded