java.sql.SQLException: ORA-01422: exact fetch returns more than requested number of rows ORA-06512: at "DEV_OIM.RECON_CREATE_EVENTS", line 69 ORA-06512: at "DEV_OIM.RECON_CREATE_EVENTS", line 122 ORA-06512: at line 1 Error Code: 1422 Call: BEGIN RECON_CREATE_EVENTS.XL_SP_RECON_CREATE_EVENTS(p_intJobID=>?, p_strProfileName=>?, p_strJobName=>?, p_intBatchSize=>?, p_strEventStatus=>?, p_strChangeType=>?, p_strEntityType=>?, p_intResourceObjectKey=>?, p_strLoggedinUserName=>?, p_intMaxRetryCount=>?, p_strActionPerformed=>?, p_strKeyField=>?, p_dateActionDate=>?, p_intEventID=>?, p_intBatchID=>?, p_intPrevBatchID=>?, p_strBatchCompleteFlag=>?); END; bind => [-1, Expat User, Non-Scheduled Job, 500, Event Received, CHANGELOG, Account, 23, XELSYSADM, 5, Event Created by Recon API, 62,TESTUSER, null, => eventID, => batchID, => prevBatchID, => batch_complete_flag] Query: DataReadQuery()

Oracle Community | 724373 | 5 years ago
  1. 0

    Custom reconciliation gets error

    Oracle Community | 5 years ago | 724373
    java.sql.SQLException: ORA-01422: exact fetch returns more than requested number of rows ORA-06512: at "DEV_OIM.RECON_CREATE_EVENTS", line 69 ORA-06512: at "DEV_OIM.RECON_CREATE_EVENTS", line 122 ORA-06512: at line 1 Error Code: 1422 Call: BEGIN RECON_CREATE_EVENTS.XL_SP_RECON_CREATE_EVENTS(p_intJobID=>?, p_strProfileName=>?, p_strJobName=>?, p_intBatchSize=>?, p_strEventStatus=>?, p_strChangeType=>?, p_strEntityType=>?, p_intResourceObjectKey=>?, p_strLoggedinUserName=>?, p_intMaxRetryCount=>?, p_strActionPerformed=>?, p_strKeyField=>?, p_dateActionDate=>?, p_intEventID=>?, p_intBatchID=>?, p_intPrevBatchID=>?, p_strBatchCompleteFlag=>?); END; bind => [-1, Expat User, Non-Scheduled Job, 500, Event Received, CHANGELOG, Account, 23, XELSYSADM, 5, Event Created by Recon API, 62,TESTUSER, null, => eventID, => batchID, => prevBatchID, => batch_complete_flag] Query: DataReadQuery()
  2. 0

    ORA-01801: date format is too long for internal buffer

    Oracle Community | 7 years ago | 708337
    java.sql.SQLException: ORA-01801: date format is too long for internal buffer
  3. 0

    My problem in using weblogic Datasource and proxy user

    Oracle Community | 7 years ago | TakhteJamshid
    java.sql.SQLException: Unsupported feature
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Call a in out procedure using WebLogic JNDI

    Coderanch | 2 years ago | Jasi Ambalangadan
    java.sql.SQLException: Invalid column index
  6. 0

    java.sql.SQLException: ORA-00904: invalid identifier

    Google Groups | 6 years ago | laredotornado
    java.sql.SQLException: ORA-00904: "NPS_LOG"."PKG_NPSLOG"."GET_LKUP": invalid identifier

    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-01422: exact fetch returns more than requested number of rows ORA-06512: at "DEV_OIM.RECON_CREATE_EVENTS", line 69 ORA-06512: at "DEV_OIM.RECON_CREATE_EVENTS", line 122 ORA-06512: at line 1 Error Code: 1422 Call: BEGIN RECON_CREATE_EVENTS.XL_SP_RECON_CREATE_EVENTS(p_intJobID=>?, p_strProfileName=>?, p_strJobName=>?, p_intBatchSize=>?, p_strEventStatus=>?, p_strChangeType=>?, p_strEntityType=>?, p_intResourceObjectKey=>?, p_strLoggedinUserName=>?, p_intMaxRetryCount=>?, p_strActionPerformed=>?, p_strKeyField=>?, p_dateActionDate=>?, p_intEventID=>?, p_intBatchID=>?, p_intPrevBatchID=>?, p_strBatchCompleteFlag=>?); END; bind => [-1, Expat User, Non-Scheduled Job, 500, Event Received, CHANGELOG, Account, 23, XELSYSADM, 5, Event Created by Recon API, 62,TESTUSER, null, => eventID, => batchID, => prevBatchID, => batch_complete_flag] Query: DataReadQuery()

      at weblogic.rjvm.ResponseImpl.unmarshalReturn()
    2. weblogic.rjvm
      ResponseImpl.unmarshalReturn
      1. weblogic.rjvm.ResponseImpl.unmarshalReturn(ResponseImpl.java:234)
      1 frame
    3. weblogic.rmi.cluster
      ClusterableRemoteRef.invoke
      1. weblogic.rmi.cluster.ClusterableRemoteRef.invoke(ClusterableRemoteRef.java:348)
      2. weblogic.rmi.cluster.ClusterableRemoteRef.invoke(ClusterableRemoteRef.java:259)
      2 frames
    4. Thor.API.Operations
      tcReconciliationOperationsIntfEJB_troehf_tcReconciliationOperationsIntfRemoteImpl_1035_WLStub.createReconciliationEventx
      1. Thor.API.Operations.tcReconciliationOperationsIntfEJB_troehf_tcReconciliationOperationsIntfRemoteImpl_1035_WLStub.createReconciliationEventx(Unknown Source)
      1 frame
    5. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
      4. java.lang.reflect.Method.invoke(Unknown Source)
      4 frames
    6. weblogic.ejb.container
      RemoteBusinessIntfProxy.invoke
      1. weblogic.ejb.container.internal.RemoteBusinessIntfProxy.invoke(RemoteBusinessIntfProxy.java:85)
      1 frame
    7. Unknown
      $Proxy2.createReconciliationEventx
      1. $Proxy2.createReconciliationEventx(Unknown Source)
      1 frame
    8. Thor.API.Operations
      tcReconciliationOperationsIntfDelegate.createReconciliationEvent
      1. Thor.API.Operations.tcReconciliationOperationsIntfDelegate.createReconciliationEvent(Unknown Source)
      1 frame
    9. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
      4. java.lang.reflect.Method.invoke(Unknown Source)
      4 frames
    10. Thor.API.Base
      SecurityInvocationHandler$1.run
      1. Thor.API.Base.SecurityInvocationHandler$1.run(SecurityInvocationHandler.java:68)
      1 frame
    11. weblogic.security.acl
      AuthenticatedSubject.doAs
      1. weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
      1 frame
    12. weblogic.security.service
      SecurityManager.runAs
      1. weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
      1 frame
    13. weblogic.security
      Security.runAs
      1. weblogic.security.Security.runAs(Security.java:41)
      1 frame
    14. Thor.API.Security
      weblogicLoginSession.runAs
      1. Thor.API.Security.LoginHandler.weblogicLoginSession.runAs(weblogicLoginSession.java:52)
      1 frame
    15. Thor.API.Base
      SecurityInvocationHandler.invoke
      1. Thor.API.Base.SecurityInvocationHandler.invoke(SecurityInvocationHandler.java:79)
      1 frame
    16. Unknown
      $Proxy3.createReconciliationEvent
      1. $Proxy3.createReconciliationEvent(Unknown Source)
      1 frame
    17. oracle.iam.samples
      SampleOIMClient.main
      1. oracle.iam.samples.SampleOIMClient.ReconcileExpatUser(SampleOIMClient.java:357)
      2. oracle.iam.samples.SampleOIMClient.main(SampleOIMClient.java:401)
      2 frames