Symptom
- ASE error log reports error 1289
- Most commonly seen on dbcc commands (but not limited to this type of command)
Error: 1289, Severity: 20, State: 3
Internal Error in lock manager routine: Invalid lock mode exclusive page, requested by task (family id 123, spid 45) conflicts with existing family request mode exclusive page belonging to task (family id 123, spid 67). - The ASE error log may contain warnings of a shortage of meta data descriptors:
- Usually a warning for just 1 of the parameter types is reported, most likely indexes or partitions:
Increase the config parameter 'number of open partitions' to avoid descriptor reuse. Reuse may result in performance degradation.
Increase the config parameter 'number of open indexes' to avoid descriptor reuse. Reuse may result in performance degradation.
Increase the config parameter 'number of open objects' to avoid descriptor reuse. Reuse may result in performance degradation.
- Usually a warning for just 1 of the parameter types is reported, most likely indexes or partitions:
- As a result
- Messages are printed that dbcc checks failed, for example:
Checkstorage check aborted for dbid '4', objid '1943506995', indid '2'. Type of check 'index chain'. Total checks aborted '1'. - ASE may become unresponsive, requiring a reboot to clear the situation
- Messages are printed that dbcc checks failed, for example:
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE)
- 16.0 SP03 PL12, PL13 & PL14
- 16.0 SP04 PL03 & PL04
Product
SAP Adaptive Server Enterprise 16.0
Keywords
sp_dbcc_runcheck , sp_dbcc_recommendations , checkstorage, 'open indexes', 828339, CR 828339, CR#828339, hangs, unresponsive , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BW-SYS-DB-SYB , BW 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.