Error mt_CreateEvent: Grid widget in dashboard returns error if to many rows are to be displayed

[Alexander Koeppe]

Describe the bug
Dashboard with 2 grid widgets. Widget 1 with Totals working fine. Widget 2 with detailed information. When there are too many rows to be displayed, widget does not work anymore and returns:

Data query failed. Please review setting. Details”

• Status:        500
• Message:   Error: Internal Server Error SystemOutOfMemory

If you select a n-Element on the filter instead of Total the query works again. When the query fails it has about 1.400 rows to be displayed. In Arc result is shown in about 3 seconds.

RAM consumption is at 66%, so there should be enough RAM available.

‌

Error in Pulse:
3520 APLIQOFPM_DEV CWMmio ERROR 8:04:05 TM1.Event mt_CreateEvent: Creation of event failed. GetLastError() = 1450

‌

Restarting the TM1 server does solve the problem but it occurs after a short while again. So the query is working a while but then fails again.

Component
Dashboard with 2 grid widgets

Version UX
2021.21.11 FP2

[tomer ganz]

this issue has been closed as a workaround has been applied and this related to an edge case which related to a customization done on the product from the customer side.

[Alexander Koeppe]

Issue is related to connected widget. For the connected widget an MDX is generated. If too many dimensions are used the MDX is getting to long causing the behaviour.

[Scott Wiltshire]

Removing milestone: 2022_Q1 (automated comment)