# Facing issue while upgrading to IIQ 8.4 version **URL:** \ **Category:** IIQ Discussion and Questions\ **Tags:** identityiq\ **Created:** [October 17, 2024, 8:25am UTC](https://developer.sailpoint.com/discuss/t/facing-issue-while-upgrading-to-iiq-8-4-version/85754 "2024-10-17T08:25:31Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![sarkarS01](https://avatars.discourse-cdn.com/v4/letter/s/278dde/32.png) [@sarkarS01](https://developer.sailpoint.com/discuss/u/sarkarS01)\ **Post date:** [October 17, 2024, 8:25am UTC](https://developer.sailpoint.com/discuss/t/facing-issue-while-upgrading-to-iiq-8-4-version/85754/1 "2024-10-17T08:25:31Z")
## 8.4 version upgrade ![iiqConsole](https://global.discourse-cdn.com/sailpoint/original/3X/c/5/c5b54d83dc6247d8f94f0548135c18ef53361724.jpeg) I am in middle of upgrading to 8.4 version and facing issue related to that. As part of upgrade, after running the db upgrade script, while launching iiq console, getting error related to version(attached the screenshot) Any suggestions would be appreciated. ---
**Author:** ![chintjub](https://avatars.discourse-cdn.com/v4/letter/c/9e8a1a/32.png) [@chintjub](https://developer.sailpoint.com/discuss/u/chintjub)\ **Post date:** [October 17, 2024, 8:34am UTC](https://developer.sailpoint.com/discuss/t/facing-issue-while-upgrading-to-iiq-8-4-version/85754/2 "2024-10-17T08:34:35Z")
check the version matrix before you proceed to upgrade, version compatibility should be there ---
**Author:** ![sarkarS01](https://avatars.discourse-cdn.com/v4/letter/s/278dde/32.png) [@sarkarS01](https://developer.sailpoint.com/discuss/u/sarkarS01)\ **Post date:** [October 17, 2024, 8:38am UTC](https://developer.sailpoint.com/discuss/t/facing-issue-while-upgrading-to-iiq-8-4-version/85754/3 "2024-10-17T08:38:31Z")
Yes checked, versions are compatible. Any insight related to sailpoint provided db upgrade script not updating system\_version only schema\_version got updated, would be helpful. (Please refer to both the screenshots.) ---
**Author:** ![rquku](https://avatars.discourse-cdn.com/v4/letter/r/43a26b/32.png) [@rquku](https://developer.sailpoint.com/discuss/u/rquku)\ **Post date:** [October 17, 2024, 9:50am UTC](https://developer.sailpoint.com/discuss/t/facing-issue-while-upgrading-to-iiq-8-4-version/85754/4 "2024-10-17T09:50:50Z")
Hej Sarkar, after you have run the db upgrade script, you are expected to run the iiq upgrade command. Upon successful execution of iiq upgrade you should be able to use iiq console again. Thanks, Renad ---
**Author:** ![GutteStolt](https://avatars.discourse-cdn.com/v4/letter/g/9fc348/32.png) [@GutteStolt](https://developer.sailpoint.com/discuss/u/GutteStolt)\ **Post date:** [October 17, 2024, 11:50am UTC](https://developer.sailpoint.com/discuss/t/facing-issue-while-upgrading-to-iiq-8-4-version/85754/5 "2024-10-17T11:50:51Z")
Hello Subhra, The ran the last query that updates the database version. ![image](https://global.discourse-cdn.com/sailpoint/original/3X/5/5/557195e780296cc8db95a64a8c526aef57875883.png) This just an example, you can check in the upgrade script in database folder Thanks. ---
**Author:** ![sarkarS01](https://avatars.discourse-cdn.com/v4/letter/s/278dde/32.png) [@sarkarS01](https://developer.sailpoint.com/discuss/u/sarkarS01)\ **Post date:** [October 17, 2024, 11:59am UTC](https://developer.sailpoint.com/discuss/t/facing-issue-while-upgrading-to-iiq-8-4-version/85754/6 "2024-10-17T11:59:53Z")
Hi Renad, Are you suggesting irrespective of database version mismatch, like below - system\_version : 8.3-45 schema\_version : 8.4-87 Should I proceed with" iiq upgrade"? Will that work still? ---
**Author:** ![sarkarS01](https://avatars.discourse-cdn.com/v4/letter/s/278dde/32.png) [@sarkarS01](https://developer.sailpoint.com/discuss/u/sarkarS01)\ **Post date:** [October 17, 2024, 12:02pm UTC](https://developer.sailpoint.com/discuss/t/facing-issue-while-upgrading-to-iiq-8-4-version/85754/7 "2024-10-17T12:02:59Z")
Hi Shubham, yes, I checked the upgrade script. There is nothing command for system\_version (only command present for schema\_version). In my case schema\_version already got updated, as expected. ---
**Author:** ![rquku](https://avatars.discourse-cdn.com/v4/letter/r/43a26b/32.png) [@rquku](https://developer.sailpoint.com/discuss/u/rquku)\ **Post date:** [October 17, 2024, 12:15pm UTC](https://developer.sailpoint.com/discuss/t/facing-issue-while-upgrading-to-iiq-8-4-version/85754/8 "2024-10-17T12:15:27Z")
Yes, that is exactly the command that you need to execute. The issue is that your database version is already in the version 8.4. The application itself is still in the 8.3pX. And that is the mismatch that happens. Therefore when you execute the command iiq upgrade, also the application will be upgraded to 8.4 Br, Renad ---
**Author:** ![sarkarS01](https://avatars.discourse-cdn.com/v4/letter/s/278dde/32.png) [@sarkarS01](https://developer.sailpoint.com/discuss/u/sarkarS01)\ **Post date:** [October 17, 2024, 12:24pm UTC](https://developer.sailpoint.com/discuss/t/facing-issue-while-upgrading-to-iiq-8-4-version/85754/9 "2024-10-17T12:24:16Z")
Hello Renad, Message says the opposite regarding database only while launching iiq console, below sharing again - “Error creating bean with name ‘versionChecker’ defined in class path resource [configBeans.xml]: Invocation of init method failed; nested exception is sailpoint.api.DatabaseVersionException: **Application’s system version 8.4-104 does not match IdentityIQ database’s system version 8.3-45** ” Please let me know, your suggestion. ---
**Author:** ![rquku](https://avatars.discourse-cdn.com/v4/letter/r/43a26b/32.png) [@rquku](https://developer.sailpoint.com/discuss/u/rquku)\ **Post date:** [October 17, 2024, 12:53pm UTC](https://developer.sailpoint.com/discuss/t/facing-issue-while-upgrading-to-iiq-8-4-version/85754/10 "2024-10-17T12:53:58Z")
Can you run this query in your database `select * from identityiq,spt_database_version` and show us the input here. Thanks, Renad ---
**Author:** ![sarkarS01](https://avatars.discourse-cdn.com/v4/letter/s/278dde/32.png) [@sarkarS01](https://developer.sailpoint.com/discuss/u/sarkarS01)\ **Post date:** [October 17, 2024, 1:17pm UTC](https://developer.sailpoint.com/discuss/t/facing-issue-while-upgrading-to-iiq-8-4-version/85754/11 "2024-10-17T13:17:36Z")
![db](https://global.discourse-cdn.com/sailpoint/original/3X/f/2/f2c10f7aae5860891f57339b0286562b1595655f.jpeg) @rquku, please find the query result ---
**Author:** ![rquku](https://avatars.discourse-cdn.com/v4/letter/r/43a26b/32.png) [@rquku](https://developer.sailpoint.com/discuss/u/rquku)\ **Post date:** [October 17, 2024, 2:24pm UTC](https://developer.sailpoint.com/discuss/t/facing-issue-while-upgrading-to-iiq-8-4-version/85754/12 "2024-10-17T14:24:05Z")
Based on the query results, you can see that the schema version was upgraded, but the system was not, which led to the mismatch. By running the `./iiq upgrade` command this issue should get resolved. ---
**Author:** ![suyatra\_sinha1992](https://avatars.discourse-cdn.com/v4/letter/s/e47c2d/32.png) [@suyatra\_sinha1992](https://developer.sailpoint.com/discuss/u/suyatra_sinha1992)\ **Post date:** [October 18, 2024, 9:55am UTC](https://developer.sailpoint.com/discuss/t/facing-issue-while-upgrading-to-iiq-8-4-version/85754/13 "2024-10-18T09:55:35Z")
@sarkarS01, this happens when you do not run the iiq upgrade and your application and DB versions are different. Happened with me several times. Like Renad suggested, run the iiq upgrade from cmd and it will upgrade the db to the correct version. If not upgrading, check the db scripts and change it accordingly and then run the upgrade again. Cheers! ---
**Author:** ![suyatra\_sinha1992](https://avatars.discourse-cdn.com/v4/letter/s/e47c2d/32.png) [@suyatra\_sinha1992](https://developer.sailpoint.com/discuss/u/suyatra_sinha1992)\ **Post date:** [October 18, 2024, 11:14am UTC](https://developer.sailpoint.com/discuss/t/facing-issue-while-upgrading-to-iiq-8-4-version/85754/15 "2024-10-18T11:14:20Z")
@sarkarS01 I found this in you iiq.properties dataSourceAccessHistory.username=identityiqah dataSourceAccessHistory.password= You do have provided the encrypted password, right? I mean just because you are sharing with us, you have not provided, right? If no password set, use the below script CREATE DATABASE identityiqah (If not already there) GO CREATE LOGIN identityiqah WITH password=‘Add your encrypted password here’ GO ---
**Author:** ![sarkarS01](https://avatars.discourse-cdn.com/v4/letter/s/278dde/32.png) [@sarkarS01](https://developer.sailpoint.com/discuss/u/sarkarS01)\ **Post date:** [October 18, 2024, 11:40am UTC](https://developer.sailpoint.com/discuss/t/facing-issue-while-upgrading-to-iiq-8-4-version/85754/16 "2024-10-18T11:40:34Z")
@suyatra_sinha1992, yes I have already provided encrypted password in iiq.properties for “identityiqah” but it seems I am getting error related to that. Separately able to connect to that db with that particular password as well. ---
**Author:** ![rquku](https://avatars.discourse-cdn.com/v4/letter/r/43a26b/32.png) [@rquku](https://developer.sailpoint.com/discuss/u/rquku)\ **Post date:** [October 18, 2024, 1:27pm UTC](https://developer.sailpoint.com/discuss/t/facing-issue-while-upgrading-to-iiq-8-4-version/85754/17 "2024-10-18T13:27:41Z")
Can you try to use the password in plaintext initially? It would sort out the issues, where you use the wrong encrypted key, which usually happen if just get the encrypted value from a different stage. Br, Renad ---
**Author:** ![sarkarS01](https://avatars.discourse-cdn.com/v4/letter/s/278dde/32.png) [@sarkarS01](https://developer.sailpoint.com/discuss/u/sarkarS01)\ **Post date:** [October 18, 2024, 1:59pm UTC](https://developer.sailpoint.com/discuss/t/facing-issue-while-upgrading-to-iiq-8-4-version/85754/18 "2024-10-18T13:59:36Z")
@rquku, I have tried both ways, Keeping plain text password keeping encrypted version (context.encrypt(“\*\*\*\*\*\*”)) But both ways getting the same error. Is there any additional setup needs to be done for password? Am I missing out on anything? Thanks & Regards, Subhra Sarkar ---
**Author:** ![Manish4031](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/manish4031/32/14030_2.png) [@Manish4031](https://developer.sailpoint.com/discuss/u/Manish4031)\ **Post date:** [October 20, 2024, 9:36am UTC](https://developer.sailpoint.com/discuss/t/facing-issue-while-upgrading-to-iiq-8-4-version/85754/19 "2024-10-20T09:36:27Z")
Hi @sarkarS01 Did you check user permission also check timeout. Thanks, Prakash ---
**Author:** ![sarkarS01](https://avatars.discourse-cdn.com/v4/letter/s/278dde/32.png) [@sarkarS01](https://developer.sailpoint.com/discuss/u/sarkarS01)\ **Post date:** [October 21, 2024, 12:29pm UTC](https://developer.sailpoint.com/discuss/t/facing-issue-while-upgrading-to-iiq-8-4-version/85754/20 "2024-10-21T12:29:16Z")
Completed upgrade, thanks to all for your suggestions!! ---
**Author:** ![system](https://global.discourse-cdn.com/sailpoint/original/2X/f/f2136700ed5e3703e0b85e02f6be799dacca7735.png) [@system](https://developer.sailpoint.com/discuss/u/system)\ **Post date:** [December 20, 2024, 12:29pm UTC](https://developer.sailpoint.com/discuss/t/facing-issue-while-upgrading-to-iiq-8-4-version/85754/21 "2024-12-20T12:29:48Z")
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.