Wednesday, 30 January 2019

ORA-00600: internal error code, arguments: [ktspfpblk:kcbz_objdchk], [0], [0],

Symptom:

ORA-00600,ORA-00600: [ktspfpblk:kcbz_objdchk],[0], [0], ,DBSQL_SQL_ERROR,CX_SY_OPEN_SQL_DB,
Index Corruption

Solution:

1. Check if you have any runtime errors in ST22:

Runtime Errors DBSQL_SQL_ERROR
Exception CX_SY_OPEN_SQL_DB
Date and Time 08.01.2019 15:44:06
Parameters:
P1 "DDXTF"
P2 "SQL code: 600"
P3 "SQL message: ORA-00600: internal error code, arguments:
[ktspfpblk:kcbz_objdchk], [0], [0], [1], [], [], [], [], [], [], [], []"
P4 "SQL dbsl rc: 99"

2. Check if you can identify the table having the issue from the runtime error:


Here issue is with table "DDXTF"

4. Analyze the table and the associated index to solve the issue:

Save the structure of the index.
Drop the index.
Recreate the index

Follow the below link for the detailed steps :

Hope this helps!!!
Abraham



No comments:

Post a Comment