Upgrade from 8.3p2 to 8.4

IdentityIQ (IIQ) IIQ Discussion and Questions
1

Our Identityiq is of type Oracle.Our identityiqah is of type postgresql.
Updated the iiq.properties file accourdingly .
Updated the upgrade_identityiq_tables.oracle .commented out everything for identityiqah.Then Ran the upgrade command.
Similarly updated teh same for Identityiqah.

Now we are checking schema version for Oracle there is a mismatch
NAME | SYSTEM_VERSION | SCHEMA_VERSION

main | 8.3-45 | 8.4-87

I have also updated the iiq properties related to 8.4.
On running the upgrade command it is giving ¨Schema version [ null ] does not match required version [ 8.4-87 ]. Please run the upgrade_identityiq_tables.* script first¨

2

This is a recurring error on IIQ upgrade, because there isnt the sql instruction to update the system_version column.

You need to connect to db and update manually this column with
update identityiq.spt_database_version set system_version = ‘8.4-87’ where name = ‘main’. The same this for identityiqah db, in this case the table is spt_hist_database_version.

2 Likes
3

Hi @enistri_devo ,I have updated the system_version for identityiq database.But My identityiqah db table spt_hist_database_version is empty with 0 rows.Can i manually update the name system,Schema version into tyhis table and try?

4

Hi @aishwarykumar4050 ,

Please make sure you ran identityiqah scripts with DBA access with no errors.
Once you run it, you should be able to see something like this.
image

Thanks,
Siva

5

yes, but like @SivaLankapalli says, be sure about the script because its very strange that you dont have any rows.

6

looks like you have missed/commented out the following few lines from the upgrade script of access history database.

/* – This is necessary to maintain the schema version. DO NOT REMOVE

insert into identityiqah.spt_hist_database_version (system_version,name) (‘8.4-00’,‘main’);
update identityiqah.spt_hist_database_version set schema_version = ‘8.4-87’ where name =‘main’
commit;

The expected values for 8.4
Note:
schema_version will be updated when we run the upgrade database script and system_version will be updated when we run the upgrade command from console. 
`||spt_hist_database_version||
|system_version|schema_version|
|8.4-00            |8.4-87|

||spt_database_version||
|system_version|schema_version|
|8.4-104          | 8.4-87|`
7

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.