SAP Knowledge Base Article - Preview

2891877 - Deadlock occurs frequently in saptools database of target ASE - SAP ASE for BW and BS

Symptom

1.SRS error log message

E. 2020/01/19 12:59:10. ERROR #1028 DSI EXEC(107(7) <DS>.<DB>) - neric/dsi/dsiqmint.c(5172)
Message from server: Message: 1205, State 1, Severity 13 -- 'Your server command (family id #0, process id #469) encountered a deadlock situation. Please re-run your command.

2.At target ASE

Deadlock Id 5: Process (Familyid 0, Spid 955, Suid 4) was executing a INSERT command in the procedure 'objid 0' at line 1 at nested level 2.

Deadlock Id 5: Process 955 was involved in application 'JS Agent - sapsa'.
Deadlock Id 5: Process 955 was involved on host name ''.
Deadlock Id 5: Process 955 was involved in transaction '$chained_transaction'.
Executing procedure: SP_DBH_INDEXES
Deadlock Id 5: Process (Familyid 0, Spid 1496, Suid 6) was executing a DROP INDEX command at line 1.
Deadlock Id 5: Process 1496 was involved in application 'RepServer'.
Deadlock Id 5: Process 1496 was involved on host name 'we1p304770004'.
Deadlock Id 5: Process 1496 was involved in transaction '$DROP INDEX /BIC/FZMPCOTHSD./BIC/FZMPCOTHSD~02 ID=1537046572 from ddl'.
SQL Text:
SQL Text: DROP INDEX [/BIC/FZMPCOTHSD].[/BIC/FZMPCOTHSD~02]


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
  • SAP NetWeaver (NW) - All versions 

Product

SAP enhancement package 2 for SAP NetWeaver 7.0

Keywords

sp_sjobhelp, sp_sjobmodify, deadlock, SP_COLLECT_DBH_INDEXES, SP_DBH_INDEXES , KBA , BW-SYS-DB-SYB , BW on Adaptive Server Enterprise , 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.