Symptom
- There was an Error 12313 which caused an internal "database shutdown"
- After few seconds of the internal database shutdown, ASE was trying to recover the DB but if failed.
- ASE errorlog messages include :
Error: 12313, Severity: 21, State: 1
Internal error: Insert into page id 2038 of index id 11 of table 'Table7' (id = 1888006726) in database 'SID' tried to replace undeleted RID (4188,21) at slot 269 and ridposn 0. Try dropping and recreating the index.
A transaction in database 'SID' (spid=37) has hit a fatal error during rollback. ASE will try to reboot an d recover the database. The XREC_BEGINXACT of this failing transaction is (838803, 129).
.........................................
---------- Shutting Down Database 'SID' ----------
.........................................
Database SID with dbid 4 is already shut down.
Error: 2259, Severity: 16, State: 1
Warning: System process 13 is using the database 'SID', dbid 4 while a database shutdown is being attempted. If the database shutdown is unsuccessful, retry it later.
Database SID with dbid 4 is already shut down.
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 16.0 SP03 & SP04
- Use of in-row LOB (text) tables
- This issue is not limited to BOBJ systems only, but appears to be mostly in that environment due to use of in-row LOB for certain BOBJ tables
Product
SAP Adaptive Server Enterprise 16.0
Keywords
Error 12313, CR821309, CR827506 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , 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