OIC Call to OnPremise Stored Proc Times out frequently
SummarySynchronous OIC Call to OnPremise Stored Proc Times out frequently and sometimes retrieves data in 40 secs
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.