Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
OIC Call to OnPremise Stored Proc Times out frequently — Cloud Customer Connect
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
16
Views
1
Comments
edited Apr 29, 2021 4:22AM in Integration 1 comment

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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