Thanks Jason – Yes, it is the “Aw, snap!” message in Chrome.
There are no browser console messages when this happens.
As far as the size of the pivot table, the “all elements” option for the data has many, many data elements. There are six data element groups, and when I break it down group by group, there is only one group that fails, with 73 data elements. When this happens, I’m selecting data at the “District” level, and there are many districts.
Yesterday, I started breaking down the 73 elements into smaller groups, selecting 10 at a time. When I did this, the table rendered, but with no data, in all cases. But no “Aw Snap” message.
The downloaded CSV file, however, has data. The file is 212 MB, and takes an exceedingly long time to process, even though I don’t think of his as a huge file.
This normally is a result of loading a pivot with “too much” data. What too much is is not entirely clear and can depend on a number of factors. Do you get an “Aww snap!” message in the browser? Are you trying to load a “big” pivot with lots of data?
If possible, I would suggest to load smaller subsets of data or use the “Download CSV” function if you are experiencing this issue.
Also, any browser console and/or server messages when executing the pivot would be helpful to diagnose the problem.
On Tue, Jun 20, 2017 at 4:46 PM, Chris van Hasselt CVanHasselt@fhi360.org wrote:
We are experiencing a problem running pivot tables on version 2.26 of DHIS 2. When the data is requested via the API, the data is returned very quickly. However when we launch a pivot table, specifically with the all the data elements, the pivot table hangs.
Has anyone seen this type of thing before? Any suggestions on what to look for?
Thanks in advance,
Chris van Hasselt
| IT Project Manager
359 Blackwell Street, Suite 200 | Durham, NC 27701
O: 919.544.7040 x11271 | email@example.com |
Visit us at www.fhi360.org
Mailing list: https://launchpad.net/~dhis2-users
Post to : firstname.lastname@example.org
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp
Jason P. Pickering