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
Welcome to the community
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.
Thank you for your answer.
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?
Thanks a lot!
No real best practices as such only the contents of the page below which may not help as it all depends on the workflow.