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

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 'sunspot'.
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 'sunspot'.
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 = `sunspot', user = `sa' program name = `isql' host processes = `19926' .

End of deadlock information.

 SCC deadlock Alert Configuration:

alert_config.png


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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.