Registry error: Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'PREF_LISA_VERSION'.

Products

• Service Virtualization

Issue/Introduction

After upgrading from DevTest 10.7.2 to DevTest 10.8.1, getting this error when starting the Registry:

2025-06-11T13:51:47,195Z (09:51) [main] ERROR com.itko.lisa.coordinator.TestRegistryImpl - Cannot determine previously installed DevTest version. You are running version older than 8.5.0
com.itko.lisa.exception.UpgradeException: Cannot determine previously installed DevTest version. You are running version older than 8.5.0
    at com.itko.lisa.utils.db.safeguard.DatabaseSafeGuard.getDBLisaVersion(DatabaseSafeGuard.java:193) ~[lisa-core-10.8.1.jar:?]
    at com.itko.lisa.utils.db.safeguard.DatabaseSafeGuard.checkIfMigrationIsPossible(DatabaseSafeGuard.java:120) ~[lisa-core-10.8.1.jar:?]
    at com.itko.lisa.utils.db.safeguard.DatabaseSafeGuard.checkIfDatabaseCanBeChanged(DatabaseSafeGuard.java:104) ~[lisa-core-10.8.1.jar:?]
    at com.itko.lisa.coordinator.TestRegistryImpl.main(TestRegistryImpl.java:2209) [lisa-core-10.8.1.jar:?]
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:?]
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77) ~[?:?]
    at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?]
    at java.base/java.lang.reflect.Method.invoke(Method.java:568) ~[?:?]
    at com.exe4j.runtime.LauncherEngine.launch(LauncherEngine.java:84) [i4jruntime.jar:?]
    at com.exe4j.runtime.WinLauncher$2.run(WinLauncher.java:90) [i4jruntime.jar:?]
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'PREF_LISA_VERSION'.
    at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:262) ~[mssql-jdbc-8.2.0.jre8.jar:?]
    at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1632) ~[mssql-jdbc-8.2.0.jre8.jar:?]

Context: This was not an upgrade in-place.  DevTest 10.8.1 was installed on a new server.  The Registry in the DevTest 10.7.2 was on Oracle.  A new Registry database was created on SQL Server and the data from Oracle Registry database was exported and then imported to SQL Server Registry database (still at the 10.7.2 schema).

 

NOTE: IAM and Enterprise Dashboard were running on the embedded database in 10.7.2, so new 10.8.1 IAM and Enterprise Dashboard databases were created on SQL Server.

Environment

DevTest 10.8.1 on Windows 2022

SQL Server 2022

Cause

The problem was because the DB User didn't have DB Owner privileges for the LISA DB.

What was interesting is that the same user that was used to create all the IAM and Enterprise Dashboard tables was used on for the Registry.  Even tried the sa userid and it failed as well.  Seems like userid, including sa, did not have dbowner privileges.  

Resolution

We created a new user name and made sure it had dbowner privileges.  Started the Registry and then the lisadb schema was updated from 10.7.2 to 10.8.1