This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
FAQ
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results forย 
Search instead forย 
Did you mean:ย 

Oracle Execute Snap - Hangs

Hemanth
New Contributor

โ€Ž05-03-2018 09:16 AM

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

0 Kudos
2 REPLIES 2

Hemanth
New Contributor

โ€Ž05-03-2018 09:46 AM

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

0 Kudos

Dhivya_Aroma1
New Contributor III

โ€Ž09-17-2021 11:21 AM

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

0 Kudos