oracle.iam.platform.tx.OIMTransactionException: java.sql.SQLException: ORA-20001: An error was encountered - XL_SP_ReconBlkRqdcAcntMatch while Processing Batch no 45503 ORA-20001: An error was encountered - XL_SP_ReconBlkUserMatch while Processing Batch ID 45503 ORA-01013: user requested cancel of current operation ORA-06512: at "OIM01PT_OIM.XL_SP_RECONBLKRQDCACNTMATCH", line 468 ORA-06512: at "OIM01PT_OIM.XL_SP_RECONBLKACNTRQDCMTCHCRUD", line 69 ORA-06512: at line 1at oracle.iam.platform.tx.OIMTransactionManager.execute(OIMTransactionManager.java:28)

Oracle Community | 2661067 | 3 years ago
  1. 0

    I am getting an error while migrating AD User data from OIM 9i to 11gR2

    Oracle Community | 3 years ago | 2661067
    oracle.iam.platform.tx.OIMTransactionException: java.sql.SQLException: ORA-20001: An error was encountered - XL_SP_ReconBlkRqdcAcntMatch while Processing Batch no 45503 ORA-20001: An error was encountered - XL_SP_ReconBlkUserMatch while Processing Batch ID 45503 ORA-01013: user requested cancel of current operation ORA-06512: at "OIM01PT_OIM.XL_SP_RECONBLKRQDCACNTMATCH", line 468 ORA-06512: at "OIM01PT_OIM.XL_SP_RECONBLKACNTRQDCMTCHCRUD", line 69 ORA-06512: at line 1at oracle.iam.platform.tx.OIMTransactionManager.execute(OIMTransactionManager.java:28)
  2. 0

    OIM 11g R2 - Recon events not getting linked

    Oracle Community | 4 years ago | 881156
    oracle.iam.platform.tx.OIMTransactionException: java.sql.SQLException: ORA-01422: exact fetch returns more than requested number of rows ORA-06512: at "DEV_OIM.XL_SP_RECONBLKCHILDMTHACNTCRUD", line 730 ORA-06512: at "DEV_OIM.XL_SP_RECONBLKACNTRQDCMTCHCRUD", line 91 ORA-06512: at line 1at oracle.iam.platform.tx.OIMTransactionManager.execute(OIMTransactionManager.java:28)
  3. 0

    OIMClient: Failed to create the request in the repository

    Oracle Community | 3 years ago | Zhang Zhongyi
    oracle.iam.platform.tx.OIMTransactionException: oracle.iam.request.exception.RequestServiceException: Failed to create the request in the repository.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. oracle.iam.platform.tx.OIMTransactionException

      java.sql.SQLException: ORA-20001: An error was encountered - XL_SP_ReconBlkRqdcAcntMatch while Processing Batch no 45503 ORA-20001: An error was encountered - XL_SP_ReconBlkUserMatch while Processing Batch ID 45503 ORA-01013: user requested cancel of current operation ORA-06512: at "OIM01PT_OIM.XL_SP_RECONBLKRQDCACNTMATCH", line 468 ORA-06512: at "OIM01PT_OIM.XL_SP_RECONBLKACNTRQDCMTCHCRUD", line 69 ORA-06512: at line 1at oracle.iam.platform.tx.OIMTransactionManager.execute(OIMTransactionManager.java:28)

      at oracle.iam.reconciliation.dao.ReconActionDao$1ReconDBCall.command()
    2. oracle.iam.reconciliation
      ActionTask.execute
      1. oracle.iam.reconciliation.dao.ReconActionDao$1ReconDBCall.command(ReconActionDao.java:1440)
      2. oracle.iam.reconciliation.dao.ReconActionDao$1ReconDBCall.command(ReconActionDao.java:1436)
      3. oracle.iam.reconciliation.dao.DBCall.execute(DBCall.java:17)
      4. oracle.iam.reconciliation.dao.ReconActionDao.processSPCall(ReconActionDao.java:1484)
      5. oracle.iam.reconciliation.dao.ReconActionDao.executeBulkAccountMatchCRUD(ReconActionDao.java:905)
      6. oracle.iam.reconciliation.impl.AccountHandler.executeBulkCUD(AccountHandler.java:77)
      7. oracle.iam.reconciliation.impl.BaseEntityTypeHandler.process(BaseEntityTypeHandler.java:56)
      8. oracle.iam.reconciliation.impl.ActionEngine.processBatch(ActionEngine.java:118)
      9. oracle.iam.reconciliation.impl.ActionEngine.execute(ActionEngine.java:91)
      10. oracle.iam.reconciliation.impl.ActionTask.execute(ActionTask.java:72)
      10 frames
    3. oracle.iam.platform
      MessageReceiver.onMessage
      1. oracle.iam.platform.async.impl.TaskExecutor.executeUnmanagedTask(TaskExecutor.java:99)
      2. oracle.iam.platform.async.impl.TaskExecutor.execute(TaskExecutor.java:69)
      3. oracle.iam.platform.async.messaging.MessageReceiver.onMessage(MessageReceiver.java:68)
      3 frames
    4. Java RT
      Method.invoke
      1. sun.reflect.GeneratedMethodAccessor1309.invoke(Unknown Source)
      2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      3. java.lang.reflect.Method.invoke(Method.java:601)
      3 frames
    5. com.bea.core
      JdkDynamicAopProxy.invoke
      1. com.bea.core.repackaged.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
      2. com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
      3. com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
      4. com.bea.core.repackaged.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
      5. com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
      6. com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
      7. com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
      8. com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
      9. com.bea.core.repackaged.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
      9 frames
    6. Unknown
      $Proxy459.onMessage
      1. $Proxy459.onMessage(Unknown Source)
      1 frame
    7. weblogic.ejb.container
      MDListener.onMessage
      1. weblogic.ejb.container.internal.MDListener.execute(MDListener.java:583)
      2. weblogic.ejb.container.internal.MDListener.transactionalOnMessage(MDListener.java:486)
      3. weblogic.ejb.container.internal.MDListener.onMessage(MDListener.java:388)
      3 frames
    8. weblogic.jms.client
      JMSSession$UseForRunnable.run
      1. weblogic.jms.client.JMSSession.onMessage(JMSSession.java:4659)
      2. weblogic.jms.client.JMSSession.execute(JMSSession.java:4345)
      3. weblogic.jms.client.JMSSession.executeMessage(JMSSession.java:3821)
      4. weblogic.jms.client.JMSSession.access$000(JMSSession.java:115)
      5. weblogic.jms.client.JMSSession$UseForRunnable.run(JMSSession.java:5170)
      5 frames
    9. weblogic.work
      ExecuteThread.run
      1. weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl.run(SelfTuningWorkManagerImpl.java:545)
      2. weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
      3. weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
      3 frames