Symptom
- You are running SAP Extended Warehouse Management (EWM) application on SAP ASE database.
- Several, continuous deadlock errors are encountered on the /LIME/COLL_W2IM table while users execute any transaction within EWM.
- UPDATE processes on the /LIME/COLL_W2IM deadlock each other very frequently causing a disruption of user activity.
- Offending sql code:
UPDATE "/LIME/COLL_W2IM" SET "GUID_DISPATCH" = ? WHERE "MANDT" = ? AND "GUID_DISPATCH" = ? AND "GUID_COLL_GROUP" IN ( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ) /* R3:/LIME/SAPLDISPATCHER:15666 T:/LIME/COLL_W2IM M:100 */
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 15.7 for Business Suite
- SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
- SAP Extended Warehouse Management (EWM)
- SAP Netweaver (NW) 7.4
Product
SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP Extended Warehouse Management 7.0 ; SAP NetWeaver 7.4
Keywords
EWM, sybase, SQL1205, "SQL Error: 1205" , KBA , 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.