Table doesn't exist in database (2.0 Beta issue w/ sql server)

I am new to dreamfactory and I am trying to get a webservice working on top of a existing MSSQL database.
I am using the hosted version and got an error.

Is this a bug or did I forget to set something.

Thanks for your advice

Hi,

Did anybody solve this issue in an other way?

Thanks,

JJ

Jan, are you using the hosted version at enterprise.dreamfactory.com or cloud.dreamfactory.com?
Also, did you create this table using the Schema manager in the admin UI?

Hi Drew,
I am experiencing the exact same issue. I have created an instance via cloud.dreamfactory (old v1.9) to a MS SQL database and can return records from the tables without any issue. I have also created an instance via enterprise.dreamfctory to the same database to test v2.0 and although the table names return in the service, I cannot return any data as I get the same error as above ‘Table ‘tablename’ does not exist in the database’

We were having a problem on the hosted system with MS SQL, but I believed it to be resolved.
What is the name of the example table you are using? Is it case sensitive?

Issue does occur with VMware bitnami-dreamfactory-2.0.beta-3-ubuntu-14.04 as well.
Connected to Northwind db hosted on Azure.

http://192.168.178.37:80/api/v2/Northwind/_table comes back with all tables, but trying to access one like http://192.168.178.37:80/api/v2/Northwind/_table/Categories fails.

Reponse body:

{
  "error": {
    "context": null,
    "message": "Table "Categories" does not exist in the database.",
    "code": 404,
    "trace": [
      "0 [internal function]: DreamFactory\\Core\\Resources\\BaseDbTableResource->handleGet()",
      "1 /opt/bitnami/apps/dreamfactory/htdocs/vendor/dreamfactory/df-core/src/Components/RestHandler.php(271): call_user_func(Array)",
      "2 /opt/bitnami/apps/dreamfactory/htdocs/vendor/dreamfactory/df-core/src/Components/RestHandler.php(177): DreamFactory\\Core\\Components\\RestHandler->processRequest()",
      "3 /opt/bitnami/apps/dreamfactory/htdocs/vendor/dreamfactory/df-core/src/Components/RestHandler.php(224): DreamFactory\\Core\\Components\\RestHandler->handleRequest(Object(DreamFactory\\Core\\Utility\\ServiceRequest), 'Categories')",
      "4 /opt/bitnami/apps/dreamfactory/htdocs/vendor/dreamfactory/df-core/src/Services/BaseDbService.php(116): DreamFactory\\Core\\Components\\RestHandler->handleResource(Array)",
      "5 /opt/bitnami/apps/dreamfactory/htdocs/vendor/dreamfactory/df-core/src/Components/RestHandler.php(172): DreamFactory\\Core\\Services\\BaseDbService->handleResource(Array)",
      "6 /opt/bitnami/apps/dreamfactory/htdocs/vendor/dreamfactory/df-core/src/Services/BaseRestService.php(65): DreamFactory\\Core\\Components\\RestHandler->handleRequest(Object(DreamFactory\\Core\\Utility\\ServiceRequest), '_table/Categori...')",
      "7 /opt/bitnami/apps/dreamfactory/htdocs/vendor/dreamfactory/df-core/src/Utility/ServiceHandler.php(57): DreamFactory\\Core\\Services\\BaseRestService->handleRequest(Object(DreamFactory\\Core\\Utility\\ServiceRequest), '_table/Categori...')",
      "8 /opt/bitnami/apps/dreamfactory/htdocs/bootstrap/cache/compiled.php(17493): DreamFactory\\Core\\Utility\\ServiceHandler::processRequest('v2', 'northwind', '_table/Categori...')",
      "9 /opt/bitnami/apps/dreamfactory/htdocs/bootstrap/cache/compiled.php(17458): DreamFactory\\Http\\Controllers\\RestController->handleService('v2', 'Northwind', '_table/Categori...')",
      "10 [internal function]: DreamFactory\\Http\\Controllers\\RestController->handleGET('v2', 'Northwind', '_table/Categori...')",
      "11 /opt/bitnami/apps/dreamfactory/htdocs/bootstrap/cache/compiled.php(8766): call_user_func_array(Array, Array)",
      "12 /opt/bitnami/apps/dreamfactory/htdocs/bootstrap/cache/compiled.php(8835): Illuminate\\Routing\\Controller->callAction('handleGET', Array)",
      "13 /opt/bitnami/apps/dreamfactory/htdocs/bootstrap/cache/compiled.php(8815): Illuminate\\Routing\\ControllerDispatcher->call(Object(DreamFactory\\Http\\Controllers\\RestController), Object(Illuminate\\Routing\\Route), 'handleGET')",
      "14 [internal function]: Illuminate\\Routing\\ControllerDispatcher->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request))",
      "15 /opt/bitnami/apps/dreamfactory/htdocs/bootstrap/cache/compiled.php(9472): call_user_func(Object(Closure), Object(Illuminate\\Http\\Request))",
      "16 /opt/bitnami/apps/dreamfactory/htdocs/bootstrap/cache/compiled.php(17857): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))",
      "17 [internal function]: Dreamfactory\\Http\\Middleware\\Limits->handle(Object(Illuminate\\Http\\Request), Object(Closure))",
      "18 /opt/bitnami/apps/dreamfactory/htdocs/bootstrap/cache/compiled.php(9464): call_user_func_array(Array, Array)",
      "19 /opt/bitnami/apps/dreamfactory/htdocs/bootstrap/cache/compiled.php(17752): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))",
      "20 [internal function]: DreamFactory\\Http\\Middleware\\AccessCheck->handle(Object(Illuminate\\Http\\Request), Object(Closure))",
      "21 /opt/bitnami/apps/dreamfactory/htdocs/bootstrap/cache/compiled.php(9464): call_user_func_array(Array, Array)",
      "22 [internal function]: Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))",
      "23 /opt/bitnami/apps/dreamfactory/htdocs/bootstrap/cache/compiled.php(9454): call_user_func(Object(Closure), Object(Illuminate\\Http\\Request))",
      "24 /opt/bitnami/apps/dreamfactory/htdocs/bootstrap/cache/compiled.php(8816): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))",
      "25 /opt/bitnami/apps/dreamfactory/htdocs/bootstrap/cache/compiled.php(8801): Illuminate\\Routing\\ControllerDispatcher->callWithinStack(Object(DreamFactory\\Http\\Controllers\\RestController), Object(Illuminate\\Routing\\Route), Object(Illuminate\\Http\\Request), 'handleGET')",
      "26 /opt/bitnami/apps/dreamfactory/htdocs/bootstrap/cache/compiled.php(7755): Illuminate\\Routing\\ControllerDispatcher->dispatch(Object(Illuminate\\Routing\\Route), Object(Illuminate\\Http\\Request), 'DreamFactory\\\\Ht...', 'handleGET')",
      "27 /opt/bitnami/apps/dreamfactory/htdocs/bootstrap/cache/compiled.php(7726): Illuminate\\Routing\\Route->runWithCustomDispatcher(Object(Illuminate\\Http\\Request))",
      "28 /opt/bitnami/apps/dreamfactory/htdocs/bootstrap/cache/compiled.php(7379): Illuminate\\Routing\\Route->run(Object(Illuminate\\Http\\Request))",
      "29 [internal function]: Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request))",
      "30 /opt/bitnami/apps/dreamfactory/htdocs/bootstrap/cache/compiled.php(9472): call_user_func(Object(Closure), Object(Illuminate\\Http\\Request))",
      "31 [internal function]: Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))",
      "32 /opt/bitnami/apps/dreamfactory/htdocs/bootstrap/cache/compiled.php(9454): call_user_func(Object(Closure), Object(Illuminate\\Http\\Request))",
      "33 /opt/bitnami/apps/dreamfactory/htdocs/bootstrap/cache/compiled.php(7380): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))",
      "34 /opt/bitnami/apps/dreamfactory/htdocs/bootstrap/cache/compiled.php(7368): Illuminate\\Routing\\Router->runRouteWithinStack(Object(Illuminate\\Routing\\Route), Object(Illuminate\\Http\\Request))",
      "35 /opt/bitnami/apps/dreamfactory/htdocs/bootstrap/cache/compiled.php(7353): Illuminate\\Routing\\Router->dispatchToRoute(Object(Illuminate\\Http\\Request))",
      "36 /opt/bitnami/apps/dreamfactory/htdocs/bootstrap/cache/compiled.php(2262): Illuminate\\Routing\\Router->dispatch(Object(Illuminate\\Http\\Request))",
      "37 [internal function]: Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}(Object(Illuminate\\Http\\Request))",
      "38 /opt/bitnami/apps/dreamfactory/htdocs/bootstrap/cache/compiled.php(9472): call_user_func(Object(Closure), Object(Illuminate\\Http\\Request))",
      "39 /opt/bitnami/apps/dreamfactory/htdocs/vendor/barryvdh/laravel-cors/src/HandleCors.php(43): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))",
      "40 [internal function]: Barryvdh\\Cors\\HandleCors->handle(Object(Illuminate\\Http\\Request), Object(Closure))",
      "41 /opt/bitnami/apps/dreamfactory/htdocs/bootstrap/cache/compiled.php(9464): call_user_func_array(Array, Array)",
      "42 /opt/bitnami/apps/dreamfactory/htdocs/bootstrap/cache/compiled.php(17836): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))",
      "43 [internal function]: DreamFactory\\Http\\Middleware\\FirstUserCheck->handle(Object(Illuminate\\Http\\Request), Object(Closure))",
      "44 /opt/bitnami/apps/dreamfactory/htdocs/bootstrap/cache/compiled.php(9464): call_user_func_array(Array, Array)",
      "45 /opt/bitnami/apps/dreamfactory/htdocs/bootstrap/cache/compiled.php(12789): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))",
      "46 [internal function]: Illuminate\\View\\Middleware\\ShareErrorsFromSession->handle(Object(Illuminate\\Http\\Request), Object(Closure))",
      "47 /opt/bitnami/apps/dreamfactory/htdocs/bootstrap/cache/compiled.php(9464): call_user_func_array(Array, Array)",
      "48 /opt/bitnami/apps/dreamfactory/htdocs/bootstrap/cache/compiled.php(11412): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))",
      "49 [internal function]: Illuminate\\Session\\Middleware\\StartSession->handle(Object(Illuminate\\Http\\Request), Object(Closure))",
      "50 /opt/bitnami/apps/dreamfactory/htdocs/bootstrap/cache/compiled.php(9464): call_user_func_array(Array, Array)",
      "51 /opt/bitnami/apps/dreamfactory/htdocs/bootstrap/cache/compiled.php(12530): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))",
      "52 [internal function]: Illuminate\\Cookie\\Middleware\\AddQueuedCookiesToResponse->handle(Object(Illuminate\\Http\\Request), Object(Closure))",
      "53 /opt/bitnami/apps/dreamfactory/htdocs/bootstrap/cache/compiled.php(9464): call_user_func_array(Array, Array)",
      "54 /opt/bitnami/apps/dreamfactory/htdocs/bootstrap/cache/compiled.php(12469): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))",
      "55 [internal function]: Illuminate\\Cookie\\Middleware\\EncryptCookies->handle(Object(Illuminate\\Http\\Request), Object(Closure))",
      "56 /opt/bitnami/apps/dreamfactory/htdocs/bootstrap/cache/compiled.php(9464): call_user_func_array(Array, Array)",
      "57 /opt/bitnami/apps/dreamfactory/htdocs/bootstrap/cache/compiled.php(2936): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))",
      "58 [internal function]: Illuminate\\Foundation\\Http\\Middleware\\CheckForMaintenanceMode->handle(Object(Illuminate\\Http\\Request), Object(Closure))",
      "59 /opt/bitnami/apps/dreamfactory/htdocs/bootstrap/cache/compiled.php(9464): call_user_func_array(Array, Array)",
      "60 [internal function]: Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))",
      "61 /opt/bitnami/apps/dreamfactory/htdocs/bootstrap/cache/compiled.php(9454): call_user_func(Object(Closure), Object(Illuminate\\Http\\Request))",
      "62 /opt/bitnami/apps/dreamfactory/htdocs/bootstrap/cache/compiled.php(2209): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))",
      "63 /opt/bitnami/apps/dreamfactory/htdocs/bootstrap/cache/compiled.php(2192): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter(Object(Illuminate\\Http\\Request))",
      "64 /opt/bitnami/apps/dreamfactory/htdocs/public/index.php(53): Illuminate\\Foundation\\Http\\Kernel->handle(Object(Illuminate\\Http\\Request))",
      "65 {main}"
    ]
  }
}

