Oracle Execute Snap - Hangs

[Hemanth]

Hi,

One of my Oracle Execute snap hangs in the pipeline execution. This is a straight forward Update command, this will update one record. If the pipeline is stopped and executed this will complete in few seconds. Not sure what causing the issue, deleted the snap and created a new one still the problem exists.

Regards,
Hemanth

[Hemanth]

I let the snap to run and it failed with below error.

SQL operation failed

Resolution:
Please check for valid Snap properties and input data.

Reason:
error occurred during batching: IO Error: Connection timed out, error code: 17081

[Dhivya_Aroma1]

Hi,

I am facing same issue now.
An update query in Oracle Execute Snap which is updating one record is hanging and data didnt flow further.
Stopping and executing manually runs without any issue.
Can you help what could be the reason?

Thanks,
Dhivya Aroma