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()

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Samebug tips

Do you know how to solve this issue? Write a tip to help other users and build your expert profile.

Solutions on the web

via Oracle Community by 724373, 1 year ago
=>?, 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()
via Oracle Community by 708337, 1 year ago
ORA-01801: date format is too long for internal buffer
via Oracle Community by TakhteJamshid, 1 year ago
via Oracle Community by 906570, 1 year ago
User: dmadmin, failed to be authenticated.
via Oracle Community by 666705, 1 year ago
ORA-01089: immediate shutdown in progress - no operations are permitted
via Oracle Community by 666705, 1 year ago
[BEA][Oracle JDBC Driver][Oracle]ORA-00911: invalid character
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 weblogic.ejb.container.internal.RemoteBusinessIntfProxy.invoke(RemoteBusinessIntfProxy.java:85)
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 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 oracle.iam.samples.SampleOIMClient.ReconcileExpatUser(SampleOIMClient.java:357)
at oracle.iam.samples.SampleOIMClient.main(SampleOIMClient.java:401)

Users with the same issue

You are the first who have seen this exception. Write a tip to help other users and build your expert profile.

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.