java.sql.SQLException: ORA-20001: An error was encountered - XL_SP_ReconBlkRqdcAcntMatch while Processing Batch no 4 ORA-20001: An error was encountered - XL_SP_ReconBlkUserMatch while Processing Batch ID 4 ORA-01747: invalid user.table.column, table.column, or column specification ORA-06512: at "DEV_OIM.XL_SP_RECONBLKRQDCACNTMATCH", line 468 ORA-06512: at "DEV_OIM.XL_SP_RECONBLKACNTRQDCMTCHCRUD", line 69 ORA-06512: at line 1at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)

Oracle Community | 2781494 | 2 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

    Problem during Active Directory riconciliation event oracle identity manager 11gr2

    Oracle Community | 2 years ago | 2781494
    java.sql.SQLException: ORA-20001: An error was encountered - XL_SP_ReconBlkRqdcAcntMatch while Processing Batch no 4 ORA-20001: An error was encountered - XL_SP_ReconBlkUserMatch while Processing Batch ID 4 ORA-01747: invalid user.table.column, table.column, or column specification ORA-06512: at "DEV_OIM.XL_SP_RECONBLKRQDCACNTMATCH", line 468 ORA-06512: at "DEV_OIM.XL_SP_RECONBLKACNTRQDCMTCHCRUD", line 69 ORA-06512: at line 1at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
  2. 0

    OIM11gr2 Error while performing Recon with status field

    Oracle Community | 4 years ago | 967886
    oracle.iam.platform.utils.SuperRuntimeException: oracle.iam.platform.tx.OIMTransactionException: java.sql.SQLException: ORA-19202: Error occurred in XML processing ORA-00972: identifier is too long ORA-06512: at "SYS.DBMS_XMLGEN", line 7 ORA-06512: at "SYS.DBMS_XMLGEN", line 147 ORA-06512: at "DEV_OIM.OIM_SP_RECONBLKACCOUNTCHGLOG", line 294 ORA-06512: at "DEV_OIM.XL_SP_RECONBLKCHILDMTHACNTCRUD", line 3380 ORA-06512: at "DEV_OIM.XL_SP_RECONBLKACNTRQDCMTCHCRUD", line 91 ORA-06512: at line 1at oracle.iam.reconciliation.dao.DBCall.execute(DBCall.java:24)
  3. 0

    DBAT Trusted Reconciliation error

    Oracle Community | 2 years ago | 2752381
    oracle.iam.platform.tx.OIMTransactionException: 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
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    OIM11g - GTC Trusted - Events are in Data Received state

    Oracle Community | 6 years ago | vicky
    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 11330 ORA-01013: user requested cancel of current operation ORA-06512: at "QIOR_OIM.XL_SP_RECONBLKUSRRQDCVALDNMTCH", line 760 ORA-06512: at "QIOR_OIM.OIM_SP_RECONBLKUSRMLSWRAPPER", line 54 ORA-06512: at line 1at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
  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_ReconBlkRqdcAcntMatch while Processing Batch no 4 ORA-20001: An error was encountered - XL_SP_ReconBlkUserMatch while Processing Batch ID 4 ORA-01747: invalid user.table.column, table.column, or column specification ORA-06512: at "DEV_OIM.XL_SP_RECONBLKRQDCACNTMATCH", line 468 ORA-06512: at "DEV_OIM.XL_SP_RECONBLKACNTRQDCMTCHCRUD", line 69 ORA-06512: at line 1at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)

    at oracle.jdbc.driver.T4CTTIoer.processError()
  2. Oracle jdbc
    OraclePreparedStatementWrapper.execute
    1. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
    2. oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
    3. oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
    4. oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
    5. oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)
    6. oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:213)
    7. oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1111)
    8. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488)
    9. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)
    10. oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3954)
    11. oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:9353)
    12. oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1539)
    12 frames
  3. weblogic.jdbc.wrapper
    PreparedStatement.execute
    1. weblogic.jdbc.wrapper.PreparedStatement.execute(PreparedStatement.java:99)
    1 frame
  4. oracle.iam.reconciliation
    ReconActionDao$1ReconDBCall$1.process
    1. oracle.iam.reconciliation.dao.ReconActionDao$1ReconDBCall$1.process(ReconActionDao.java:1465)
    2. oracle.iam.reconciliation.dao.ReconActionDao$1ReconDBCall$1.process(ReconActionDao.java:1448)
    2 frames
  5. oracle.iam.platform
    OIMTransactionCallback.doInTransaction
    1. oracle.iam.platform.tx.OIMTransactionCallback.doInTransaction(OIMTransactionCallback.java:13)
    2. oracle.iam.platform.tx.OIMTransactionCallback.doInTransaction(OIMTransactionCallback.java:6)
    2 frames
  6. Spring Tx
    TransactionTemplate.execute
    1. org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:128)
    1 frame
  7. oracle.iam.platform
    OIMTransactionManager.execute
    1. oracle.iam.platform.tx.OIMTransactionManager.execute(OIMTransactionManager.java:22)
    1 frame
  8. oracle.iam.reconciliation
    ActionTask.execute
    1. oracle.iam.reconciliation.dao.ReconActionDao$1ReconDBCall.command(ReconActionDao.java:1448)
    2. oracle.iam.reconciliation.dao.ReconActionDao$1ReconDBCall.command(ReconActionDao.java:1444)
    3. oracle.iam.reconciliation.dao.DBCall.execute(DBCall.java:17)
    4. oracle.iam.reconciliation.dao.ReconActionDao.processSPCall(ReconActionDao.java:1492)
    5. oracle.iam.reconciliation.dao.ReconActionDao.executeBulkAccountMatchCRUD(ReconActionDao.java:907)
    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.executeTask(ActionTask.java:77)
    11. oracle.iam.reconciliation.impl.ActionTask.execute(ActionTask.java:66)
    11 frames
  9. 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
  10. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    4. java.lang.reflect.Method.invoke(Method.java:597)
    4 frames
  11. com.bea.core
    ReflectiveMethodInvocation.proceed
    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)
    3 frames