Troubleshooting
Problem
During application deployment, socket connection errors, DSRA exceptions from the database, 100% CPU, and hanging threads can occur with WebSphere Process Server.
Symptom
As code is deployed to a server, the server can create a socket write error to WPSDB for an XA transaction. The log files are then filled with hanging threads and the server begins consuming 100% of CPU resources, which causes the server to becomes non-responsive. You must stop and restart the server.
An example of this issue is when you use the Microsoft SQL Server JDBC Driver 2.0 while Java™ database connectivity (JDBC) Driver 3.0 is currently available and recommended for use.
Cause
Examine the log files and look for DSRAxxxxE exceptions that point to features that are not implemented. With an incorrect level of the JDBC driver, some features might not be supported, which can cause resource issues.
When a connection error occurs, the connection pool manager tries to destroy the connection. This process involves cleaning up JDBC objects that are associated with the connection and a call to JDBC driver. If the JDBC driver is at an incorrect version level, some missing features might cause socket write exceptions, DSRAxxxE exceptions, hangs, high CPU, and so on.
Diagnosing The Problem
You might see messages that are similar to the following text:
[9/23/11 18:21:33:179 CDT] 00000012 ConnectionEve A J2CA0056I: The Connection Manager received a fatal connection error from the Resource Adapter for resource
jdbc/com.ibm.ws.sib/esbnode.server1-CEI.esbcell.BUS. The exception is:
com.microsoft.sqlserver.jdbc.SQLServerException: Software caused connection abort: recv failed
[9/23/11 18:21:33:195 CDT] 00000012 WSRdbManagedC W DSRA1300E: Feature is not implemented: javax.sql.PooledConnection.removeStatementEventListener
Resolving The Problem
Refer to the WebSphere Application Server detailed system requirements page and verify that the JDBC driver level. Use a later driver, if possible
Historical Number
52587370000
Product Synonym
WPS
Was this topic helpful?
Document Information
More support for:
WebSphere Process Server
Software version:
7.0.0.4, 7.0.0.3, 7.0.0.2, 7.0.0.1, 7.0
Operating system(s):
Windows
Document number:
464567
Modified date:
15 June 2018
UID
swg21572444