Integration

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