Hi Team,
We are doing upgradation from 8.3 to 8.4, we are getting an error while we run the upgrde_identityiq_table slq file in DB, can you please help on this
Hi @sureshbomm, with which ever user you are running upgrade commands, you either don’t have permissions to run or identity access history database is not created.
identity access history database is created as part of version 8.4.
Just want to understand do we need to create a new user identityiqah for creating new identity access history DB
no need to create new user as long as permissions are present to create the identityah database thats enough
1 Like
Please check the upgrade script, You would need to create the new user name and password for the new database/schema you are creating. First see if you have permission to create the new database/schema, if not, ask your dba to create the database/schema, and then run the run the upgrade script.
SailPoint recommends using separate databases for IdentityIQ and IdentityIQ AH .
- After creating the AH DB, add the new DB user and password for it in
iiq.propertiesso IIQ can connect to both databases.
I have created identityiqah and executed script but we are getting version checker issue, I have seen the system version is still 8.3.xx but the schema_ version 8.4.xx in spt_database_version. Please let me know what is the issue What is the issue
Did you run iiq upgrade script? Check whether you deleted the old 8.3 war file inside the webapps directory, because whenever you restart tomcat it will try to redeploy.
Hi @sureshbomm
Refer this article - https://developer.sailpoint.com/discuss/t/failing-to-upgrade-to-iiq-8-4/162383
Make sure the user that you are using for upgrade have proper permissions and in the database check the user mapping has correct schema defined. In the above blog comments have all the details and steps.
did you check in all your databases, what is the schema version schema_version" showing when you run the query
`1.select schema_version from identityiq.spt_database_version" & identityiqah` ??,
2. select schema_version from identityiqah.spt_hist_database_version
if there is a version mismatch, can you please update the schema_version to the 8.4 “8.4-87”
post updating it run the upgrade script. It should fixed your error.
@sureshbomm , I encountered the same issue during our upgrade. You’ll need to coordinate with your DBA to prepare the necessary script in collaboration with the DBA team, and ensure it’s executed using the root DBA use.
Make sure the newly created identityiqah database has the following required permissions.
ALTER USER identityiqah WITH DEFAULT_SCHEMA = identityiqah;
Thanks,
Unable to check IdentityIQ database version: Unable to connect to: jdbc:sqlserver://testserver:1433;databaseName=identityiq;
2025-09-22T02:11:15,469 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
We are getting this error, we have not added the identityiqah DB details in the IIQ props file, if we add those details it is showing the same error but it is not connecting to the identityiqah insted of identityiq DB.
Hi @sureshbomm
Note:
There’s no need to update the schema_version in the tables below during a fresh installation, but it might be necessary during an upgrade.
update identityiqah.spt_hist_database_version set schema_version = '8.4-87' where name = 'main':
commit;
update identityiq.spt_database_version set schema_version = '8.4-87' where name = 'main';
commit;
Please refer below comment: on top of these cross check the driver file at ../lib folder and iiq.properties file DB connection details, try to delete temp and work folder then try it out.
The error usually comes when the iiq.properties is not configured properly for both identityiq and identityiqah databases. Make sure the connection string is pointing to the correct DB, the driver in /lib matches SQL Server version, and the DB user has permissions on both schemas
1 Like
Common Cause of Error: Improper iiq.properties Configuration
This error typically occurs when the iiq.properties file is not correctly configured for both the identityiq and identityiqah databases. To resolve it, ensure the following:
-
The connection strings point to the correct databases.
-
The JDBC driver in the
/libdirectory matches the version of SQL Server in use. -
The database user has appropriate permissions on both schemas (
identityiqandidentityiqah).
Thanks,@siva
Hi @sureshbomm
When running database scripts that create databases, it’s important to ensure the passwords set in the script comply with the database’s password policy. If a script creates a user without setting a valid password, or if the password doesn’t meet the policy requirements—such as length, complexity, or expiration rules—the account may not be created properly or may lack necessary permissions. Always verify that the script-defined password aligns with the current password policy settings of the database.
Unable to check IdentityIQ database version: Unable to connect to: jdbc:sqlserver://test:1433;databaseName=identityiqah;
2025-09-23T05:56:23,341 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://test:1433;databaseName=identityiqah;
Sep 23, 2025 5:56:23 AM org.apache.catalina.core.StandardContext listenerStart
SEVERE: Exception sending context initialized event to listener instance of class [sailpoint.web.StartupContextListener]
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://test:1433;databaseName=identityiqah;
Verfied Spt_database_version table in identityiq
System_version =8.3-45
schema_version = 8.4-87
We are getting above error. we are getting identityiq insted of identityiqah if we try with identityiq details only in iiq file. we can able to connect to DB using MSSM app using same username and passowrd, there is no issue with username and paasword
Please suggest if any steps and need to check
IdentityIQ is generic message if the version details missing in either of the databases(identityiq or identityiqah)
Please check the identityiqah user mapping details from DB side.
Did you check below version details from identityiqah?
select * from identityiqah.spt_hist_database_version;
Verified in identityiqah database version table
System_version =8.4-00
schema_version = 8.4-87
Dear @sureshbomm
Please cross check your iiq.properties file whether you have updated the correct sections and user mapping details of identityiqah from DB side.