Error transferring data: Failure when receiving data from the peer

[gesh2112]

I have a large workflow that calls multiple APIs.  It is basically pulling all the data for our Seismic down to SQL database.  It was scheduled and working great until Sept 27th.  Now two of the roughly 20 APIs get the above message.  I have verified using Postman that nothing changed in the calling of the APIs.  Postman brings data back but it takes a while.  I can limit the data coming back in and then it works but I need the full data set.

So I was thinking there was a timeout issue and I verified that the workflow does not have any timeout in the System Settings and the Cancel jobs running longer than (seconds) is not checked.  I have tried a throttle and some other stuff but nothing seems to fix the issue.

Does anyone have any other ideas on what I can try next?

[Garabujo7]

Hello @gesh2112 ,

Have you used this settings in the download tool?

It may be helpful.

Gabriel

[gesh2112]

Yes, this is my current setting.  Not sure if I made the correct changes.

[Felipe_Ribeir0]

Hi @gesh2112 . 

1)The alteryx workflow works making the call requesting limited number of rows?

2)How many rows this call should generate? 

If 1) is Yes and 2)Is many, i think that you gonna need to paginate this API call.