IBM FileNet P8, Version 5.2.1            

Receiving deadlock errors when you federate large quantities of documents

When you federate large quantities of documents, export throughput is lower than expected and many errors appear in the exporter log.

Symptoms

The following error appears frequently in the exporter log:

ERROR - Unable to retrieve batch id='E8B1739C-FF4B-8B4B-9150-82BB21B54FA5' com.filenet.cfs.iice.federator.exception.DataAccessException: com.microsoft.sqlserver.jdbc.SQLServerException: Transaction (Process ID 59) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Transaction (Process ID 59) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

Causes

Excessive concurrency among export worker threads is causing contention for exclusive access to database resources, resulting in deadlocks.

Resolving the problem



Last updated: October 2015
p8pco022.htm

© Copyright IBM Corporation 2015.