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: DROP INDEX [/BIC/FZMPCOTHSD].[/BIC/FZMPCOTHSD~02]
- SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
- SAP NetWeaver (NW) - All versions
sp_sjobhelp, sp_sjobmodify, deadlock, SP_COLLECT_DBH_INDEXES, SP_DBH_INDEXES , KBA , BW-SYS-DB-SYB , BW on Adaptive Server Enterprise , Problem
About this pageThis 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.