SAP Knowledge Base Article - Preview

2034945 - SCC is not reporting deadlocks even though the alert has been configured - SAP ASE

Symptom

  • ASE is configured to print deadlock information  in the errorlog  via  configuration parameter,  'print deadlock information = 1'. 
  • SCC is configured to send  a warning ALERT on the deadlock when the count = 1.  
  • After a deadlock occurs ASE does log the information but SCC does not send the expected ALERT.
  • A snippet of the deadlock message reported by ASE

    server  Deadlock Id 5 detected
    Deadlock Id 5 detected. 1 deadlock chain(s) involved.
    Deadlock Id 5: Process (Familyid 0, Spid 15, Suid 1) was executing a UPDATE command at line 3.
    Deadlock Id 5: Process 15 was involved in application 'isql'.
    Deadlock Id 5: Process 15 was involved on host name 'test'.
    Deadlock Id 5: Process 15 was involved in transaction '$user_transaction'.
    SQL Text: UPDATE tempdb.dbo.foo SET col1 = 1
    Deadlock Id 5: Process (Familyid 0, Spid 16, Suid 1) was executing a UPDATE command at line 1.
    Deadlock Id 5: Process 16 was involved in application 'isql'.
    Deadlock Id 5: Process 16 was involved on host name 'test'.
    Deadlock Id 5: Process 16 was involved in transaction '$user_transaction'.
    SQL Text: UPDATE tempdb.dbo.bar SET col1 = 1
    Deadlock Id 5: Process (Familyid 0, Spid 16) was waiting for a 'update page' lock on page 897 of table 'bar' in database 'tempdb' but process
    (Familyid 0, Spid 15) already held a 'exclusive page' lock on it.
    Deadlock Id 5: Process (Familyid 0, Spid 15) was waiting for a 'update page' lock on page 889 of table 'foo' in database 'tempdb' but process
    (Familyid 0, Spid 16) already held a 'exclusive page' lock on it.
    Deadlock Id 5: Process (Familyid 0, Spid 15) was chosen as the victim.
    Victim process host = `test', user = `sa' program name = `isql' host processes = `19926' .


Read more...

Environment

  • Sap Control Center Framework - 3.2.7
  • SCC Management Agent Plugin - 3.2.7
  • ASE Management Agent Plugin - 3.2.8
  • SAP Adaptive Server Enterprise (ASE)  15.7

Product

SAP Adaptive Server Enterprise 15.7 ; SAP DB Control Center all versions

Keywords

Sap control center, KPI, deadlocks , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , 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.