# IIQ Console Connecting Error **URL:** \ **Category:** IIQ Discussion and Questions\ **Tags:** identityiq\ **Created:** [July 23, 2025, 2:28pm UTC](https://developer.sailpoint.com/discuss/t/iiq-console-connecting-error/159276 "2025-07-23T14:28:24Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Mani\_AMAT](https://avatars.discourse-cdn.com/v4/letter/m/67e7ee/32.png) [@Mani\_AMAT](https://developer.sailpoint.com/discuss/u/Mani_AMAT)\ **Post date:** [July 23, 2025, 2:28pm UTC](https://developer.sailpoint.com/discuss/t/iiq-console-connecting-error/159276/1 "2025-07-23T14:28:24Z")
D:\Program Files\Apache Software Foundation\Tomcat 9.0\webapps\identityiqdev\WEB-INF\bin\>iiq console Setting iiq.hostname to DCA-DEV-689-console org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘systemStarter’ defined in class path resource [iiqBeans.xml]: Invocation of init method failed; nested exception is java.lang.RuntimeException: sailpoint.tools.GeneralException: could not extract ResultSet we restored the prod db in our dev server and copied the identityiq folder and updated prop file tried starting the tomcat and connecting to iiq console is failing with above error ---
**Author:** ![pattabhi](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/pattabhi/32/25700_2.png) [@pattabhi](https://developer.sailpoint.com/discuss/u/pattabhi)\ **Post date:** [July 23, 2025, 4:37pm UTC](https://developer.sailpoint.com/discuss/t/iiq-console-connecting-error/159276/2 "2025-07-23T16:37:30Z")
Hi @Mani_AMAT Could you please provide the following details? - OS version: - Java version: - IIQ version and patch level: - Database version: - JDBC Driver file name: - server.xml - identityiq.spt\_database\_version; I have worked on a similar setup, and the above-mentioned details are crucial to understand the issue. Thanks & Regards, Pattabhi ---
**Author:** ![pattabhi](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/pattabhi/32/25700_2.png) [@pattabhi](https://developer.sailpoint.com/discuss/u/pattabhi)\ **Post date:** [July 24, 2025, 7:18am UTC](https://developer.sailpoint.com/discuss/t/iiq-console-connecting-error/159276/3 "2025-07-24T07:18:06Z")
Hi @Mani_AMAT, In my experience performing an upgrade from 7.0p6 to 8.4p2, we were in a similar situation where we were unable to connect to `iiq console` after restoring data from the Production to the Stage environment. { cross check the environment variable like java version, tomcat base version, path } We have tried commands like `iiq.bat console -u spadmin -p admin` The underlying issue was: The OS version difference (2012 vs. 2022) was a major issue, along with other factors like the DB component (`SQL Server 2016`), JDBC driver files, `iiq.properties`, and `server.xml` file. You can refer to my topic: [Step-by-Step: Best Practices for IdentityIQ 7.1p6 to 8.4p2 Upgradation](https://developer.sailpoint.com/discuss/t/step-by-step-best-practices-for-identityiq-7-1p6-to-8-4p2-upgradation/123098) where I listed all the components key for a successful migration. So, in your case, it could be one of the following: 1. OS version difference or Database issue config issue. 2. Driver file issue with respect to java version. 3. Misconfiguration of `iiq.properties` or `server.xml` 4. Corrupted deployed folder content during the restore. 5. Possibly database default schema configuration. I hope this will help you troubleshoot your `iiq.bat console` connectivity issue. Thanks & Regards, Pattabhi ---
**Author:** ![Mani\_AMAT](https://avatars.discourse-cdn.com/v4/letter/m/67e7ee/32.png) [@Mani\_AMAT](https://developer.sailpoint.com/discuss/u/Mani_AMAT)\ **Post date:** [July 24, 2025, 9:32am UTC](https://developer.sailpoint.com/discuss/t/iiq-console-connecting-error/159276/4 "2025-07-24T09:32:53Z")
Hi @pattabhi, Please find the requested details below - OS version: 10.0.20348 N/A Build 20348 - Java version: java version “17.0.12” 2024-07-16 LTS - IIQ version and patch level: 8.2 p1 - Database version: 16.0.1000.6 - JDBC Driver file name: mssql-jdbc-9.2.1.jre8.jar - server.xml - identityiq.spt\_database\_version; - 8.2-12 ---
**Author:** ![pattabhi](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/pattabhi/32/25700_2.png) [@pattabhi](https://developer.sailpoint.com/discuss/u/pattabhi)\ **Post date:** [July 24, 2025, 9:45am UTC](https://developer.sailpoint.com/discuss/t/iiq-console-connecting-error/159276/5 "2025-07-24T09:45:54Z")
Hi @Mani_AMAT OS: `Windows Server 2022` & DB: `MS SQL Server 2016` looks good aligned with my approach. As per **SailPoint** Installation document of `IdentityIQ 8.2`, we need to use `jdk 1.8(8) or JDK 11` So my recommendation is downgrade java from `JDK 17` to `JDK 11` and use following driver file. `mssql-jdbc-12.6.3.jre11.jar` (or) latest: `mssql-jdbc-12.10.1.jre11.jar` ---
**Author:** ![system](https://global.discourse-cdn.com/sailpoint/original/2X/f/f2136700ed5e3703e0b85e02f6be799dacca7735.png) [@system](https://developer.sailpoint.com/discuss/u/system)\ **Post date:** [September 22, 2025, 9:46am UTC](https://developer.sailpoint.com/discuss/t/iiq-console-connecting-error/159276/6 "2025-09-22T09:46:24Z")
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.