SAP Knowledge Base Article - Preview

3364790 - Blocking or Deadlocks on DFacetCacheCore are causing stability or performance issues in SAP Extended ECM by OpenText

Symptom

In Extended ECM after upgrading to one of the affected versions you or your DBA may start to see performance issues tied to queries associated with the DFacetCacheCore table. The affected queries that are blocking or deadlocking each other may look like the following:
UPDATE DFacetCacheCore SET DateAdded = :A1, Data = :A2, Deleted = 0, DescendantCount = :A3 WHERE 6=6 AND DataID = :A4 AND k1 = :A5 AND k2 = :A6 AND k3 = :A7 AND k4 = :A8 
INSERT INTO KMutex ( Section, TimeAdded ) VALUES ( :A1, :A2 ) 


Read more...

Environment

SAP Extended ECM by OpenText

Product

SAP Extended Enterprise Content Management by OpenText all versions

Keywords

KBA , XX-PART-OPT-ECM , SAP Extended Enterprise Content Management by OpenText(xECM) , 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.