I am having a csv file with 10000 records and now i am trying to read the csv file in nintex workflow and loop through each record.
But the workflow is erroring with a generic error - Workflow errored out.
Tried with Pause , site workflow, list workflow but i am not able to get all the records in csv processed.
Please suggest what i need to do to fix this issue.
Thanks in advance,
@usharamanamma ….It seems you're writing lot of rows into the SharePoint and there is a chance that your SQL table is getting locked. Also, try below things:
Thank you for the reply.
For now I am only looping foreach item and logging history to check how many rows processed. I want to check first how much time it might take. So didn't use commit . But used pause. Even then there is no luck . Sometimes at pause , it's erroring and sometimes after pause after sometime it's erroring.
So not able to understand how to fix this. Normally how many records can a Nintex workflow process? What are the ways to fix this as it erroring even at pause?
@usharamanamma pause action is based on the timer job so for each iteration, it might delay your time too. Also since you're querying the SQL table and it's returning a lot of results, there is a chance you may have connection issues too.
There is no set # of records you can process, various factors play a big part in it e.g. Connection time with SQL, timer jobs, # of workflows timer job processing, resources on SQL and SharePoint servers, etc.