java.sql.SQLException: Invalid column index

Oracle Community | SUDHIR BHILAR | 2 years ago
  1. 0

    UI getting errored out when the data is inserted into the table

    Oracle Community | 7 years ago | User549949-Oracle
    java.sql.SQLException: Invalid column index
  2. 0

    Invalid Index Error....

    Oracle Community | 9 years ago | 619461
    java.sql.SQLException: Invalid column index
  3. Speed up your debug routine!

    Automated exception search integrated into your IDE

  4. 0

    Invalid column index

    Oracle Community | 6 years ago | Manoj Madhusoodanan
    java.sql.SQLException: Invalid column index
  5. 0

    R12.1.3 - Error when searching for customer simple search - JBO-27022: Fail

    Oracle Community | 6 years ago | sseth29
    java.sql.SQLException: Invalid column index

    1 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

      Invalid column index

      at oracle.jdbc.driver.OracleResultSetImpl.getObject()
    2. Oracle jdbc
      OracleResultSetImpl.getObject
      1. oracle.jdbc.driver.OracleResultSetImpl.getObject(OracleResultSetImpl.java:2389)
      1 frame
    3. weblogic.jdbc.wrapper
      ResultSet_oracle_jdbc_driver_OracleResultSetImpl.getObject
      1. weblogic.jdbc.wrapper.ResultSet_oracle_jdbc_driver_OracleResultSetImpl.getObject(Unknown Source)
      1 frame
    4. oracle.jbo.server
      ViewObjectImpl.first
      1. oracle.jbo.server.OracleSQLBuilderImpl.doLoadFromResultSet(OracleSQLBuilderImpl.java:1200)
      2. oracle.jbo.server.AttributeDefImpl.loadFromResultSet(AttributeDefImpl.java:1634)
      3. oracle.jbo.server.ViewRowImpl.populate(ViewRowImpl.java:2221)
      4. oracle.jbo.server.ViewDefImpl.createInstanceFromResultSet(ViewDefImpl.java:1073)
      5. oracle.jbo.server.ViewObjectImpl.createRowFromResultSet(ViewObjectImpl.java:3045)
      6. oracle.jbo.server.ViewObjectImpl.createInstanceFromResultSet(ViewObjectImpl.java:2917)
      7. oracle.jbo.server.QueryCollection.populateRow(QueryCollection.java:2398)
      8. oracle.jbo.server.QueryCollection.fetch(QueryCollection.java:2256)
      9. oracle.jbo.server.QueryCollection.get(QueryCollection.java:1504)
      10. oracle.jbo.server.ViewRowSetImpl.getRow(ViewRowSetImpl.java:3705)
      11. oracle.jbo.server.ViewRowSetIteratorImpl.doFetch(ViewRowSetIteratorImpl.java:2815)
      12. oracle.jbo.server.ViewRowSetIteratorImpl.ensureRefreshed(ViewRowSetIteratorImpl.java:2671)
      13. oracle.jbo.server.ViewRowSetIteratorImpl.ensureRefreshed(ViewRowSetIteratorImpl.java:2631)
      14. oracle.jbo.server.ViewRowSetIteratorImpl.first(ViewRowSetIteratorImpl.java:1471)
      15. oracle.jbo.server.ViewRowSetImpl.first(ViewRowSetImpl.java:2836)
      16. oracle.jbo.server.ViewObjectImpl.first(ViewObjectImpl.java:5831)
      16 frames
    5. oracle.apps.per
      AppraisalsHomeAMImpl.getViewPageCode
      1. oracle.apps.per.selfservice.appraisals.server.AppraisalsHomeAMImpl.initAppraisalVO(AppraisalsHomeAMImpl.java:423)
      2. oracle.apps.per.selfservice.appraisals.server.AppraisalsHomeAMImpl.getViewPageCode(AppraisalsHomeAMImpl.java:464)
      2 frames
    6. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      4. java.lang.reflect.Method.invoke(Method.java:606)
      4 frames
    7. oracle.apps.fnd
      OAApplicationModuleImpl.invokeMethod
      1. oracle.apps.fnd.framework.server.OAUtility.invokeMethod(Unknown Source)
      2. oracle.apps.fnd.framework.server.OAUtility.invokeMethod(Unknown Source)
      3. oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:775)
      3 frames
    8. oracle.apps.per
      ApprEntryPageCO.processRequest
      1. oracle.apps.per.selfservice.appraisals.webui.ApprEntryPageCO.processRequest(ApprEntryPageCO.java:140)
      1 frame
    9. oracle.apps.fnd
      OAPageBean.preparePage
      1. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:631)
      2. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:267)
      3. oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1295)
      4. oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(OAPageLayoutBean.java:1569)
      5. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:1003)
      6. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:970)
      7. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:690)
      8. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:267)
      9. oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(Unknown Source)
      10. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:1003)
      11. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:970)
      12. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:690)
      13. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:267)
      14. oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(OABodyBean.java:353)
      15. oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2771)
      16. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1991)
      17. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:567)
      18. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:455)
      18 frames
    10. _pages
      __oa._jspService
      1. _pages.__oa._jspService(__oa.java:233)
      1 frame
    11. weblogic.servlet.jsp
      JspBase.service
      1. weblogic.servlet.jsp.JspBase.service(JspBase.java:34)
      1 frame
    12. Atmosphere weblogic
      RequestDispatcherImpl.forward
      1. weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
      2. weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
      3. weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301)
      4. weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:184)
      5. weblogic.servlet.internal.RequestDispatcherImpl.invokeServlet(RequestDispatcherImpl.java:526)
      6. weblogic.servlet.internal.RequestDispatcherImpl.forward(RequestDispatcherImpl.java:253)
      6 frames
    13. weblogic.servlet.jsp
      PageContextImpl.forward
      1. weblogic.servlet.jsp.PageContextImpl.forward(PageContextImpl.java:159)
      1 frame
    14. _pages
      __oa._jspService
      1. _pages.__oa._jspService(__oa.java:246)
      1 frame
    15. weblogic.servlet.jsp
      JspBase.service
      1. weblogic.servlet.jsp.JspBase.service(JspBase.java:34)
      1 frame
    16. Atmosphere weblogic
      FilterChainImpl.doFilter
      1. weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
      2. weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
      3. weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301)
      4. weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
      5. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
      5 frames
    17. oracle.apps.fnd
      WLFilter.doFilter
      1. oracle.apps.fnd.security.WLFilter.doFilter(WLFilter.java:213)
      1 frame
    18. Atmosphere weblogic
      FilterChainImpl.doFilter
      1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
      1 frame
    19. oracle.apps.jtf
      JTFWrapperFilter.doFilter
      1. oracle.apps.jtf.cabo.interceptor.JTFWrapperFilter.doFilter(JTFWrapperFilter.java:141)
      1 frame
    20. Atmosphere weblogic
      FilterChainImpl.doFilter
      1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
      1 frame
    21. oracle.apps.jtf
      ReleaseResFilter.doFilter
      1. oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(Unknown Source)
      1 frame
    22. Atmosphere weblogic
      FilterChainImpl.doFilter
      1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
      1 frame
    23. oracle.apps.fnd
      AppsServletFilter.doFilter
      1. oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:432)
      1 frame
    24. Atmosphere weblogic
      FilterChainImpl.doFilter
      1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
      1 frame
    25. oracle.security.jps
      JpsAbsFilter$1.run
      1. oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:119)
      1 frame
    26. Java RT
      AccessController.doPrivileged
      1. java.security.AccessController.doPrivileged(Native Method)
      1 frame
    27. oracle.security.jps
      JpsFilter.doFilter
      1. oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:315)
      2. oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:442)
      3. oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:103)
      4. oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:171)
      5. oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)
      5 frames
    28. Atmosphere weblogic
      FilterChainImpl.doFilter
      1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
      1 frame
    29. oracle.dms.servlet
      DMSServletFilter.doFilter
      1. oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:139)
      1 frame
    30. Atmosphere weblogic
      WebAppServletContext$ServletInvocationAction.run
      1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
      2. weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3748)
      3. weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3714)
      3 frames
    31. weblogic.security.acl
      AuthenticatedSubject.doAs
      1. weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
      1 frame
    32. weblogic.security.service
      SecurityManager.runAs
      1. weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
      1 frame
    33. Atmosphere weblogic
      ServletRequestImpl.run
      1. weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2283)
      2. weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2182)
      3. weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1491)
      3 frames
    34. weblogic.work
      ExecuteThread.run
      1. weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
      2. weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
      2 frames