1 Reply Latest reply: Nov 15, 2012 10:51 PM by 548396 RSS

    JBO-30019, JBO-28006 and ORA-03237 errors

    875275
      Hi,

      We have an application With ADF running on Oracle Application Server. It had been working fine until we did database upgrade last weekend. However, since the upgrade was not successfull, we rollbacked. after rollback, I restart OC4J for this application.

      Now we experience some strange errors. for PS_TXN table, we even don't have this table in the schema or creation of this table in the source code, but I did see PS_TXN_seq there. Can you please tell me how to fix the errors? Thanks.

      1. JBO-30019 error was shown on the screen:

      JBO-30019: An unavailable cookie state is detected while attempting to use a cookie

      2. in application.log, there are JBO-28006 and ORA-03237 errors


      oracle.jbo.PCollException: JBO-28006: Could not create persistence table PS_TXN
      at oracle.jbo.PCollException.throwException(PCollException.java:39)
      at oracle.jbo.pcoll.OraclePersistManager.createTable(OraclePersistManager.java:97
      0)
      at oracle.jbo.pcoll.OraclePersistManager.queryNextCollectionId(OraclePersistManag
      er.java:1388)
      at oracle.jbo.pcoll.PCollManager.register(PCollManager.java:566)
      at oracle.jbo.pcoll.PCollection.<init>(PCollection.java:103)
      at oracle.jbo.pcoll.PCollManager.createCollection(PCollManager.java:464)
      at oracle.jbo.server.DBSerializer.setup(DBSerializer.java:153)
      at oracle.jbo.server.DBSerializer.passivateRootAM(DBSerializer.java:286)
      at oracle.jbo.server.DBSerializer.passivateRootAM(DBSerializer.java:267)
      at oracle.jbo.server.ApplicationModuleImpl.passivateStateInternal(ApplicationModu
      leImpl.java:5305)
      at oracle.jbo.server.ApplicationModuleImpl.passivateState(ApplicationModuleImpl.j
      ava:5192)
      at oracle.jbo.server.ApplicationPoolMessageHandler.doPoolMessage(ApplicationPoolM
      essageHandler.java:332)
      at oracle.jbo.server.ApplicationModuleImpl.doPoolMessage(ApplicationModuleImpl.ja
      va:7769)
      at oracle.jbo.common.ampool.ApplicationPoolImpl.sendPoolMessage(ApplicationPoolIm
      pl.java:4074)
      at oracle.jbo.common.ampool.ApplicationPoolImpl.manageReferencingState(Applicatio
      nPoolImpl.java:1239)
      at oracle.jbo.common.ampool.ApplicationPoolImpl.finalizeResource(ApplicationPoolI
      mpl.java:1156)
      at oracle.jbo.pool.ResourcePool.removeResourceInternal(ResourcePool.java:749)
      at oracle.jbo.common.ampool.ApplicationPoolImpl.doManagedCheckin(ApplicationPoolI
      mpl.java:2430)
      at oracle.jbo.common.ampool.ApplicationPoolImpl.releaseApplicationModule(Applicat
      ionPoolImpl.java:1348)
      at oracle.jbo.common.ampool.SessionCookieImpl.releaseApplicationModule(SessionCoo
      kieImpl.java:722)
      at oracle.jbo.common.ampool.SessionCookieImpl.releaseApplicationModule(SessionCoo
      kieImpl.java:642)
      at oracle.adf.model.bc4j.DCJboDataControl.releaseApplicationModule(DCJboDataContr
      ol.java:1644)
      at oracle.adf.model.bc4j.DCJboDataControl.endRequest(DCJboDataControl.java:1433)
      at oracle.adf.model.BindingContext.endRequest(BindingContext.java:695)
      at oracle.adf.model.BindingRequestHandler.invokeEndRequest(BindingRequestHandler.
      java:354)
      at oracle.adf.model.BindingRequestHandler.endRequest(BindingRequestHandler.java:2
      20)
      at oracle.adf.model.servlet.ADFBindingFilter.doFilter(ADFBindingFilter.java:166)
      at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.2.0)].s
      erver.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:20)
      at oracle.adfinternal.view.faces.webapp.AdfFacesFilterImpl._invokeDoFilter(AdfFac
      esFilterImpl.java:228)
      at oracle.adfinternal.view.faces.webapp.AdfFacesFilterImpl._doFilterImpl(AdfFaces
      FilterImpl.java:197)
      at oracle.adfinternal.view.faces.webapp.AdfFacesFilterImpl.doFilter(AdfFacesFilte
      rImpl.java:123)
      at oracle.adf.view.faces.webapp.AdfFacesFilter.doFilter(AdfFacesFilter.java:103)
      at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.2.0)].s
      erver.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:20)
      at mccs.common.filters.TaskFilter.doFilter(TaskFilter.java:42)
      at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.2.0)].s
      erver.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:669)
      at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.2.0)].s
      erver.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:340)
      at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.2.0)].s
      erver.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:830)
      at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.2.0)].s
      erver.http.AJPRequestHandler.run(AJPRequestHandler.java:228)
      at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.2.0)].s
      erver.http.AJPRequestHandler.run(AJPRequestHandler.java:133)
      at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.2.0)].u
      til.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:1
      92)
      at java.lang.Thread.run(Thread.java:534)
      ## Detail 0 ##
      java.sql.SQLException: ORA-03237: Initial Extent of specified size cannot be allocated in
      tablespace (XXXXX)

      at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:137)
      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:315)
      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:281)
      at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:638)
      at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:112)
      at oracle.jdbc.driver.T4CStatement.execute_for_rows(T4CStatement.java:560)
      at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1
      160)
      at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1653)
      at oracle.jbo.pcoll.OraclePersistManager.createTable(OraclePersistManager.java:94
      3)
      at oracle.jbo.pcoll.OraclePersistManager.queryNextCollectionId(OraclePersistManager.java:1388)
      at oracle.jbo.pcoll.PCollManager.register(PCollManager.java:566)
      at oracle.jbo.pcoll.PCollection.<init>(PCollection.java:103)
      at oracle.jbo.pcoll.PCollManager.createCollection(PCollManager.java:464)
      at oracle.jbo.server.DBSerializer.setup(DBSerializer.java:153)
      at oracle.jbo.server.DBSerializer.passivateRootAM(DBSerializer.java:286)
      at oracle.jbo.server.DBSerializer.passivateRootAM(DBSerializer.java:267)
      at oracle.jbo.server.ApplicationModuleImpl.passivateStateInternal(ApplicationModuleImpl.java:5305)
      at oracle.jbo.server.ApplicationModuleImpl.passivateState(ApplicationModuleImpl.java:5192)
      at oracle.jbo.server.ApplicationPoolMessageHandler.doPoolMessage(ApplicationPoolMessageHandler.java:332)
      at oracle.jbo.server.ApplicationModuleImpl.doPoolMessage(ApplicationModuleImpl.java:7769)
      at oracle.jbo.common.ampool.ApplicationPoolImpl.sendPoolMessage(ApplicationPoolImpl.java:4074)
      at oracle.jbo.common.ampool.ApplicationPoolImpl.manageReferencingState(ApplicationPoolImpl.java:1239)
      at oracle.jbo.common.ampool.ApplicationPoolImpl.finalizeResource(ApplicationPoolImpl.java:1156)
      at oracle.jbo.pool.ResourcePool.removeResourceInternal(ResourcePool.java:749)
      at oracle.jbo.common.ampool.ApplicationPoolImpl.doManagedCheckin(ApplicationPoolImpl.java:2430)
      at oracle.jbo.common.ampool.ApplicationPoolImpl.releaseApplicationModule(ApplicationPoolImpl.java:1348)
      at oracle.jbo.common.ampool.SessionCookieImpl.releaseApplicationModule(SessionCookieImpl.java:722)
      at oracle.jbo.common.ampool.SessionCookieImpl.releaseApplicationModule(SessionCookieImpl.java:642)
      at oracle.adf.model.bc4j.DCJboDataControl.releaseApplicationModule(DCJboDataControl.java:1644)
      at oracle.adf.model.bc4j.DCJboDataControl.endRequest(DCJboDataControl.java:1433)
      at oracle.adf.model.BindingContext.endRequest(BindingContext.java:695)
      at oracle.adf.model.BindingRequestHandler.invokeEndRequest(BindingRequestHandler.java:354)
      at oracle.adf.model.BindingRequestHandler.endRequest(BindingRequestHandler.java:220)
      at oracle.adf.model.servlet.ADFBindingFilter.doFilter(ADFBindingFilter.java:166)
      at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.2.0)].server.http.EvermindFilterChain.doFilter(Eve
      rmindFilterChain.java:20)
      at oracle.adfinternal.view.faces.webapp.AdfFacesFilterImpl._invokeDoFilter(AdfFacesFilterImpl.java:228)
      at oracle.adfinternal.view.faces.webapp.AdfFacesFilterImpl._doFilterImpl(AdfFacesFilterImpl.java:197)
      at oracle.adfinternal.view.faces.webapp.AdfFacesFilterImpl.doFilter(AdfFacesFilterImpl.java:123)
      at oracle.adf.view.faces.webapp.AdfFacesFilter.doFilter(AdfFacesFilter.java:103)
      at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.2.0)].server.http.EvermindFilterChain.doFilter(Eve
      rmindFilterChain.java:20)
      at mccs.common.filters.TaskFilter.doFilter(TaskFilter.java:42)
      at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.2.0)].server.http.ServletRequestDispatcher.invoke(
      ServletRequestDispatcher.java:669)
      at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.2.0)].server.http.ServletRequestDispatcher.forward
      Internal(ServletRequestDispatcher.java:340)
      at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.2.0)].server.http.HttpRequestHandler.processReques
      t(HttpRequestHandler.java:830)
      at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.2.0)].server.http.AJPRequestHandler.run(AJPRequest
      Handler.java:228)
      at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.2.0)].server.http.AJPRequestHandler.run(AJPRequest
      Handler.java:133)
      at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.2.0)].util.ReleasableResourcePooledExecutor$MyWork
      er.run(ReleasableResourcePooledExecutor.java:186)
      at java.lang.Thread.run(Thread.java:534)


      Thank you.

      Edited by: 872272 on Nov 14, 2012 3:30 PM