Skip to Content
0
Nov 06, 2012 at 10:32 AM

Upgrade SAP BW 7.3 - error on DSO activation

155 Views

Our SAP basis team has upgraded our BW system from version 7.0 tot version BW 7.3 (SAPKW73008). Now I am testing the etl flows.

I have loaded some data to a dso. On activation, i am getting an error caused by a short dump with following details. It seems to me there is a problem with the index tables of certain BW objects after the upgrade.

Does anybody know how to solve this problem?

Category ABAP Server Resource Shortage

Runtime Errors DBIF_RSQL_SQL_ERROR

Except. CX_SY_OPEN_SQL_DB

Date and Time 06.11.2012 10:07:04

Short text

SQL error 600 while accessing table "/BIC/B0000328000".

What happened?

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

[qerltcUserIterGet_1], [37], [37], [], [], [], [], [], [], [], [], []

ORA-01502: index 'SAPSR3./BIC/B0000328000~0' or partition of such index is in unusable state"

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 "INSERT_ODS" "(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:

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

[qerltcUserIterGet_1], [37], [37], [], [], [], [], [], [], [], [], [

ORA-01502: index 'SAPSR3./BIC/B0000328000~0' or partition of such index is in unusable state"

Kr, Guy Verschueren