throw TypeError('value is out of bounds');

[paulomcnally]

[root@ISAAPI01 ser-web-api]# node api.js
Kill PID:6644

buffer.js:784
    throw TypeError('value is out of bounds');
          ^
TypeError: value is out of bounds
    at TypeError (<anonymous>)
    at checkInt (buffer.js:784:11)
    at Buffer.writeUInt32LE (buffer.js:841:5)
    at WritableTrackingBuffer.writeUInt32LE (/sites/ser-web-api/node_modules/mssql/node_modules/tedious/lib/tracking-buffer/writable-tracking-buffer.js:92:17)
    at WritableTrackingBuffer.writeUInt64LE (/sites/ser-web-api/node_modules/mssql/node_modules/tedious/lib/tracking-buffer/writable-tracking-buffer.js:119:17)
    at Object.TYPE.writeParameterData (/sites/ser-web-api/node_modules/mssql/node_modules/tedious/lib/data-type.js:268:25)
    at new RpcRequestPayload (/sites/ser-web-api/node_modules/mssql/node_modules/tedious/lib/rpcrequest-payload.js:66:22)
    at Connection.callProcedure (/sites/ser-web-api/node_modules/mssql/node_modules/tedious/lib/connection.js:731:56)
    at /sites/ser-web-api/node_modules/mssql/lib/tedious.js:723:33
    at dispense (/sites/ser-web-api/node_modules/mssql/node_modules/generic-pool/lib/generic-pool.js:247:16)
    at Object.me.acquire (/sites/ser-web-api/node_modules/mssql/node_modules/generic-pool/lib/generic-pool.js:316:5)
    at Request._acquire (/sites/ser-web-api/node_modules/mssql/lib/main.js:884:37)
    at Request.TediousRequest.execute (/sites/ser-web-api/node_modules/mssql/lib/tedious.js:586:21)
    at Request.execute (/sites/ser-web-api/node_modules/mssql/lib/main.js:1088:56)
    at /sites/ser-web-api/controllers/lubricantes.js:28:21
    at Array.forEach (native)
    at /sites/ser-web-api/controllers/lubricantes.js:12:14
    at /sites/ser-web-api/helpers/mssql.js:40:17
    at /sites/ser-web-api/node_modules/mssql/lib/main.js:236:51
    at /sites/ser-web-api/node_modules/mssql/lib/tedious.js:330:20
    at /sites/ser-web-api/node_modules/mssql/node_modules/generic-pool/lib/generic-pool.js:278:11
    at Connection.<anonymous> (/sites/ser-web-api/node_modules/mssql/lib/tedious.js:308:24)
    at Connection.g (events.js:180:16)
    at Connection.EventEmitter.emit (events.js:92:17)
    at Connection.processedInitialSql (/sites/ser-web-api/node_modules/mssql/node_modules/tedious/lib/connection.js:690:17)
    at Connection.STATE.LOGGED_IN_SENDING_INITIAL_SQL.events.message (/sites/ser-web-api/node_modules/mssql/node_modules/tedious/lib/connection.js:173:23)
    at Connection.dispatchEvent (/sites/ser-web-api/node_modules/mssql/node_modules/tedious/lib/connection.js:573:59)
    at MessageIO.<anonymous> (/sites/ser-web-api/node_modules/mssql/node_modules/tedious/lib/connection.js:528:22)
    at MessageIO.EventEmitter.emit (events.js:92:17)
    at MessageIO.eventData (/sites/ser-web-api/node_modules/mssql/node_modules/tedious/lib/message-io.js:58:21)
    at Socket.<anonymous> (/sites/ser-web-api/node_modules/mssql/node_modules/tedious/lib/message-io.js:3:59)
    at Socket.EventEmitter.emit (events.js:95:17)
    at Socket.<anonymous> (_stream_readable.js:746:14)
    at Socket.EventEmitter.emit (events.js:92:17)
    at emitReadable_ (_stream_readable.js:408:10)
    at emitReadable (_stream_readable.js:404:5)
    at readableAddChunk (_stream_readable.js:165:9)
    at Socket.Readable.push (_stream_readable.js:127:10)
    at TCP.onread (net.js:528:21)
[root@ISAAPI01 ser-web-api]# 

[kenleese]

Using SQL Server 2014 Express:

CREATE TABLE t11s_db.t11s.Test
(
[id] INT NOT NULL,
latitude NUMERIC(8,5),
longitude NUMERIC(8,5),
PRIMARY KEY NONCLUSTERED ([id] ASC)
);

Using node.js 10.23, mssql 0.5.3, default driver (tedious):
INSERT INTO t11s.Test VALUES (@p0,@p1,@p2);
where parameters are:
INTNOTNULL: @p0 = 118583
NUMERIC(8,5): @p1 = 36.13636
NUMERIC(8,5): @p2 = -115.16225

buffer.js:784
throw TypeError('value is out of bounds');
^
TypeError: value is out of bounds
at TypeError ()
at checkInt (buffer.js:784:11)
at Buffer.writeUInt32LE (buffer.js:841:5)
at WritableTrackingBuffer.writeUInt32LE (D:\Trippo\etl\node_modules\mssql\node_modules\tedious\lib\tracking-buffer\writable-tracking-buffer.js:92:17)
at Object.TYPE.writeParameterData (D:\Trippo\etl\node_modules\mssql\node_modules\tedious\lib\data-type.js:332:25)
at new RpcRequestPayload (D:\Trippo\etl\node_modules\mssql\node_modules\tedious\lib\rpcrequest-payload.js:66:22)
at Connection.execSql (D:\Trippo\etl\node_modules\mssql\node_modules\tedious\lib\connection.js:712:56)
at D:\Trippo\etl\node_modules\mssql\lib\tedious.js:563:33
at dispense (D:\Trippo\etl\node_modules\mssql\node_modules\generic-pool\lib\generic-pool.js:247:16)
at Object.me.acquire (D:\Trippo\etl\node_modules\mssql\node_modules\generic-pool\lib\generic-pool.js:316:5)

I suspect the issue may be related to the NUMERIC data type.

[patriksimek]

Fixed in Tedious 0.2.3 - tediousjs/tedious#147