Hi,
Migrated the AD Connector componenets from DEV to SIT and when I run the target recon getting the below error.
[2017-10-10T19:13:03.669+11:00] [oim_server1] [WARNING] [] [oracle.iam.platform.async] [tid: [ACTIVE].ExecuteThread: '25' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: oiminternal] [ecid: 0000LvaQJVjFk375rJ4EyY1Pp9Mt000004,0] [APP: oim#11.1.2.0.0] Error occurred while executing unmanaged async task. Task Name:oracle.iam.reconciliation.impl.ActionTask
==> oim_server1.out <==
<10/10/2017 7:13:03 PM AEDT> <Warning> <oracle.iam.platform.async> <BEA-000000> <Error occurred while executing unmanaged async task. Task Name:oracle.iam.reconciliation.impl.ActionTask>
==> oim_server1-diagnostic.log <==
[2017-10-10T19:13:03.669+11:00] [oim_server1] [WARNING] [] [oracle.iam.platform.async] [tid: [ACTIVE].ExecuteThread: '25' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: oiminternal] [ecid: 0000LvaQJVjFk375rJ4EyY1Pp9Mt000004,0] [APP: oim#11.1.2.0.0] Exception for above message i.e IAM-0050000[[
oracle.iam.platform.utils.SuperRuntimeException: oracle.iam.platform.tx.OIMTransactionException: java.sql.SQLException: ORA-20001: Error occured in XL_SP_ReconBlkChildMthAcntCRUD while processing Batch ID - 249488 XL_SP_ReconBlkChildMthAcntCRUD failed e_xlSpReconBlkChildMthAcntCRUD - FORMAT_ERROR_BACKTRACE: ORA-06512: at "IGD_OIM.XL_SP_RECONBLKCHILDMTHACNTCRUD", line 318
FORMAT_ERROR_STACK: ORA-20101:
-20101 -ERROR- ORA-20101:
ORA-06512: at "IGD_OIM.XL_SP_RECONBLKCHILDMTHACNTCRUD", line 3609
ORA-06512: at "IGD_OIM.XL_SP_RECONBLKACNTRQDCMTCHCRUD", line 91
ORA-06512: at line 1
at oracle.iam.reconciliation.impl.ActionEngine.processBatch(ActionEngine.java:125)
at oracle.iam.reconciliation.impl.ActionEngine.execute(ActionEngine.java:91)
at oracle.iam.reconciliation.impl.ActionTask.executeTask(ActionTask.java:77)
at oracle.iam.reconciliation.impl.ActionTask.execute(ActionTask.java:66)
at oracle.iam.platform.async.impl.TaskExecutor.executeUnmanagedTask(TaskExecutor.java:99)
at oracle.iam.platform.async.impl.TaskExecutor.execute(TaskExecutor.java:69)
at oracle.iam.platform.async.messaging.MessageReceiver.onMessage(MessageReceiver.java:68)
at sun.reflect.GeneratedMethodAccessor4472.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at com.bea.core.repackaged.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
at com.bea.core.repackaged.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at com.bea.core.repa
Clicked on Create Reconciliation Profile and still see the same error.
Please help. Its a show stopper at the moment. Recon works in dev n not in SIT.
Thanks,
Sahana