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

Oracle Community | 869785 | 5 years ago
  1. 0

    OIM ORA-01427 error

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

    java.sql.SQLException: SQL string is not Query

    Oracle Community | 4 years ago | user10313574
    java.sql.SQLException: SQL string is not Query
  3. 0

    Passing complete sql query as a parameter to dataset in report

    Stack Overflow | 3 years ago | Bhaskar
    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 | 11 months ago
    java.sql.SQLException: Missing IN or OUT parameter at index:: 1
  6. 0

    WLS version 10.3.4.0 - Failing to switch over DB during fail over.

    Oracle Community | 6 years ago | 712753
    java.sql.SQLException: OALL8 is in an inconsistent state

  1. qavid 1 times, last 5 months ago
18 unregistered visitors
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