Installation issues with 4.7.14

[petednz]

Hi - just tried to give this a run for its money. first issue was link not showing up in Menu, once I figured that was Access and there was a Permission involved, I now see the menu item and do not get access denied at civicrm/activity-report

But all I get is the page permanently loading. No drupal log errors or any such to help me give you a clue.

Fatal error: Maximum execution time of 300 seconds exceeded in /.../sites/all/modules/civicrm/Civi/API/SelectQuery.php on line 162

[petednz]

In case this is a conflict with other extensions, these are what are enabled

CiviCRM Report Error (ca.bidon.reporterror)
Civisualize. The missing data visualization extension (eu.tttp.civisualize)
Custom Field triggers for alted (nz.co.fuzion.altedtriggers)
Annual Year Level (nz.co.fuzion.annualyearlevel)
Entity Settings Helper Extension (nz.co.fuzion.entitysetting)
ExtendedReport (nz.co.fuzion.extendedreport)
Related Permissions Module (nz.co.fuzion.relatedpermissions)

[xurizaemon]

Nice work, this extension looks 🎸

On the site @petednz is testing, the extension page times out because the site in question has ~30K activities + custom fields, and the page tries to load all the activities into the page as a JSON array.

[petednz]

tried it on a more vanilla site. was able to get page to load at /civicrm/activity-report but all i see is Activity Pivot Table and have 19 errors showing in console eg
activity-report:492 GET http://rm11473.fudev.co.nz/sites//files/civicrm/ext/uk.co.compucorp.civicrm.activityreport/css/pivottable/c3.min.css?r=hdmQ0 activity-report:494 GET http://rm11473.fudev.co.nz/sites//files/civicrm/ext/uk.co.compucorp.civicrm.activityreport/css/style.css?r=hdmQ0 activity-report:493 GET http://rm11473.fudev.co.nz/sites//files/civicrm/ext/uk.co.compucorp.civicrm.activityreport/css/pivottable/pivot.css?r=hdmQ0 activity-report:398 GET http://rm11473.fudev.co.nz/sites//files/civicrm/ext/uk.co.compucorp.civicrm.activityreport/js/pivottable/jquery-migrate-1.4.1.min.js?r=hdmQ0 activity-report:400 GET http://rm11473.fudev.co.nz/sites//files/civicrm/ext/uk.co.compucorp.civicrm.activityreport/js/pivottable/jquery-ui-1.9.2.custom.min.js?r=hdmQ0 activity-report:402 GET http://rm11473.fudev.co.nz/sites//files/civicrm/ext/uk.co.compucorp.civicrm.activityreport/js/pivottable/pivot.min.js?r=hdmQ0

[jamienovick]

Hi Peter / xurizaemon, thanks for the feedback. We'd welcome patches if you can see solutions, otherwise well try and get some eyes on looking at how this can scale to a larger number of activities in the new year.

Best

[jamienovick]

@petednz @xurizaemon Can I ask you guys to test out the latest version of the extension? It has some caching for larger data sets now
Let me know your thoughts.
Best
Jamie

[petednz]

Sure. have assigned to kaylie for some testing.