Hello, I have a dashboard that isn't working while...
# gooddata-cloud
s
Hello, I have a dashboard that isn't working while it should (LDM looks ok, and using the analyze feature i'm able to find some entries). Can someone inspect the traces with id "30612d4467e61a9518e006f6668e8a35" and "88200732cc976618cdd0729bca72f32f" ? The message is "general error" which isn't helpful. Thanks!
v
Hi Simon, "General error" usually means that an SQL query failed in the data source itself, this is what I found in the logs.
Copy code
No matching signature for function DATETIME_ADD for argument types: STRING, INTERVAL INT64 DATE_TIME_PART. Supported signatures: DATETIME_ADD(DATETIME, INTERVAL INT64 DATE_TIME_PART); DATETIME_ADD(TIMESTAMP, INTERVAL INT64 DATE_TIME_PART) at [2:29
Copy code
No matching signature for operator >= for argument types: STRING, DATETIME. Supported signature: ANY >= ANY at [6:7]
So it looks like there is a column, which is assumed to be a date, but in reality it is a string.
🙌 1
s
Hello, thank you for hour help, this gives me some context to dig deeper. cheers