We are oftenly getting the following Adpater run time exception error “[ART.117.4002] Adapter Runtime (Adapter Service): Unable to invoke adapter service SATURN_ASN.Services:getInboundForMcData. [ADA.1.316] Cannot execute the SQL statement “SELECT MCDATA_INBOUNDID_SEQ.NEXTVAL FROM DUAL”. " (17410) No more data to read from socket” No more data to read from socket".
This connection is used to invoke a Oracle SEQUENCE for each transaction.
Oftenly we are getting the error and whenever we refresh the connections, it started working.
Some of my colleagues also facing the same kind of error in the connections to the same Database. They are using different connection.
Connection details attached as a zip file “JDBC_Connection_Parameters.zip”
Need u`r expertise suggestion to stop reoccurence of this error. DB is a Oracle Database.