Timeout error on Salesforce Input

Question

Hi all, first time posting to the Alteryx community here.

My issue has to do with the Salesforce Input tool. After some heavy googling and roaming around the community I did not find a case handling my error.

I have created an Alteryx workflow through Alteryx Designer where I fetch data using the Salesforce Input tool. I'm loading quite large amounts of data (1-2 million rows), so I have split up the Salesforce inputs so that each call won't be too big.

It works just fine when I run it locally through Designer, and manually on the Server (runtime ~25-30 minutes). However once I put the workflow on a nightly schedule I notice the workflow failing.

Any ideas why?

Best,

Brian

vmartinez · Answer

Hi @brian_ye22,

in addition to your findings, have you tried to optimise the query as mentioned by William?

https://help.salesforce.com/articleView?id=000334796&type=1&mode=1

Best,

Vianney

brian_ye22 · Answer

Thanks all for the prompt replies from here!

I've done some experimenting and I noticed that my issue is solved when I execute the same workflow using the Salesforce input a second time 15 minutes after the first attempt. The first attempt will always fail but the second one seems to work all the time (at least for all daily schedules since this case was created).

I'm not sure if this should be accepted as a solution since it does not make sense to have two identical consecutive workflows.

I think it has to do with what @vmartinez suggests. It takes too long time to fetch all data via the API since there are other workflows running in parallel, occupying necessary resources to finish the API call, hence the API call will be open longer than the threshold allows.

I'm looking into another solution in the future, where I will only fetch the change of data for every API call hence making each API call smaller. I guess I will need some kind of middle/temp storage for this that works on scheduled basis on the Server to make this work.

WilliamR · Answer

Hi @brian_ye22 ,

are you sure your server can connect to Salesforce? Can you check this before?

If this is the case, you can have a look to this thread to try to optimize the query if this is possible:

https://help.salesforce.com/articleView?id=000334796&type=1&mode=1

(If this post helps, then please consider it as the solution to help the other members find it more quickly).