SAP system’s Oracle Table Corruption – DBIF_RSQL_SQL_ERROR

If you get an error message “DBIF_RSQL_SQL_ERROR” with “SQL error in the database when accessing a table” detail information in your ST22 transaction then you should check the following steps for this issue…

We had this situation last week ;

All SM50 activities were hangs for the related database table , ST22 shown like below

SAP system's Oracle Table Corruption - DBIF_RSQL_SQL_ERROR

Detail of the messages were look like below screen

Database error text……..: “ORA-00600: internal error code, arguments:
 [ktspgsb-inc], [1], [0], [], [], [], [], [], [], [], [], []”
Internal call code………: “[RSQL/INSR/SXMSCLUP ]“
Please check the entries in the system log (Transaction SM21).

SAP system's Oracle Table Corruption - DBIF_RSQL_SQL_ERROR

None of process can use the table “SXMSCLUP

SAP system's Oracle Table Corruption - DBIF_RSQL_SQL_ERROR

We have decided to start REORG operation for this database table

On OS side execute the following syntax ;

brspace -f tbreorg -t SXMSCLUP

SAP system's Oracle Table Corruption - DBIF_RSQL_SQL_ERROR

SAP system's Oracle Table Corruption - DBIF_RSQL_SQL_ERROR

After this step had been completed (took several hours depending to table record count) , problem was solved…

 

 

 

 

Leave a Reply


five × = 25

Blogroll