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

Products

• CA Cloud Test Mobile
• CA Application Test

Issue/Introduction

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: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'QRTZ_LOCKS'.]]

Cause

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

Environment

Release : 10.3

Component : CA Service Virtualization

Resolution

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.