"ORA-00936: missing expression" Error Running Reconciliation Job During "select osi.request_key from osi..." SQL (Doc ID 2256677.1)

Last updated on APRIL 19, 2017

Applies to:

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

Symptoms

OIM : 11.1.2.3.160419

Reconciliation process is failing and provides the following error in the log:
-----------------------

[2017-04-04T15:32:01.899-04:00] [oim_server1] [ERROR] [] [XELLERATE.DATABASE] [tid: [ACTIVE].ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: oiminternal] [ecid: ...] [APP: oim#11.1.2.0.0] select osi.request_key from osi where mil_key=1455 and orc_key=11161 and sch_key=[[
java.sql.SQLSyntaxErrorException: ORA-00936: missing expression

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:202)
at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:942)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1283)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1441)
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1690)
at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:446)
at weblogic.jdbc.wrapper.Statement.executeQuery(Statement.java:506)
at com.thortech.xl.util.JDBCUtils.executeQuery(JDBCUtils.java:159)
at com.thortech.xl.dataaccess.tcDataBase.readPartialStatement(tcDataBase.java:760)
at com.thortech.xl.dataobj.tcDataBase.readPartialStatement(tcDataBase.java:287)
at com.thortech.xl.dataaccess.tcDataSet.executeQuery(tcDataSet.java:935)
at com.thortech.xl.dataobj.tcDataSet.executeQuery(tcDataSet.java:1572)
at com.thortech.xl.dataaccess.tcDataSet.executeQuery(tcDataSet.java:903)
at com.thortech.xl.dataobj.tcDataSet.executeQuery(tcDataSet.java:1539)
at com.thortech.xl.dataobj.tcScheduleItem.getRequestKeyFromContext(tcScheduleItem.java:6940)
at com.thortech.xl.dataobj.tcScheduleItem.initialize(tcScheduleItem.java:289)
at com.thortech.xl.dataobj.tcScheduleItem.<init>(tcScheduleItem.java:239)
at com.thortech.xl.adapterfactory.events.tcAdpEvent.updateSchItem(tcAdpEvent.java:155)
at com.thortech.xl.adapterfactory.events.tcAdpEvent.finalizeProcessAdapter(tcAdpEvent.java:3915)
at com.thortech.xl.adapterfactory.events.tcAdpEvent.finalizeAdapter(tcAdpEvent.java:4079)
at com.thortech.xl.adapterGlue.ScheduleItemEvents.adpTSTSWFCHANGEOIMDISPLAYNAME.implementation(adpTSTSWFCHANGEOIMDISPLAYNAME.java:69)

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms