IIQ upgrade 8.3 -- > identity 8.4

IdentityIQ (IIQ) IIQ Discussion and Questions
1

Which IIQ version are you inquiring about?

```

I am upgrading from IdentityIQ version 8.3 to 8.4. During the upgrade, when I run the “iiq upgrade” command, I’m getting a schema version mismatch error. Even though I already ran the “upgrade identity tables” script, it keeps asking me to run it again.
I could see schema_version version has been set as 8.4.87 from identityiq.spt_database_version

select schema_version from identityiq.spt_database_version; While running upgrade script I was getting errors, but I fixed the errors. Any suggestions.

```

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 checked the schema version in access history (identityiqah) database?

3

@Nara By any chance, do you have the errors that came while executing db upgrade scripts? There is a possibility that while fixing it, you may miss any query and causing the this issue.

4

Please compare the version of all the schema of your SailPoint IIQ. Compare if it matches with the compatible version. Or check the logs if something is missed while you were executing the query.

5

@Nara check this thread, you might have this issue. I think we encounter same issue then i used this command.

Error: Invalid object name ‘spt_database_version’ - Compass

ALTER USER identityiq WITH DEFAULT_SCHEMA = identityiq;

 

The above syntax assumes the original DDL script provided has not been edited with a custom user / schema name. If it has been modified, you can trial / error test with the username and the DB name.