This issue could be permission issue on new Accesshistory DB user -due to this while running upgrade it is not reading the dentityiqah.spt_hist_database_version- Please get support from DB admin to assign appropriate permission on new AccessHistory db user to read spt_hist_database_version in AH DB . I faced similar issue and it was resolved after deleting the new Access history DB and restore the old DB and took support from DB admin to run upgrade DB script manually from them.
Thanks for the below information @pravin_ranjan .
Can you also provide information related to JAR for PostgreSQL database that need to be placed in lib folder. Our current java version is java-17-openjdk-17.0.14.0.7-3.el8.x86_64.
Let me know if you need any additional information.
You can check from here : Download | pgJDBC
Still facing issue in migration/upgradation? recently we have completed migration to 8.4 came across similar issues but resolved it successfully.
the sql driver which we have used is: mssql-jdbc-12.6.3.jre11.jar let me know if you need any help.
Hi @pravin_ranjan ,Our Identityiq db is of tybe oracle and identityiqah db is postgresql.While running the upgrade command "upgrade_identityiq_tables.oracle " it is giving error “user ‘IDENTITYIQAH’ does not exist” seems that we need to run the command separately for identityiqah .Can you guide here ?
Dear Aishwary Kumar , not sure the combination of 2 database types will be supported by SailPoint, but you could give a try by keeping the respective drivers for oralce and postgresql.
note: comment out the Access History portion from the script when executing against oracle – line number 17 onwards till end.
similarly comment out the first 16 lines when you executing against postgresql DB.
Note: in iiq.properties point out the correct connection details for access history postgresql databse