Forum Discussion

AaronB's avatar
AaronB
Qrew Trainee
2 years ago

Pipeline error: Formula Query Execution took too long

I found some posts similar to this regarding reports but none for Pipelines so here is my situation.  I've also run the Performance Analyzer, Performance Insights, and Performance Optimizer but not h...
MarceloBenavide's avatar
MarceloBenavide
Qrew Cadet
2 years ago

 are you using a do-loop to loop through the 4k records and make changes to each of the 20 fields in each iteration?



------------------------------
Marcelo Benavides
------------------------------
AaronB's avatar
AaronB
Qrew Trainee
2 years ago

Marcelo,

Basically...yes.

Pipeline Step A:  Pipeline triggered

Step B:  Search for all the records in the table Query:  {3.GT.0}

For each record:  Step C:  Update Record (values in fields 11-15 moved to fields 16-20)

                            Step D:  Update Record (values in fields 6-10 moved to fields 11-15)

                            Step E:  Update Record (values in fields 1-5 moved to fields 6-10)

End for each.



------------------------------
Aaron B
ab1692@att.com
------------------------------