Got EspExceptionSQLSelectFailed and EspExceptionSQLConnectionFailed error in ESP Report Server

book

Article ID: 242476

calendar_today

Updated On:

Products

ESP Workload Automation

Issue/Introduction

We noticed errors below in Report Server STC and wonder if it's related:
EspMessageInJHR: Connection unexpectedly closed: EspExceptionSQLSelectFailed: Ýjcc¨Ýt4¨Ý2030¨Ý11211¨Ý3.72.54¨ A communication error occurred during operations on the connection's underlying socket, socket input stream, or socket output stream. Error location: Reply.fill() - socketInputStream.read (-1). Message: Read failed. ERRORCODE=-4499, SQLSTATE=08001 SQLState=08001 ErrorCode=-4499 Method=EspRecord.selectSQL

EspMessageInJHR: EspExceptionSQLConnectionFailed: Ýjcc¨Ýt4¨Ý2043¨Ý11550¨Ý3.72.54¨ Exception java.net.ConnectException: Error opening socket to server mvsnbhp-db2r961.allstate.com/10.195.252.25 on port 59,605 with message: EDC8128I Connection refused. (Connection refused). ERRORCODE=-4499, SQLSTATE=08001 SQLState=08001 ErrorCode=-4499 Method=EspDBManager.getConnection

Environment

Release : 12.0

Component : ESP REPORT SERVER

Resolution

It should be related to the restart of DB was performed while report server is running. Most probably the first message was generated because of broken connection to DB. And most probably the second one was generated while the report server attempted to connect the DB again and DB refused the connection.