To overcome Deadlock issue while running events

Error:

org.quartz.JobPersistenceException: Couldn't update trigger state(s): Transaction (Process ID 69) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. [See nested exception: java.sql.SQLException: Transaction (Process ID 69) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.]

Cause:

Mostly this deadlock issue comes with “Microsoft SQL Server” when large number of events are activated.

Solution:

On facing above deadlock issue while running events, then we need to add the property below in “quartz.properties” file present in “<AdeptiaSuite_Installation_Directory>/ServerKernel/etc” folder. After adding this property we need to restart the “kernel” & “webrunner” to bring this property into effect.

Change the following property:

org.quartz.jobStore.acquireTriggersWithinLock = true