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

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  

References

Add any references to other internal or external articles

​