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)

Oracle Community | 795717 | 3 years ago
  1. 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)
  2. 0

    OIM11g - GTC Trusted - Events are in Data Received state

    Oracle Community | 5 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)
  3. 0

    Trusted Source Errore 11g - OIM_SP_RECONBLKUSRMLSWRAPPER

    Oracle Community | 4 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
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    BEA-380002:Invoke JCA outbound service failed with connection error, except

    Oracle Community | 4 years ago | 944460
    java.sql.SQLException: ORA-01001: invalid cursor ORA-06512: at "QA_11.SOA_GET_BANK_AND_BRANCH", 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 "1001" 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

    Unable to Index Content in UCM 11gR1-11.1.1.5.0 with Oracle Text Search

    Oracle Community | 5 years ago | 920613
    intradoc.data.DataException: !csDbUnableToExecuteCallableQuery,CoracleTextOptimizeIndex!$ORA-20000: Oracle Text error: DRG-50857: oracle error in drvddl.IndexOptimizeRebuild ORA-20000: Oracle Text error: DRG-50857: oracle error in dreogc ORA-01013: user requested cancel of current operation ORA-06512: at "CTXSYS.DRUE"\, line 160 ORA-06512: at "CTXSYS.CTX_DDL"\, line 941 ORA-06512: at line 1at intradoc.jdbc.JdbcWorkspace.handleSQLException(JdbcWorkspace.java:2461)
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-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)

    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:889)
    3. oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:476)
    4. oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:204)
    5. oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:540)
    6. oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:213)
    7. oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1075)
    8. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1466)
    9. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3752)
    10. oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3937)
    11. oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:9259)
    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:1316)
    2. oracle.iam.reconciliation.dao.ReconActionDao$1ReconDBCall.command(ReconActionDao.java:1299)
    3. oracle.iam.reconciliation.dao.DBCall.execute(DBCall.java:17)
    4. oracle.iam.reconciliation.dao.ReconActionDao.processSPCall(ReconActionDao.java:1344)
    5. oracle.iam.reconciliation.dao.ReconActionDao.executeBulkAccountMatchCRUD(ReconActionDao.java:844)
    6. oracle.iam.reconciliation.impl.AccountHandler.executeBulkCUD(AccountHandler.java:72)
    7. oracle.iam.reconciliation.impl.BaseEntityTypeHandler.process(BaseEntityTypeHandler.java:42)
    8. oracle.iam.reconciliation.impl.ActionEngine.processBatch(ActionEngine.java:137)
    9. oracle.iam.reconciliation.impl.ActionEngine.execute(ActionEngine.java:92)
    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:101)
    2. oracle.iam.platform.async.impl.TaskExecutor.execute(TaskExecutor.java:71)
    3. oracle.iam.platform.async.messaging.MessageReceiver.onMessage(MessageReceiver.java:68)
    3 frames
  6. 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
  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
    $Proxy492.onMessage
    1. $Proxy492.onMessage(Unknown Source)
    1 frame