Dashboard not loading for one specific user

[quintenvandenb1]

Hi all

At the customer, we are experiencing an issue regarding homepages that we can simply not find out the problem for over 2 months already. It is a report on the homepage that is loading based on the task table all "groups work" that is unassigned " grouped by "assignment group"

For one user it works perfect, for one very specific user it always gives the "Maximum execution time exceeded" warning for that specific widget.

All groups, roles, and user data are identical to the one that has no issue. If I run the report using the list view and the matching encoded query, it returns the exact same amount of records for both users.

A parallel is enabled for the homepage and the amount has the default value which is 2. I tried transferring the homepage from the one to the other user and also no result.

So to confirm, the issue is not related to all of the following:

- homepage
- widget
- report
- ACL
- User record
- roles
- groups

What am I missing here? I'm starting to think that this problem might have to do with the node the user is on.

Any help on this topic would be much appreciated as it is a big and urgent matter right now.

I thank you all for reading this.

Best regards,

Quinten Van den Berghe

The filter

[quintenvandenb1]

I think what you said is most close to the actual answer. Thank you.

[Allen Andreas]

Glad you got it resolved...and what was the actual answer? Because I responded multiple times and in one of mine I suggested to remove the filters and troubleshoot things that way...if there was performance issues and to find out where the problem was.

Thanks

[quintenvandenb1]

Hello there

Sorry for the late response. I'm not often active anymore due to meetings. The problem was too many records and the group by. Other than that, it sometimes is related to things on ServiceNow side itself including this situation. Creating an HI ticket would be the solution then.