Node-red-contrib-mssql-plus 0.12.2 EREQUEST/Invalid string error

General
,
1

Hello,

Can anybody help me about debugging the following error.
I tried with different data types, but I couldn't find out where the problem is after many hours.
This was a working solution until I updated the mssql-plus module.
Node-Red Log:

21 Feb 13:33:39 - [info] Starting flows
21 Feb 13:33:39 - [info] Started flows
21 Feb 13:33:39 - [info] [mqtt-broker:35f072cb3207907c] Connected to broker: mqtt://...
21 Feb 13:33:39 - [info] [mqtt-broker:da531418c5b0fb46] Connected to broker: mqtt://...
21 Feb 13:33:41 - [info] [MSSQL-CN:DECKLACK] Connected to server : ...\SCHMID_CELL, database : DECKLACK, port : 1433, user : Grafana_Decklack
21 Feb 13:34:01 - [info] [MSSQL-CN:Node-Red Teszt] Connected to server : ...\SCHMID_CELL, database : NODE-RED_TESZT, port : 1433, user : Grafana_test
21 Feb 13:34:01 - [info] [MSSQL-CN:Node-Red Teszt] Error connecting to server : ...\SCHMID_CELL, database : NODE-RED_TESZT, port : 1433, user : Grafana_test
RequestError: Invalid string.
    at BulkLoad.done [as callback] (C:\Users\OkumaIoT.JOST10\.node-red\node_modules\mssql\lib\tedious\request.js:307:19)
    at Parser.onEndOfMessage (C:\Users\OkumaIoT.JOST10\.node-red\node_modules\tedious\lib\connection.js:2823:22)
    at Object.onceWrapper (node:events:509:28)
    at Parser.emit (node:events:390:28)
    at Parser.emit (node:domain:475:12)
    at Readable.<anonymous> (C:\Users\OkumaIoT.JOST10\.node-red\node_modules\tedious\lib\token\token-stream-parser.js:32:12)
    at Readable.emit (node:events:390:28)
    at Readable.emit (node:domain:475:12)
    at endReadableNT (node:internal/streams/readable:1343:12)
    at processTicksAndRejections (node:internal/process/task_queues:83:21) {
  code: 'EREQUEST',
  originalError: TypeError: Invalid string.
      at Object.validate (C:\Users\OkumaIoT.JOST10\.node-red\node_modules\tedious\lib\data-types\varchar.js:118:13)
      at RowTransform._transform (C:\Users\OkumaIoT.JOST10\.node-red\node_modules\tedious\lib\bulk-load.js:116:26)
      at RowTransform.Transform._write (node:internal/streams/transform:184:23)
      at writeOrBuffer (node:internal/streams/writable:389:12)
      at _write (node:internal/streams/writable:330:10)
      at RowTransform.Writable.write (node:internal/streams/writable:334:10)
      at Readable.ondata (node:internal/streams/readable:754:22)
      at Readable.emit (node:events:390:28)
      at Readable.emit (node:domain:475:12)
      at Readable.read (node:internal/streams/readable:527:10),
  number: undefined,
  lineNumber: undefined,
  state: undefined,
  class: undefined,
  serverName: undefined,
  procName: undefined,
  precedingErrors: []
}
21 Feb 13:34:01 - [error] [MSSQL:Teszt] Invalid string.

mssql-table:

USE [NODE-RED_TESZT]
GO

