topic Re: I am facing BeanCreation Exception in New to SailPoint

I am facing BeanCreation Exception

okapi — Wed, 15 Feb 2023 19:29:11 GMT

WARN main springframework.context.support.ClassPathXmlApplicationContext:551 - 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: Cannot create JDBC driver of class '' for connect URL 'null' 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: Cannot create JDBC driver of class '' for connect URL 'null'

Re: I am facing BeanCreation Exception

deepika_panwar — Thu, 16 Feb 2023 05:28:14 GMT

Is this a new installation or recently upgraded environment? The error looks related to database connectivity issue

Check DB String in iiq.properties file if this is correct and mapped to right DB type
Try connecting iiq console from WEB-INF\bin, do you see same error.
Check DB user has permission on iiq schema

Re: I am facing BeanCreation Exception

okapi — Sat, 18 Feb 2023 09:38:49 GMT

I have reinstall Everything and now I am able to run ./iiq console and not getting any error,

I have started the tomcat , when i am calling http://localhost:8080/identityid, I am getting 404-Not Found error.
MySql version is Server version: 5.7.41 MySQL Community Server (GPL)

Java Version : java version "1.8.0_202"

SailPoint version : IdentityIq-7.3

Please help me

Re: I am facing BeanCreation Exception

patilshruti — Thu, 07 Dec 2023 15:24:39 GMT

@okapi @deepika_panwar Did you get resolution to this above issue? If yes, could you please provide the details I am facing similar issue.

@rakesh_thammanabhatla

Re: I am facing BeanCreation Exception

deepika_panwar — Thu, 07 Dec 2023 16:03:26 GMT

@patilshruti ,

Can you please provide some more details about your environment, is it new environment or was is working earlier and stopped working. Please tell when do you get the error.

Did you follow below troubleshooting steps that I shared earlier ?

Is this a new installation or recently upgraded environment? The error looks related to database connectivity issue

Check DB String in iiq.properties file if this is correct and mapped to right DB type
Try connecting iiq console from WEB-INF\bin, do you see same error.
Check DB user has permission on iiq schema

Re: I am facing BeanCreation Exception

patilshruti — Fri, 08 Dec 2023 11:54:59 GMT

@deepika_panwar

This was working earlier and stopped working (not a new/updated environment)

The DB string in iiq.properties file is correct
Yes, I get the same error while connecting to iiq console from WEB-INF\bin
Yes, DB user has permission in iiq schema (as this was a working environment)

Re: I am facing BeanCreation Exception

deepika_panwar — Fri, 08 Dec 2023 12:38:56 GMT

Hi @patilshruti ,

If you get the same error while connecting to iiq console then please verify your database status and database string again. You can try to restart your database. The issue is with database connection, nothing to do with Tomcat. You may want to check if something changed at database side.

Re: I am facing BeanCreation Exception

NEHARAI — Thu, 13 Jun 2024 17:53:45 GMT

I m getting the below error

Setting iiq.hostname to DESKTOP-C1LA607-console
2024-06-13T23:20:19,193 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: Cannot create PoolableConnectionFactory (Plugin 'mysql_native_password' is not loaded)
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: Cannot create PoolableConnectionFactory (Plugin 'mysql_native_password' is not loaded)

Re: I am facing BeanCreation Exception

smandal — Mon, 05 Aug 2024 08:33:37 GMT

Hi Any update on this,

Any solution to this?

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: Cannot create PoolableConnectionFactory (Public Key Retrieval is not allowed)

I am also getting the same error. It was running normally and then suddenly this happened

Re: I am facing BeanCreation Exception

joannragan — Mon, 05 Aug 2024 09:29:08 GMT

Hello SailPoint Community,

It looks like you are encountering a BeanCreationException related to the versionChecker bean in your Spring application. This error is often caused by a misconfiguration in your configBeans.xml file, particularly with the JDBC driver settings. The root cause here seems to be that the JDBC driver class is not defined and the connection URL is null. I would recommend double-checking your database configuration settings to ensure that the driver class and URL are correctly specified. For more detailed troubleshooting steps, you might want to visit resources like Spotify Palette, which offers tools and tips for managing complex configurations.

Best Regards!!

Re: I am facing BeanCreation Exception

bakerstamper — Tue, 08 Oct 2024 03:30:06 GMT

Fresh 8.4 installation with SQL Server 16

Same error.

(incidentally, this install worked just fine with MySQL in under an hour...I'm a couple days in with Sql Server backend)

1) Here's what happens when I run 'iiq console':

* note: I get same error if I shut off the database, so this is a fundamental connection issue*

(the SPHOME and CLASSPATH were put in the iiq script by me for debugging)

$ ./iiq console
adding exports for Java 17
SPHOME is /c/Users/levis/dev/SailPoint/identityiq_home
CLASSPATH is /c/Users/levis/dev/SailPoint/identityiq_home/WEB-INF/classes:/c/Users/levis/dev/SailPoint/identityiq_home/WEB-INF/lib/identityiq.jar:/c/Users/levis/dev/SailPoint/identityiq_home/WEB-INF/lib/mssql-jdbc-12.8.1.jre8.jar
iiq.hostname : hplaptop-console
2024-10-07T23:23:43,771 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: Invalid object name 'spt_database_version'.
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: Invalid object name 'spt_database_version'.

==========

I can connect with a local python script and enumerate a table:

$ python ./test.py
Connection successful!

Table Structure (identityiq.spt_database_version):
Column Name: name, Data Type: nvarchar, Size: 255
Column Name: system_version, Data Type: nvarchar, Size: 128
Column Name: schema_version, Data Type: nvarchar, Size: 128

Table Data (spt_work_item):
Connection closed.
(sqlenv)

python code:

mport pyodbc

# Define the connection parameters

server = 'localhost' # Change this to your server name

database = 'identityiq'

username = 'sa'

password = '*******'

# Establish connection to the database

try:

connection = pyodbc.connect(

f'DRIVER={{SQL Server}};SERVER={server};DATABASE={database};UID={username};PWD={password}'

)

print("Connection successful!")

# Create a cursor object to interact with the database

cursor = connection.cursor()

# Get and print table structure (column names and types)

print("\nTable Structure (identityiq.spt_database_version):")

columns = cursor.columns(table='spt_database_version')

for column in columns:

print(f"Column Name: {column.column_name}, Data Type: {column.type_name}, Size: {column.column_size}")

# Execute a query to retrieve all rows from the Employees table

cursor.execute("SELECT * FROM identityiq.spt_database_version")

# Fetch all rows from the query result

rows = cursor.fetchall()

# Display the rows

print("\nTable Data (spt_work_item):")

for row in rows:

print(row)

except pyodbc.Error as e:

print("Error connecting to the database:", e)

finally:

# Close the connection to the database

if connection:

connection.close()

print("Connection closed.")

Re: I am facing BeanCreation Exception

vmaladkar24 — Thu, 06 Feb 2025 18:09:06 GMT

DB MySQL:

ERROR log: 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: Cannot create PoolableConnectionFactory (Public Key Retrieval is not allowed)

Solution: Add "allowPublicKeyRetrieval=true" iiq.properties for dataSource.url

dataSource.url=jdbc:mysql://localhost/identityiq?useServerPrepStmts=true&allowPublicKeyRetrieval=true&tinyInt1isBit=true&useSSL=false&characterEncoding=UTF-8&serverTimezone=UTC