The request to your server either failed or returned invalid data. (Hosted, direct Postgres connection)

[dogweather]

Feature(s) impacted

All.

Observed behavior

Tables and columns briefly visible. Data not shown. Intead, the error message. Also, 500 and 404 errors in the browser console.

Expected behavior

No idea. I haven’t been able to use the app yet.

Failure Logs

Context

• Project name: News Desk
• Team name: Public.Law
• Environment name: production
• Agent (forest package) hosted web app
• Database type: Postgres v13

[dogweather]

Update: I found — by trialing Jet Admin — that the error was the Postgres user needing:

GRANT USAGE ON SCHEMA [schema name] TO [user name];

… in addition to permissions on the tables.

Jet Admin shows the actual error messages during UI creation, which was an immense help.

[Alban_Bertolini]

Hello,
Could you provide additional details regarding the problem in order to assist in replicating the issue?