OIC Call to OnPremise Stored Proc Times out frequently

Summary

Synchronous OIC Call to OnPremise Stored Proc Times out frequently and sometimes retrieves data in 40 secs

Content

We have a App Driven Orchestration calling a Stored Procedure on On-Premise Oracle Database connected via a Connectivity Agent.

For a sample input request, the data is retrieved in 40 Seconds in one run and subsequent runs for the same request ends in error (Timeout)

Upon investigating on Connectivity Agent logs, we see the below Errors:

Internal Exception: java.sql.SQLRecoverableException: IO Error: Socket read interrupted Error Code: 17002

Internal Exception: java.sql.SQLRecoverableException: Closed Connection Error Code: 17008

Meanwhile the Stored procedure returns same data for the same request within 40 seconds when run on a sql developer connecting to OnPremise DB.