oracle.jbo.AttributeLoadException: JBO-27021: Failed to load custom data type value at index 1 with java object of type oracle.jbo.domain.Number due to java.sql.SQLException.

Oracle Community | 774430 | 7 years ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    Delete error on my uploaded application

    Oracle Community | 7 years ago | 774430
    oracle.jbo.AttributeLoadException: JBO-27021: Failed to load custom data type value at index 1 with java object of type oracle.jbo.domain.Number due to java.sql.SQLException.

    Root Cause Analysis

    1. java.sql.SQLException

      Result set already closed

      at weblogic.jdbc.wrapper.ResultSet.checkResultSet()
    2. weblogic.jdbc.wrapper
      ResultSet_oracle_jdbc_driver_OracleResultSetImpl.getBytes
      1. weblogic.jdbc.wrapper.ResultSet.checkResultSet(ResultSet.java:110)
      2. weblogic.jdbc.wrapper.ResultSet.preInvocationHandler(ResultSet.java:65)
      3. weblogic.jdbc.wrapper.ResultSet_oracle_jdbc_driver_OracleResultSetImpl.getBytes(Unknown Source)
      3 frames
    3. oracle.jbo.domain
      Number$1facClass.createDatum
      1. oracle.jbo.domain.Number$1facClass.createDatum(Number.java:107)
      1 frame
    4. oracle.jbo.server
      ViewObjectImpl.setRangeStart
      1. oracle.jbo.server.OracleSQLBuilderImpl.doLoadFromResultSet(OracleSQLBuilderImpl.java:1308)
      2. oracle.jbo.server.AttributeDefImpl.loadFromResultSet(AttributeDefImpl.java:2331)
      3. oracle.jbo.server.ViewRowImpl.populate(ViewRowImpl.java:3618)
      4. oracle.jbo.server.ViewDefImpl.createInstanceFromResultSet(ViewDefImpl.java:2108)
      5. oracle.jbo.server.ViewObjectImpl.createRowFromResultSet(ViewObjectImpl.java:5174)
      6. oracle.jbo.server.ViewObjectImpl.createInstanceFromResultSet(ViewObjectImpl.java:5023)
      7. oracle.jbo.server.QueryCollection.populateRow(QueryCollection.java:3232)
      8. oracle.jbo.server.QueryCollection.fetch(QueryCollection.java:3092)
      9. oracle.jbo.server.QueryCollection.get(QueryCollection.java:2097)
      10. oracle.jbo.server.ViewRowSetImpl.getRow(ViewRowSetImpl.java:4773)
      11. oracle.jbo.server.ViewRowSetIteratorImpl.scrollRange(ViewRowSetIteratorImpl.java:1350)
      12. oracle.jbo.server.ViewRowSetIteratorImpl.setRangeStartWithRefresh(ViewRowSetIteratorImpl.java:2708)
      13. oracle.jbo.server.ViewRowSetIteratorImpl.setRangeStart(ViewRowSetIteratorImpl.java:2693)
      14. oracle.jbo.server.ViewRowSetImpl.setRangeStart(ViewRowSetImpl.java:2853)
      15. oracle.jbo.server.ViewObjectImpl.setRangeStart(ViewObjectImpl.java:9289)
      15 frames
    5. oracle.adf.model
      DCIteratorBinding.setRangeStart
      1. oracle.adf.model.binding.DCIteratorBinding.setRangeStart(DCIteratorBinding.java:3373)
      1 frame
    6. oracle.adfinternal.view
      FacesCtrlHierBinding$FacesModel.setRowIndex
      1. oracle.adfinternal.view.faces.model.binding.RowDataManager._bringInToRange(RowDataManager.java:103)
      2. oracle.adfinternal.view.faces.model.binding.RowDataManager.setRowIndex(RowDataManager.java:61)
      3. oracle.adfinternal.view.faces.model.binding.FacesCtrlHierBinding$FacesModel.setRowIndex(FacesCtrlHierBinding.java:602)
      3 frames
    7. Apache MyFaces Trinidad API
      UIXCollection.processDecodes
      1. org.apache.myfaces.trinidad.model.CollectionModel.isRowAvailable(CollectionModel.java:86)
      2. org.apache.myfaces.trinidad.component.UIXCollection.isRowAvailable(UIXCollection.java:392)
      3. org.apache.myfaces.trinidad.model.ModelUtils.findLastIndex(ModelUtils.java:141)
      4. org.apache.myfaces.trinidad.component.TableUtils.getLast(TableUtils.java:84)
      5. org.apache.myfaces.trinidad.component.TableUtils.getLast(TableUtils.java:58)
      6. org.apache.myfaces.trinidad.component.UIXTable._processStamps(UIXTable.java:509)
      7. org.apache.myfaces.trinidad.component.UIXTable.processFacetsAndChildren(UIXTable.java:374)
      8. org.apache.myfaces.trinidad.component.UIXCollection.decodeChildrenImpl(UIXCollection.java:196)
      9. org.apache.myfaces.trinidad.component.UIXComponentBase.decodeChildren(UIXComponentBase.java:974)
      10. org.apache.myfaces.trinidad.component.UIXCollection.processDecodes(UIXCollection.java:190)
      10 frames
    8. oracle.adfinternal.view
      LifecycleImpl$ApplyRequestValuesCallback.invokeContextCallback
      1. oracle.adfinternal.view.faces.lifecycle.LifecycleImpl$ApplyRequestValuesCallback.invokeContextCallback(LifecycleImpl.java:1175)
      1 frame
    9. Apache MyFaces Trinidad API
      UIXComponentBase.invokeOnNamingContainerComponent
      1. org.apache.myfaces.trinidad.component.UIXCollection.invokeOnComponent(UIXCollection.java:1030)
      2. org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnChildrenComponents(UIXComponentBase.java:1319)
      3. org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnComponent(UIXComponentBase.java:1413)
      4. org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnChildrenComponents(UIXComponentBase.java:1319)
      5. org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnComponent(UIXComponentBase.java:1413)
      6. org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnChildrenComponents(UIXComponentBase.java:1319)
      7. org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnComponent(UIXComponentBase.java:1413)
      8. org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnChildrenComponents(UIXComponentBase.java:1319)
      9. org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnComponent(UIXComponentBase.java:1413)
      10. org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnChildrenComponents(UIXComponentBase.java:1319)
      11. org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnNamingContainerComponent(UIXComponentBase.java:1369)
      11 frames
    10. oracle.adf.view
      UIXRegion.invokeOnComponent
      1. oracle.adf.view.rich.component.fragment.UIXRegion.invokeOnComponent(UIXRegion.java:544)
      1 frame
    11. Apache MyFaces Trinidad API
      UIXComponentBase.invokeOnChildrenComponents
      1. org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnChildrenComponents(UIXComponentBase.java:1319)
      2. org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnComponent(UIXComponentBase.java:1413)
      3. org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnChildrenComponents(UIXComponentBase.java:1319)
      4. org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnComponent(UIXComponentBase.java:1413)
      5. org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnChildrenComponents(UIXComponentBase.java:1319)
      6. org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnComponent(UIXComponentBase.java:1413)
      7. org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnChildrenComponents(UIXComponentBase.java:1319)
      8. org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnComponent(UIXComponentBase.java:1413)
      9. org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnChildrenComponents(UIXComponentBase.java:1319)
      10. org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnComponent(UIXComponentBase.java:1413)
      11. org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnChildrenComponents(UIXComponentBase.java:1319)
      11 frames
    12. oracle.adf.view
      ContextSwitchingComponent.invokeOnComponent
      1. oracle.adf.view.rich.component.fragment.ContextSwitchingComponent.invokeOnComponent(ContextSwitchingComponent.java:191)
      1 frame
    13. Apache MyFaces Trinidad API
      UIXComponentBase.invokeOnChildrenComponents
      1. org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnChildrenComponents(UIXComponentBase.java:1319)
      2. org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnComponent(UIXComponentBase.java:1413)
      3. org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnChildrenComponents(UIXComponentBase.java:1319)
      4. org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnComponent(UIXComponentBase.java:1413)
      5. org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnChildrenComponents(UIXComponentBase.java:1319)
      5 frames
    14. oracle.adf.view
      UIXInclude.invokeOnComponent
      1. oracle.adf.view.rich.component.fragment.UIXInclude.invokeOnComponent(UIXInclude.java:146)
      1 frame
    15. Apache MyFaces Trinidad API
      UIXComponentBase.invokeOnComponent
      1. org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnChildrenComponents(UIXComponentBase.java:1319)
      2. org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnComponent(UIXComponentBase.java:1413)
      3. org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnChildrenComponents(UIXComponentBase.java:1319)
      4. org.apache.myfaces.trinidad.component.UIXComponentBase.invokeOnComponent(UIXComponentBase.java:1413)
      4 frames
    16. oracle.adf.view
      RichDocument.invokeOnComponent
      1. oracle.adf.view.rich.component.rich.RichDocument.invokeOnComponent(RichDocument.java:161)
      1 frame
    17. JavaEE 7
      UIComponentBase.invokeOnComponent
      1. javax.faces.component.UIComponent.invokeOnComponent(UIComponent.java:731)
      2. javax.faces.component.UIComponentBase.invokeOnComponent(UIComponentBase.java:675)
      2 frames
    18. oracle.adfinternal.view
      LifecycleImpl.execute
      1. oracle.adfinternal.view.faces.lifecycle.LifecycleImpl._executePhase(LifecycleImpl.java:313)
      2. oracle.adfinternal.view.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:177)
      2 frames
    19. JavaEE 7
      FacesServlet.service
      1. javax.faces.webapp.FacesServlet.service(FacesServlet.java:265)
      1 frame
    20. 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:292)
      4. weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
      5. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
      5 frames
    21. com.wipro.ewarranty
      ApplicationSessionExpiryFilter.doFilter
      1. com.wipro.ewarranty.view.adf.sample.ApplicationSessionExpiryFilter.doFilter(ApplicationSessionExpiryFilter.java:49)
      1 frame
    22. Atmosphere weblogic
      FilterChainImpl.doFilter
      1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
      1 frame
    23. oracle.adf.model
      ADFBindingFilter.doFilter
      1. oracle.adf.model.servlet.ADFBindingFilter.doFilter(ADFBindingFilter.java:191)
      1 frame
    24. Atmosphere weblogic
      FilterChainImpl.doFilter
      1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
      1 frame
    25. oracle.adfinternal.view
      RegistrationFilter.doFilter
      1. oracle.adfinternal.view.faces.webapp.rich.RegistrationFilter.doFilter(RegistrationFilter.java:97)
      1 frame
    26. org.apache.myfaces
      TrinidadFilterImpl$FilterListChain.doFilter
      1. org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl$FilterListChain.doFilter(TrinidadFilterImpl.java:420)
      1 frame
    27. oracle.adfinternal.view
      AdsFilter.doFilter
      1. oracle.adfinternal.view.faces.activedata.AdsFilter.doFilter(AdsFilter.java:60)
      1 frame
    28. org.apache.myfaces
      TrinidadFilterImpl.doFilter
      1. org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl$FilterListChain.doFilter(TrinidadFilterImpl.java:420)
      2. org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl._doFilterImpl(TrinidadFilterImpl.java:247)
      3. org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl.doFilter(TrinidadFilterImpl.java:157)
      3 frames
    29. Apache MyFaces Trinidad API
      TrinidadFilter.doFilter
      1. org.apache.myfaces.trinidad.webapp.TrinidadFilter.doFilter(TrinidadFilter.java:92)
      1 frame
    30. Atmosphere weblogic
      FilterChainImpl.doFilter
      1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
      1 frame
    31. oracle.security.jps
      JpsAbsFilter$1.run
      1. oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:94)
      1 frame
    32. Java RT
      AccessController.doPrivileged
      1. java.security.AccessController.doPrivileged(Native Method)
      1 frame
    33. oracle.security.jps
      JpsFilter.doFilter
      1. oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:313)
      2. oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:413)
      3. oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:138)
      4. oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:70)
      4 frames
    34. Atmosphere weblogic
      FilterChainImpl.doFilter
      1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
      1 frame
    35. oracle.dms.wls
      DMSServletFilter.doFilter
      1. oracle.dms.wls.DMSServletFilter.doFilter(DMSServletFilter.java:326)
      1 frame
    36. Atmosphere weblogic
      WebAppServletContext$ServletInvocationAction.run
      1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
      2. weblogic.servlet.internal.RequestEventsFilter.doFilter(RequestEventsFilter.java:27)
      3. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
      4. weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3592)
      4 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(SecurityManager.java:121)
      1 frame
    39. Atmosphere weblogic
      ServletRequestImpl.run
      1. weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2202)
      2. weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2108)
      3. weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1432)
      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