Could not store trigger 'NJAMS.NJAMS_JOB_PROC_STATISTICS' for 'NJAMS.NJAMS_JOB_PROC

Products	Versions
TIBCO BusinessWorks ProcessMonitor	-
Not Applicable	-

Description

Description:

NJAMS.NJAMS_JOB_PROC_STATISTICS' with the following error stack.

2015-03-09 14:30:47,079 ERROR [QuartzScheduler_NJAMS-VDV1ARCHAPP031425925257082_MisfireHandler] org.quartz.impl.jdbcjobstore.JobStoreTX: MisfireHandler: Error handling misfires: Couldn't store trigger 'NJAMS.NJAMS_JOB_PROC_STATISTICS' for 'NJAMS.NJAMS_JOB_PROC_STATISTICS' job:Transaction (Process ID 85) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

org.quartz.JobPersistenceException: Couldn't store trigger 'NJAMS.NJAMS_JOB_PROC_STATISTICS' for 'NJAMS.NJAMS_JOB_PROC_STATISTICS' job:Transaction (Process ID 85) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. [See nested exception: com.microsoft.sqlserver.jdbc.SQLServerException: Transaction (Process ID 85) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.]

at org.quartz.impl.jdbcjobstore.JobStoreSupport.storeTrigger(JobStoreSupport.java:1212)

at org.quartz.impl.jdbcjobstore.JobStoreSupport.doUpdateOfMisfiredTrigger(JobStoreSupport.java:1026)

at org.quartz.impl.jdbcjobstore.JobStoreSupport.recoverMisfiredJobs(JobStoreSupport.java:975)

at org.quartz.impl.jdbcjobstore.JobStoreSupport.doRecoverMisfires(JobStoreSupport.java:3174)

at org.quartz.impl.jdbcjobstore.JobStoreSupport$MisfireHandler.manage(JobStoreSupport.java:3934)

at org.quartz.impl.jdbcjobstore.JobStoreSupport$MisfireHandler.run(JobStoreSupport.java:3955)

Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Transaction (Process ID 85) 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.SQLServerStatement.getNextResult(SQLServerStatement.java:1515)

at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPrepared Statement.java:404)

at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedS tatement.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.executeUpdate(SQLServerPreparedStatement.jav a:314)

at org.quartz.impl.jdbcjobstore.StdJDBCDelegate.updateTrigger(StdJDBCDelegate.java:1226)

at org.quartz.impl.jdbcjobstore.JobStoreSupport.storeTrigger(JobStoreSupport.java:1207)

Symptoms:
TIBCO BusinessWorks ProcessMonitor(bwpm) GUI hangs. In Main view it shows processing and loading is slow.

Cause:
Deadlock occurred in database and due to which stored procedure NJAMS_JOB_PROC_STATISTICS failed to execute.

Issue/Introduction

Could not store trigger 'NJAMS.NJAMS_JOB_PROC_STATISTICS' for 'NJAMS.NJAMS_JOB_PROC_STATISTICS' .

Resolution

While it is reported as an ERROR, it really is a WARNING. The BWPM server will retry the operation (NJAMS_JOB_PROC_STATISTICS) every minute. We can ignore the error and continue to monitor. If the issue persists then bounce the BWPM server or check the database which queries are blocking the stored procedure NJAMS_JOB_PROC_STATISTICS and creating deadlock.

Welcome to "KB Articles"