java.sql.SQLException: Attempt to set a parameter name that does not occur in the SQL: 1

Oracle Community | ORA_USER1122 | 3 years ago
  1. 0

    JBO-27122: SQL error during statement preparation. Statement - In Receiving VO

    Oracle Community | 3 years ago | ORA_USER1122
    java.sql.SQLException: Attempt to set a parameter name that does not occur in the SQL: 1
  2. 0

    How to extend CompetenceElementsVO

    Oracle Community | 7 years ago | 748660
    java.sql.SQLException: Attempt to set a parameter name that does not occur in the SQL: 1
  3. 0

    OAF

    Oracle Community | 5 years ago | 745071
    java.sql.SQLException: Attempt to set a parameter name that does not occur in the SQL: 1
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    VO Extension Error in modifying the query of XML Publisher Report Template

    Oracle Community | 5 years ago | 745071
    java.sql.SQLException: Attempt to set a parameter name that does not occur in the SQL: 1
  6. 0

    Attempt to set a parameter name that does not occur in the SQL: 1

    Oracle Community | 5 years ago | 907823
    java.sql.SQLException: Attempt to set a parameter name that does not occur in the SQL: 1

    2 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

      Attempt to set a parameter name that does not occur in the SQL: 1

      at oracle.jdbc.driver.OraclePreparedStatement.setObjectAtName()
    2. Oracle jdbc
      OraclePreparedStatementWrapper.setObjectAtName
      1. oracle.jdbc.driver.OraclePreparedStatement.setObjectAtName(OraclePreparedStatement.java:11915)
      2. oracle.jdbc.driver.OraclePreparedStatementWrapper.setObjectAtName(OraclePreparedStatementWrapper.java:815)
      2 frames
    3. oracle.jbo.server
      OAJboViewObjectImpl.executeQueryForCollection
      1. oracle.jbo.server.OracleSQLBuilderImpl.bindParamValue(OracleSQLBuilderImpl.java:3966)
      2. oracle.jbo.server.BaseSQLBuilderImpl.bindParametersForStmt(BaseSQLBuilderImpl.java:3335)
      3. oracle.jbo.server.ViewObjectImpl.bindParametersForCollection(ViewObjectImpl.java:14008)
      4. oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:804)
      5. oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:669)
      6. oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java:3754)
      7. oracle.jbo.server.OAJboViewObjectImpl.executeQueryForCollection(Unknown Source)
      7 frames
    4. oracle.apps.fnd
      OAViewObjectImpl.executeQueryForCollection
      1. oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQueryForCollection(OAViewObjectImpl.java:4560)
      1 frame
    5. oracle.jbo.server
      ViewObjectImpl.executeQuery
      1. oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:743)
      2. oracle.jbo.server.ViewRowSetImpl.executeQueryForMasters(ViewRowSetImpl.java:892)
      3. oracle.jbo.server.ViewRowSetImpl.executeQueryForMode(ViewRowSetImpl.java:806)
      4. oracle.jbo.server.ViewRowSetImpl.executeQuery(ViewRowSetImpl.java:800)
      5. oracle.jbo.server.ViewObjectImpl.executeQuery(ViewObjectImpl.java:3674)
      5 frames
    6. oracle.apps.fnd
      OAViewObjectImpl.executeQuery
      1. oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQuery(OAViewObjectImpl.java:439)
      1 frame
    7. oracle.apps.icx
      ReceiveItemsAMImpl.initQuery
      1. oracle.apps.icx.por.rcv.server.ReceiveItemsVOImpl.executeQuery(ReceiveItemsVOImpl.java:115)
      2. oracle.apps.icx.por.rcv.server.ReceiveItemsAMImpl.initQuery(ReceiveItemsAMImpl.java:170)
      2 frames
    8. 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
    9. oracle.apps.fnd
      OAApplicationModuleImpl.invokeMethod
      1. oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:190)
      2. oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:720)
      2 frames
    10. oracle.apps.icx
      RcvSrchCO.processRequest
      1. oracle.apps.icx.por.rcv.webui.RcvSrchCO.renderSearchResult(RcvSrchCO.java:536)
      2. oracle.apps.icx.por.rcv.webui.RcvSrchCO.processRequest(RcvSrchCO.java:90)
      2 frames
    11. oracle.apps.fnd
      OAPageBean.preparePage
      1. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:604)
      2. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
      3. oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1183)
      4. oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(OAPageLayoutBean.java:1569)
      5. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:976)
      6. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:943)
      7. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:663)
      8. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
      9. oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(OAFormBean.java:385)
      10. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:976)
      11. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:943)
      12. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:663)
      13. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
      14. oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(OABodyBean.java:353)
      15. oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2629)
      16. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1949)
      17. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:549)
      18. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:437)
      18 frames
    12. Unknown
      _OA._jspService
      1. _OA._jspService(_OA.java:212)
      1 frame
    13. com.orionserver.http
      OrionHttpJspPage.service
      1. com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
      1 frame
    14. oracle.jsp.runtimev2
      JspServlet.service
      1. oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:390)
      2. oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)
      3. oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)
      3 frames
    15. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
      1 frame
    16. com.evermind.server
      ServletRequestDispatcher$2.oc4jRun
      1. com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:734)
      2. com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:391)
      3. com.evermind.server.http.ServletRequestDispatcher.unprivileged_forward(ServletRequestDispatcher.java:280)
      4. com.evermind.server.http.ServletRequestDispatcher.access$100(ServletRequestDispatcher.java:68)
      5. com.evermind.server.http.ServletRequestDispatcher$2.oc4jRun(ServletRequestDispatcher.java:214)
      5 frames
    17. oracle.oc4j.security
      OC4JSecurity.doPrivileged
      1. oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:284)
      1 frame
    18. com.evermind.server
      EvermindPageContext.forward
      1. com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:219)
      2. com.evermind.server.http.EvermindPageContext.forward(EvermindPageContext.java:395)
      2 frames
    19. Unknown
      _OA._jspService
      1. _OA._jspService(_OA.java:221)
      1 frame
    20. com.orionserver.http
      OrionHttpJspPage.service
      1. com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
      1 frame
    21. oracle.jsp.runtimev2
      JspServlet.service
      1. oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:390)
      2. oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)
      3. oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)
      3 frames
    22. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
      1 frame
    23. com.evermind.server
      ServletRequestDispatcher$2.oc4jRun
      1. com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:734)
      2. com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:391)
      3. com.evermind.server.http.ServletRequestDispatcher.unprivileged_forward(ServletRequestDispatcher.java:280)
      4. com.evermind.server.http.ServletRequestDispatcher.access$100(ServletRequestDispatcher.java:68)
      5. com.evermind.server.http.ServletRequestDispatcher$2.oc4jRun(ServletRequestDispatcher.java:214)
      5 frames
    24. oracle.oc4j.security
      OC4JSecurity.doPrivileged
      1. oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:284)
      1 frame
    25. com.evermind.server
      EvermindPageContext.forward
      1. com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:219)
      2. com.evermind.server.http.EvermindPageContext.forward(EvermindPageContext.java:395)
      2 frames
    26. Unknown
      _OA._jspService
      1. _OA._jspService(_OA.java:221)
      1 frame
    27. com.orionserver.http
      OrionHttpJspPage.service
      1. com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
      1 frame
    28. oracle.jsp.runtimev2
      JspServlet.service
      1. oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:390)
      2. oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)
      3. oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)
      3 frames
    29. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
      1 frame
    30. com.evermind.server
      ResourceFilterChain.doFilter
      1. com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
      1 frame
    31. oracle.apps.jtf
      ReleaseResFilter.doFilter
      1. oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26)
      1 frame
    32. com.evermind.server
      EvermindFilterChain.doFilter
      1. com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)
      1 frame
    33. oracle.apps.fnd
      AppsServletFilter.doFilter
      1. oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:318)
      1 frame
    34. com.evermind.server
      AJPRequestHandler.run
      1. com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:642)
      2. com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:391)
      3. com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:908)
      4. com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:458)
      5. com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:313)
      6. com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:199)
      6 frames
    35. oracle.oc4j.network
      ServerSocketReadHandler$SafeRunnable.run
      1. oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
      1 frame
    36. com.evermind.util
      ReleasableResourcePooledExecutor$MyWorker.run
      1. com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
      1 frame
    37. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:662)
      1 frame