Support (offered by community volunteers) > Using Core CiviCRM Functions

Dashboard hangs and never finishes loading

<< < (2/2)

Hershel:
You can't re-upgrade. The upgrader will tell you there's nothing to do.

Do you have any other modules enabled that perhaps have JS files?

Did you compare your Net tab to the demo?

EdP:
It may be totally unrelated, but there are a group of people for whom the dashboard takes ages to load and eventually reports "false".
Details here http://forum.civicrm.org/index.php/topic,18157.0.html
I suppose it is possible that yours is the same issue but that you never get the timeout (or whatever it is) that gives the false response.
E

jake.mw:
It doesn't look like anyone has posted on this recently, but I ran into the same issue on a new installation.

The dashboard hangs as shown in the screenshot.  Widgets do not report "false" (that's a different issue); the widget simply shows "loading" as usual, and never completes.  On the server side, a bunch of mysql processes stack up and never complete.  After enough page loads, the entire server grounds to a halt.

After some debugging, I determined:

* this is an issue with the Activity report
* it only affects users who are using ACL, and who do not have the 'view all contacts' permission

I have attached a patch to the Activity report which fixed the issue for me.  Is there somewhere else I should post the issue and patch?

The root issue seems to be that the inner join on {alias}.id=null quickly becomes a very large result set if most activities do not have assigned targets or assignees.  A small database with only a few thousand activities was enough to cause mysql to hang.

kung:
Hi, JakeMW.  I have exactly the same problem and I have also tracked it to the Activity Report.  However, I don't match your other criteria regarding ACLs and contacts, so I suspect it's some other issue in the report.  If/when I find it I'll post my results here.

Navigation

[0] Message Index

[*] Previous page