Status of Scheduler Diagnostics is 'Critical' with 'org.quartz.JobPersistenceException: Couldn't recover jobs: [FMWGEN][SQLServer JDBC Driver' errors

(Doc ID 2347158.1)

Last updated on JANUARY 18, 2018

Applies to:

BI Publisher (formerly XML Publisher) - Version 12.2 to 12c [Release 12.2 to 12.0]
Information in this document applies to any platform.

Symptoms

Scheduler of BI Publisher Enterprise failing with these error messages while clicking on 'Scheduler Diagnostics' from Navigation :- Administration => System Maintenance => Scheduler Diagnostics 

Quartz Start Error; org.quartz.SchedulerConfigException: Failure occured during job recovery. [See nested exception: org.quartz.JobPersistenceException: Couldn't recover jobs: [FMWGEN][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 80) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. [See nested exception: java.sql.SQLTransactionRollbackException: [FMWGEN][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 80) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.]]

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms