Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » xls export failing for large data Birt 2.6.2
xls export failing for large data Birt 2.6.2 [message #1354882] Wed, 14 May 2014 13:19 Go to next message
Hiren Parghi is currently offline Hiren Parghi
Messages: 3
Registered: May 2014
Junior Member
We are using Birt 2.6.2 to generate the excel reports.

We have two report design files(for two report types).


For one report design file, excel generation working fine for large data. It automatically adds new sheet in the excel. Its working properly.
For this we are using static design file.

For another report design file, excel generation fails with following exception for large data(more than 67000 rows). This design file is generated dynamic.
If the no. of rows are less than 65,000 then its working properly.

Caused by: java.lang.NegativeArraySizeException
at org.eclipse.birt.report.engine.emitter.excel.layout.Page.synchronize(Page.java:744)
at org.eclipse.birt.report.engine.emitter.excel.layout.ExcelLayoutEngine.endRow(ExcelLayoutEngine.java:492)
at org.eclipse.birt.report.engine.emitter.excel.ExcelEmitter.endRow(ExcelEmitter.java:125)


What could be the reason for above exception?
Is there anything wrong in design file or something wrong in my code?

Thanks
Re: xls export failing for large data Birt 2.6.2 [message #1356672 is a reply to message #1354882] Thu, 15 May 2014 07:04 Go to previous messageGo to next message
Hiren Parghi is currently offline Hiren Parghi
Messages: 3
Registered: May 2014
Junior Member
Actually i found following thing. My report has following property:

<property name="layoutPreference">auto layout</property>

If i remove the auto layout then excel creates new sheet once first sheet reach to 65535 rows. But it shows only 8 columns even though i have 20 columns in the report.

If i keep the auto layout then excel is not generated properly.It throws NegativeArraySizeException.


Re: xls export failing for large data Birt 2.6.2 [message #1371795 is a reply to message #1356672] Wed, 21 May 2014 14:45 Go to previous message
Kristopher Clark is currently offline Kristopher Clark
Messages: 130
Registered: January 2013
Senior Member
Hiren Parghi wrote:
> Actually i found following thing. My report has following property:
>
> <property name="layoutPreference">auto layout</property>
>
> If i remove the auto layout then excel creates new sheet once first
> sheet reach to 65535 rows. But it shows only 8 columns even though i
> have 20 columns in the report.
>
> If i keep the auto layout then excel is not generated properly.It throws
> NegativeArraySizeException.
>
>
>

On auto layout, have you set the page break interval on your table? You
might try setting that to something like 100 and seeing if you can force
it to work that way, otherwise are you able to use the spudsoft xls emitter?

-Kris
Previous Topic:Table of one month, sum data from timestamps ofone day
Next Topic:Using new Docx Emitter programmatically
Goto Forum:
  


Current Time: Sat Oct 25 23:36:43 GMT 2014

Powered by FUDForum. Page generated in 0.02322 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software