Cannot read property 'TABLE_SCHEMA' of undefined

[moguzalp]

My globally installed packages are:

npm@3.3.6 sequelize-auto@0.1.4 sequelize-cli@2.0.0 tedious@1.12.3

and I am trying to run:

c:\>sequelize-auto -d toto -h localhost -u sa -p 1433 -x supersecret -e mssql -o "./models"

which gives me:

Unhandled rejection TypeError: Cannot read property 'TABLE_SCHEMA' of undefined.

I can successfully run my select: SELECT TABLE_NAME, TABLE_SCHEMA FROM INFORMATION_SCHEMA.TABLES; on my SQL SERVER 2014 (not sqlexpress)

I can successfully run raw select via given connection params in my app

Here is fullstack of error

Unhandled rejection TypeError: Cannot read property 'TABLE_SCHEMA' of undefined at C:\Users\murat.oguzalp\AppData\Roaming\npm\node_modules\sequelize-auto\li b\index.js:43:34 at C:\Users\murat.oguzalp\AppData\Roaming\npm\node_modules\sequelize-auto\no de_modules\async\lib\async.js:187:20 at C:\Users\murat.oguzalp\AppData\Roaming\npm\node_modules\sequelize-auto\no de_modules\async\lib\async.js:239:13 at _arrayEach (C:\Users\murat.oguzalp\AppData\Roaming\npm\node_modules\seque lize-auto\node_modules\async\lib\async.js:91:13) at _each (C:\Users\murat.oguzalp\AppData\Roaming\npm\node_modules\sequelize- auto\node_modules\async\lib\async.js:82:13) at Object.async.forEachOf.async.eachOf (C:\Users\murat.oguzalp\AppData\Roami ng\npm\node_modules\sequelize-auto\node_modules\async\lib\async.js:238:9) at Object.async.forEach.async.each (C:\Users\murat.oguzalp\AppData\Roaming\n pm\node_modules\sequelize-auto\node_modules\async\lib\async.js:215:22) at C:\Users\murat.oguzalp\AppData\Roaming\npm\node_modules\sequelize-auto\li b\index.js:33:13 at tryCatcher (C:\Users\murat.oguzalp\AppData\Roaming\npm\node_modules\seque lize-auto\node_modules\bluebird\js\main\util.js:26:23) at Promise._settlePromiseFromHandler (C:\Users\murat.oguzalp\AppData\Roaming \npm\node_modules\sequelize-auto\node_modules\bluebird\js\main\promise.js:507:31 ) at Promise._settlePromiseAt (C:\Users\murat.oguzalp\AppData\Roaming\npm\node _modules\sequelize-auto\node_modules\bluebird\js\main\promise.js:581:18) at Promise._settlePromises (C:\Users\murat.oguzalp\AppData\Roaming\npm\node_ modules\sequelize-auto\node_modules\bluebird\js\main\promise.js:697:14) at Async._drainQueue (C:\Users\murat.oguzalp\AppData\Roaming\npm\node_module s\sequelize-auto\node_modules\bluebird\js\main\async.js:123:16) at Async._drainQueues (C:\Users\murat.oguzalp\AppData\Roaming\npm\node_modul es\sequelize-auto\node_modules\bluebird\js\main\async.js:133:10) at Immediate.Async.drainQueues [as _onImmediate] (C:\Users\murat.oguzalp\App Data\Roaming\npm\node_modules\sequelize-auto\node_modules\bluebird\js\main\async .js:15:14) at processImmediate [as _immediateCallback] (timers.js:374:17)

[zolrath]

I'm having the exact same issue on SQL Server 2012.

Executing (default): SELECT TABLE_NAME, TABLE_SCHEMA FROM INFORMATION_SCHEMA.TABLES;
Unhandled rejection TypeError: Cannot read property 'TABLE_SCHEMA' of undefined

Would greatly appreciate any help solving this!

[DPM1]

+1

Same issue

[durango]

Issue should be resolved, I don't have a local MSSQL instance to test but we're using Sequelize's table name methods now.