Symptom
- System job is getting cancelled with runtime error "DBIF_RSQL_SQL_ERROR"
- ST22 dump log shows:
Runtime Errors DBIF_RSQL_SQL_ERROR
Exception CX_SY_OPEN_SQL_DB
|Short text
|SQL error in the database when accessing a table.
- SQL Server ERRORLOG shows error message:
Error: 8646, Severity: 21, State: 1.
Unable to find index entry in index ID 1, of table 1112728854, in database 'SID'. The indicated index is corrupt or there is
a problem with the current update plan. Run DBCC CHECKDB or DBCC CHECKTABLE. If the problem persists, contact product support.
Read more...
Environment
• SAP Systems based on SAP NetWeaver
• Microsoft SQL Server 2005 and higher
Keywords
8646,DBIF_RSQL_SQL_ERROR,index is corrupt, DBCC CHECKDB, DBCC CHECKTABLE , KBA , BC-DB-MSS , SQL Server in SAP NetWeaver Products , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.