Avatar

Level 6

Hi @Ofattah, when you say that you use the workflow with another account and it works just fine. Do you mean that this is another AC user that running it? if yes, be sure to check the difference between your rights. As example, a SQL query gets more complicated if not administrator because it adds lot of security checkings in the SQL request generated to the DB. As a personnal opinion, I would try to put a split activity in order to split in 10 different branch the rest of your workflow: you'll be able to see that:

1- if the problem disappear => that means that this is an issue with the total amount of data and its complexity that is involved

2- if the issue pops on one branch but not the other before, you can nail the issue to a particular data in that segmentation: you can just then select the same population of this branch and segment it again in 10 part. with this method, you'll find at the end which record(s) is/are causing the issue

 

I've not any better suggestion: I know that this is time consuming