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
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"
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