Could not process key 'dataSource' in PropertyOverrideConfigurer

IdentityIQ (IIQ) IIQ Discussion and Questions
1

Hi Team,

I am installing IIQ 8.4 on Oracle. 1. I don’t think Sailpoint understand how to create database; 2. After all the databases created, the insert data into the main table had missing from the script and only update, update what when the table is emptiness data? 3. I manually insert the data using the history data and run update data into the main table.
Now, when I run the iiq console, the encrypted password is not working, I hardcode the passwors and username.
with encrypted password:

# ./iiq console
iiq.hostname : oracledb_hostname-console
2023-11-28T10:15:44,146  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:oracle:thin:@nediacredhat8.dodiis.ic.gov:1521/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:oracle:thin:@oracledb_hostname:1521/identityiq

Error without encrypted password and hardcode username/password

iiq.hostname : oracledb_hostname-console
 2023-11-28T10:13:54,644  WARN main springframework.context.support.ClassPathXmlApplicationContext:559 - Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.BeanInitializationException: Could not process key 'dataSource' in PropertyOverrideConfigurer; nested exception is org.springframework.beans.factory.BeanInitializationException: Invalid key 'dataSource': expected 'beanName.property'
org.springframework.beans.factory.BeanInitializationException: Could not process key 'dataSource' in PropertyOverrideConfigurer; nested exception is org.springframework.beans.factory.BeanInitializationException: Invalid key 'dataSource': expected 'beanName.property'

Even hardcode passwordk in double quote, identityiq/“Password*1234” and/or using tnsnames connection:
dataSource=jdbc:oracle:thin:identityiq/"Password*1234"@(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = oracledb_hostname) (PORT = 1521))) (CONNECT_DATA = (SID = IDENTITYIQ)))

How to connect sailpoint on Oracle?

2

Could you please paste complete iiq.properties file? Feel free to anonymize if needed.

3

Classification: UNCLASSIFIED

since I am still testing not using encrypted passwords, I commented the 1st identityiq encryption connection out.

thank you,

Bach-Nga

Classification: UNCLASSIFIED

iiq.properties (9.4 KB)

4

I think the problem is here
image

it should be dataSource.url - not just dataSource

5

Classification: UNCLASSIFIED

as you see
##dataSource.username=identityiq
##dataSource.password=1:ACP:VHGrGBFYLIDoRdWK2VUg0s0hZuSraCRCrW0MKqWumLc=

Oracle

URL Format: dataSource.url=jdbc:oracle::<username/password>@::

dataSource=jdbc:oracle:thin:identityiq/“Password*1234”@(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = oracledb_host) (PORT = 1521))) (CONNECT_DATA = (SID = IDENTITYIQ)))

###dataSource.url=jdbc:oracle:thin:@oracledb_hostname:1521/identityiq

I have tried w/o hardcode the password (in bold) and received the same error

even put the dataSource.url same error

image.png1229×381 16.1 KB

./iiq console

iiq.hostname : sailpoint_hostname-console
2023-11-28T13:57:12,661 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:oracle:thin:identityiq/“Password1234"@(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = oracledb_hostname) (PORT = 1521))) (CONNECT_DATA = (SID = 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:oracle:thin:identityiq/"Password1234”@(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = oracledb_hostname) (PORT = 1521))) (CONNECT_DATA = (SID = IDENTITYIQ)))

Classification: UNCLASSIFIED

6

GM. Any status on this problem? How to connect iiq on Oracle?

7

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.