Skip to main content
Kofax

The transaction was blocked on the locked resources by another process and was chosen as a victim

Article # 3035140 - Page views: 34

Article # 3035140 - Page views: 34

Issue

When running hourly plan:

Can't execute query. The transaction (process ID 70) was blocked on the locked resources by another process and was chosen as a victim. Run the transaction back.

 

Cause

Missing database optimization

 

Solution

1. Increasing capacity for SQL server

2. Set SkipWritingWhenEPIsRunning to 1 in Listener config file (C:\Program Files\KFX Web Agent\Web.config). Set value to 1 to prevent data from being written to the Data database while the Hourly Plan is running.

3. Ask DBA to rebuild all indexes on kafc_data database, it will help improve query speed.

4. Delete old unnecessary data from KAFC database.

 

Level of Complexity 

Moderate

 

Applies to  

Product Version Build Environment Hardware
Kofax analytics for capture 2.1 2.1.0.3 N/A N/A

References

Add any references to other internal or external articles

  • Was this article helpful?