Install on identityiq 8.4 error

Xdipa2407 · August 19, 2024, 1:04pm

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 · August 19, 2024, 1:15pm

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 · August 19, 2024, 1:38pm

Make sure you placed the ojdbc jar file too

Xdipa2407 · August 19, 2024, 2:12pm

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 · August 19, 2024, 2:18pm

Hi @Xdipa2407,

Could you please share the iiq.properties file?

enistri_devo · August 19, 2024, 2:27pm

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 · August 19, 2024, 3:46pm

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 · August 19, 2024, 10:13pm

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 · August 20, 2024, 6:39am

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 · August 20, 2024, 6:43am

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 · August 20, 2024, 6:44am

iiq.properties 8.4 file.txt (17.2 KB)

Kindly find the attached iiq.properties file.

Xdipa2407 · August 20, 2024, 7:01am

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 · August 20, 2024, 7:06am

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

telnet works?

ankush-shirbhate · August 20, 2024, 7:15am

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 · August 20, 2024, 7:23am

Hi @Xdipa2407,

try telnet using command prompt

telnet dbhost port

Regards,
Arun

Xdipa2407 · August 20, 2024, 7:25am

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

Manish4031 · August 21, 2024, 12:20pm

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

Regards
Vidya Prakash

Xdipa2407 · August 21, 2024, 1:04pm

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 · August 21, 2024, 1:08pm

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 · August 21, 2024, 1:31pm

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

Topic		Replies	Views
We were unable to connect to the IIQ console and received the following error ct to: jdbc:sqlserver://w8882:1479;databaseName=identityiq;" IIQ Discussion and Questions identityiq	3	49	October 31, 2024
Install on MS SqlServer error IIQ Discussion and Questions identityiq	20	123	October 5, 2024
Error upgrading to 8.4 IIQ Discussion and Questions identityiq	12	960	July 10, 2024
Unable to connect MS SQL IIQ Discussion and Questions identityiq	11	195	September 20, 2024
Upgrade on load balanced servers IIQ Discussion and Questions identityiq	4	29	November 2, 2024

Install on identityiq 8.4 error

Problem

Related topics