[Please insert images here, otherwise delete this section]
Please share any other relevant files that may be required (for example, logs).
[Please insert files here, otherwise delete this section]
Share all details about your problem, including any error messages you may have received
We are trying upgrade from 8.3p2 to 8.5.We are successful to upgrade to 8.4 and after that we have updated java version, updated database schema version further to 8.5.In the final step where are are running ./iiq upgrade , we are running in to the attached issue .This same iiq.properties file used in 8.4 .We have also replaced the ojdbc8 with ojdbc11.
Validation Point#1 correct driver jar file
Please verify whether you have the driver file. Check the WEB-INF/lib folder to ensure the driver has been copied from the backup or the previous version of the application.
Validation Point#2 iiq.properties file.
Update the iiq.properties file from scratch, entering the connection details one by one from the backup file. Additionally, there is a new DB access history section; please update that accordingly.
Validation Point#3 system/schema version details.
Finally, check spt_database_version and spt_hist_database_version to confirm the current state of the system and schema versions. This will indicate the current progress of the migration."
The upgrade is failing because IdentityIQ cannot connect to the database at all.
Both the JDBC URL and driver class are coming as null/empty, which means the DB configuration is not being read.
This usually happens when iiq.properties is missing, incorrect, or not loaded.
It can also occur if the JDBC driver JAR is not present in WEB-INF/lib.
Because the DB connection fails, IIQ cannot check the schema and throws a misleading table upgrade