Exception encountered during context initialization

IdentityIQ (IIQ) IIQ Discussion and Questions
,
1

Which IIQ version are you inquiring about?

```

upgrading IdentityIQ from version IIQ 8.3 to IIQ 8.4 and simultaneously moving our SQL Server from 2016 to 2022. While executing iiq upgrade command getting following.

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

Please share any images or screenshots, if relevant.

[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.

[Replace this text with the problem that you are facing]

2

@Nara Have you executed the upgrade database scripts? Also, please check in iiq.properties, if you are passing encrypt=true;trustServerCertificate=true; in the host url or not?

3

Please go through the below link, it should help you to fix the issue.

https://community.sailpoint.com/t5/IdentityIQ-Wiki/Error-Invalid-object-name-spt-database-version/ta-p/72179

4

Error message indicates that expected DB version is missing for required IIQ version.

please check Upgrade DB script for IIQ 8.4 version with actual value in DB table.

Probably you might need to run upgrade script again if version number is not updated in DB

5

@mandarsane

The database version was not updated correctly during the upgrade. I manually updated the version and re-ran the iiq upgrade command; however, the same error persists.

6

@Nara Have you checked the article shared above? Please try running this query in DB and try again:

ALTER USER identityiq WITH DEFAULT_SCHEMA = identityiq;

7

My DBA has confirmed that schema has been set to identityiq. Thank you.

8

I mean you can execute DB scripts, not iiq-upgrade command in IIQ Console