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.
SAP Knowledge Base Article - Preview