← Back to team overview

dhis2-devs team mailing list archive

Re: [Dhis2-users] Problem loading pivot table results

 

As long as you are selecting orgunits by level, and not explicitly, that
should not be a problem.

On 5 April 2017 at 09:08, Jason Pickering <jason.p.pickering@xxxxxxxxx>
wrote:

> You maybe getting a "HTTP Error 414 Request URI too long" error in the
> browser. This happens when the URL generated by the client is too big to be
> handled by the HTTP server. Check the JS console in the browser and see.
>
> Jan's method may work, but it will not work if you are getting that error.
>
> Regards,
> Jason
>
>
>
> On Wed, Apr 5, 2017 at 9:06 AM, Jan Henrik Øverland <jan@xxxxxxxxx> wrote:
>
>> Hi Tantely,
>>
>> You can dump larger chunks of data by doing the following:
>>
>> - Open the pivot tables app
>> - Select what you need in the left menu
>> - Do not click "update" -  instead click the small down-arrow next to the
>> update button and download as CSV
>>
>> Jan
>>
>> On 5 April 2017 at 08:32, Raminosoa Rabemanantsoa, Tantely <
>> traminosoa@xxxxxxxxxx> wrote:
>>
>>> Dear Calle,
>>>
>>> Thank you for your suggestions. In order to dump the results, I have to
>>> lower the number of OrgUnits by splitting them by parents OrgUnits and loop
>>> the process unitl all OrgUnits are done.
>>>
>>> Regards,
>>>
>>> Tantely.
>>>
>>>
>>> On Tue, Apr 4, 2017 at 11:00 AM, Calle Hedberg <calle.hedberg@xxxxxxxxx>
>>> wrote:
>>>
>>>> Hi
>>>>
>>>> This is a common problem - the pivot table app cannot process/display
>>>> larger sets of data, which is typically what you get when selecting the
>>>> lowest OU level.
>>>>
>>>> Try dumping the result out into another format (CSV, Excel), and then
>>>> process that into the report format you want.
>>>>
>>>> Regards
>>>> Calle
>>>>
>>>> On 3 April 2017 at 13:05, Raminosoa Rabemanantsoa, Tantely <
>>>> traminosoa@xxxxxxxxxx> wrote:
>>>>
>>>>> Dear DHIS2 community,
>>>>>
>>>>>
>>>>> We are using DHIS2 2.24. When we are running pivot table and are using
>>>>> some indicators by selecting the lowest level of OrgUnit (Community Health
>>>>> Workers), the application is running without any results output (an
>>>>> illustration is attached). The application is only responding when we are
>>>>> going up to a higher level in the OrgUnit tree. Are there some memories
>>>>> parameters to tune or what should be done to troubleshoot this issue, as we
>>>>> really need the results presented with the lowest OrgUnit. In the server
>>>>> side, we are using 16 cores CPU and 64 Gb of RAM.
>>>>>
>>>>>
>>>>> Thank you for your support,
>>>>>
>>>>>
>>>>> Regards,
>>>>>
>>>>>
>>>>> Tantely.
>>>>>
>>>>> *This message and its attachments are confidential and solely for the
>>>>> intended recipients. If received in error, please delete them and notify
>>>>> the sender via reply e-mail immediately.*
>>>>>
>>>>> _______________________________________________
>>>>> Mailing list: https://launchpad.net/~dhis2-devs
>>>>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>>>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>>>> More help   : https://help.launchpad.net/ListHelp
>>>>>
>>>>>
>>>>
>>>>
>>>> --
>>>>
>>>> *******************************************
>>>>
>>>> Calle Hedberg
>>>>
>>>> 46D Alma Road, 7700 Rosebank, SOUTH AFRICA
>>>>
>>>> Tel/fax (home): +27-21-685-6472 <+27%2021%20685%206472>
>>>>
>>>> Cell: +27-82-853-5352 <+27%2082%20853%205352>
>>>>
>>>> Iridium SatPhone: +8816-315-19119 <+881%206%20315%2019119>
>>>>
>>>> Email: calle.hedberg@xxxxxxxxx
>>>>
>>>> Skype: calle_hedberg
>>>>
>>>> *******************************************
>>>>
>>>>
>>>
>>>
>>>
>>>
>>> *This message and its attachments are confidential and solely for the
>>> intended recipients. If received in error, please delete them and notify
>>> the sender via reply e-mail immediately.*
>>>
>>> _______________________________________________
>>> Mailing list: https://launchpad.net/~dhis2-users
>>> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>>
>> --
>> Jan Henrik Øverland
>> Software developer, DHIS 2
>> University of Oslo
>> http://www.dhis2.org <https://www.dhis2.org/>
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> Jason P. Pickering
> email: jason.p.pickering@xxxxxxxxx
> tel:+46764147049
>



-- 
Jan Henrik Øverland
Software developer, DHIS 2
University of Oslo
http://www.dhis2.org <https://www.dhis2.org/>

Follow ups

References