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 and later
Information in this document applies to any platform.


On : 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] [] [ORG.IDENTITYCONNECTORS.DBUM.DBUMCONNECTOR]... [APP: oim#] org.identityconnectors.dbum.DBUMConnector : conditionCheck : Assertion Failed:
... [ERROR] [] [ORG.IDENTITYCONNECTORS.DBUM.SQLEXECUTIONHANDLER] ... [APP: oim#] 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(
at org.identityconnectors.dbum.utils.Utils.parseParamDefn(
at org.identityconnectors.dbum.QueryBuilder.setQueryParam(
at org.identityconnectors.dbum.QueryBuilder.buildSearchQuery(
at org.identityconnectors.dbum.SQLExecutionHandler.searchAccounts(
at org.identityconnectors.dbum.SQLExecutionHandler.executeAccountSearch(
at org.identityconnectors.dbum.DBUMConnector.executeQuery(
at org.identityconnectors.dbum.DBUMConnector.executeQuery(
at org.identityconnectors.framework.impl.api.local.operations.SearchImpl.rawSearch(
at sun.reflect.GeneratedMethodAccessor4847.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(
at java.lang.reflect.Method.invoke(
at org.identityconnectors.framework.impl.api.local.operations.ConnectorAPIOperationRunnerProxy.invoke(
at com.sun.proxy.$ Source)



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

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