Created on 06-05-2019 04:04 PM - edited 08-17-2019 03:06 PM
Have a process that I started yesterday. It was working and processing flow files. It is pulling from SQL and pushing to SQL and the data pull has roughly 15 million rows. When I started yesterday it had 29 files in the queue (where is says 27 now). It did process the initial 2 flow files. This morning I come in and it stopped processing the files right before the ExecuteSQL processor. I read on another thread about number of threads, it was set to 20 and I increased to 30 and then 50 with no change. I did stop the processor and restart, no luck. The server is clustered but I am only using it on a single node. Attached are images of the processing and how it essentially stopped, the queued up files, the schedule and properties of the executesql processor.
Thanks in advance!
Created 06-05-2019 05:32 PM
Problem solved.....the processor was set to "Primary Node Only", once I set it to use "All nodes", the flow started processing files again.
Used this link to solve my issue: