ORA-30556 Error when Generating Recon Profile after Applying Patch

(Doc ID 2328598.1)

Last updated on FEBRUARY 13, 2018

Applies to:

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

Symptoms


Applying OIM 11g R2 PS2 BP09 (22504794) patch, while trying to regenerate the Reconciliation profile ( as per 4.7 of Patch README ) through design console encountering the following error:

<Error> <XELLERATE.SERVER> <BEA-000000> <Error encountered during recon profile creation
oracle.iam.reconciliation.exception.ConfigException: oracle.iam.platform.tx.OIMTransactionException: oracle.iam.platform.entitymgr.SchemaUpdateException: ALTER TABLE RA_ADUSERE469E5C8 MODIFY RA_EMPLOYEEID99E49BAD VARCHAR2(80)
at oracle.iam.reconciliation.impl.config.CoreProfileManagerImpl.updateSchema(CoreProfileManagerImpl.java:370)
at oracle.iam.reconciliation.impl.config.CoreProfileManagerImpl.configureStagingTable(CoreProfileManagerImpl.java:328)
at oracle.iam.reconciliation.impl.config.CoreProfileManagerImpl.configure(CoreProfileManagerImpl.java:101)
at oracle.iam.reconciliation.impl.config.CoreProfileManagerImpl.configure(CoreProfileManagerImpl.java:83)
at oracle.iam.reconciliation.impl.config.ProfileManagerImpl.configure(ProfileManagerImpl.java:105)
.
.
Caused By: oracle.iam.platform.tx.OIMTransactionException: oracle.iam.platform.entitymgr.SchemaUpdateException: ALTER TABLE RA_ADUSERE469E5C8 MODIFY RA_EMPLOYEEID99E49BAD VARCHAR2(80)
at oracle.iam.platform.tx.OIMTransactionManager.execute(OIMTransactionManager.java:28)
at oracle.iam.platform.entitymgr.provider.rdbms.RDBMSRepository.updateSchema(RDBMSRepository.java:291)
at oracle.iam.reconciliation.impl.config.CoreProfileManagerImpl.updateSchema(CoreProfileManagerImpl.java:368)
at oracle.iam.reconciliation.impl.config.CoreProfileManagerImpl.configureStagingTable(CoreProfileManagerImpl.java:328)
at oracle.iam.reconciliation.impl.config.CoreProfileManagerImpl.configure(CoreProfileManagerImpl.java:101)
at oracle.iam.reconciliation.impl.config.CoreProfileManagerImpl.configure(CoreProfileManagerImpl.java:83)
at oracle.iam.reconciliation.impl.config.ProfileManagerImpl.configure(ProfileManagerImpl.java:105)
.
.
Caused By: oracle.iam.platform.entitymgr.SchemaUpdateException: ALTER TABLE RA_ADUSERE469E5C8 MODIFY RA_EMPLOYEEID99E49BAD VARCHAR2(80)
at oracle.iam.platform.entitymgr.provider.rdbms.RDBMSRepository.executeUpdate(RDBMSRepository.java:488)
at oracle.iam.platform.entitymgr.provider.rdbms.RDBMSRepository.modifySchema(RDBMSRepository.java:383)
at oracle.iam.platform.entitymgr.provider.rdbms.RDBMSRepository.access$100(RDBMSRepository.java:70)
at oracle.iam.platform.entitymgr.provider.rdbms.RDBMSRepository$1.processWithoutResult(RDBMSRepository.java:301)
at oracle.iam.platform.tx.OIMTransactionCallbackWithoutResult.process(OIMTransactionCallbackWithoutResult.java:9)
at oracle.iam.platform.tx.OIMTransactionCallback.doInTransaction(OIMTransactionCallback.java:13)
at oracle.iam.platform.tx.OIMTransactionCallback.doInTransaction(OIMTransactionCallback.java:6)
at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:128)
at oracle.iam.platform.tx.OIMTransactionManager.execute(OIMTransactionManager.java:22)
at oracle.iam.platform.entitymgr.provider.rdbms.RDBMSRepository.updateSchema(RDBMSRepository.java:291)
.
.
Caused By: java.sql.SQLException: ORA-30556: either functional or bitmap join index is defined on the column to be modified

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.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1115)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3904)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1512)
at weblogic.jdbc.wrapper.PreparedStatement.executeUpdate(PreparedStatement.java:172)
at oracle.iam.platform.entitymgr.provider.rdbms.RDBMSRepository.executeUpdate(RDBMSRepository.java:486)



Changes

 Applied Build Patch

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