Issue with SailPoint IIQ Upgrade from 8.3 to 8.4

GutteStolt · April 8, 2025, 1:41pm

Hi All,

I am working on upgrading SailPoint IdentityIQ from version 8.3 to 8.4 and have encountered an issue during the process.

So far, I have followed the below upgrade steps,

Download identityiq-8.4.zip from Compass.
Stop the IdentityIQ application.
Take a backup of the DB and jar the IdentityIQ installation directory.
Copy WEB-INF/classes/iiq.properties and log4j.properties to /tmp.
Delete all from /tomcat/webapps/identityiq directory. Unzip identityiq-8.4.zip and copy identityiq.war to /tomcat/webapps/identityiq. jar –xvf identityiq.war
Copy /tmp/iiq.properties and log4j.properties to WEB-INF/classes.

but I am stuck at Step 7. When trying to upgrade the IIQ tables from the command line, the system is unable to open the .sql file. Should I manually execute these SQL queries using a database tool? If so, who this will happen ?

Please let me know if any additional details are needed. Appreciate any guidance!

vishal_kejriwal1 · April 8, 2025, 2:28pm

It could be permission issue .
Yes you can manually execute query using database tools . ( no issue at all )

pravin_ranjan · April 9, 2025, 1:38am

@GutteStolt add on vishal,

iiq.properties and log4j.properties ( it should be log4j2.properties)

also in 8.4, you have diffs in iiq.properties and log4j2.properties so you need to update your old properties files. you cannot directly copy paste from 8.3 to 8.4.

In 8.4, we have access history db and it’s entries in properties files.

this document is very good : IdentityIQ Upgrade Plan document template - Compass

also, you need to download the external jar that was no longer provided with iiq now. I mean sqljdbc driver.

enjoy

GutteStolt · April 9, 2025, 9:18am

Hi @pravin_ranjan ,

Thanks you for the information.

In 8.4 what are the exact diffs in iiq.properties file. I have compared the both(old and new one) iiq.pro file. As you mentioned the i can the Access history. But not understand completely what need to do with that.

If we simply copy past the existing the iiq.pro and log4j.prof files what will the impact/issue?

What exact changes i need to do new iiq. pro and log4j.pr files and what will be deifies?

Thanks,
Shubham

GutteStolt · April 24, 2025, 10:28am

Hi @pravin_ranjan

As you mentioned, I encountered an error while running the IIQ upgrade command. After that, I added the JDBC JAR file to the lib folder as suggested.

However, I’m still receiving the following error message:

Could this be related to the iiq.properties file configuration?

Thanks,

pravin_ranjan · April 24, 2025, 1:28pm

check the compatible driver

Support matrix - JDBC Driver for SQL Server | Microsoft Learn

check this thread, it might be some permission issue also

Update 8.1p4 to version 8.2 error in the database - IdentityIQ (IIQ) / IIQ Discussion and Questions - SailPoint Developer Community

GutteStolt · April 24, 2025, 1:55pm

Hi @pravin_ranjan

I have validated the version compatibility. We have java jdk 11 for that have added the mssql-jdbc-12.8.0.jre11.jar file but still same error we are getting.

Thanks

LarryG · April 24, 2025, 2:24pm

Unfortunately, the document you reference has not been updated for upgrading to 8.4. The last upgrade it references is 8.3p2. Since there are database changes in 8.4, the document isn’t really good for upgrading to current.

pravin_ranjan · April 24, 2025, 2:33pm

Can you please share the steps ? is it same as above as below

Download identityiq-8.4.zip from Compass.

Stop the IdentityIQ application.

Take a backup of the DB and jar the IdentityIQ installation directory.

Copy WEB-INF/classes/iiq.properties and log4j.properties to /tmp.

Delete all from /tomcat/webapps/identityiq directory. Unzip identityiq-8.4.zip and copy identityiq.war to /tomcat/webapps/identityiq. jar –xvf identityiq.war

Copy /tmp/iiq.properties and log4j.properties to WEB-INF/classes.

also when u copied the sql jdbc driver ? if possible then share the iiq.properties file.

GutteStolt · April 24, 2025, 2:50pm

Hi @pravin_ranjan

Related to the access db history that are all changes i need to do. i don’t have added those entry in the new iiq.proererties file. I have attached the iiq.properties file here.
iiq.properties (1.8 KB)

pravin_ranjan · April 24, 2025, 3:02pm

I don’t think you can do upgrade without access history db. by default it was disabled so you only need to create access history db and it’s tables.

I will check again and see it was mentioned in doc.

“The Access History feature is enabled by default for new installations but is disabled by default for upgrades, due to configuration requirements. Refer to the IdentityIQ Access History guide for information on how to configure and enable this feature.”

What’s New in IdentityIQ 8.4 - Compass

pravin_ranjan · April 24, 2025, 3:11pm

@GutteStolt in Installation doc it mentioned

Note: As of 8.4, there is a new identityiqah database, which supports the new Access History feature. The identityiqah database must be created as part of the installation, even if you do not intend to use the Access History feature.

8.4 IdentityIQ Installation Guide - Compass

GutteStolt · April 24, 2025, 3:15pm

Hi @pravin_ranjan

The database is created. What are the details i need to update in the iiq.properties file.

pravin_ranjan · April 24, 2025, 3:28pm

You have to update entry for access History

##### Access History ####

##### Data Source Properties for Access History #####
dataSourceAccessHistory.maxWaitMillis=10000
dataSourceAccessHistory.maxTotal=50
dataSourceAccessHistory.minIdle=5
#dataSourceAccessHistory.minEvictableIdleTimeMillis=300000
#dataSourceAccessHistory.maxOpenPreparedStatements=-1

dataSourceAccessHistory.username=identityiqah
dataSourceAccessHistory.password=PWD

also Inside

### MSSQL Server ###

harrypatrick · April 24, 2025, 3:50pm

The error java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver means SailPoint can’t find the SQL Server driver. It’s usually expected in /identityiq/WEB-INF/lib.

However, since this is happening in the console (not the main app), something might be off. To check, go to /identityiq/WEB-INF/bin and run:

java -cp "mssql-jdbc-12.8.0.jre11.jar" com.microsoft.sqlserver.jdbc.SQLServerDriver

If you still see the ClassNotFoundException, it means Java can’t find the driver. In that case, add the JAR to your classpath and try again.

GutteStolt · April 25, 2025, 7:04am

Hi @pravin_ranjan ,

I have added the access history details in the iiq.properties file. Now i have encountered the below error msg.

Is this error related to the db misconfiguration?.

thanks,

GutteStolt · April 25, 2025, 11:48am

Hi @pravin_ranjan
Can you please help me with this?
Thanks

pravin_ranjan · April 25, 2025, 2:04pm

can u run this query in db ?

select * from identityiq.spt_database_version;

also check one more step, you might need to change identityiqah as default schema for identityiqah

thread :

Upgrade from 8.3 to 8.4 error - Invalid object name “spt_database_version” - IdentityIQ (IIQ) / IIQ Discussion and Questions - SailPoint Developer Community

aishwarykumar4050 · May 6, 2025, 1:57pm

Hi @pravin_ranjan can you tell me about JAR is required if my db type is Oracle .Please specify the link

pravin_ranjan · May 6, 2025, 2:02pm

Required JDBC Driver JAR Files - Compass