dhis2-devs team mailing list archive

[Jason Pickering <jason.p.pickering@xxxxxxxxx>]

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