CAPIM : ENTM cleanup deadlock problem

Document ID : KB000117348
Last Modified Date : 11/10/2018
Show Technical Document Details
Issue:
If we try to run "cleanup feature" to remove data of database manually,
we may see the following deadlock errors in server.log file.
==
2018-08-19 15:49:05,808 ERROR [com.ca.ppm.elm.jobs.SendAuditMsgToTibcoQueueJob] com.microsoft.sqlserver.jdbc.SQLServerException:
Transaction (Process ID 55) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)
 at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:254)
 at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:84)
 at com.microsoft.sqlserver.jdbc.SQLServerResultSet.(SQLServerResultSet.java:311)
 at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1526)
 at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:404)
 at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:350)
 at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)
 at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)
 at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180)
 at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155)
 at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:285)
 at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:342)
 at com.ca.ppm.audit.provider.impl.AuditProviderImpl.getAuditCount(AuditProviderImpl.java:511)
 at com.ca.ppm.elm.jobs.SendAuditMsgToTibcoQueueJob.execute(SendAuditMsgToTibcoQueueJob.java:153)
 at org.quartz.core.JobRunShell.run(JobRunShell.java:203)
 at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)
==
Environment:
Windows
CA PIM ENTM r12.9SP2 
Resolution:
Please add the following lines in the end of "C:\jboss-4.2.3.GA\server\default\deploy\IdentityMinder.ear\config\quartz.properties".
org.quartz.jobStore.lockOnInsert = true
org.quartz.jobStore.useDBLocks = true