My Oracle Support Banner

"Invalid parameter definition syntax" Error when Using Colon ":" Character In Query File Of DBUM Connector (Doc ID 2447926.1)

Last updated on JULY 21, 2020

Applies to:

Identity Manager Connector - Version 11.1.1.8.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.1.1.8.0 version, Database Connectors

Unable to use Colon character in Query file of DBUM Connector Bundle JAR

There is a syntax error encountered when using colon ':' character in the parameter of Search.query file in DBUM connector bundle jar.
Using this in SEARCH_USER of Search.query file inside DBUM connector bundle Bundle JAR.
 

ERROR

... [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)

 

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!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.