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


#1

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


#2

Hi,

Did anybody solve this issue in an other way?

Thanks,

JJ


#3

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?


#4

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’


#5

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?


#6

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}"
    ]
  }
}

#7

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


#8

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

Note: the SQL server system tables work


#9

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


#10

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

Any solution to this yet?


#11

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?


#12

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.


#13

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.


#14

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


#15

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


#16

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


#17