iPaas SQL Query Timeout

I have several long running queries that are timing out pulling data back to my iPaas flows.  I have updated the connection timeout in the connection string for MS SQL to 60 seconds and I have reviewed the configuration of the SQL server and verified that the timeout is set to 600 seconds.  I am still seeing queries time out at aroudn 30 seconds.  Any ideas on what I should try next?

Tags iPaaS TIMEOUT
Asked by Michael Olson on Wed 7/10/24 9:22 PM
Sign In to leave feedback or contribute an answer

Answers (2)

This answer has been marked as the accepted answer
Michael Ligouri Fri 7/26/24 12:24 PM

Hi Michael,

Are you running these steps in test mode or in actual Flow Runs (such as triggered runs, or clicking the Run Flow button)? If your connector is using a proxy, it will have a shorter timeout for test mode.

Cheers,
Mike Ligouri
Technical Support Consultant

No feedback
I seen a post in the questions, I'm trying via normal RUN now vs test mode, however again some of these loads could take minutes.

Let you know shortly.

Thanks, - Alex Haberer Fri 11/8/24 3:00 PM
Alex Haberer Fri 11/8/24 3:10 PM

This is what I see when running normally. Looks like it ran without going into the "on-failure" section. However do you know what the timeout would be when running? We are converting out process to iPaaS and some queries were pretty long running.

 

Thanks,

No feedback
According to this KB, after sending a proxied request, iPaaS will wait up to 60 seconds for a reply from the proxy server. After 60 seconds with no reply, the iPaaS flow will enter a wait state. The flow will remain in the wait state until the proxy server returns a response. After the flow receives a response, it will resume at the next step.

https://solutions.teamdynamix.com/TDClient/1965/Portal/KB/ArticleDet?ID=146455

So in your case and screenshot, step 5 in the playback is the proxy service waiting on a response from your SQL server (the yellow Wait step color coding), and then step 6 (the green color coding) is the proxy server successfully responding back to iPaaS and running the query.

So to me, it sounds like the query itself won't timeout, just waiting for the initial response. - Michael Ligouri Fri 11/8/24 3:28 PM