You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

OIC Call to OnPremise Stored Proc Times out frequently

Received Response
edited Apr 29, 2021 4:22AM in Integration 1 comment


Synchronous 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.

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!