Forum Discussion

Hemanth's avatar
Hemanth
New Contributor
8 years ago

Oracle Execute Snap - Hangs

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

2 Replies

  • Hemanth's avatar
    Hemanth
    New Contributor
    8 years ago

    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's avatar
    Dhivya_Aroma1
    New Contributor III
    4 years ago

    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