java.sql.SQLException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • Custom reconciliation gets error
    via by 724373,
  • Call a in out procedure using WebLogic JNDI
    via by Jasi Ambalangadan,
    • 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(ResponseImpl.java:234) at weblogic.rmi.cluster.ClusterableRemoteRef.invoke(ClusterableRemoteRef.java:348) at weblogic.rmi.cluster.ClusterableRemoteRef.invoke(ClusterableRemoteRef.java:259) at Thor.API.Operations.tcReconciliationOperationsIntfEJB_troehf_tcReconciliationOperationsIntfRemoteImpl_1035_WLStub.createReconciliationEventx(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at weblogic.ejb.container.internal.RemoteBusinessIntfProxy.invoke(RemoteBusinessIntfProxy.java:85) at $Proxy2.createReconciliationEventx(Unknown Source) at Thor.API.Operations.tcReconciliationOperationsIntfDelegate.createReconciliationEvent(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at Thor.API.Base.SecurityInvocationHandler$1.run(SecurityInvocationHandler.java:68) at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321) at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120) at weblogic.security.Security.runAs(Security.java:41) at Thor.API.Security.LoginHandler.weblogicLoginSession.runAs(weblogicLoginSession.java:52) at Thor.API.Base.SecurityInvocationHandler.invoke(SecurityInvocationHandler.java:79) at $Proxy3.createReconciliationEvent(Unknown Source) at oracle.iam.samples.SampleOIMClient.ReconcileExpatUser(SampleOIMClient.java:357) at oracle.iam.samples.SampleOIMClient.main(SampleOIMClient.java:401)
    No Bugmate found.