Dashboard hangs and never finishes loading

[miko]

The CiviCRM dashboard, since upgrade, now never loads dashlets and hangs.  See attached.  I've seen this problem posted elsewhere and the other people were advised to clear their caches.  But I've done this in all browsers.

There was some comment about the need to clear session caches during upgrade to 3.4.1 but I tried to follow all of the upgrade instructions- if something is wrong with the CiviCRM cache- how can that be fixed.  I tried clearing it again.

Basically nothing I've tried works.  If anyone can list other possible causes or solutions, I'd be grateful.

[Hershel]

You should clear the CiviCRM template cache--delete all files and directories in

sites/default/files/civicrm/templates_c

If that fails, then you will need to use Firebug for Firefox and look in the Net tab for any errors.

[miko]

Hi Hershel- thanks.  That didn't help.  I'm also not seeing any errors in NET.  The list is HUGE.  Are errors a different color?

[Hershel]

Unfound files should be in red. Perhaps compare the NET tab of your install to the demo : http://drupal.demo.civicrm.org/civicrm

Also, try using the Garland theme on your install, to make sure your theme is not the issue.

[miko]

Thanks.  It's not the theme because the same happens in Garland.  When looking at NET, nothing is red.   I'm so bummed.  I'm wondering- is it a problem to RE-UPGRADE to the same version of CiviCRM?  I'm considering trying that.

[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.