MSSQL Node is creating errors on 1.44.1

[Caretek1]

Bug Description

Hi self hosted 1.44.1 started to give errors on MSSQL complete update queries reverted and problem was solved

To Reproduce

Pre Schedule Nodes of MSSQL specifically update queries creating problem

Expected behavior

Workflows of MSSQL nodes creating errors

Operating System

Ubuntu 22.04

n8n Version

1.44.1

Node.js Version

1.44.1

Database

MySQL

Execution mode

main (default)

[Joffcom]

Hey @Caretek1,

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

[Caretek1]

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

[Joffcom]

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

[Giorgio-gatti]

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"
]
}
}

[Joffcom]

Hey @Giorgio-gatti & @Caretek1,

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

[Giorgio-gatti]

Hi,

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

[Joffcom]

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