"Invalid parameter definition syntax" Error when Using Colon ":" Character In Query File Of DBUM Connector
(Doc ID 2447926.1)
Last updated on MARCH 15, 2023
Applies to:
Identity Manager Connector - Version 11.1.1.8.0 to 11.1.1.8.0 [Release 11g]Information in this document applies to any platform.
Symptoms
When using Colon (:) character in SEARCH_USER of Search.query file inside DBUM connector bundle Bundle Jar, following syntax error is encountered:
... [ERROR] [] [ORG.IDENTITYCONNECTORS.DBUM.DBUMCONNECTOR]... [APP: oim#11.1.2.0.0] org.identityconnectors.dbum.DBUMConnector : conditionCheck : Assertion Failed:
... [ERROR] [] [ORG.IDENTITYCONNECTORS.DBUM.SQLEXECUTIONHANDLER] ... [APP: oim#11.1.2.0.0] org.identityconnectors.dbum.SQLExecutionHandler : executeAccountSearch : Error while searching user records[[
org.identityconnectors.framework.common.exceptions.ConnectorException: Invalid parameter definition syntax ColQuery:(select concat(TO_CHAR((SELECT distinct CASE WHEN REHIRE_DT IS NULL or REHIRE_DT = '' and start_date is not NULL THEN START_DATE ELSE REHIRE_DT END AS START_DDDATE FROM MMC_WORKDAY_OIM_STAGING WHERE MMC_ADDL_ID = wd.MMC_ADDL_ID AND EMPLID=wd.EMPLID and mmc_addl_id is NOT NULL and emplid is not NULL), 'yyyy/MM/dd HH\:mm\:ss'), ' EDT') from dual)
at org.identityconnectors.dbum.utils.DBUMAssertions.conditionCheck(DBUMAssertions.java:57)
at org.identityconnectors.dbum.utils.Utils.parseParamDefn(Utils.java:653)
at org.identityconnectors.dbum.QueryBuilder.setQueryParam(QueryBuilder.java:349)
at org.identityconnectors.dbum.QueryBuilder.buildSearchQuery(QueryBuilder.java:279)
at org.identityconnectors.dbum.SQLExecutionHandler.searchAccounts(SQLExecutionHandler.java:279)
at org.identityconnectors.dbum.SQLExecutionHandler.executeAccountSearch(SQLExecutionHandler.java:95)
at org.identityconnectors.dbum.DBUMConnector.executeQuery(DBUMConnector.java:199)
at org.identityconnectors.dbum.DBUMConnector.executeQuery(DBUMConnector.java:74)
at org.identityconnectors.framework.impl.api.local.operations.SearchImpl.rawSearch(SearchImpl.java:105)
at org.identityconnectors.framework.impl.api.local.operations.SearchImpl.search(SearchImpl.java:82)
at sun.reflect.GeneratedMethodAccessor4847.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.identityconnectors.framework.impl.api.local.operations.ConnectorAPIOperationRunnerProxy.invoke(ConnectorAPIOperationRunnerProxy.java:93)
at com.sun.proxy.$Proxy664.search(Unknown Source)
... [ERROR] [] [ORG.IDENTITYCONNECTORS.DBUM.SQLEXECUTIONHANDLER] ... [APP: oim#11.1.2.0.0] org.identityconnectors.dbum.SQLExecutionHandler : executeAccountSearch : Error while searching user records[[
org.identityconnectors.framework.common.exceptions.ConnectorException: Invalid parameter definition syntax ColQuery:(select concat(TO_CHAR((SELECT distinct CASE WHEN REHIRE_DT IS NULL or REHIRE_DT = '' and start_date is not NULL THEN START_DATE ELSE REHIRE_DT END AS START_DDDATE FROM MMC_WORKDAY_OIM_STAGING WHERE MMC_ADDL_ID = wd.MMC_ADDL_ID AND EMPLID=wd.EMPLID and mmc_addl_id is NOT NULL and emplid is not NULL), 'yyyy/MM/dd HH\:mm\:ss'), ' EDT') from dual)
at org.identityconnectors.dbum.utils.DBUMAssertions.conditionCheck(DBUMAssertions.java:57)
at org.identityconnectors.dbum.utils.Utils.parseParamDefn(Utils.java:653)
at org.identityconnectors.dbum.QueryBuilder.setQueryParam(QueryBuilder.java:349)
at org.identityconnectors.dbum.QueryBuilder.buildSearchQuery(QueryBuilder.java:279)
at org.identityconnectors.dbum.SQLExecutionHandler.searchAccounts(SQLExecutionHandler.java:279)
at org.identityconnectors.dbum.SQLExecutionHandler.executeAccountSearch(SQLExecutionHandler.java:95)
at org.identityconnectors.dbum.DBUMConnector.executeQuery(DBUMConnector.java:199)
at org.identityconnectors.dbum.DBUMConnector.executeQuery(DBUMConnector.java:74)
at org.identityconnectors.framework.impl.api.local.operations.SearchImpl.rawSearch(SearchImpl.java:105)
at org.identityconnectors.framework.impl.api.local.operations.SearchImpl.search(SearchImpl.java:82)
at sun.reflect.GeneratedMethodAccessor4847.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.identityconnectors.framework.impl.api.local.operations.ConnectorAPIOperationRunnerProxy.invoke(ConnectorAPIOperationRunnerProxy.java:93)
at com.sun.proxy.$Proxy664.search(Unknown Source)
Steps to reproduce:
1- Install and configure the DBUM 11.1.1.8 connector.
2- Modify the Search.query file inside DBUM connector bundle Bundle Jar.
3- Upload this jar to be used by the connector.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |