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

[Allen Andreas]

Hi,

Other than thinking that the dashboard hasn't been shared with the user...a few questions:

1) Has it ever loaded before for them?

2) Have you tried different browsers?

3) Are they trying to load this through a VPN or something of that nature?

4) What does their load clock say in the bottom right hand corner of their screen?

As you can see, you have a TON of filter possibilities...so I would maybe try to remove some and see if it starts to load and see if you can pinpoint what exactly is going on.

[quintenvandenb1]

Hi Allen

We tried many things, however, the issue is related to the user in some way that we just can't figure out.

 

[Allen Andreas]

Yes, I understand that, haha, which is why you posted here, so I'm trying to help you, as per my list of questions and suggestions above. So as you can see, it's definitely timing out for this user. Seems more network related. As suggested previously, you could try and remove some of the filter parameters and see where it starts to go wrong (granted you'll need ALL the parameters, but I'm just trying to help find root cause) and/or have them try another browser. If they are a remote employee....have them check their internet and all that basic troubleshooting. See if they can get it to load by going somewhere else (using another internet connection, etc.).

[Adam Stout · Accepted solution]

Can they load the report directly?  On a side note, those conditions are just asking for performance issues (too many ORs on the task table).  Have you tried looking at the plan and making sure you have some reasonable indexes?  Any chance you could add active = true to all of these?