MSSQL Node is creating errors on 1.44.1 about n8n HOT 7 CLOSED

Hi,

good morning, I'm testing it in production and everything seems to be working fine. Thank u!

from n8n.

Hey @Caretek1,

Are you able to share what the error actually is and which version you downgraded to which doesn't have the issue?

from n8n.

Hi i down graded to 1.42.1.

basically error was coming on MSSQL node and was mostly on update queries with variable from {{$json.xxxx}} sometime error reported it was a production machine so i had to revert it immediately

from n8n.

Was it the same error message that is in #9665?

from n8n.

when use UPDATE operation in SQL from n8n i have this error:

{ "errorMessage": "Cannot read properties of undefined (reading 'error')", "errorDetails": {}, "n8nDetails": { "n8nVersion": "1.44.1 (Self Hosted)", "binaryDataMode": "default", "stackTrace": [ "TypeError: Cannot read properties of undefined (reading 'error')", " at /usr/local/lib/node_modules/n8n/node_modules/n8n-core/dist/WorkflowExecute.js:666:253", " at /usr/local/lib/node_modules/n8n/node_modules/n8n-core/dist/WorkflowExecute.js:1079:20" ] } }

This is breaking my automations :*{
"errorMessage": "Cannot read properties of undefined (reading 'error')",
"errorDetails": {},
"n8nDetails": {
"n8nVersion": "1.44.1 (Self Hosted)",
"binaryDataMode": "default",
"stackTrace": [
"TypeError: Cannot read properties of undefined (reading 'error')",
" at /usr/local/lib/node_modules/n8n/node_modules/n8n-core/dist/WorkflowExecute.js:666:253",
" at /usr/local/lib/node_modules/n8n/node_modules/n8n-core/dist/WorkflowExecute.js:1079:20"
]
}
}

from n8n.

Hey @Giorgio-gatti & @Caretek1,

Can you try updating to 1.44.2 and let me know if you still see this.

from n8n.

Perfect, I am going to mark this as closed for now.

from n8n.