Entitlement Post Delete schedule job fails with ORA-00913: too many values

(Doc ID 2314111.1)

Last updated on OCTOBER 04, 2017

Applies to:

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

Symptoms

In a system with a huge number of entitlements running the Entitlement Post Delete schedule job fails with the following error:

[2017-08-07T02:03:45.831-04:00] [oim_server4] [ERROR] [] [oracle.iam.provisioning.util] [tid: OIMQuartzScheduler_Worker-3] [userId:oiminternal] [ecid:f1371e2323bfc1c3:1ce9189d:15d68dcfa89:-8000-0000000000000004,1:30135] [APP:oim#11.1.2.0.0] DOBProvisioningUtil.populateEntitlementInstances() : 17385d06:03:45[[
com.thortech.xl.orb.dataaccess.tcDataAccessException
at
com.thortech.xl.dataaccess.tcDataAccessExceptionUtil.createException(tcDataAccessExceptionUtil.java:81)
at
com.thortech.xl.dataaccess.tcDataBase.createException(tcDataBase.java:3209)
at
com.thortech.xl.dataaccess.tcDataBase.readPartialPreparedStatement(tcDataBase.java:1411)
at
com.thortech.xl.dataaccess.tcDataBase.readPreparedStatement(tcDataBase.java:1190)
at
com.thortech.xl.dataobj.PreparedStatementUtil.execute(PreparedStatementUtil.java:355)
at
oracle.iam.provisioning.spi.DOBProvisioningUtil.populateEntitlementInstances(DOBProvisioningUtil.java:2776)
...
Caused by: java.sql.SQLSyntaxErrorException: ORA-00913: too many values

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)

 

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