RequestError: Invalid object name 'dbo.ACL'

[Enver Daniel Francisco Báez]

hi, i try the request all item of a model by the method get findall, but doesn't work; those method haved been generated by strongloop migration tool at strongloop explorer.

the message:

{

  "error": {
    "name": "RequestError",
    "status": 500,
    "message": "Invalid object name 'dbo.ACL'.",
    "code": "EREQUEST",
    "number": 208,
    "lineNumber": 1,
    "state": 1,
    "class": 16,
    "serverName": "PAPEL2",
    "procName": "",
    "precedingErrors": [],
    "stack": "RequestError: Invalid object name 'dbo.ACL'.\n    at Connection.<anonymous> (c:\\Users\\e.francisco\\Documents\\FlujoArchivos\\node_modules\\loopback-connector-mssql\\node_modules\\mssql\\lib\\tedious.js:649:17)\n    at Connection.emit (events.js:107:17)\n    at Parser.<anonymous> (c:\\Users\\e.francisco\\Documents\\FlujoArchivos\\node_modules\\loopback-connector-mssql\\node_modules\\mssql\\node_modules\\tedious\\lib\\connection.js:444:15)\n    at Parser.emit (events.js:107:17)\n    at Parser.nextToken (c:\\Users\\e.francisco\\Documents\\FlujoArchivos\\node_modules\\loopback-connector-mssql\\node_modules\\mssql\\node_modules\\tedious\\lib\\token\\token-stream-parser.js:91:18)\n    at Parser.addBuffer (c:\\Users\\e.francisco\\Documents\\FlujoArchivos\\node_modules\\loopback-connector-mssql\\node_modules\\mssql\\node_modules\\tedious\\lib\\token\\token-stream-parser.js:68:17)\n    at Connection.sendDataToTokenStreamParser (c:\\Users\\e.francisco\\Documents\\FlujoArchivos\\node_modules\\loopback-connector-mssql\\node_modules\\mssql\\node_modules\\tedious\\lib\\connection.js:891:35)\n    at Connection.STATE.SENT_CLIENT_REQUEST.events.data (c:\\Users\\e.francisco\\Documents\\FlujoArchivos\\node_modules\\loopback-connector-mssql\\node_modules\\mssql\\node_modules\\tedious\\lib\\connection.js:275:23)\n    at Connection.dispatchEvent (c:\\Users\\e.francisco\\Documents\\FlujoArchivos\\node_modules\\loopback-connector-mssql\\node_modules\\mssql\\node_modules\\tedious\\lib\\connection.js:752:59)\n    at MessageIO.<anonymous> (c:\\Users\\e.francisco\\Documents\\FlujoArchivos\\node_modules\\loopback-connector-mssql\\node_modules\\mssql\\node_modules\\tedious\\lib\\connection.js:680:22)"
  }
}

can you help to detect what is the problem.

the connection work with MSQL 'cause bring me the all tables.

[Junior abad santur]

hI Hello friend .. I found the same problem, you could locate an a solution?

[Raymond Feng]

You need to create DB tables by hand or run automigrate/autoupdate. 

See: http://docs.strongloop.com/display/LB/Creating+a+database+schema+from+models

You can use StrongLoop Arc as the GUI for db migrations.

See: http://docs.strongloop.com/display/APIS/Creating+and+editing+models#Creatingandeditingmodels-Migratingamodel

Thanks,

---

Raymond Feng

Co-Founder and Architect @ StrongLoop, Inc.

StrongLoop makes it easy to develop APIs in Node, plus get DevOps capabilities like monitoring, debugging and clustering.

On Jul 15, 2015, at 9:28 AM, Junior abad santur <jrsan...@gmail.com> wrote:

hI Hello friend .. I found the same problem, you could locate an a solution?

--
You received this message because you are subscribed to the Google Groups "LoopbackJS" group.
To unsubscribe from this group and stop receiving emails from it, send an email to loopbackjs+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/loopbackjs/067925fa-09f8-42c6-9fe0-4478e5da3aa4%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Mark Twain]

I am seeing the same error on all the rest urls. 

I reverse engineered the rest urls using Arc on my sql server database. 

any ideas ? 

[Michael DeMutis]

Solution here:  https://loopback.io/doc/en/lb2/Creating-database-tables-for-built-in-models.html

2.x docs work for 3.x for this task