Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Re: WebSphere Portal 6.1.0.23 - DB error when stopping the server's.

87 views
Skip to first unread message

ya...@us.ibm.com

unread,
Sep 28, 2009, 5:47:41 PM9/28/09
to
Hello,
Try these technotes:

- *WebSphere Portal SystemOut.log J2CA0056I com.ibm.websphere.ce.cm.StaleConnectionException Connection reset* at http://www.ibm.com/support/docview.wss?rs=688&uid=swg21372849

- *StaleConnectionException errors in logs while trying to perform WebSphere Portal tasks with Oracle as the database* at http://www.ibm.com/support/docview.wss?rs=688&uid=swg21256674

- *Required actions when configuring XA Oracle JDBC providers for WebSphere Portal* at http://www.ibm.com/support/docview.wss?rs=688&&uid=swg21319393

Thank you,
David Yang
WebSphere Portal support

The postings on this site are my own and do not necessarily represent the positions, strategies, or opinions of IBM.

rajsri123abc

unread,
Sep 28, 2009, 5:22:13 PM9/28/09
to
Hi we are using websphere portal 6.1.0.23 and every thing works fine . but when ever i bring down the portal servers. i am getting the follow error message's in systemout.log. Any help is greatly appriciated...

9/28/09 16:01:04:436 CDT] 0000000e MCWrapper E J2CA0081E: Method destroy failed while trying to execute method destroy on ManagedConnection WSRdbManagedConnectionImpl@6130786a from resource No longer available. Caught exception: com.ibm.ws.exception.WsException: DSRA0080E: An exception was received by the Data Store Adapter. See original exception message: Io exception: Connection reset. with SQL State : null SQL Code : 17002
at com.ibm.ws.rsadapter.exceptions.DataStoreAdapterException.setLinkedException(DataStoreAdapterException.java:464)
at com.ibm.ws.rsadapter.AdapterUtil.mapException(AdapterUtil.java:2231)
at com.ibm.ws.rsadapter.AdapterUtil.translateSQLException(AdapterUtil.java:1264)
at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.destroy(WSRdbManagedConnectionImpl.java:3194)
at com.ibm.ejs.j2c.MCWrapper.destroy(MCWrapper.java:1769)
at com.ibm.ejs.j2c.FreePool.cleanupAndDestroyMCWrapper(FreePool.java:717)
at com.ibm.ejs.j2c.FreePool.cleanupAndDestroyAllFreeConnections(FreePool.java:2339)
at com.ibm.ejs.j2c.PoolManager.serverShutDown(PoolManager.java:1470)
at com.ibm.ejs.j2c.ConnectionServerShutDownFactoryImpl.shutdown(ConnectionServerShutDownFactoryImpl.java:89)
at com.ibm.ejs.j2c.RALifeCycleManagerImpl.shutdown(RALifeCycleManagerImpl.java:1405)
at com.ibm.ejs.j2c.RALifeCycleManagerImpl.stop(RALifeCycleManagerImpl.java:454)
at com.ibm.ws.runtime.component.ContainerImpl.stopComponents(ContainerImpl.java:1036)
at com.ibm.ws.runtime.component.ContainerImpl.stop(ContainerImpl.java:685)
at com.ibm.ws.runtime.component.ApplicationServerImpl.stop(ApplicationServerImpl.java:227)
at com.ibm.ws.runtime.component.ContainerImpl.stopComponents(ContainerImpl.java:1036)
at com.ibm.ws.runtime.component.ContainerImpl.stop(ContainerImpl.java:685)
at com.ibm.ws.runtime.component.ServerImpl.stop(ServerImpl.java:625)
at com.ibm.ws.runtime.component.ServerCollaborator$ShutdownHook$1.run(ServerCollaborator.java:687)
at com.ibm.ws.security.auth.ContextManagerImpl.runAs(ContextManagerImpl.java:4132)
at com.ibm.ws.security.auth.ContextManagerImpl.runAsSystem(ContextManagerImpl.java:4229)
at com.ibm.ws.runtime.component.ServerCollaborator$ShutdownHook.run(ServerCollaborator.java:677)
at com.ibm.ws.runtime.component.ServerCollaborator$StopAction.alarm(ServerCollaborator.java:641)
at com.ibm.ejs.util.am._Alarm.run(_Alarm.java:90)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1473)
Caused by: com.ibm.websphere.ce.cm.StaleConnectionException: Io exception: Connection resetDSRA0010E: SQL State = null, Error Code = 17,002
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:494)
at com.ibm.websphere.rsadapter.GenericDataStoreHelper.mapExceptionHelper(GenericDataStoreHelper.java:523)
at com.ibm.websphere.rsadapter.GenericDataStoreHelper.mapException(GenericDataStoreHelper.java:578)
at com.ibm.ws.rsadapter.AdapterUtil.mapException(AdapterUtil.java:2159)
... 22 more
---- Begin backtrace for Nested Throwables
java.sql.SQLException: Io exception: Connection resetDSRA0010E: SQL State = null, Error Code = 17,002
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
at oracle.jdbc.driver.T4CConnection.logoff(T4CConnection.java:480)
at oracle.jdbc.driver.PhysicalConnection.close(PhysicalConnection.java:1175)
at oracle.jdbc.pool.OraclePooledConnection.close(OraclePooledConnection.java:246)
at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.destroy(WSRdbManagedConnectionImpl.java:3187)
at com.ibm.ejs.j2c.MCWrapper.destroy(MCWrapper.java:1769)
at com.ibm.ejs.j2c.FreePool.cleanupAndDestroyMCWrapper(FreePool.java:717)
at com.ibm.ejs.j2c.FreePool.cleanupAndDestroyAllFreeConnections(FreePool.java:2339)
at com.ibm.ejs.j2c.PoolManager.serverShutDown(PoolManager.java:1470)
at com.ibm.ejs.j2c.ConnectionServerShutDownFactoryImpl.shutdown(ConnectionServerShutDownFactoryImpl.java:89)
at com.ibm.ejs.j2c.RALifeCycleManagerImpl.shutdown(RALifeCycleManagerImpl.java:1405)
at com.ibm.ejs.j2c.RALifeCycleManagerImpl.stop(RALifeCycleManagerImpl.java:454)
at com.ibm.ws.runtime.component.ContainerImpl.stopComponents(ContainerImpl.java:1036)
at com.ibm.ws.runtime.component.ContainerImpl.stop(ContainerImpl.java:685)
at com.ibm.ws.runtime.component.ApplicationServerImpl.stop(ApplicationServerImpl.java:227)
at com.ibm.ws.runtime.component.ContainerImpl.stopComponents(ContainerImpl.java:1036)
at com.ibm.ws.runtime.component.ContainerImpl.stop(ContainerImpl.java:685)
at com.ibm.ws.runtime.component.ServerImpl.stop(ServerImpl.java:625)
at com.ibm.ws.runtime.component.ServerCollaborator$ShutdownHook$1.run(ServerCollaborator.java:687)
at com.ibm.ws.security.auth.ContextManagerImpl.runAs(ContextManagerImpl.java:4132)
at com.ibm.ws.security.auth.ContextManagerImpl.runAsSystem(ContextManagerImpl.java:4229)
at com.ibm.ws.runtime.component.ServerCollaborator$ShutdownHook.run(ServerCollaborator.java:677)
at com.ibm.ws.runtime.component.ServerCollaborator$StopAction.alarm(ServerCollaborator.java:641)
at com.ibm.ejs.util.am._Alarm.run(_Alarm.java:90)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1473)

0 new messages