I'm getting an unresponsive page every time I try ...
# gooddata-cloud
f
I'm getting an unresponsive page every time I try to open a dashboard. Something is causing it to hang, and it just sits like that forever. Is there any way you can check why it's happening? I'm guessing a specific table/chart that's causing this, but I can't see anything in console log
m
Hi Filip, looking in our logs I found this message:
Copy code
message=Enumerating datetime attributes='[attribute/posted_date.day/zentist-main]' is not allowed,<no detail>
Which it could be related to whit maql query:
Copy code
"msg": "Get SQL",
"action": "grpcGetSql",
Copy code
"request": "maql {\n  dimension {\n    id: \"posted_date.day\"\n    space: \"zentist-main\"\n    type: LABEL\n  }\n  timestamp: \"2025-05-09T13:50:32+00:00\"\n  limit: -1\n  timezone: \"Etc/UTC\"\n}\ncontext {\n  organizationId: \"cocdjf4vto\"\n  workspaceId: \"zentist-main\"\n}\ndataSamplingPercentage: 100.0\nweekType: EU\n",
But still I can not find the insight, probably you have an insight where you are doing some arithmetic with a datetime attribute, more specific with
posted_date.day
. Let me know if that helps.
f
Are you sure that this is causing the crashing? I don't remember doing this, but it's possible someone else might've...
m
In that case, can you let us to know at what time the screenshot was taken, or if you can share the HAR file would be nice.
No problem, I have impersonate your orgID ad Admin, and I can see the same issue. I can generate HAR file, I will keep you updated
f
it only hangs in the parent workspace. Child workspaces don't have this problem
m
Hi Filip, my apologies for the first message. Now, after the impersonation I found the error:
Copy code
message=xtab-rows: The limit for the maximum size of the dimension without metrics was exceeded. Limit: 100_000. Actual: 362_956.
The error indicates that you’re hitting the size limit when not using a metric in an insight, so we would recommend you to add a metric there, or limit the amount of data by filtering. But still I can not find the insight, and I can not change it on the UI before it crashes. Maybe you can remember if you did some recent changes in some of the insights on that dashboard which could be affected, or you updated the datasource by adding more data?
f
I did do a recent change where I removed all join keys between tables (there were cluttering up the LDM and there were like 40). I also can't find this table - I checked and all tables have a metric on them, even drilldowns
I think the issue was a treemap with >500 segments in it. I limited it to 200 and it seems fixed now.
m
Hi Filip, thank you for letting me know. I was just trying to find the insight into the problem. I can confirm from my side that it is working. Please let me know if you need further assistance.
f
@Mauricio Cabezas It seems some clients are still complaining that it becomes unresponsive. Can you check if there are any others errors right now?
m
Hi Filip, I have impersonated your org, and I have checked the same workspace as the previous issue but for me is loading without any problem. Can you please confirm to us which Dashboard or workspace is affected? also which clients/user , feel free to use DM.
f
So it was the treemap again- in certain cases sum(value) was negative so it was crashing and bringing down the whole dashboard with it. We could remove the negative values, but decided to remove the whole chart altogether for now. Sorry for bothering you again.
m
Hi Filip, thank you for this update. Can you please share with us the direct link to the insight (by DM)? It would be nice to us have the 'shape' of the specific log for future reference and quick troubleshooting. Thank you for your cooperation.
f
id: ca7b4624-5c7e-484f-b972-cbfc8a1cf310
name: Collections - Posted by Date & Practice Group
Should originate in our
zentist-main
workspace, but crashed in
child_1_48
yesterday
🙌 1
1