Loop not processing all items

[Joao_Marques]

Hello!

So I am making a workflow to fetch all my Facebook ad accounts and then fetch all campaigns in each ad account and save it into MySQL.

My issue is that everything is running perfectly except the loop is not running through all the items I have a total of 73 accounts and the loops is only running 35 accounts, then stops without any error… It just stops.

Anything I can do to fix this?

Information on your n8n setup

• n8n version: 1.85.2
• Database (default: SQLite): MySQL
• n8n EXECUTIONS_PROCESS setting (default: own, main): Main
• Running n8n via (Docker, npm, n8n cloud, desktop app): Cloud
• Operating system: MacOS

[Olek]

A blind shot: MySQL node output is one item short. This might have blocked the loop if the node doesn’t return any data at some point.

You may probably overcome this by setting node to Always Output Data.

Unless you the error is logical, then you need to dig deeper.

If the above helps you to resolve the issue, please mark this post as a Solution.

[Franz]

I suggest to do it this way.
Sometimes there are troubles when there are coming more items back, than going out of a loop node.