Got EspExceptionSQLSelectFailed and EspExceptionSQLConnectionFailed error in ESP Report Server
search cancel

Got EspExceptionSQLSelectFailed and EspExceptionSQLConnectionFailed error in ESP Report Server

book

Article ID: 242476

calendar_today

Updated On:

Products

ESP Workload Automation

Issue/Introduction

The following errors are seen in the Report Server started task.  Are these errors 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 <server name>/##.###.###.## on port #### 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

The errors are related to the restart of the database being performed while the report server is running.  The first message was generated because of broken connection to the database.  The second message was generated while the report server attempted to connect to the database again, and the database refused the connection.