oracle.iam.platform.utils.SuperRuntimeException: oracle.iam.platform.utils.SuperRuntimeException: java.sql.SQLException: ORA-20001: An error was encountered - XL_SP_ReconBlkUsrRqdcValdnMtch while Processing Batch ID ORA-20001: An error was encountered - XL_SP_ReconBlkUserMatch while Processing Batch ID 151 ORA-01013: user requested cancel of current operation ORA-06512: at "PROD_OIM.XL_SP_RECONBLKUSRRQDCVALDNMTCH", line 760 ORA-06512: at "PROD_OIM.OIM_SP_RECONBLKUSRMLSWRAPPER", line 54 ORA-06512: at line 1at oracle.iam.reconciliation.impl.ActionEngine.processBatch(ActionEngine.java:145)

Oracle Community | vicky | 6 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    OIM11g - GTC Trusted - Events are in Data Received state

    Oracle Community | 6 years ago | vicky
    oracle.iam.platform.utils.SuperRuntimeException: oracle.iam.platform.utils.SuperRuntimeException: java.sql.SQLException: ORA-20001: An error was encountered - XL_SP_ReconBlkUsrRqdcValdnMtch while Processing Batch ID ORA-20001: An error was encountered - XL_SP_ReconBlkUserMatch while Processing Batch ID 151 ORA-01013: user requested cancel of current operation ORA-06512: at "PROD_OIM.XL_SP_RECONBLKUSRRQDCVALDNMTCH", line 760 ORA-06512: at "PROD_OIM.OIM_SP_RECONBLKUSRMLSWRAPPER", line 54 ORA-06512: at line 1at oracle.iam.reconciliation.impl.ActionEngine.processBatch(ActionEngine.java:145)
  2. 0

    Trusted Source Errore 11g - OIM_SP_RECONBLKUSRMLSWRAPPER

    Oracle Community | 5 years ago | 935811
    java.sql.SQLException: ORA-06550: line 1, column 7: PLS-00905: object DEV_OIM.OIM_SP_RECONBLKUSRMLSWRAPPER is invalid ORA-06550: line 1, column 7: PL/SQL: Statement ignored
  3. 0

    OIM 11.1.1.5.7 OpenLDAP Delete Reconciliation Issue

    Oracle Community | 3 years ago | 795717
    java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error ORA-06512: at "NCSUDEV2_OIM.XL_SP_RECONBLKCHILDMTHACNTCRUD", line 1057 ORA-06512: at "NCSUDEV2_OIM.XL_SP_RECONBLKACNTRQDCMTCHCRUD", line 90 ORA-06512: at line 1at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:457)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    JCA Transport Database Errors catching/understanding.

    Oracle Community | 7 years ago | 782468
    java.sql.SQLException: ORA-01013: user requested cancel of current operation ORA-06512: at "SINGLE_OSB_DOMAIN_VM1.CUSTOMER_TRIGGER", line 2 ORA-04088: error during execution of trigger 'SINGLE_OSB_DOMAIN_VM1.CUSTOMER_TRIGGER' ORA-06512: at "SINGLE_OSB_DOMAIN_VM1.TIMEOUTED_PROC", line 5 ORA-06512: at line 1 Check to ensure that the API is defined in the database and that the parameters match the signature of the API. This exception is considered retriable, likely due to a communication failure. To classify it as non-retriable instead add property nonRetriableErrorCodes with value "1013" to your deployment descriptor (i.e. weblogic-ra.xml). To auto retry a retriable fault set these composite.xml properties for this invoke: jca.retry.interval, jca.retry.count, and jca.retry.backoff. All properties are integers.
  6. 0

    Debug « Middleware Magic

    middlewaremagic.com | 2 years ago
    java.sql.SQLException: Closed Connection
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. java.sql.SQLException

    ORA-20001: An error was encountered - XL_SP_ReconBlkUsrRqdcValdnMtch while Processing Batch ID ORA-20001: An error was encountered - XL_SP_ReconBlkUserMatch while Processing Batch ID 151 ORA-01013: user requested cancel of current operation ORA-06512: at "PROD_OIM.XL_SP_RECONBLKUSRRQDCVALDNMTCH", line 760 ORA-06512: at "PROD_OIM.OIM_SP_RECONBLKUSRMLSWRAPPER", line 54 ORA-06512: at line 1at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:74)

    at oracle.jdbc.driver.DatabaseError.newSQLException()
  2. Oracle jdbc
    OraclePreparedStatementWrapper.execute
    1. oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:135)
    2. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:210)
    3. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:473)
    4. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:423)
    5. oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1095)
    6. oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:201)
    7. oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1036)
    8. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1379)
    9. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3568)
    10. oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3739)
    11. oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:8150)
    12. oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1535)
    12 frames
  3. weblogic.jdbc.wrapper
    PreparedStatement.execute
    1. weblogic.jdbc.wrapper.PreparedStatement.execute(PreparedStatement.java:99)
    1 frame
  4. oracle.iam.reconciliation
    ActionTask.execute
    1. oracle.iam.reconciliation.dao.ReconActionDao$1ReconDBCall.command(ReconActionDao.java:1288)
    2. oracle.iam.reconciliation.dao.ReconActionDao$1ReconDBCall.command(ReconActionDao.java:1271)
    3. oracle.iam.reconciliation.dao.DBCall.execute(DBCall.java:17)
    4. oracle.iam.reconciliation.dao.ReconActionDao.processSPCall(ReconActionDao.java:1316)
    5. oracle.iam.reconciliation.dao.ReconActionDao.executeBulkUserMatchCRUD(ReconActionDao.java:686)
    6. oracle.iam.reconciliation.impl.UserHandler.executeBulkCUD(UserHandler.java:568)
    7. oracle.iam.reconciliation.impl.BaseEntityTypeHandler.process(BaseEntityTypeHandler.java:34)
    8. oracle.iam.reconciliation.impl.ActionEngine.processBatch(ActionEngine.java:129)
    9. oracle.iam.reconciliation.impl.ActionEngine.execute(ActionEngine.java:90)
    10. oracle.iam.reconciliation.impl.ActionTask.execute(ActionTask.java:72)
    10 frames
  5. oracle.iam.platform
    MessageReceiver.onMessage
    1. oracle.iam.platform.async.impl.TaskExecutor.executeUnmanagedTask(TaskExecutor.java:100)
    2. oracle.iam.platform.async.impl.TaskExecutor.execute(TaskExecutor.java:70)
    3. oracle.iam.platform.async.messaging.MessageReceiver.onMessage(MessageReceiver.java:68)
    3 frames
  6. Java RT
    Method.invoke
    1. sun.reflect.GeneratedMethodAccessor582.invoke(Unknown Source)
    2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    3. java.lang.reflect.Method.invoke(Method.java:597)
    3 frames
  7. 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
  8. Unknown
    $Proxy379.onMessage
    1. $Proxy379.onMessage(Unknown Source)
    1 frame
  9. weblogic.ejb.container
    MDListener.onMessage
    1. weblogic.ejb.container.internal.MDListener.execute(MDListener.java:466)
    2. weblogic.ejb.container.internal.MDListener.transactionalOnMessage(MDListener.java:371)
    3. weblogic.ejb.container.internal.MDListener.onMessage(MDListener.java:327)
    3 frames
  10. 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
  11. weblogic.work
    ExecuteThread.run
    1. weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl.run(SelfTuningWorkManagerImpl.java:528)
    2. weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
    3. weblogic.work.ExecuteThread.run(ExecuteThread.java:173)
    3 frames