Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

Tags:
Not what you were looking for? View more on this topic or Ask a question