search cancel

Failure obtaining db row lock: Invalid object name 'QRTZ_LOCKS'


Article ID: 201316


Updated On:


CA Cloud Test Mobile CA Application Test


Received error when starting up Enterprise Service Dashboard in 10.3

  • WARN  org.flywaydb.core.internal.command.DbMigrate - Schema [dbo] has a version (16) that is newer than the latest available migration (15) !
  • ERROR dradis.Application - Exception: Failed to start bean 'quartzScheduler'; nested exception is org.springframework.scheduling.SchedulingException: Could not start Quartz Scheduler; nested exception is org.quartz.SchedulerConfigException: Failure occured during job recovery. [See nested exception: org.quartz.impl.jdbcjobstore.LockException: Failure obtaining db row lock: Invalid object name 'QRTZ_LOCKS'. [See nested exception: Invalid object name 'QRTZ_LOCKS'.]]


Release : 10.3

Component : CA Service Virtualization


The Enterprise Dashboard database was upgraded to 10.4 mistakenly, then the user tried to connect the upgraded database to Enterprise Dashboard 10.3


In this specific issue; the QRTZ* tables have been removed in the 10.4 release, so when trying to connect it back to the 10.3 Enterprise Dashboard, these tables were missing.

When you connect a newer version of DevTest to an Enterprise Dashboard or Registry database then that database will be automatically upgraded.  Once the database is upgraded to the newer version, then the database cannot go back to the older version.