IBM Support

Getting DSRA0080E, "com.ibm.db2.jcc.b.SqlException: invalid operation: connection closed" due to DisconnectException

Troubleshooting


Problem

Customer uses DB2. After a normal application server start, many DSRA0080E exceptions are generated in the in the SystemOut.log. A trace with the components j2c, RRA and database enabled looks like: com.ibm.websphere.ce.cm.StaleConnectionException: A communication error has been detected. Communication protocol being used: UWReply.fill(). Communication API being used: recvBuff(). Location where the error was detected: ReasonCode=71. Communication function detecting the error: *. Protocol specific error codes(s) TCP/IP SOCKETS DB2ConnectionCorrelator: *LOCAL.db2inst1.050809212337 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:80) ... com.ibm.db2.jcc.b.DisconnectException: A communication error has been detected. Communication protocol being used: UWReply.fill(). Communication API being used: recvBuff(). Location where the error was detected: ReasonCode=71. Communication function detecting the error: *. Protocol specific error codes(s) TCP/IP SOCKETS DB2ConnectionCorrelator: *LOCAL.db2inst1.050809212337 at com.ibm.db2.jcc.c.a.a(a.java:374) at com.ibm.db2.jcc.uw.UWReply.b(UWReply.java:108) at com.ibm.db2.jcc.c.cb.c(cb.java:222) ... [8/9/05 16:24:29:859 CDT] 1cc4f3f8 WSJdbcUtil e Encountered a Stale Connection: com.ibm.ws.rsadapter.jdbc.WSJccConnection@d8333c9 [8/9/05 16:24:29:859 CDT] 1cc4f3f8 WSJccConnecti > close com.ibm.ws.rsadapter.jdbc.WSJccConnection@d8333c9 ... [8/9/05 16:24:29:919 CDT] 1cc4f3f8 GenericDataSt > mapExceptionHelper [8/9/05 16:24:29:919 CDT] 1cc4f3f8 DB2DataStoreH > findMappingClass for: com.ibm.db2.jcc.b.SqlException: invalid operation: connection closed [8/9/05 16:24:29:919 CDT] 1cc4f3f8 DB2DataStoreH e the DataStoreHelper is: com.ibm.websphere.rsadapter.DB2UniversalDataStoreHelper@71e173df [8/9/05 16:24:29:919 CDT] 1cc4f3f8 GenericDataSt > findMappingClass for exception com.ibm.db2.jcc.b.SqlException: invalid operation: connection closed at com.ibm.db2.jcc.b.o.Ab(o.java:3683) at com.ibm.db2.jcc.b.o.getCatalog(o.java:1704) at com.ibm.db2.jcc.b.ec.getCatalog(ec.java:223) at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.getCatalog(WSRdbManagedConnectionImpl.java:688) ... [8/9/05 16:24:29:920 CDT] 1cc4f3f8 WSRdbManagedC W DSRA0080E: An exception was received by the Data Store Adapter. See original exception message: com.ibm.db2.jcc.b.SqlException: invalid operation: connection closed at com.ibm.db2.jcc.b.o.Ab(o.java:3683) at com.ibm.db2.jcc.b.o.getCatalog(o.java:1704) ...

[{"Product":{"code":"SSEQTP","label":"WebSphere Application Server"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Java 2 Connectivity (J2C)","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"8.5.5;8.5;8.0;7.0;6.1;6.0","Edition":"Base;Enterprise","Line of Business":{"code":"LOB77","label":"Automation Platform"}},{"Product":{"code":"SSNVBF","label":"Runtimes for Java Technology"},"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Component":"Java SDK","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB08","label":"Cognitive Systems"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Historical Number

01986;999;781

Document Information

Modified date:
03 March 2025

UID

swg21231434