dhis2-devs team mailing list archive

[Bob Jolliffe <bobjolliffe@xxxxxxxxx>]

OK I haven't really looked at Person aggregation, but I can see from
the log that its trying to return some kind of result as an xls file.
And it too big to fit :-)

On 17 September 2012 16:28, Olav Poppe <olav.poppe@xxxxxx> wrote:
> This wasn't actually when generating an xls-file, but inside DHIS2 (when running "Person aggregation"). It was a large dataset/many periods, but then I guess the results should be paginated or not displayed in as much detail.
>
>
> 17. sep. 2012 kl. 14:55 skrev Bob Jolliffe <bobjolliffe@xxxxxxxxx>:
>
>> Oops.  I guess you've exceeded the 65,536 rows hard limit of xls
>> files.  The only way to increase the number of rows is to use the
>> .xlsx format and I don't think jxl supports this.  POI?
>>
>> On the other hand, do you really want a spreadsheet that big?
>>
>> On 17 September 2012 13:15, Olav P <1051925@xxxxxxxxxxxxxxxxxx> wrote:
>>> Public bug reported:
>>>
>>> Trying to aggregate for a large number of org units and/or periods, DHIS2 show a blank page and the log shows:
>>> * ERROR 2012-09-17 12:07:11,071 Error while executing action (ExceptionInterceptor.java [TP-Processor2])
>>> jxl.write.biff.RowsExceededException: The maximum number of rows permitted on a worksheet been exceeded
>>>        at jxl.write.biff.WritableSheetImpl.getRowRecord(WritableSheetImpl.java:1214)
>>>        at jxl.write.biff.WritableSheetImpl.addCell(WritableSheetImpl.java:1151)
>>>        at org.hisp.dhis.system.grid.GridUtils.toXlsInternal(GridUtils.java:280)
>>>        at org.hisp.dhis.system.grid.GridUtils.toXls(GridUtils.java:228)
>>>        at org.hisp.dhis.result.GridXlsResult.execute(GridXlsResult.java:119)
>>>        at com.opensymphony.xwork2.DefaultActionInvocation.executeResult(DefaultActionInvocation.java:374)
>>> …..
>>>
>>> ** Affects: dhis2
>>>     Importance: Undecided
>>>         Status: New
>>>
>>> --
>>> You received this bug notification because you are a member of DHIS 2
>>> developers, which is subscribed to DHIS.
>>> https://bugs.launchpad.net/bugs/1051925
>>>
>>> Title:
>>>  Person aggregation: blank page when too many org units/period
>>>
>>> Status in DHIS 2 - District Health Information Software:
>>>  New
>>>
>>> Bug description:
>>>  Trying to aggregate for a large number of org units and/or periods, DHIS2 show a blank page and the log shows:
>>>  * ERROR 2012-09-17 12:07:11,071 Error while executing action (ExceptionInterceptor.java [TP-Processor2])
>>>  jxl.write.biff.RowsExceededException: The maximum number of rows permitted on a worksheet been exceeded
>>>        at jxl.write.biff.WritableSheetImpl.getRowRecord(WritableSheetImpl.java:1214)
>>>        at jxl.write.biff.WritableSheetImpl.addCell(WritableSheetImpl.java:1151)
>>>        at org.hisp.dhis.system.grid.GridUtils.toXlsInternal(GridUtils.java:280)
>>>        at org.hisp.dhis.system.grid.GridUtils.toXls(GridUtils.java:228)
>>>        at org.hisp.dhis.result.GridXlsResult.execute(GridXlsResult.java:119)
>>>        at com.opensymphony.xwork2.DefaultActionInvocation.executeResult(DefaultActionInvocation.java:374)
>>>  …..
>>>
>>> To manage notifications about this bug go to:
>>> https://bugs.launchpad.net/dhis2/+bug/1051925/+subscriptions
>>>
>>> _______________________________________________
>>> 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
>>
>> _______________________________________________
>> 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
>