I am experiencing similar issues. I will bring this to the attention of the engineering team.

Same thing here on DreamFactory 2.0.beta-3 (64-bit) Windows.

Note: the SQL server system tables work

Is everybody who is experiencing this issue using case sensitive table names?

If you by case sensitive mean capital and small letters mixed then yes, e.g. “Customers”.

Any solution to this yet?

I’m experiencing this issue with DF v2 beta-4 locally hosted, and SQL Server 2008 R2, when trying to retrieve records from table myTableName:

http://127.0.0.1/api/v2/sql/_table/myTableName

Works fine when retrieving list of tables.

¿Anything wrong?

there was an issue where tablenames were getting converted to all lowercase, which causes this error.
The issue has been fixed in the DreamFactory master branch repo. I do not know if this fix has been packaged by Bitnami yet. I will check.

Confirmed that this fix is NOT in the Bitnami package yet. It should be included in the next release, 2.0.0 (not beta!)

If you prefer, you can perform a manual update of your code via git and composer instead of waiting on a Bitnami release.

Hi Drew,
will check installing recent version 2.0.1 of Windows package (noticed that no ‘x64’ option to download, assuming that is 32bit package)

Thanks

That’s right. We unlisted the 64 bit package entirely. Too many issues, and no discernible benefit.

A post was split to a new topic: Table does not exist in database