IIQ upgrade issue from 8.3 to 8.4

IdentityIQ (IIQ) IIQ Discussion and Questions
1

Which IIQ version are you inquiring about?

8.4

Hello ,

We are in process of upgrading iiq from 8.3 to 8.4

Followed the standard manual process, the upgrade scripts has been executed successfully and new DB has been created with name identityah. We are trying to run the “iiq upgrade” command, but ended up with the below error message.

I have already gone through few posts made for the same issue, but couldn’t resolve it. Looking for the assistance to proceed with the upgrade process as we are stuck in this step.

Database - MS SQL Server 2019
JAVA version - JDK 11 (just updated during the iiq upgrade as it throws compatible issue)
JDBC driver - updated to 12.8 as it throws compatible issue

Thanks in advance!

ERROR main sailpoint.server.upgrade.Upgrader:1523 - Invalid object name ‘spt_database_version’.
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name ‘spt_database_version’.

image
image1342×433 16.8 KB

2

it seems like you didn’t updated iiq.properties file with the latest file that come with 8.4
compare the iiq.properties file with 8.4 installer and the one which is giving error.

3

I have done making changes to the iiq prop file with url, username and password.

4

Hi @NPM15,

try to execute directly the upgrade script into db

5

Yes I executed directly from DB only

6

Hi @NPM15 ,
Seems something wrong in your iiq properties. Check the db details.

Thanks

1 Like
7

ok, and now if you extract the application and start tomcat, it works?

8

Is it okay to start the application server without resolving this issue?

9

I checked the prop, don’t find any issues with that

10

if you update the DB correctly, you can start the IIQ 8.4(with the own configuration) and check if you have other problems

11

tried starting the service but got “FAIL - Application at context path [/identityiq] could not be started” error

12

Ok is a different error. Do you have some logs?

13

Try again in below order and see if this helps

  1. run upgrade db script
  2. modify iiq properties to update all the required values , 8.4 has one new additional DS added for access history
  3. run upgrade cmd
  4. connect to console
  5. start app server
14

the system version of the database is not updating after executing the iiq upgrade command, hope this causes the issue. But someone said that the system version will updated automatically after the upgrade command execution. Is that so?

15

Yes that will get updated as part of update cmd .

16

this is the issue currently facing, the version is not upgrading automatically for the identityiq database.

17

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