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.
Missing database optimization
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
|Kofax analytics for capture||2.1||220.127.116.11||N/A||N/A|
Add any references to other internal or external articles