Record with identifier xxxx not found

[anywheresa]

I have just installed the latest version of Dreamfactory
I can add new API keys and API types etc. I can even call the tables via API connection, however, I cannot edit any of the API, roles etc.
I also cannot access view, only tables. I can see all the view in Admin settings but as soon as I click a table or view

I get these errors
Record with identifier xxxx not found
and Table "amwhiz_customer_plans-amwhiz_customer_plans" does not exist in the database when I selecta table in the schema, even though I can access the table when calling the API.
Seem like there is a problem with the latest version.

[nicdavidson]

Hello!

Can you specify what type of database you're trying to connect to while testing here? I'll see what I can/can't recreate.

Typically, views should be seen and treated the same as tables within DF. But you will want to make sure the user DreamFactory is using to connect to the database has permissions for that view.

[anywheresa]

Hi @nicdavidson
Thank you for your reply.
Let me start again and try and provide more detail.
INSTALLATION OF DF.

1. Although DF advocates that you can install older versions, this is not true or it simply does not work. No matter which version I tried I still install the latest. Maybe because there is not option to Uninstall before you install another version. So anyway. I have the latest version (6.2.0) or so I think, installed on Ubuntu 22.04. I am using the community access to postgreSQL.

THE DD INTERFACE

I can create the following in DF to access my postgreSQL db.

1. API Keys
2. API Types
3. ROLES and associate them to _table/, _proc/ (Stored Procedure access just does not work full stop). I can also associate the roles with the API key.
4. SCHEMA - I can also see my Schema under Admin, containing all my tables and views.

Right so that was the creation process. No problem. BUT......

Now I want to try and view or edit anything. Nothing of the above created functionality is accessible. I get an error on every occasion when trying to access any of the above settings.

Example: If I try to access API Keys, this is what I get......
Record with identifier 'XXXX' not found.

I get the same error (just with a different identifier number) when trying to access/edit/view API Types, Roles, Schema as well.

DATA ACCESS
Table and View Access works.
Stored procedure access does not work. I was told in the github issue tracker that this functionality was never completed by DF dev????)
Using API Docs, this is the error I get when trying to post to a Stored Procedures...
{
"error": {
"code": 404,
"context": null,
"message": "Procedure 'new_customer_plan' does not exist in the database.",
"status_code": 404
}
}