Getting below error while upgrading to 8.4 version ,can anyone suggest what this error
2026-04-28T12:29:49,514 WARN main springframework.context.support.ClassPathXmlApplicationContext:559 - Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘versionChecker’ defined in class path resource [configBeans.xml]: Invocation of init method failed; nested exception is java.lang.RuntimeException: Unable to check IdentityIQ database version: Unable to connect to: jdbc:sqlserver://sp-test-db\SAILPOINTTESTIIQ:1434;databaseName=identityiquat;encrypt=false;
org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘versionChecker’ defined in class path resource [configBeans.xml]: Invocation of init method failed; nested exception is java.lang.RuntimeException: Unable to check IdentityIQ database version: Unable to connect to: jdbc:sqlserver://sp-test-db\SAILPOINTTESTIIQ:1434;databaseName=identityiquat;encrypt=false;
As per the Error, it seems it is not able to connect to Database. Please check if your password is updated. If passowrd is changed then make the changes in the iiq.properties file.
Other items that you need to check is:
Check the network settings, try to do the telnet from the sailpoint server to the DB Server to see if the connectivity is present or not.
Also make sure your DB version is supported with the the Sailpoint version.
@lsaipriya26 - It would be good if you could check what is the value of select * from identityiq.spt_database_version If it says anything with 8.3 that means the upgrade scripts did not run correctly.
Execute this query → update identityiq.spt_database_version set system_version = '8.x-xx' where name = 'main';
Also, verify datasource in iiq.properties - dataSource.url=jdbc:mysql://localhost/identityiq?useServerPrepStmts=true&tinyInt1isBit=true&useUnicode=true&characterEncoding=utf8&useSSL=false&allowPublicKeyRetrieval=true
Hi @kannan_sb85 , Above error is solved actually dB was deleted ,so i had created it again and restore old dB and ran 8.4 upgrade table script , now getting below error,17
2026-04-30T07:01:34,173 ERROR main sailpoint.server.upgrade.Upgrader:1523 - Invalid object name ‘spt_database_version’.
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name ‘spt_database_version’.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:356) ~[mssql-jdbc-13.4.0.jre11.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1927) ~[mssql-jdbc-13.4.0.jre11.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:764) ~[mssql-jdbc-13.4.0.jre11.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:663) ~[mssql-jdbc-13.4.0.jre11.jar:?]
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7832) ~[mssql-jdbc-13.4.0.jre11.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:5024) ~[mssql-jdbc-13.4.0.jre11.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:364) ~[mssql-jdbc-13.4.0.jre11.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:282) ~[mssql-jdbc-13.4.0.jre11.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:577) ~[mssql-jdbc-13.4.0.jre11.jar:?]
at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:122) ~[commons-dbcp2-2.9.0.jar:2.9.0]
at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:122) ~[commons-dbcp2-2.9.0.jar:2.9.0]
at sailpoint.tools.JdbcUtil.queryString(JdbcUtil.java:474) ~[identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552]
at sailpoint.server.upgrade.Upgrader.getDatabaseSchemaVersion(Upgrader.java:1617) ~[identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552]
at sailpoint.server.upgrade.Upgrader.validateSchemaVersion(Upgrader.java:1495) [identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552]
at sailpoint.server.upgrade.Upgrader.validateSchemaVersions(Upgrader.java:1163) [identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552]
at sailpoint.server.upgrade.Upgrader.execute(Upgrader.java:1092) [identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552]
at sailpoint.server.upgrade.Upgrader.main(Upgrader.java:643) [identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552]
at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:?]
at jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77) ~[?:?]
at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?]
at java.lang.reflect.Method.invoke(Method.java:568) ~[?:?]
at sailpoint.launch.Launcher.main(Launcher.java:250) [identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552]
Please run the upgrade_identityiq_tables.* script first.
Tried Alter schema to set default schema to iiq and ah and for plugin still getting same error can you help what might be missing
@lsaipriya26 - First, check where the table actually exists. Run this query in your SQL Server Management Studio (SSMS):
SELECT s.name AS schema_name, t.name AS table_name
FROM sys.tables t
JOIN sys.schemas s ON t.schema_id = s.schema_id
WHERE t.name = 'spt_database_version';
The most common fix is to ensure the IIQ database user’s default schema matches the schema where the tables were created (usually identityiq or dbo).
Run the following (replace identityiq_user with your actual IIQ DB username):
ALTER USER identityiq_user WITH DEFAULT_SCHEMA = dbo;
If still the table is completely missing, you must manually run the versioning script found in your IIQ installation.
Finally Check your identityiq.properties file and ensure the sessionFactory.hibernateProperties.hibernate.default_schema property (if present) matches your SQL Server schema.