java.sql.SQLException: ORA-01427: single-row subquery returns more than one row

Oracle Community | 869785 | 6 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

    OIM ORA-01427 error

    Oracle Community | 6 years ago | 869785
    java.sql.SQLException: ORA-01427: single-row subquery returns more than one row
  2. 0

    Passing complete sql query as a parameter to dataset in report

    Stack Overflow | 4 years ago | Bhaskar
    java.sql.SQLException: SQL string is not Query
  3. 0

    java.sql.SQLException: SQL string is not Query

    Oracle Community | 5 years ago | user10313574
    java.sql.SQLException: SQL string is not Query
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    java.sql.SQLException: Missing IN or OUT parameter | Oracle Community

    oracle.com | 1 year ago
    java.sql.SQLException: Missing IN or OUT parameter at index:: 1
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-01427: single-row subquery returns more than one row

    at oracle.jdbc.driver.SQLStateMapping.newSQLException()
  2. Oracle jdbc
    OraclePreparedStatementWrapper.executeQuery
    1. oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
    2. oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112)
    3. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173)
    4. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
    5. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
    6. oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)
    7. oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
    8. oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:947)
    9. oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:891)
    10. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186)
    11. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3381)
    12. oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3425)
    13. oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1490)
    13 frames
  3. weblogic.jdbc.wrapper
    PreparedStatement.executeQuery
    1. weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatement.java:128)
    1 frame
  4. com.thortech.xl
    tcFormInstanceOperations_2j82mm_EOImpl_WLSkel.invoke
    1. com.thortech.xl.dataaccess.tcDataBase.readPartialPreparedStatement(Unknown Source)
    2. com.thortech.xl.dataaccess.tcDataBase.readPreparedStatement(Unknown Source)
    3. com.thortech.xl.dataobj.PreparedStatementUtil.execute(Unknown Source)
    4. com.thortech.xl.dataobj.tcObjectItemInfo.checkPasswordPolicy(Unknown Source)
    5. com.thortech.xl.dataobj.tcObjectItemInfo.eventPreInsert(Unknown Source)
    6. com.thortech.xl.dataobj.tcDataObj.insert(Unknown Source)
    7. com.thortech.xl.dataobj.tcDataObj.save(Unknown Source)
    8. com.thortech.xl.dataobj.tcTableDataObj.save(Unknown Source)
    9. com.thortech.xl.ejb.beansimpl.tcFormInstanceOperationsBean.addObjectFormChildData(Unknown Source)
    10. com.thortech.xl.ejb.beansimpl.tcFormInstanceOperationsBean.addObjectFormChildData(Unknown Source)
    11. com.thortech.xl.ejb.beans.tcFormInstanceOperationsSession.addObjectFormChildData(Unknown Source)
    12. com.thortech.xl.ejb.beans.tcFormInstanceOperations_2j82mm_EOImpl.addObjectFormChildData(tcFormInstanceOperations_2j82mm_EOImpl.java:1728)
    13. com.thortech.xl.ejb.beans.tcFormInstanceOperations_2j82mm_EOImpl_WLSkel.invoke(Unknown Source)
    13 frames
  5. weblogic.rmi.internal
    ServerRequest.sendReceive
    1. weblogic.rmi.internal.ServerRequest.sendReceive(ServerRequest.java:174)
    1 frame
  6. weblogic.rmi.cluster
    ClusterableRemoteRef.invoke
    1. weblogic.rmi.cluster.ClusterableRemoteRef.invoke(ClusterableRemoteRef.java:345)
    2. weblogic.rmi.cluster.ClusterableRemoteRef.invoke(ClusterableRemoteRef.java:259)
    2 frames
  7. com.thortech.xl
    tcFormInstanceOperations_2j82mm_EOImpl_1030_WLStub.addObjectFormChildData
    1. com.thortech.xl.ejb.beans.tcFormInstanceOperations_2j82mm_EOImpl_1030_WLStub.addObjectFormChildData(Unknown Source)
    1 frame
  8. Thor.API.Operations
    tcFormInstanceOperationsClient.addObjectFormChildData
    1. Thor.API.Operations.tcFormInstanceOperationsClient.addObjectFormChildData(Unknown Source)
    1 frame
  9. Java RT
    Method.invoke
    1. sun.reflect.GeneratedMethodAccessor997.invoke(Unknown Source)
    2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    3. java.lang.reflect.Method.invoke(Method.java:597)
    3 frames
  10. Thor.API.Base
    SecurityInvocationHandler$1.run
    1. Thor.API.Base.SecurityInvocationHandler$1.run(Unknown Source)
    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(Unknown Source)
    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(Unknown Source)
    1 frame
  15. Thor.API.Base
    SecurityInvocationHandler.invoke
    1. Thor.API.Base.SecurityInvocationHandler.invoke(Unknown Source)
    1 frame
  16. Unknown
    $Proxy65.addObjectFormChildData
    1. $Proxy65.addObjectFormChildData(Unknown Source)
    1 frame
  17. com.bitur.service
    RequestDataService.genReqKeySumitNow
    1. com.bitur.service.RequestDataService.processObjectForms(RequestDataService.java:3082)
    2. com.bitur.service.RequestDataService.genReqKeySumitNow(RequestDataService.java:2909)
    2 frames
  18. com.bitur.struts2
    RequestVerificationAction.submitNow
    1. com.bitur.struts2.requestVerification.RequestVerificationAction.submitNow(RequestVerificationAction.java:1232)
    1 frame
  19. 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
  20. XWork
    ValidationInterceptor.doIntercept
    1. com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:452)
    2. com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:291)
    3. com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:254)
    4. com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:176)
    5. com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
    6. com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
    7. com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:263)
    7 frames
  21. Struts2
    AnnotationValidationInterceptor.doIntercept
    1. org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doIntercept(AnnotationValidationInterceptor.java:68)
    1 frame
  22. XWork
    DefaultActionInvocation.invoke
    1. com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
    2. com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
    3. com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept(ConversionErrorInterceptor.java:133)
    4. com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
    5. com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:207)
    6. com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
    7. com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
    8. com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:207)
    9. com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
    10. com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
    11. com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:190)
    12. com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
    12 frames
  23. Struts2
    MultiselectInterceptor.intercept
    1. org.apache.struts2.interceptor.MultiselectInterceptor.intercept(MultiselectInterceptor.java:75)
    1 frame
  24. XWork
    DefaultActionInvocation.invoke
    1. com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
    1 frame
  25. Struts2
    CheckboxInterceptor.intercept
    1. org.apache.struts2.interceptor.CheckboxInterceptor.intercept(CheckboxInterceptor.java:94)
    1 frame
  26. XWork
    DefaultActionInvocation.invoke
    1. com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
    1 frame
  27. Struts2
    FileUploadInterceptor.intercept
    1. org.apache.struts2.interceptor.FileUploadInterceptor.intercept(FileUploadInterceptor.java:243)
    1 frame
  28. XWork
    DefaultActionInvocation.invoke
    1. com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
    2. com.opensymphony.xwork2.interceptor.ModelDrivenInterceptor.intercept(ModelDrivenInterceptor.java:100)
    3. com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
    4. com.opensymphony.xwork2.interceptor.ScopedModelDrivenInterceptor.intercept(ScopedModelDrivenInterceptor.java:141)
    5. com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
    5 frames
  29. Struts2
    DebuggingInterceptor.intercept
    1. org.apache.struts2.interceptor.debugging.DebuggingInterceptor.intercept(DebuggingInterceptor.java:267)
    1 frame
  30. XWork
    DefaultActionInvocation.invoke
    1. com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
    2. com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.java:142)
    3. com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
    4. com.opensymphony.xwork2.interceptor.PrepareInterceptor.doIntercept(PrepareInterceptor.java:166)
    5. com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
    6. com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
    7. com.opensymphony.xwork2.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:176)
    8. com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
    8 frames
  31. Struts2
    ServletConfigInterceptor.intercept
    1. org.apache.struts2.interceptor.ServletConfigInterceptor.intercept(ServletConfigInterceptor.java:164)
    1 frame
  32. XWork
    DefaultActionInvocation.invoke
    1. com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
    2. com.opensymphony.xwork2.interceptor.AliasInterceptor.intercept(AliasInterceptor.java:190)
    3. com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
    4. com.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:187)
    5. com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
    5 frames
  33. com.bitur.struts2
    AuthenticationInterceptor.intercept
    1. com.bitur.struts2.security.AuthenticationInterceptor.intercept(AuthenticationInterceptor.java:171)
    1 frame
  34. XWork
    DefaultActionInvocation.invoke
    1. com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
    1 frame
  35. Struts2
    StrutsPrepareAndExecuteFilter.doFilter
    1. org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:52)
    2. org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:485)
    3. org.apache.struts2.dispatcher.ng.ExecuteOperations.executeAction(ExecuteOperations.java:77)
    4. org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter.doFilter(StrutsPrepareAndExecuteFilter.java:91)
    4 frames
  36. Atmosphere weblogic
    WebAppServletContext$ServletInvocationAction.run
    1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:42)
    2. weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3496)
    2 frames
  37. weblogic.security.acl
    AuthenticatedSubject.doAs
    1. weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
    1 frame
  38. weblogic.security.service
    SecurityManager.runAs
    1. weblogic.security.service.SecurityManager.runAs(Unknown Source)
    1 frame
  39. Atmosphere weblogic
    ServletRequestImpl.run
    1. weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2180)
    2. weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2086)
    3. weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1406)
    3 frames
  40. weblogic.work
    ExecuteThread.run
    1. weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
    2. weblogic.work.ExecuteThread.run(ExecuteThread.java:173)
    2 frames