can someone please help me understand what the err...
# gooddata-cloud
s
can someone please help me understand what the error is here?
Copy code
{
  "title": "Bad Request",
  "status": 400,
  "detail": "An error has occurred while calculating the result",
  "resultId": "79c082dd3e7dafe73666573f8cce65c9a4a9d49b",
  "reason": "General error",
  "traceId": "ef266f9b6e47d44754793d706c602b72"
}
"General error" is a very generic error message. this happens when I add a specific field called [Profile field] Gender for this workspace
k
New message text here
m
Hi Sasha, let me check the logs to provide more context. In the meantime can you please let us know which 'action' you were performing? 'Adding specific field...' you mean Attribute to some insight in the AD?
s
yes
m
Hi Sasha, our apologies for the Generic error message. Checking in our logs we found:
Copy code
"msg": "Execution of SQL statement has failed",
...
Caused by: net.snowflake.client.jdbc.SnowflakeSQLException: SQL compilation error: error line 2 at position 485\ninvalid identifier '\"t15\".\"gender_[155]
The error it’s coming from Snowflake: the query is using a column that doesn’t exist (or has a bad name). Specifically, something like "t15"."gender_[155]" is being referenced, and Snowflake is rejecting it as an invalid identifier. Please, make sure the Gender profile field is mapped to the actual column name in your Snowflake table (e.g. gender or whatever the real column is), not to something like gender_[155]. Once that mapping matches the real column, the error should go away.
Hi Sasha, Please, let us to know if you need further assistance.