Our flow has been running fine each day but failed this morning with this error
Error evaluating prepSQL: Error: Cannot find module 'numbro'
Require stack:
- /tmp/src/runMultipleBlocksHandler.js (line -30)
Running in editor (i.e. run with previous blocks) works.
I commented out the require statement according to this post which resolved the issue.
Thanks for sharing how you solved this issue! How long have you been using this workflow successfully?
I'm going to mark this as solved for now since there is a workaround, but we'll still investigate the cause.
I thought the issue was resolved but now I'm getting this error at the final step when I try to write back to the database. Similar to this thread's error, it works fine if I run the blocks with previous, but if I click Run at the top or use the scheduler, the flow fail. I suspect these are run in a different environment or something.
We are cloud hosted on 3.160.0
New error:
Unexpected Error request to https://[our company name].tryretool.com/api/workflow/runQueryForSandboxed failed, reason: getaddrinfo EMFILE [our company name].tryretool.com
Following up with our engineering team now about the numbro module issue.
Can you please share a screenshot of the block that's failing?
