AMX node startup error: Could not start Security Service. java.sql.SQLException: [tibcosoftwareinc][Oracle JDBC Driver]No more data available to read

AMX node startup error: Could not start Security Service. java.sql.SQLException: [tibcosoftwareinc][Oracle JDBC Driver]No more data available to read

book

Article ID: KB0091954

calendar_today

Updated On:

Products Versions
TIBCO ActiveMatrix Service Grid -
Not Applicable -

Description

Resolution:
For TIBCO Data Direct Oracle JDBC Driver "No more data available to read" error is generated when an existing connection in the connection pool is no longer valid. A request checks out an existing connection and attempts to reuse it, but if the connection is no longer good, then this error is thrown and the connection is removed from the connection pool.

When an existing database connection cannot communicate by TCP to the other end of the connection, then the "No more data available to read" error will return. This would also be true if there is network congestion that makes the remote database unreachable. The "No more data available to read" error can also be received when all existing connections are depleted. To solve this, the number of connections needs to be increased.

Issue/Introduction

AMX node startup error: Could not start Security Service. java.sql.SQLException: [tibcosoftwareinc][Oracle JDBC Driver]No more data available to read