1. Download identityiq-8.1.zip from Compass.
2. Stop the IdentityIQ application.
3. Take a backup of the DB and jar the IdentityIQ installation directory.
4. Copy WEB-INF/classes/iiq.properties and log4j.properties to /tmp.
5. Delete all from /tomcat/webapps/identityiq directory. Unzip identityiq-8.1.zip and copy identityiq.war to /tomcat/webapps/identityiq. jar –xvf identityiq.war
Note: If you have SSB/SSD used in your environment for build, do the build the war file and copy paste the war file.
Reference for the Build procedure using SSD:
Quick Deployment/Patch Upgrade Procedure using SSD
Quick Deployment along with Patch and Accelerator Pack Procedure using SSD
6. Copy /tmp/iiq.properties and log4j.properties to WEB-INF/classes.
7. Run upgrade DDL: log into mysql; source upgrade_identityiq_tables.mysql.
8. Launch the console (from WEB-INF/bin: ./iiq console). Import sp.init-custom.xml. (This reloads all upgraded managed XML objects.)
Note: If you face any error opening iiq console
C:\Tomcat\webapps\identityiq\WEB-INF\bin>iiq console -u spadmin -p admin
Setting iiq.hostname to xyy-console
Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
2020-08-20T11:14:57,523 WARN main springframework.context.support.ClassPathXmlApplicationContext:557 - 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 sailpoint.api.DatabaseVersionException: System version 8.1-46 does not match database version 8.0-28
Execute this query --> update identityiq.spt_database_version set system_version = '8.1-46' where name = 'main';
9. Restart the application.
10. Perform all test cases (according to your test plan documents).
