Calling Database Stored Procedure Through Agent Fails With Error "ICS runtime execution error Error Reason: oracle.tip.adapter.sa.api.JCABindingException: Operation Timedout. A timeout has occured while trying to perform the Database operation" (Doc ID 3014053.1)

Last updated on APRIL 11, 2024

Applies to:

Symptoms

On : 24.1.3 version, Adapter - Database - Oracle Databases (DBaaS, ADW, ATP)

Call to DB Stored procedure is failing with error.

ERROR
-----------------------
Error Summary: ICS runtime execution error Error Reason: oracle.tip.adapter.sa.api.JCABindingException: Operation Timedout.
A timeout has occured while trying to perform the Database operation.
The Database operation took more time to complete.
Please tune the stored procedure to return the response with in the time limits. This exception is considered not retriable, likely due to a modelling mistake.
LimitExceededException Fault Details :

  Operation Timedout
  A timeout has occured while trying to perform the Database operation.
  The Database operation took more time to complete.
  serviceInvocationError
  Please tune the stored procedure to return the response with in the time limits.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Issue specific to customer production instance transaction fails with timeout error.
 

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.