Eclipse Community Forums: BIRT » xls export failing for large data Birt 2.6.2

Help

Home

Home » Archived » BIRT » xls export failing for large data Birt 2.6.2

Show: Today's Messages :: Show Polls :: Message Navigator

xls export failing for large data Birt 2.6.2 [message #1354882]

Wed, 14 May 2014 13:19

Eclipse User

Messages: 10
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

Report message to a moderator

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

Eclipse User

Messages: 10
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.

Report message to a moderator

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

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 23 12:01:42 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter