Hi everyone, we're new and after setting up our first data source we're getting "*Sorry, we can't display this visualization*" on any field we drag in. I'm tracing the SQL on our side and with "Test connection" on the data source a "select 1" is executed against our database. When I drag any field into a viz a "select 1" is issued again but never any other SQL query. This is the error: Sorry, we can't display this visualization A calculation error occurred. See the raw error response for details Error trace ID: b6fc5bc830566c1656c0567e837ca229 The raw response:

{

"title": "Bad Request",

"status": 400,

"detail": "An error has occurred while calculating the result",

"resultId": "555ce751b81caba6898988828100fa6ad1ed936d",

"reason": "General error",

"traceId": "b6fc5bc830566c1656c0567e837ca229"

}

Any help appreciated. Thank you!

Hi Terry, based on our logs I can see the following:

"detail": "General error; caused by The server principal \"gooddata\" is not able to access the database \"demo-dev-db\" under the current security context."

This error usually means the mapped DB user does not have the required access to the target database (

demo-dev-db

).

Hi @Joseph Heun, yes, that makes complete sense. A new DB user was created for this test and there is a cross-database query going on behind the scenes. The user wasn't added to the second DB. Thank you!

Glad to hear it is sorted!