Last updated on FEBRUARY 05, 2017

Applies to:

Goal

Experiencing an issue in production environment where recon events from RACF are being stuck in a "Data Received" (not linked to any user) status instead of completing to "creation successful" or "update successful". Following error is seen in the oim_server-diagnostic.log:
-------------------------------------------------------------------------------------------
[2014-02-19T16:32:33.161+01:00] [oim_server4] [ERROR] [] [oracle.iam.reconciliation.dao] [tid: OIMQuartzScheduler_Worker-7] [userId: oiminternal] [ecid: 46548e54c8a06ceb:1cd0c706:1443fdaeff1:-7ffd-0000000000000004,1:29034] [APP: oim#11.1.2.0.0] Calling stored procedure - XL_SP_RECONEVALUATEACCOUNT[[
 intUserKey_in = 4
 intEventKey_in = 5481242
 strRequiredAttributesList_in =
 strMappedTableName_in = UD_EZCUSER
 strTargetTableName_in = RA_EZCUSERCE1EE9D
 strEntityTableName_in = USR
 strAccountMatchingRule_in = (UPPER(UD_EZCUSER.UD_EZCUSER_UID)=UPPER(RA_EZCUSERCE1EE9D.RA_USERID5A729590))
 strEntityMatchingRule_in = ((UPPER(USR.usr_email)=UPPER(RA_EZCUSERCE1EE9D.RA_EMAIL77A5CCD2)))
 strChildTargetTableName_in =
 strChildReqAttributesList_in =
 strStagingITResColName_in = RA_ITRESOURCENAME70C9F928
]]


[2014-02-19T16:34:34.959+01:00] [oim_server4] [ERROR] [] [ORACLE.IAM.CONNECTORS.ICFCOMMON.PROV.ICPROVISIONINGMANAGER] [tid: OIMQuartzScheduler_Worker-2] [userId: oiminternal] [ecid: 46548e54c8a06ceb:1cd0c706:1443fdaeff1:-7ffd-0000000000000004,1:29026] [APP: oim#11.1.2.0.0] oracle.iam.connectors.icfcommon.prov.ICProvisioningManager : createObject : Error while creating user[[
org.identityconnectors.framework.common.exceptions.AlreadyExistsException: User [Noeleen McCrystal] already exists
at org.identityconnectors.framework.impl.serializer.CommonObjectHandlers$1.createException(CommonObjectHandlers.java:138)
at org.identityconnectors.framework.impl.serializer.CommonObjectHandlers$1.createException(CommonObjectHandlers.java:137)
at org.identityconnectors.framework.impl.serializer.CommonObjectHandlers$ThrowableHandler.deserialize(CommonObjectHandlers.java:115)
at org.identityconnectors.framework.impl.serializer.binary.BinaryObjectDecoder$InternalDecoder.readObject(BinaryObjectDecoder.java:162)
at org.identityconnectors.framework.impl.serializer.binary.BinaryObjectDecoder.readObject(BinaryObjectDecoder.java:313)
at org.identityconnectors.framework.impl.serializer.binary.BinaryObjectDecoder.readObjectField(BinaryObjectDecoder.java:417)
at org.identityconnectors.framework.impl.serializer.MessageHandlers$5.deserialize(MessageHandlers.java:155)
at org.identityconnectors.framework.impl.serializer.binary.BinaryObjectDecoder$InternalDecoder.readObject(BinaryObjectDecoder.java:162)
at org.identityconnectors.framework.impl.serializer.binary.BinaryObjectDecoder.readObject(BinaryObjectDecoder.java:313)
at org.identityconnectors.framework.impl.api.remote.RemoteFrameworkConnection.readObject(RemoteFrameworkConnection.java:153)
at org.identityconnectors.framework.impl.api.remote.RemoteOperationInvocationHandler.invoke(RemoteOperationInvocationHandler.java:101)
at $Proxy1593.create(Unknown Source)
at sun.reflect.GeneratedMethodAccessor43720.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.identityconnectors.framework.impl.api.DelegatingTimeoutProxy.invoke(DelegatingTimeoutProxy.java:107)
at $Proxy1593.create(Unknown Source)
at sun.reflect.GeneratedMethodAccessor43720.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.identityconnectors.framework.impl.api.LoggingProxy.invoke(LoggingProxy.java:76)
at $Proxy1593.create(Unknown Source)
---------------------------------------------------------------------------

Please advise possible cause and resolution on this issue.
 

Solution