Jakub Denk
07/24/2023, 1:29 PM500
. I can see the following error in logs:
ts="2023-07-24 13:07:33.571" level=ERROR msg="[33d5eb11-22] 500 Server Error for HTTP PUT \"/api/v1/layout/workspaces/workspaceId/logicalModel\"" logger=org.springframework.boot.autoconfigure.web.reactive.error.AbstractErrorWebExceptionHandler thread=reactor-http-epoll-8 orgId=default spanId=1d3f152d9dd5a2a6 traceId=1d3f152d9dd5a2a6 userId=admin exc="org.jetbrains.exposed.exceptions.ExposedSQLException: org.postgresql.util.PSQLException: ERROR: relation \"obj_base\" does not exist
Can someone please guide me on how to resolve this issue? Thanks!Jakub Denk
07/24/2023, 1:34 PMPosition: 69. Statement(s): SELECT obj_base.entity_type, obj_base.\"space\", obj_base.api_id FROM obj_base WHERE (obj_base.organization = ?) AND (FALSE) AND TRUE AND TRUE" logger=Exposed thread=reactor-http-epoll-8 orgId=default spanId=4207ed8debe4e561 traceId=4207ed8debe4e561 userId=admin exc="org.jetbrains.exposed.exceptions.ExposedSQLException: org.postgresql.util.PSQLException: ERROR: relation \"obj_base\" does not exist
Jakub Denk
07/24/2023, 1:39 PMgooddata/gooddata-cn-ce:2.3.2
Francisco Antunes
07/24/2023, 1:57 PMrelation does not exist
error is thrown by Postgres when a statement references a table name that can’t be found in the referenced database. Please take a look at the Statement
bit of the call and make sure that obj_base
is being referenced correctly there. Could be as simple as a missing character, for exampleJakub Denk
07/24/2023, 2:00 PMobj_base
in my ldm model at all 🤷Francisco Antunes
07/24/2023, 2:06 PMStatement
string of the call lives under the sql
object, which defines the dataset on the LDM via a query that runs on your data source. Here it is on the log you sent us:
SELECT obj_base.entity_type, obj_base.\"space\", obj_base.api_id FROM obj_base WHERE (obj_base.organization = ?) AND (FALSE) AND TRUE AND TRUE"
Note that the query wants to use the obj_base
table on the source data. The error indicates that the query cannot be completed because that particular table cannot be found. So it’d be a matter of ensuring that this query is referencing the data source correctly.
Check the API Reference for this call for the request body schema.Jan Soubusta
07/24/2023, 2:15 PMJakub Denk
07/24/2023, 2:15 PMsql
attributes on none of our datasetsMichal Hauzírek
07/24/2023, 2:15 PMJan Soubusta
07/24/2023, 2:16 PMJan Soubusta
07/24/2023, 2:16 PMdocker-compose exec gooddata-cn-ce bash
su - postgres
psql md
Jakub Denk
07/24/2023, 2:21 PMJakub Denk
07/24/2023, 2:22 PM