Error upgrading to 8.4

[Alyson_Trad]

Which IIQ version are you inquiring about?

Version 8.3

Share all details related to your problem, including any error messages you may have received.

I am in the middle of 8.3 and 8.4. When I run the iiq console command, I get the below error:

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 java.lang.RuntimeException: Unable to check IdentityIQ database version: Invalid object name ‘spt_database_version’.

I did find an article to run:
ALTER USER identityiq WITH DEFAULT_SCHEMA = identityiq;

Which I did successfully, but I am still seeing the same error. Any suggestions?

[vishal_kejriwal1 (Vishal Kejriwal)]

Did you already execute the database script ? are you upgrading to 8.3 or 8.4?

[Alyson_Trad]

We were going from 8.2 to 8.4.
Currently we are on 8.3 and in the process of going to 8.4. I have already ran the Upgrade_tables script against my database and have the new database “identityiqah”.

When I go to check if its ready for iiq upgrade, I get this error when running the iiq console.

[vishal_kejriwal1 (Vishal Kejriwal)]

Did you updated iiq.properties ?

[Alyson_Trad]

I belive that is part of my issue. I have added the new database to the properties file.

When this section is removed, I get the expected “Application’s system version 8.4-104 does not match IdentityIQ database’s system version 8.3-44”

However, when I add in the new database, that is when I get the error.

[vishal_kejriwal1 (Vishal Kejriwal)]

I would say use 8.4 iiq.properties file and modify accordingly . Please update the schema after this change .

[iamksatish (Satish Kurasala)]

Can you share your iiq.properties file( replacing the sensitive content with XXX)

[kjakubiak (Kamil Jakubiak)]

It would be good if you could check what is the value of select * from identityiq.spt_database_version
If it says anything with 8.3 that simply means that the upgrade scripts did not run correctly.

This is how it should look like in 8.4

[Alyson_Trad]

I ran that against our database and see:
System_verion: 8.3-44
Schema_version: 8.4-87

[Alyson_Trad]

As an update, it was the iiq properties file that was the issue.
I needed to add the new identityiqah database information at the bottom on the file. I was trying to place it next to the identityiq DB information.

Appreciate everyone’s help on this!

[vishal_kejriwal1 (Vishal Kejriwal)]

@Alyson_Trad ,
My answer was correct

[pravin_ranjan (Kumar Ranjan)]

Hi @Alyson_Trad

For upgrade related there is one best document in compass. this document has step by step process for both linux and windows. it’s worth to keep handy.

IdentityIQ Upgrade Plan document template - Compass (sailpoint.com)