/****** Object:  Table [dbo].[Okuma_SF_teszt]    Script Date: 2024. 02. 21. 13:38:10 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[Okuma_SF_teszt](
	[MachineNo] [int] NULL,
	[MacType] [varchar](50) NULL,
	[MachineName] [varchar](50) NULL,
	[Date] [datetime] NULL,
	[PowerOn] [bit] NULL,
	[AlarmState] [bit] NULL,
	[LimitState] [bit] NULL,
	[ProgramStopState] [bit] NULL,
	[FeedHoldState] [bit] NULL,
	[STMState] [bit] NULL,
	[RunState] [bit] NULL,
	[CuttingState] [bit] NULL,
	[SetUp] [bit] NULL,
	[NoOperator] [bit] NULL,
	[Wait] [bit] NULL,
	[Maintenance] [bit] NULL,
	[Other] [bit] NULL,
	[ManualMode] [bit] NULL,
	[MDIMode] [bit] NULL,
	[AutoMode] [bit] NULL,
	[MacManMode] [bit] NULL,
	[ToolSetMode] [bit] NULL,
	[OriginSetMode] [bit] NULL,
	[ParameterSetMode] [bit] NULL,
	[ProgramOpeMode] [bit] NULL,
	[ProgramFileName] [varchar](50) NULL,
	[AlarmLevel] [int] NULL,
	[AlarmNo] [int] NULL,
	[AlarmCode] [varchar](50) NULL,
	[AlarmString] [varchar](50) NULL,
	[AlarmMessage] [varchar](200) NULL,
	[AlarmObject] [varchar](50) NULL,
	[PowerOnTime] [int] NULL,
	[AlarmStateTime] [int] NULL,
	[AlarmRunStateTime] [int] NULL,
	[LimitStateTime] [int] NULL,
	[ProgramStopStateTime] [int] NULL,
	[FeedHoldStateTime] [int] NULL,
	[STMStateTime] [int] NULL,
	[RunStateTime] [int] NULL,
	[CuttingTime] [int] NULL,
	[SpindleCMDTime] [int] NULL,
	[TotalActivePower] [int] NULL,
	[SetUpTime] [int] NULL,
	[NoOperatorTime] [int] NULL,
	[WaitTime] [int] NULL,
	[MaintenanceTime] [int] NULL,
	[OtherTime] [int] NULL,
	[ManualModeTime] [int] NULL,
	[MDIModeTime] [int] NULL,
	[AutoModeTime] [int] NULL,
	[MacManModeTime] [int] NULL,
	[ToolSetModeTime] [int] NULL,
	[OriginSetModeTime] [int] NULL,
	[ParameterSetModeTime] [int] NULL,
	[ProgramOpeModeTime] [int] NULL,
	[FeedOverride] [int] NULL,
	[SpindleOverride] [int] NULL
) ON [PRIMARY]
GO

flow:

msg object after function execution:

{"payload":[{"MachineNo":1,"MacType":0,"MachineName":"LU45II","Date":"2024-02-22T07:21:00.000Z","PowerOn":0,"AlarmState":0,"LimitState":0,"ProgramStopState":0,"FeedHoldState":0,"STMState":0,"RunState":0,"CuttingState":0,"SetUp":0,"NoOperator":0,"Wait":0,"Maintenance":0,"Other":0,"ManualMode":0,"MDIMode":0,"AutoMode":0,"MacManMode":0,"ToolSetMode":0,"OriginSetMode":0,"ParameterSetMode":0,"ProgramOpeMode":0,"ProgramFileName":"R-41654-FO.MIN","AlarmLevel":0,"AlarmNo":0,"AlarmCode":"","AlarmString":"","AlarmMessage":"","AlarmObject":0,"PowerOnTime":0,"AlarmStateTime":0,"AlarmRunStateTime":0,"LimitStateTime":0,"ProgramStopStateTime":0,"FeedHoldStateTime":0,"STMStateTime":0,"RunStateTime":0,"CuttingTime":0,"SpindleCMDTime":0,"TotalActivePower":0,"SetUpTime":0,"NoOperatorTime":0,"WaitTime":0,"MaintenanceTime":0,"OtherTime":0,"ManualModeTime":0,"MDIModeTime":0,"AutoModeTime":0,"MacManModeTime":0,"ToolSetModeTime":0,"OriginSetModeTime":0,"ParameterSetModeTime":0,"ProgramOpeModeTime":0,"FeedOverride":0,"SpindleOverride":0},{"MachineNo":2,"MacType":0,"MachineName":"LB4000EXII","Date":"2024-02-22T07:21:00.000Z","PowerOn":1,"AlarmState":0,"LimitState":1,"ProgramStopState":0,"FeedHoldState":0,"STMState":1,"RunState":1,"CuttingState":1,"SetUp":0,"NoOperator":0,"Wait":0,"Maintenance":1,"Other":0,"ManualMode":0,"MDIMode":0,"AutoMode":1,"MacManMode":0,"ToolSetMode":0,"OriginSetMode":1,"ParameterSetMode":0,"ProgramOpeMode":0,"ProgramFileName":"KMZ-41L006.MIN","AlarmLevel":0,"AlarmNo":0,"AlarmCode":"","AlarmString":"","AlarmMessage":"","AlarmObject":0,"PowerOnTime":60000,"AlarmStateTime":0,"AlarmRunStateTime":0,"LimitStateTime":26000,"ProgramStopStateTime":0,"FeedHoldStateTime":0,"STMStateTime":6000,"RunStateTime":40000,"CuttingTime":40000,"SpindleCMDTime":34000,"TotalActivePower":100,"SetUpTime":0,"NoOperatorTime":0,"WaitTime":0,"MaintenanceTime":20000,"OtherTime":0,"ManualModeTime":0,"MDIModeTime":0,"AutoModeTime":60000,"MacManModeTime":0,"ToolSetModeTime":0,"OriginSetModeTime":60000,"ParameterSetModeTime":0,"ProgramOpeModeTime":0,"FeedOverride":100,"SpindleOverride":100},{"MachineNo":3,"MacType":0,"MachineName":"You-Ji YV-1000A 2/1","Date":"2024-02-22T07:21:00.000Z","PowerOn":1,"AlarmState":0,"LimitState":0,"ProgramStopState":0,"FeedHoldState":0,"STMState":0,"RunState":0,"CuttingState":0,"SetUp":0,"NoOperator":0,"Wait":0,"Maintenance":0,"Other":0,"ManualMode":0,"MDIMode":0,"AutoMode":1,"MacManMode":0,"ToolSetMode":0,"OriginSetMode":0,"ParameterSetMode":0,"ProgramOpeMode":0,"ProgramFileName":"","AlarmLevel":0,"AlarmNo":0,"AlarmCode":"","AlarmString":"","AlarmMessage":"","AlarmObject":0,"PowerOnTime":60000,"AlarmStateTime":0,"AlarmRunStateTime":0,"LimitStateTime":0,"ProgramStopStateTime":0,"FeedHoldStateTime":0,"STMStateTime":0,"RunStateTime":0,"CuttingTime":0,"SpindleCMDTime":0,"TotalActivePower":0,"SetUpTime":0,"NoOperatorTime":0,"WaitTime":0,"MaintenanceTime":0,"OtherTime":0,"ManualModeTime":0,"MDIModeTime":0,"AutoModeTime":60000,"MacManModeTime":0,"ToolSetModeTime":0,"OriginSetModeTime":0,"ParameterSetModeTime":0,"ProgramOpeModeTime":0,"FeedOverride":100,"SpindleOverride":100},{"MachineNo":4,"MacType":0,"MachineName":"You-Ji YV-1000A 2/2","Date":"2024-02-22T07:21:00.000Z","PowerOn":1,"AlarmState":0,"LimitState":0,"ProgramStopState":0,"FeedHoldState":0,"STMState":0,"RunState":0,"CuttingState":0,"SetUp":0,"NoOperator":0,"Wait":0,"Maintenance":0,"Other":0,"ManualMode":1,"MDIMode":0,"AutoMode":0,"MacManMode":0,"ToolSetMode":0,"OriginSetMode":0,"ParameterSetMode":0,"ProgramOpeMode":0,"ProgramFileName":"","AlarmLevel":0,"AlarmNo":0,"AlarmCode":"","AlarmString":"","AlarmMessage":"","AlarmObject":0,"PowerOnTime":60000,"AlarmStateTime":0,"AlarmRunStateTime":0,"LimitStateTime":0,"ProgramStopStateTime":0,"FeedHoldStateTime":0,"STMStateTime":0,"RunStateTime":0,"CuttingTime":0,"SpindleCMDTime":0,"TotalActivePower":0,"SetUpTime":0,"NoOperatorTime":0,"WaitTime":0,"MaintenanceTime":0,"OtherTime":0,"ManualModeTime":60000,"MDIModeTime":0,"AutoModeTime":0,"MacManModeTime":0,"ToolSetModeTime":0,"OriginSetModeTime":0,"ParameterSetModeTime":0,"ProgramOpeModeTime":0,"FeedOverride":0,"SpindleOverride":100},{"MachineNo":5,"MacType":0,"MachineName":"You-Ji YV-1200A 1/2","Date":"2024-02-22T07:21:00.000Z","PowerOn":1,"AlarmState":0,"LimitState":0,"ProgramStopState":0,"FeedHoldState":0,"STMState":0,"RunState":0,"CuttingState":0,"SetUp":0,"NoOperator":0,"Wait":0,"Maintenance":0,"Other":0,"ManualMode":0,"MDIMode":0,"AutoMode":0,"MacManMode":0,"ToolSetMode":0,"OriginSetMode":0,"ParameterSetMode":0,"ProgramOpeMode":0,"ProgramFileName":"","AlarmLevel":0,"AlarmNo":0,"AlarmCode":"","AlarmString":"","AlarmMessage":"","AlarmObject":0,"PowerOnTime":60000,"AlarmStateTime":0,"AlarmRunStateTime":0,"LimitStateTime":0,"ProgramStopStateTime":0,"FeedHoldStateTime":0,"STMStateTime":0,"RunStateTime":0,"CuttingTime":0,"SpindleCMDTime":0,"TotalActivePower":0,"SetUpTime":0,"NoOperatorTime":0,"WaitTime":0,"MaintenanceTime":0,"OtherTime":0,"ManualModeTime":0,"MDIModeTime":0,"AutoModeTime":0,"MacManModeTime":0,"ToolSetModeTime":0,"OriginSetModeTime":0,"ParameterSetModeTime":0,"ProgramOpeModeTime":0,"FeedOverride":0,"SpindleOverride":100},{"MachineNo":6,"MacType":0,"MachineName":"You-Ji YV-1200A 1/1","Date":"2024-02-22T07:21:00.000Z","PowerOn":1,"AlarmState":0,"LimitState":0,"ProgramStopState":0,"FeedHoldState":0,"STMState":0,"RunState":0,"CuttingState":0,"SetUp":0,"NoOperator":0,"Wait":0,"Maintenance":0,"Other":0,"ManualMode":0,"MDIMode":0,"AutoMode":1,"MacManMode":0,"ToolSetMode":0,"OriginSetMode":0,"ParameterSetMode":0,"ProgramOpeMode":0,"ProgramFileName":"","AlarmLevel":0,"AlarmNo":0,"AlarmCode":"","AlarmString":"","AlarmMessage":"","AlarmObject":0,"PowerOnTime":60000,"AlarmStateTime":0,"AlarmRunStateTime":0,"LimitStateTime":0,"ProgramStopStateTime":0,"FeedHoldStateTime":0,"STMStateTime":0,"RunStateTime":0,"CuttingTime":0,"SpindleCMDTime":0,"TotalActivePower":0,"SetUpTime":0,"NoOperatorTime":0,"WaitTime":0,"MaintenanceTime":0,"OtherTime":0,"ManualModeTime":0,"MDIModeTime":0,"AutoModeTime":60000,"MacManModeTime":0,"ToolSetModeTime":0,"OriginSetModeTime":0,"ParameterSetModeTime":0,"ProgramOpeModeTime":0,"FeedOverride":100,"SpindleOverride":90},{"MachineNo":7,"MacType":0,"MachineName":"V920","Date":"2024-02-22T07:21:00.000Z","PowerOn":1,"AlarmState":0,"LimitState":1,"ProgramStopState":0,"FeedHoldState":0,"STMState":0,"RunState":0,"CuttingState":0,"SetUp":0,"NoOperator":0,"Wait":1,"Maintenance":0,"Other":0,"ManualMode":1,"MDIMode":0,"AutoMode":0,"MacManMode":0,"ToolSetMode":0,"OriginSetMode":1,"ParameterSetMode":0,"ProgramOpeMode":0,"ProgramFileName":"KDL-520OT-OP1.MIN","AlarmLevel":0,"AlarmNo":0,"AlarmCode":"","AlarmString":"","AlarmMessage":"","AlarmObject":0,"PowerOnTime":60000,"AlarmStateTime":0,"AlarmRunStateTime":0,"LimitStateTime":60000,"ProgramStopStateTime":0,"FeedHoldStateTime":0,"STMStateTime":0,"RunStateTime":0,"CuttingTime":0,"SpindleCMDTime":3000,"TotalActivePower":100,"SetUpTime":0,"NoOperatorTime":0,"WaitTime":60000,"MaintenanceTime":0,"OtherTime":0,"ManualModeTime":60000,"MDIModeTime":0,"AutoModeTime":0,"MacManModeTime":0,"ToolSetModeTime":0,"OriginSetModeTime":60000,"ParameterSetModeTime":0,"ProgramOpeModeTime":0,"FeedOverride":100,"SpindleOverride":100},{"MachineNo":8,"MacType":0,"MachineName":"Toyoda 630/1","Date":"2024-02-22T07:21:00.000Z","PowerOn":0,"AlarmState":0,"LimitState":0,"ProgramStopState":0,"FeedHoldState":0,"STMState":0,"RunState":0,"CuttingState":0,"SetUp":0,"NoOperator":0,"Wait":0,"Maintenance":0,"Other":0,"ManualMode":0,"MDIMode":0,"AutoMode":0,"MacManMode":0,"ToolSetMode":0,"OriginSetMode":0,"ParameterSetMode":0,"ProgramOpeMode":0,"ProgramFileName":"","AlarmLevel":0,"AlarmNo":0,"AlarmCode":"","AlarmString":"","AlarmMessage":"","AlarmObject":0,"PowerOnTime":0,"AlarmStateTime":0,"AlarmRunStateTime":0,"LimitStateTime":0,"ProgramStopStateTime":0,"FeedHoldStateTime":0,"STMStateTime":0,"RunStateTime":0,"CuttingTime":0,"SpindleCMDTime":0,"TotalActivePower":0,"SetUpTime":0,"NoOperatorTime":0,"WaitTime":0,"MaintenanceTime":0,"OtherTime":0,"ManualModeTime":0,"MDIModeTime":0,"AutoModeTime":0,"MacManModeTime":0,"ToolSetModeTime":0,"OriginSetModeTime":0,"ParameterSetModeTime":0,"ProgramOpeModeTime":0,"FeedOverride":0,"SpindleOverride":0},{"MachineNo":9,"MacType":0,"MachineName":"Toyoda 630/2","Date":"2024-02-22T07:21:00.000Z","PowerOn":1,"AlarmState":0,"LimitState":0,"ProgramStopState":0,"FeedHoldState":0,"STMState":0,"RunState":1,"CuttingState":0,"SetUp":0,"NoOperator":0,"Wait":0,"Maintenance":0,"Other":0,"ManualMode":0,"MDIMode":0,"AutoMode":1,"MacManMode":0,"ToolSetMode":0,"OriginSetMode":0,"ParameterSetMode":0,"ProgramOpeMode":0,"ProgramFileName":"","AlarmLevel":0,"AlarmNo":0,"AlarmCode":"","AlarmString":"","AlarmMessage":"","AlarmObject":0,"PowerOnTime":60000,"AlarmStateTime":0,"AlarmRunStateTime":0,"LimitStateTime":0,"ProgramStopStateTime":0,"FeedHoldStateTime":0,"STMStateTime":0,"RunStateTime":60000,"CuttingTime":0,"SpindleCMDTime":60000,"TotalActivePower":0,"SetUpTime":0,"NoOperatorTime":0,"WaitTime":0,"MaintenanceTime":0,"OtherTime":0,"ManualModeTime":0,"MDIModeTime":0,"AutoModeTime":60000,"MacManModeTime":0,"ToolSetModeTime":0,"OriginSetModeTime":0,"ParameterSetModeTime":0,"ProgramOpeModeTime":0,"FeedOverride":100,"SpindleOverride":100},{"MachineNo":11,"MacType":0,"MachineName":"Toyoda FH80S","Date":"2024-02-22T07:21:00.000Z","PowerOn":1,"AlarmState":0,"LimitState":0,"ProgramStopState":0,"FeedHoldState":0,"STMState":0,"RunState":0,"CuttingState":0,"SetUp":0,"NoOperator":0,"Wait":0,"Maintenance":0,"Other":0,"ManualMode":0,"MDIMode":0,"AutoMode":1,"MacManMode":0,"ToolSetMode":0,"OriginSetMode":0,"ParameterSetMode":0,"ProgramOpeMode":0,"ProgramFileName":"","AlarmLevel":0,"AlarmNo":0,"AlarmCode":"","AlarmString":"","AlarmMessage":"","AlarmObject":0,"PowerOnTime":59000,"AlarmStateTime":0,"AlarmRunStateTime":0,"LimitStateTime":0,"ProgramStopStateTime":0,"FeedHoldStateTime":0,"STMStateTime":0,"RunStateTime":0,"CuttingTime":0,"SpindleCMDTime":0,"TotalActivePower":0,"SetUpTime":0,"NoOperatorTime":0,"WaitTime":0,"MaintenanceTime":0,"OtherTime":0,"ManualModeTime":0,"MDIModeTime":0,"AutoModeTime":58000,"MacManModeTime":0,"ToolSetModeTime":0,"OriginSetModeTime":0,"ParameterSetModeTime":0,"ProgramOpeModeTime":0,"FeedOverride":100,"SpindleOverride":0},{"MachineNo":12,"MacType":0,"MachineName":"MA600-PPS","Date":"2024-02-22T07:21:00.000Z","PowerOn":1,"AlarmState":0,"LimitState":1,"ProgramStopState":0,"FeedHoldState":0,"STMState":1,"RunState":1,"CuttingState":1,"SetUp":0,"NoOperator":0,"Wait":0,"Maintenance":0,"Other":0,"ManualMode":0,"MDIMode":0,"AutoMode":1,"MacManMode":0,"ToolSetMode":0,"OriginSetMode":1,"ParameterSetMode":0,"ProgramOpeMode":0,"ProgramFileName":"PPCKMZ-41L006.MIN","AlarmLevel":0,"AlarmNo":0,"AlarmCode":"","AlarmString":"","AlarmMessage":"","AlarmObject":0,"PowerOnTime":60000,"AlarmStateTime":0,"AlarmRunStateTime":0,"LimitStateTime":3000,"ProgramStopStateTime":0,"FeedHoldStateTime":0,"STMStateTime":14000,"RunStateTime":60000,"CuttingTime":60000,"SpindleCMDTime":51000,"TotalActivePower":100,"SetUpTime":0,"NoOperatorTime":0,"WaitTime":0,"MaintenanceTime":0,"OtherTime":0,"ManualModeTime":0,"MDIModeTime":0,"AutoModeTime":60000,"MacManModeTime":0,"ToolSetModeTime":0,"OriginSetModeTime":60000,"ParameterSetModeTime":0,"ProgramOpeModeTime":0,"FeedOverride":100,"SpindleOverride":100},{"MachineNo":13,"MacType":0,"MachineName":"MA600-CELL","Date":"2024-02-22T07:21:00.000Z","PowerOn":1,"AlarmState":0,"LimitState":1,"ProgramStopState":0,"FeedHoldState":0,"STMState":0,"RunState":0,"CuttingState":0,"SetUp":1,"NoOperator":0,"Wait":0,"Maintenance":0,"Other":0,"ManualMode":0,"MDIMode":0,"AutoMode":1,"MacManMode":0,"ToolSetMode":0,"OriginSetMode":1,"ParameterSetMode":0,"ProgramOpeMode":0,"ProgramFileName":"P1697.MIN","AlarmLevel":0,"AlarmNo":0,"AlarmCode":"","AlarmString":"","AlarmMessage":"","AlarmObject":0,"PowerOnTime":60000,"AlarmStateTime":0,"AlarmRunStateTime":0,"LimitStateTime":60000,"ProgramStopStateTime":0,"FeedHoldStateTime":0,"STMStateTime":0,"RunStateTime":0,"CuttingTime":0,"SpindleCMDTime":60000,"TotalActivePower":100,"SetUpTime":60000,"NoOperatorTime":0,"WaitTime":0,"MaintenanceTime":0,"OtherTime":0,"ManualModeTime":0,"MDIModeTime":0,"AutoModeTime":60000,"MacManModeTime":0,"ToolSetModeTime":0,"OriginSetModeTime":60000,"ParameterSetModeTime":0,"ProgramOpeModeTime":0,"FeedOverride":0,"SpindleOverride":100},{"MachineNo":14,"MacType":0,"MachineName":"MULTUS-B250-CELL","Date":"2024-02-22T07:21:00.000Z","PowerOn":0,"AlarmState":0,"LimitState":0,"ProgramStopState":0,"FeedHoldState":0,"STMState":0,"RunState":0,"CuttingState":0,"SetUp":0,"NoOperator":0,"Wait":0,"Maintenance":0,"Other":0,"ManualMode":0,"MDIMode":0,"AutoMode":0,"MacManMode":0,"ToolSetMode":0,"OriginSetMode":0,"ParameterSetMode":0,"ProgramOpeMode":0,"ProgramFileName":"P1697.MIN","AlarmLevel":0,"AlarmNo":0,"AlarmCode":"","AlarmString":"","AlarmMessage":"","AlarmObject":0,"PowerOnTime":0,"AlarmStateTime":0,"AlarmRunStateTime":0,"LimitStateTime":0,"ProgramStopStateTime":0,"FeedHoldStateTime":0,"STMStateTime":0,"RunStateTime":0,"CuttingTime":0,"SpindleCMDTime":0,"TotalActivePower":0,"SetUpTime":0,"NoOperatorTime":0,"WaitTime":0,"MaintenanceTime":0,"OtherTime":0,"ManualModeTime":0,"MDIModeTime":0,"AutoModeTime":0,"MacManModeTime":0,"ToolSetModeTime":0,"OriginSetModeTime":0,"ParameterSetModeTime":0,"ProgramOpeModeTime":0,"FeedOverride":0,"SpindleOverride":0},{"MachineNo":15,"MacType":0,"MachineName":"LB4000EXII_2","Date":"2024-02-22T07:21:00.000Z","PowerOn":1,"AlarmState":0,"LimitState":0,"ProgramStopState":0,"FeedHoldState":0,"STMState":1,"RunState":1,"CuttingState":1,"SetUp":0,"NoOperator":0,"Wait":0,"Maintenance":0,"Other":0,"ManualMode":0,"MDIMode":0,"AutoMode":1,"MacManMode":0,"ToolSetMode":0,"OriginSetMode":1,"ParameterSetMode":0,"ProgramOpeMode":0,"ProgramFileName":"FUR-KMZ-41654.MIN","AlarmLevel":0,"AlarmNo":0,"AlarmCode":"","AlarmString":"","AlarmMessage":"","AlarmObject":0,"PowerOnTime":60000,"AlarmStateTime":0,"AlarmRunStateTime":0,"LimitStateTime":0,"ProgramStopStateTime":0,"FeedHoldStateTime":0,"STMStateTime":1000,"RunStateTime":60000,"CuttingTime":15000,"SpindleCMDTime":60000,"TotalActivePower":100,"SetUpTime":0,"NoOperatorTime":0,"WaitTime":0,"MaintenanceTime":0,"OtherTime":0,"ManualModeTime":0,"MDIModeTime":0,"AutoModeTime":60000,"MacManModeTime":0,"ToolSetModeTime":0,"OriginSetModeTime":60000,"ParameterSetModeTime":0,"ProgramOpeModeTime":0,"FeedOverride":100,"SpindleOverride":100},{"MachineNo":16,"MacType":0,"MachineName":"V920_2","Date":"2024-02-22T07:21:00.000Z","PowerOn":1,"AlarmState":0,"LimitState":0,"ProgramStopState":0,"FeedHoldState":0,"STMState":0,"RunState":1,"CuttingState":1,"SetUp":0,"NoOperator":0,"Wait":0,"Maintenance":0,"Other":0,"ManualMode":0,"MDIMode":0,"AutoMode":1,"MacManMode":0,"ToolSetMode":0,"OriginSetMode":1,"ParameterSetMode":0,"ProgramOpeMode":0,"ProgramFileName":"BUSZ-KULSO-OP30.MIN","AlarmLevel":0,"AlarmNo":0,"AlarmCode":"","AlarmString":"","AlarmMessage":"","AlarmObject":0,"PowerOnTime":60000,"AlarmStateTime":0,"AlarmRunStateTime":0,"LimitStateTime":0,"ProgramStopStateTime":0,"FeedHoldStateTime":0,"STMStateTime":0,"RunStateTime":60000,"CuttingTime":33000,"SpindleCMDTime":60000,"TotalActivePower":0,"SetUpTime":0,"NoOperatorTime":0,"WaitTime":0,"MaintenanceTime":0,"OtherTime":0,"ManualModeTime":0,"MDIModeTime":0,"AutoModeTime":60000,"MacManModeTime":0,"ToolSetModeTime":0,"OriginSetModeTime":60000,"ParameterSetModeTime":0,"ProgramOpeModeTime":0,"FeedOverride":100,"SpindleOverride":100}],"topic":"c:\\\\okuma-share\\\\OutputFile\\\\","file":"20240222082400_OperationResult.csv","filename":"c:\\okuma-share\\OutputFile\\20240222082400_OperationResult.csv","event":"update","size":4068,"type":"file","_msgid":"e6e30e044d424e38","columns":"MachineNo,MacType,MachineName,Date,PowerOn,AlarmState,LimitState,ProgramStopState,FeedHoldState,STMState,RunState,CuttingState,SetUp,NoOperator,Wait,Maintenance,Other,ManualMode,MDIMode,AutoMode,MacManMode,ToolSetMode,OriginSetMode,ParameterSetMode,ProgramOpeMode,ProgramFileName,AlarmLevel,AlarmNo,AlarmCode,AlarmString,AlarmMessage,AlarmObject,PowerOnTime,AlarmStateTime,AlarmRunStateTime,LimitStateTime,ProgramStopStateTime,FeedHoldStateTime,STMStateTime,RunStateTime,CuttingTime,SpindleCMDTime,TotalActivePower,SetUpTime,NoOperatorTime,WaitTime,MaintenanceTime,OtherTime,ManualModeTime,MDIModeTime,AutoModeTime,MacManModeTime,ToolSetModeTime,OriginSetModeTime,ParameterSetModeTime,ProgramOpeModeTime,FeedOverride,SpindleOverride"}

error message object of mssql node:

{"code":"EREQUEST","message":"Invalid string.","details":"Invalid string.","name":"RequestError"}

csv file sample to read:
20240222083300_OperationResult.txt (4.0 KB)

flow:
flows (1).json (28.9 KB)

Thank you in advance.

2

Hmmm. Perhaps there is a regression in one of the sub modules (the last update to mssql-plus was to improve shutdown & clean up only)

Would you try a test too try help confirm this?

There is a bulk demo in the examples (ctrl-i > examples > node-red-contrib-mssql-plus ) (or copy it from here: node-red-contrib-mssql-plus/examples/Bulk demo.json at master · bestlong/node-red-contrib-mssql-plus · GitHub) - could you import this and test it against your SQL server?

3

Hello,

I upgraded from an earlier version, but unfortunatelly I don't remember what was the original version.

I tried the demo, it's working correctly.

4

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.