node-mssql: Bulk operations suddenly stopped working.

Hello, guys 😃

I’m having problems performing a simple bulk operation. My code worked for long time, and without any changes, it suddenly started having problems. The fun fact is that the error issued is RequestError: Invalid object name '[table_name]'. at handleError but the table is created and the data is not inserted.

Expected behaviour:

Create a table if not exists and bulk insert data.

Actual behaviour:

RequestError: Invalid object name '[table_name]'. at handleError (/Users/rzuini/Desktop/dev/test/node_modules/mssql/lib/tedious/request.js:233:15) at Connection.emit (node:events:394:28) at Connection.emit (/Users/rzuini/Desktop/dev/test/node_modules/tedious/lib/connection.js:1061:18) at Parser.<anonymous> (/Users/rzuini/Desktop/dev/test/node_modules/tedious/lib/connection.js:1166:12) at Parser.emit (node:events:394:28) at Readable.<anonymous> (/Users/rzuini/Desktop/dev/test/node_modules/tedious/lib/token/token-stream-parser.js:27:14) at Readable.emit (node:events:394:28) at addChunk (/Users/rzuini/Desktop/dev/test/node_modules/readable-stream/lib/_stream_readable.js:298:12) at readableAddChunk (/Users/rzuini/Desktop/dev/test/node_modules/readable-stream/lib/_stream_readable.js:280:11) at Readable.push (/Users/rzuini/Desktop/dev/test/node_modules/readable-stream/lib/_stream_readable.js:241:10) { code: 'EREQUEST', originalError: Error: Invalid object name '[table_name]'. at handleError (/Users/rzuini/Desktop/dev/test/node_modules/mssql/lib/tedious/request.js:231:19) at Connection.emit (node:events:394:28) at Connection.emit (/Users/rzuini/Desktop/dev/test/node_modules/tedious/lib/connection.js:1061:18) at Parser.<anonymous> (/Users/rzuini/Desktop/dev/test/node_modules/tedious/lib/connection.js:1166:12) at Parser.emit (node:events:394:28) at Readable.<anonymous> (/Users/rzuini/Desktop/dev/test/node_modules/tedious/lib/token/token-stream-parser.js:27:14) at Readable.emit (node:events:394:28) at addChunk (/Users/rzuini/Desktop/dev/test/node_modules/readable-stream/lib/_stream_readable.js:298:12) at readableAddChunk (/Users/rzuini/Desktop/dev/test/node_modules/readable-stream/lib/_stream_readable.js:280:11) at Readable.push (/Users/rzuini/Desktop/dev/test/node_modules/readable-stream/lib/_stream_readable.js:241:10) { info: ErrorMessageToken { name: 'ERROR', event: 'errorMessage', number: 208, state: 1, class: 16, message: "Invalid object name '[table_name]'.", serverName: 'wbg-bi-srv', procName: '', lineNumber: 1 } }, number: 208, lineNumber: 1, state: 1, class: 16, serverName: 'wbg-bi-srv', procName: '', precedingErrors: [ RequestError: Invalid object name '[table_name]'. at handleError (/Users/rzuini/Desktop/dev/test/node_modules/mssql/lib/tedious/request.js:233:15) at Connection.emit (node:events:394:28) at Connection.emit (/Users/rzuini/Desktop/dev/test/node_modules/tedious/lib/connection.js:1061:18) at Parser.<anonymous> (/Users/rzuini/Desktop/dev/test/node_modules/tedious/lib/connection.js:1166:12) at Parser.emit (node:events:394:28) at Readable.<anonymous> (/Users/rzuini/Desktop/dev/test/node_modules/tedious/lib/token/token-stream-parser.js:27:14) at Readable.emit (node:events:394:28) at addChunk (/Users/rzuini/Desktop/dev/test/node_modules/readable-stream/lib/_stream_readable.js:298:12) at readableAddChunk (/Users/rzuini/Desktop/dev/test/node_modules/readable-stream/lib/_stream_readable.js:280:11) at Readable.push (/Users/rzuini/Desktop/dev/test/node_modules/readable-stream/lib/_stream_readable.js:241:10) { code: 'EREQUEST', originalError: Error: Invalid object name '[table_name]'. at handleError (/Users/rzuini/Desktop/dev/test/node_modules/mssql/lib/tedious/request.js:231:19) at Connection.emit (node:events:394:28) at Connection.emit (/Users/rzuini/Desktop/dev/test/node_modules/tedious/lib/connection.js:1061:18) at Parser.<anonymous> (/Users/rzuini/Desktop/dev/test/node_modules/tedious/lib/connection.js:1166:12) at Parser.emit (node:events:394:28) at Readable.<anonymous> (/Users/rzuini/Desktop/dev/test/node_modules/tedious/lib/token/token-stream-parser.js:27:14) at Readable.emit (node:events:394:28) at addChunk (/Users/rzuini/Desktop/dev/test/node_modules/readable-stream/lib/_stream_readable.js:298:12) at readableAddChunk (/Users/rzuini/Desktop/dev/test/node_modules/readable-stream/lib/_stream_readable.js:280:11) at Readable.push (/Users/rzuini/Desktop/dev/test/node_modules/readable-stream/lib/_stream_readable.js:241:10) { info: ErrorMessageToken { name: 'ERROR', event: 'errorMessage', number: 208, state: 1, class: 16, message: "Invalid object name '[table_name]'.", serverName: 'wbg-bi-srv', procName: '', lineNumber: 1 } }, number: 208, lineNumber: 1, state: 1, class: 16, serverName: 'wbg-bi-srv', procName: '' } ] }

Configuration:

const sql = require('mssql')

let params = {
    user: '---',
    password: '---',
    database: '---',
    server: '---',
}

const { user, password, database, server } = params

const sqlConfig = {
    user,
    password,
    database,
    server,
    pool: {
        max: 10,
        min: 0,
        idleTimeoutMillis: 30000
    },
    options: {
        encrypt: true, // for azure
        trustServerCertificate: false // change to true for local dev / self-signed certs
    }
}

let exec = async () => {
    // make sure that any items are correctly URL encoded in the connection string
    await sql.connect(sqlConfig)

    var table = new sql.Table('table_name')
    // or temporary table, e.g. #temptable
    table.create = true
    table.columns.add('a', sql.Int, { nullable: false, primary: true })
    table.columns.add('b', sql.VarChar(50), { nullable: false })

    table.rows.add(777, 'test')

    const request = new sql.Request()
    return request.bulk(table)

}

exec()

Does anyone have any idea where I might be going wrong?

Software versions

• NodeJS: 16.5.0
• node-mssql: 7.1.3
• SQL Server: Azure SQL Server