Security Software

Hi,

We have an issue changing a user's organization via the OIM Administration console. For some problem organisations, when a user is attempted to be moved to one of the problem organisations, a dialog box error on admin the console is displayed:

"An error occurred. The corresponding error code is IAM-0080001".

Checking the logs, the actual error stackdump starts with:
<Oct 3, 2012 9:50:44 AM EST> <Warning> <org.eclipse.persistence.session.oim> <BEA-000000> <
Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.1.3.v20110304-r9073): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-02291: integrity constraint (IAMTEST_OIM.FK_ORC_ORD) violated - parent key n
ot found
ORA-06512: at "IAMTEST_OIM.OIM_USER_MGMT", line 858
ORA-06512: at line 1

Error Code: 2291
Call: BEGIN OIM_USER_MGMT.BulkUserModify(p_intUserKey=>?, p_arUSRList=>?, p_arColumnlist=>?, p_arColumnValue=>?, p_arMLSColLocaleValue=>?, p_intReturnC
ode_out=>?, p_strErrMessage_out=>?); END;
bind => [1, oracle.sql.ARRAY@199c54c1, oracle.sql.ARRAY@199c6768, oracle.sql.ARRAY@199c489c, oracle.sql.ARRAY@199c6167, => p_intReturnCode_out,
=> p_strErrMessage_out]
Query: DataReadQuery()
at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:324)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:797)
at org.eclipse.persistence.internal.databaseaccess.DatabasePlatform.executeStoredProcedure(DatabasePlatform.java:1991)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:593)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:526)
at org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:529)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:206)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:192)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:263)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeSelect(DatasourceCallQueryMechanism.java:245)
at org.eclipse.persistence.queries.DataReadQuery.executeNonCursor(DataReadQuery.java:192)
at org.eclipse.persistence.queries.DataReadQuery.executeDatabaseQuery(DataReadQuery.java:148)
at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:740)
at org.eclipse.persistence.queries.DataReadQuery.execute(DataReadQuery.java:134)
at org.eclipse.persistence.internal.sessions.AbstractSession.internalExecuteQuery(AbstractSession.java:2392)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1291)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1273)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1233)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeSelectingCall(AbstractSession.java:1397)
at oracle.iam.oimdataproviders.impl.OIMUserDataProvider.modifyProcedureCall(OIMUserDataProvider.java:721)
at oracle.iam.oimdataproviders.impl.OIMUserDataProvider.modify(OIMUserDataProvider.java:578)
at oracle.iam.platform.entitymgr.impl.EntityManagerImpl.modifyEntity(EntityManagerImpl.java:388)
at oracle.iam.platform.kernel.impl.EntityDefaultActionHandler.execute(EntityDefaultActionHandler.java:41)
at oracle.iam.platform.kernel.impl.DefaultActionHandler.execute(DefaultActionHandler.java:41)
at oracle.iam.identity.usermgmt.impl.handlers.modify.ModifyUserActionHandler.execute(ModifyUserActionHandler.java:108)
at oracle.iam.identity.usermgmt.impl.handlers.modify.ModifyUserActionHandler.execute(ModifyUserActionHandler.java:56)
at sun.reflect.GeneratedMethodAccessor685.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at oracle.iam.platform.kernel.impl.EventHandlerDynamicProxy.invoke(EventHandlerDynamicProxy.java:30)
...

The error doesn't occur if a user is created in the problem organisation, but when the user is moved out of the problem organisation and then attempted to be moved back into the same problem organisation, the same error occurs.

We are using OIM 11g Release 1 (11.1.1.5.0)

I haven't found any references to this error in my searching so any suggestions about how we can recover/fix it are appreciated. As mentioned, only some organisations have this problem, but i cannot find any differences between these problem organisations and the other normal organisations.

Thanks.

Edited by: user10929505 on 02-Oct-2012 23:50