search cancel

ESP dSeries (DE) errors: Database Connection is NOT Valid : Connection reset

book

Article ID: 7322

calendar_today

Updated On:

Products

DSERIES- SERVER CA Workload Automation DE - System Agent (dSeries)

Issue/Introduction

User performs upgrade or migrations.  The following error may be seen during upgrade or normal operation of dSeries (DE):

 

The thread DM.dm-timer-pop collapsed. The exception is: com.ca.wa.core.engine.rdbms.DatabaseException: Server restart has been initiated 
com.ca.wa.core.engine.rdbms.DatabaseException: Server restart has been initiated 
at com.ca.wa.core.engine.rdbms.DBConnectionPool.getOrCreateConnection(DBConnectionPool.java:763)
at com.ca.wa.core.engine.rdbms.DBConnectionPool.getConnection(DBConnectionPool.java:329)
at com.ca.wa.core.engine.rdbms.RelationalDatabaseManager.getConnection(RelationalDatabaseManager.java:1691)

......] DM.Appl.APPL1234.1: [20XX-XX-XX_00:00:12.345] Database Connection is NOT Valid. Removing from pool
com.microsoft.sqlserver.jdbc.SQLServerException: Connection reset

Please refer the PIB #RI83557 to cleanup the unused server detail from the Database. 

Environment

Release: Workload Automation DE / ESP dSeries 
Component:

Cause

Connection reset is due to something on the network or at the database side.  The connection was dropped.

Resolution

The "Connection reset" means that connection was dropped by database or something in between dSeries and DE.

Consult Network admin for more details.