SAP Knowledge Base Article - Preview

2426378 - UPDATE /LIME/COLL_W2IM running into frequent deadlocks - SAP ASE for BS

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.