Unable to access IIQ console

Hi all,

When trying to access the iiq console, getting the below error:

What can be the issue?

Thanks in advance

Hi @rishavghoshacc ,

Could you give more details,

From when you are getting this problem?

Is it because of IIQ upgrade or new IIQ installation?

Possible reasons and solution -

Please make sure JDK and Web server used is as per IIQ release notes of specific version

DB server configuration should be same as iiq.properties file configuration

Hi Rishav,

Mandar is right, we’ll need a bit more detail to narrow this down. The error you’re seeing usually points to a DB/JDBC communication issue rather than just IIQ console access.

Could you please share:

  1. IIQ version

  2. JDK version being used

  3. SQL Server version

  4. JDBC driver version (mssql-jdbc jar)

  5. Whether this started after:

    • Fresh installation
    • Upgrade
    • Or config change

This will help identify if it’s a driver mismatch, TLS issue, or configuration problem.

Thanks.

@rishavghoshacc In which environment are you getting this issue? Sandbox or Dev or Production or something else?
When did it stopped working?

@neel193 I changed the password and it was working for a few hours. It suddenly stopped working

Check your DB connection, your password is not working anymore to connect to DB.
Try using old password once.

@rishavghoshacc In which version you are in ?

start with verify

a. JDBC URL, host, port, or database name

b. SQL Server JDBC driver mismatch with your SQL Server version

c. looks like it local so comment the IIQ keystore lines

if you will post the iiq.properties then it would be helpful.

@rishavghoshacc As discussed this issue is only with a specific user. Rest all are able to login, so we can rule out any possibility of DB issues and this is happening in UAT instance.

As it’s UAT, could you please try deleting the identity and recreate it using aggregation, then change the password from identity warehouse. After that try to login and let us know if it works or not,

have you tried with running idx ? it looks like some user might got corrupt.

Correct IDX rule to detect and fix IDX values - Compass

@neel193 This is the error that is the first one

image

@rishavghoshacc It looks like you don’t have permission to execute it. try running as administrator or some other user with elevated permission.