Install on identityiq 8.4 error

[Xdipa2407 (Divya Pardhi)]

Problem

We are trying to set up a Sandbox environment with the following components: Java (openlogic-openjdk-jre-11.0.21+9-windows-x64), Apache Tomcat (apache-tomcat-9.0.89), and MS SQL Server 2012 for IdentityIQ 8.4. Now, we are trying to set up the IIQ console but encountering errors. Kindly assist how to resolve this error.

D:\Tomcat\webapps\identityiq\WEB-INF\bin>iiq console iiq.hostname : DSBWDSPT01-console 2024-07-23T01:24:56,613 WARN main springframework.context.support.ClassPathXmlApplicationContext:559 - Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘versionChecker’ defined in class path resource [configBeans.xml]: Invocation of init method failed; nested exception is java.lang.RuntimeException: Unable to check IdentityIQ database version: Unable to connect to: jdbc:sqlserver://DSBWDSPT01.dsb.dk\MSSQLSERVER04:14331;databaseName=identityiq; org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘versionChecker’ defined in class path resource [configBeans.xml]: Invocation of init method failed; nested exception is java.lang.RuntimeException: Unable to check IdentityIQ database version: Unable to connect to: jdbc:sqlserver://DSBWDSPT01.dsb.dk\MSSQLSERVER04:14331;databaseName=identityiq;

And in database when we run select * from identityiq.spt_database_version;
we are getting empty table.

[enistri_devo (Emanuele Nistri)]

Hi @Xdipa2407,

after all MSSQL 2012 is not supported for IIQ 8.4:

better if install 2019 or 2022.

Also, have you execute all the script for database? Create, Upgrade and post-upgrade. You can find in identityiq/WEB-INF/database

[y_purini (Yogesh Kumar Purini)]

Make sure you placed the ojdbc jar file too

[Xdipa2407 (Divya Pardhi)]

Based on Matrix of iiq8.4 we are using below software:
Java (openlogic-openjdk-jre-11.0.21+9-windows-x64)
Apache Tomcat (apache-tomcat-9.0.89)
MS SQL Server 2022
Driver :mssql-jdbc-12.8.0.jre11

[Arun-Kumar]

Hi @Xdipa2407,

Could you please share the iiq.properties file?

[enistri_devo (Emanuele Nistri)]

ok, at the start you wrote 2012; have you execute all the script?

Also, see how do you have in spt_database_version.
Check if you have a record like this:

with main like name and both version column must be hava a value

[ankush-shirbhate]

Few things need to check here in iiq.properties file specifically around the connection parameter for DB.

• 14331 is the correct port number?
• serverName\instanceName or serverName:portNumber , not both.
  if the port is correct give it try

jdbc:sqlserver://DSBWDSPT01.dsb.dk:14331;databaseName=identityiq;

Regards
Ankush

[fcmendoza (Felipe Mendoza)]

Also, for running the SSB for 8.4 version, you need to install ANT on the server. It needs to be called when creating the war file.

[Xdipa2407 (Divya Pardhi)]

Port 14331 is correct. and I tried following command :
jdbc:sqlserver://DSBWDSPT01.dsb.dk:14331;databaseName=identityiq;

Error:
D:\Tomcat\webapps\identityiq\WEB-INF\bin>iiq console
iiq.hostname : DSBWDSPT01-console
2024-08-19T23:37:22,284 WARN main springframework.context.support.ClassPathXmlApplicationContext:559 - Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘versionChecker’ defined in class path resource [configBeans.xml]: Invocation of init method failed; nested exception is java.lang.RuntimeException: Unable to check IdentityIQ database version: Unable to connect to: jdbc:sqlserver://DSBWDSPT01.dsb.dk:14331;databaseName=identityiq;
org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘versionChecker’ defined in class path resource [configBeans.xml]: Invocation of init method failed; nested exception is java.lang.RuntimeException: Unable to check IdentityIQ database version: Unable to connect to: jdbc:sqlserver://DSBWDSPT01.dsb.dk:14331;databaseName=identityiq;

[enistri_devo (Emanuele Nistri)]

Hi @Xdipa2407,

try to add this at end of the connection string in iiq.properties & build.properties files:

encrypt=false;trustServerCertificate=false;

MMSQL want a secure connection, instead you must to declare if you dont want

PS add this to all connection string: identityiq, identityiqPlugin & identityiqah

[Xdipa2407 (Divya Pardhi)]

iiq.properties 8.4 file.txt (17.2 KB)

Kindly find the attached iiq.properties file.

[Xdipa2407 (Divya Pardhi)]

we have updated below line in all connection string: identityiq, identityiqPlugin & identityiqah, still facing the same issue.

encrypt=false;trustServerCertificate=false;

D:\Tomcat\webapps\identityiq\WEB-INF\bin>iiq console
iiq.hostname : DSBWDSPT01-console
2024-08-19T23:58:42,507 WARN main springframework.context.support.ClassPathXmlApplicationContext:559 - Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘versionChecker’ defined in class path resource [configBeans.xml]: Invocation of init method failed; nested exception is java.lang.RuntimeException: Unable to check IdentityIQ database version: Unable to connect to: jdbc:sqlserver://DSBWDSPT01.dsb.dk:14331;databaseName=identityiq;encrypt=false;trustServerCertificate=false;
org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘versionChecker’ defined in class path resource [configBeans.xml]: Invocation of init method failed; nested exception is java.lang.RuntimeException: Unable to check IdentityIQ database version: Unable to connect to: jdbc:sqlserver://DSBWDSPT01.dsb.dk:14331;databaseName=identityiq;encrypt=false;trustServerCertificate=false;

[enistri_devo (Emanuele Nistri)]

question: do you have the permission to connect on DSBWDSPT01 from your sandbox?

telnet works?

[ankush-shirbhate]

Connection parameters looks good in properties file. Please check the identityiq user name and password are correct. Quickly check the connectivity from your sandbox to DB server using ping or telnet.

[Arun-Kumar]

Hi @Xdipa2407,

try telnet using command prompt

telnet dbhost port

Regards,
Arun

[Xdipa2407 (Divya Pardhi)]

yes, we have permissions.
telnet DSBWDSPT01.dsb.dk 14331
its working.

[Manish4031 (Vidya Prakash)]

Hi Diya,
did you execute all db query in both the database identityiq and identityiqah?

Regards
Vidya Prakash

[Xdipa2407 (Divya Pardhi)]

Hi Vidya,

Yes i have run all the db queries, but when i check after running the query command. database version file is showing empty.

[Manish4031 (Vidya Prakash)]

can you check the upgrade script where we have update for this table and also identityiqah database table there is also database version table persent, also check insert query in our query script.

[Xdipa2407 (Divya Pardhi)]

When i run update script, it is showing zero row affected.