Exception occurred Module POMCM Method JobContactBO.java.updateActionState Exception Type org.hibernate.exception.LockAcquisitionException: could not execute update query, please see POM log files for details
Cause
If you use MS SQL Server 2012 database and you see campaigns stuck in load scenarios, the READ_COMMITTED_SNAPSHOT parameter in the database is not set to ON.
Proposed solution
Before you begin
Stop all POM servers and stop vpms services.
After you create a database or after you run the installDB.sh script, set the value of the READ_COMMITTED_SNAPSHOT parameter to ON.
To run the installDB.sh script, run the following command:
ALTER DATABASE <database_name> SET READ_COMMITTED_SNAPSHOT ON
