Hello,
I upgraded from 0.193.3 to 0.193.5 last night and this morning I ran a workflow that uses a Microsoft SQL node and it is failing on the SQL node. It gives the error:
TypeError: Cannot read properties of undefined (reading 'json')
at /usr/local/lib/node_modules/n8n/node_modules/n8n-core/dist/src/NodeExecuteFunctions.js:851:18
at Array.forEach (<anonymous>)
at Object.returnJsonArray (/usr/local/lib/node_modules/n8n/node_modules/n8n-core/dist/src/NodeExecuteFunctions.js:850:14)
at Object.execute (/usr/local/lib/node_modules/n8n/node_modules/n8n-nodes-base/dist/nodes/Microsoft/Sql/MicrosoftSql.node.js:311:84)
at async Workflow.runNode (/usr/local/lib/node_modules/n8n/node_modules/n8n-workflow/dist/src/Workflow.js:598:28)
at async /usr/local/lib/node_modules/n8n/node_modules/n8n-core/dist/src/WorkflowExecute.js:557:53
I tried setting up workflow with just a start node and the SQL node to see if the issue was somewhere else in my workflow but I get the same error. Here is the workflow:
System Information
- 0.193.5
- Database I’m using SQLite
- Running n8n via Docker
This workflow was running without errors in 0.193.3. I’m not sure if there is a way I can adjust the node to make it work or if I need to try to downgrade. I’d appreciate any help and advice.
Thanks
Kyle