Dear All, I want to automate data extraction from;SQL server avec I get an error while playing a select distinct query reading the data I want to extract (size : 2300 rows, 3 fields)
Error occurs at the “Microsoft SQL 1 - Execute query” → memory error or infinite execution
Stopped at “Microsoft SQL 1 - Execute query” node
Expedcted output : rows read out of the sql table
Information on your n8n setup
n8n trial version
default database
EXECUTIONS_PROCESS : default
Running via n8n cloud
OS : Windows 11 Professionnal (FR)
Could you help me solving this error? Thank you in advance for your help
Do you have a screenshot of the error and the workflow after it has ran so we can get a better idea of what might be happening? I suspect it could be that you are hitting the memory limit for your cloud plan and using a sub workflow instead of the loop could be better.
How many times does the Microsoft SQL1 node need to run as well does it need to run once for each item or just once? If it just needs to run once it might be worth setting the Execute Once option under the nodes settings so that it doesn’t potentially run the same query 500 times.
Well it seems to run forever. Ok I’l try to set the Execute Once option and if it does not work, try the subworkflow to go around the memory limit. Do you have ressources to give best practice about sub workflow use?
