We always got this exception
Could anybody help to look for the reason for this exception?
0000007c WebApp E -: com.ibm.ram.repository.core.IRepositoryAccess$RepositoryException: DSRA9110E: Connection is closed.
at com.ibm.ram.repository.core.sdo.BaseRAMSchemaAccess.getUserPreference(BaseRAMSchemaAccess.java:13101)
at com.ibm.ram.repository.core.sdo.BaseRAMSchemaAccess.getUserPreference(BaseRAMSchemaAccess.java:13041)
at com.ibm.ram.repository.security.UserUpdate.getPreference(UserUpdate.java:162)
at com.ibm.ram.repository.security.UserUpdate.getStringPreference(UserUpdate.java:180)
at com.ibm.ram.repository.security.RegisteredUser.getStringPreference(RegisteredUser.java:288)
at com.ibm.ram.repository.security.PreferenceManager.getLocalTimeZone(PreferenceManager.java:102)
at com.ibm.ram.repository.web.RAMWSServletFilter.doFilter(RAMWSServletFilter.java:437)
at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:190)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:130)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:87)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:832)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:679)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:566)
at com.ibm.ws.wswebcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:478)
at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:90)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:748)
at com.ibm.ws.wswebcontainer.WebContainer.handleRequest(WebContainer.java:1466)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:119)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:458)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:387)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.ready(HttpInboundLink.java:267)
at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.sendToDiscriminators(NewConnectionInitialReadCallback.java:214)
at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.complete(NewConnectionInitialReadCallback.java:113)
at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165)
at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
at com.ibm.io.async.AsyncChannelFuture$1.run(AsyncChannelFuture.java:205)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1473)
Caused by: com.ibm.websphere.ce.cm.ObjectClosedException: DSRA9110E: Connection is closed.
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.runtimeXIfNotClosed(WSJdbcConnection.java:2657)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepareStatement(WSJdbcConnection.java:2151)
at com.ibm.ram.repository.core.sdo.BaseRAMSchemaAccess.getUserPreference(BaseRAMSchemaAccess.java:13068)
... 26 more
0000007c WebApp E -: com.ibm.ram.repository.core.IRepositoryAccess$RepositoryException: DSRA9110E: Connection is closed.
at com.ibm.ram.repository.core.sdo.BaseRAMSchemaAccess.getUserPreference(BaseRAMSchemaAccess.java:13101)
at com.ibm.ram.repository.core.sdo.BaseRAMSchemaAccess.getUserPreference(BaseRAMSchemaAccess.java:13041)
at com.ibm.ram.repository.security.UserUpdate.getPreference(UserUpdate.java:162)
at com.ibm.ram.repository.security.UserUpdate.getStringPreference(UserUpdate.java:180)
at com.ibm.ram.repository.security.RegisteredUser.getStringPreference(RegisteredUser.java:288)
at com.ibm.ram.repository.security.PreferenceManager.getLocalTimeZone(PreferenceManager.java:102)
at com.ibm.ram.repository.web.RAMWSServletFilter.doFilter(RAMWSServletFilter.java:437)
at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:190)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:130)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:87)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:832)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:679)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:566)
at com.ibm.ws.wswebcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:478)
at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:90)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:748)
at com.ibm.ws.wswebcontainer.WebContainer.handleRequest(WebContainer.java:1466)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:119)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:458)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:387)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.ready(HttpInboundLink.java:267)
at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.sendToDiscriminators(NewConnectionInitialReadCallback.java:214)
at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.complete(NewConnectionInitialReadCallback.java:113)
at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165)
at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
at com.ibm.io.async.AsyncChannelFuture$1.run(AsyncChannelFuture.java:205)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1473)
Caused by: com.ibm.websphere.ce.cm.ObjectClosedException: DSRA9110E: Connection is closed.
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.runtimeXIfNotClosed(WSJdbcConnection.java:2657)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepareStatement(WSJdbcConnection.java:2151)
at com.ibm.ram.repository.core.sdo.BaseRAMSchemaAccess.getUserPreference(BaseRAMSchemaAccess.java:13068)
... 26 more
3 answers
Hi,
There is some problem with your database connection. There should be
plenty of other errors too about the database. One of the first ones
should indicate the real problem with the database.
Rich
Hi Rich,
Thanks for your reply, but could you please tell me possible solution to this problem? Or where can I find related information? Thanks a lot!
Assuming you're using WebSphere Application Server, look in SystemOut.log. The file is located at /<install>/IBM/WebSphere/AppServer/profiles/AppSrv01/logs/<server>/SystemOut.log or /<install>/IBM/WebSphere/AppServer/profiles/AppSrv01/logs/SystemOut.log. It may contain additional traces concerning the database connection issue.