Skip to main content


Eclipse Community Forums

      Home
Home » Archived » BIRT » ReportDocument generation problem w/2.1RC4
ReportDocument generation problem w/2.1RC4 [message #168940] Fri, 09 June 2006 19:54 Go to next message
Eclipse UserFriend
Originally posted by: smacrt.sbcglobal.net

I seem to be running into a problem with generation of report documents
from a report design.

Here's my code snippet:

EngineConfig config = new EngineConfig();
config.setEngineHome("C:\\Program
Files\\birt-runtime-2_1_0\\ReportEngine");
ReportEngine engine = new ReportEngine(config);
String reportPath = "C:\\Program
Files\\birt-rcp-report-designer-2_1_0\\workspace\\myreport.r ptdesign ";
IReportRunnable design = engine.openReportDesign(reportPath);
IRunTask task = engine.createRunTask(design);
task.setPageHandler(new GenerationListener());
task.run("c:\\temp\\rptdoc");
engine.destroy();

I get the following exceptions:

Jun 9, 2006 3:29:44 PM org.eclipse.birt.report.engine.api.impl.RunTask
doRun
SEVERE: An error happened while running the report. Cause:
java.lang.NegativeArraySizeException
at
org.eclipse.birt.data.engine.executor.cache.ResultObjectUtil .readData(ResultObjectUtil.java:135)
at
org.eclipse.birt.data.engine.executor.cache.DataFileReader.r ead(DataFileReader.java:100)
at
org.eclipse.birt.data.engine.executor.cache.DiskBasedResultS et.nextRow(DiskBasedResultSet.java:102)
at
org.eclipse.birt.data.engine.executor.cache.DiskCache.next(D iskCache.java:139)
at
org.eclipse.birt.data.engine.executor.cache.SmartCache.next( SmartCache.java:378)
at
org.eclipse.birt.data.engine.executor.transform.CachedResult Set.next(CachedResultSet.java:270)
at
org.eclipse.birt.data.engine.impl.ResultIterator.next(Result Iterator.java:188)
at
org.eclipse.birt.report.engine.data.dte.DteResultSet.next(Dt eResultSet.java:200)
at
org.eclipse.birt.report.engine.executor.ListingElementExecut or.accessQuery(ListingElementExecutor.java:150)
at
org.eclipse.birt.report.engine.executor.TableItemExecutor.ex ecute(TableItemExecutor.java:159)
at
org.eclipse.birt.report.engine.executor.ReportExecutorVisito r.visitTableItem(ReportExecutorVisitor.java:205)
at
org.eclipse.birt.report.engine.ir.TableItemDesign.accept(Tab leItemDesign.java:69)
at
org.eclipse.birt.report.engine.executor.ReportExecutor.execu te(ReportExecutor.java:129)
at
org.eclipse.birt.report.engine.executor.ReportExecutor.execu te(ReportExecutor.java:89)
at org.eclipse.birt.report.engine.api.impl.RunTask.doRun(RunTas k.java:202)
at org.eclipse.birt.report.engine.api.impl.RunTask.run(RunTask. java:111)
at org.eclipse.birt.report.engine.api.impl.RunTask.run(RunTask. java:96)
at
com.coremetrics.birt.ReportDocGenerator.generateReport(Repor tDocGenerator.java:43)
at
com.coremetrics.birt.ReportDocGenerator.main(ReportDocGenera tor.java:21)
Exception in thread "main"
org.eclipse.birt.report.engine.api.EngineException: Error happended while
running the report
at org.eclipse.birt.report.engine.api.impl.RunTask.doRun(RunTas k.java:212)
at org.eclipse.birt.report.engine.api.impl.RunTask.run(RunTask. java:111)
at org.eclipse.birt.report.engine.api.impl.RunTask.run(RunTask. java:96)
at
com.coremetrics.birt.ReportDocGenerator.generateReport(Repor tDocGenerator.java:43)
at
com.coremetrics.birt.ReportDocGenerator.main(ReportDocGenera tor.java:21)
Caused by: java.lang.NegativeArraySizeException
at
org.eclipse.birt.data.engine.executor.cache.ResultObjectUtil .readData(ResultObjectUtil.java:135)
at
org.eclipse.birt.data.engine.executor.cache.DataFileReader.r ead(DataFileReader.java:100)
at
org.eclipse.birt.data.engine.executor.cache.DiskBasedResultS et.nextRow(DiskBasedResultSet.java:102)
at
org.eclipse.birt.data.engine.executor.cache.DiskCache.next(D iskCache.java:139)
at
org.eclipse.birt.data.engine.executor.cache.SmartCache.next( SmartCache.java:378)
at
org.eclipse.birt.data.engine.executor.transform.CachedResult Set.next(CachedResultSet.java:270)
at
org.eclipse.birt.data.engine.impl.ResultIterator.next(Result Iterator.java:188)
at
org.eclipse.birt.report.engine.data.dte.DteResultSet.next(Dt eResultSet.java:200)
at
org.eclipse.birt.report.engine.executor.ListingElementExecut or.accessQuery(ListingElementExecutor.java:150)
at
org.eclipse.birt.report.engine.executor.TableItemExecutor.ex ecute(TableItemExecutor.java:159)
at
org.eclipse.birt.report.engine.executor.ReportExecutorVisito r.visitTableItem(ReportExecutorVisitor.java:205)
at
org.eclipse.birt.report.engine.ir.TableItemDesign.accept(Tab leItemDesign.java:69)
at
org.eclipse.birt.report.engine.executor.ReportExecutor.execu te(ReportExecutor.java:129)
at
org.eclipse.birt.report.engine.executor.ReportExecutor.execu te(ReportExecutor.java:89)
at org.eclipse.birt.report.engine.api.impl.RunTask.doRun(RunTas k.java:202)
... 4 more

Any idea what might be wrong here?
I have been trying to get this working for several days now and it is
quite frustrating. Please help.

Thanks.

-- Shanon
Re: ReportDocument generation problem w/2.1RC4 [message #169245 is a reply to message #168940] Mon, 12 June 2006 11:57 Go to previous messageGo to next message
Eclipse UserFriend
What is the data source for your report?
Can you try a report using the sample db and call it from your code?

Jason

"Shanon McArthur" <smacrt@sbcglobal.net> wrote in message
news:af12a8e469d5d821b6fe61d92af4ca23$1@www.eclipse.org...
>
> I seem to be running into a problem with generation of report documents
> from a report design.
>
> Here's my code snippet:
>
> EngineConfig config = new EngineConfig();
> config.setEngineHome("C:\\Program
> Files\\birt-runtime-2_1_0\\ReportEngine"); ReportEngine engine = new
> ReportEngine(config);
> String reportPath = "C:\\Program
> Files\\birt-rcp-report-designer-2_1_0\\workspace\\myreport.r ptdesign ";
> IReportRunnable design = engine.openReportDesign(reportPath); IRunTask
> task = engine.createRunTask(design);
> task.setPageHandler(new GenerationListener());
> task.run("c:\\temp\\rptdoc");
> engine.destroy();
>
> I get the following exceptions:
>
> Jun 9, 2006 3:29:44 PM org.eclipse.birt.report.engine.api.impl.RunTask
> doRun
> SEVERE: An error happened while running the report. Cause:
> java.lang.NegativeArraySizeException
> at
> org.eclipse.birt.data.engine.executor.cache.ResultObjectUtil .readData(ResultObjectUtil.java:135)
> at
> org.eclipse.birt.data.engine.executor.cache.DataFileReader.r ead(DataFileReader.java:100)
> at
> org.eclipse.birt.data.engine.executor.cache.DiskBasedResultS et.nextRow(DiskBasedResultSet.java:102)
> at
> org.eclipse.birt.data.engine.executor.cache.DiskCache.next(D iskCache.java:139)
> at
> org.eclipse.birt.data.engine.executor.cache.SmartCache.next( SmartCache.java:378)
> at
> org.eclipse.birt.data.engine.executor.transform.CachedResult Set.next(CachedResultSet.java:270)
> at
> org.eclipse.birt.data.engine.impl.ResultIterator.next(Result Iterator.java:188)
> at
> org.eclipse.birt.report.engine.data.dte.DteResultSet.next(Dt eResultSet.java:200)
> at
> org.eclipse.birt.report.engine.executor.ListingElementExecut or.accessQuery(ListingElementExecutor.java:150)
> at
> org.eclipse.birt.report.engine.executor.TableItemExecutor.ex ecute(TableItemExecutor.java:159)
> at
> org.eclipse.birt.report.engine.executor.ReportExecutorVisito r.visitTableItem(ReportExecutorVisitor.java:205)
> at
> org.eclipse.birt.report.engine.ir.TableItemDesign.accept(Tab leItemDesign.java:69)
> at
> org.eclipse.birt.report.engine.executor.ReportExecutor.execu te(ReportExecutor.java:129)
> at
> org.eclipse.birt.report.engine.executor.ReportExecutor.execu te(ReportExecutor.java:89)
> at org.eclipse.birt.report.engine.api.impl.RunTask.doRun(RunTas k.java:202)
> at org.eclipse.birt.report.engine.api.impl.RunTask.run(RunTask. java:111)
> at org.eclipse.birt.report.engine.api.impl.RunTask.run(RunTask. java:96)
> at
> com.coremetrics.birt.ReportDocGenerator.generateReport(Repor tDocGenerator.java:43)
> at
> com.coremetrics.birt.ReportDocGenerator.main(ReportDocGenera tor.java:21)
> Exception in thread "main"
> org.eclipse.birt.report.engine.api.EngineException: Error happended while
> running the report
> at org.eclipse.birt.report.engine.api.impl.RunTask.doRun(RunTas k.java:212)
> at org.eclipse.birt.report.engine.api.impl.RunTask.run(RunTask. java:111)
> at org.eclipse.birt.report.engine.api.impl.RunTask.run(RunTask. java:96)
> at
> com.coremetrics.birt.ReportDocGenerator.generateReport(Repor tDocGenerator.java:43)
> at
> com.coremetrics.birt.ReportDocGenerator.main(ReportDocGenera tor.java:21)
> Caused by: java.lang.NegativeArraySizeException
> at
> org.eclipse.birt.data.engine.executor.cache.ResultObjectUtil .readData(ResultObjectUtil.java:135)
> at
> org.eclipse.birt.data.engine.executor.cache.DataFileReader.r ead(DataFileReader.java:100)
> at
> org.eclipse.birt.data.engine.executor.cache.DiskBasedResultS et.nextRow(DiskBasedResultSet.java:102)
> at
> org.eclipse.birt.data.engine.executor.cache.DiskCache.next(D iskCache.java:139)
> at
> org.eclipse.birt.data.engine.executor.cache.SmartCache.next( SmartCache.java:378)
> at
> org.eclipse.birt.data.engine.executor.transform.CachedResult Set.next(CachedResultSet.java:270)
> at
> org.eclipse.birt.data.engine.impl.ResultIterator.next(Result Iterator.java:188)
> at
> org.eclipse.birt.report.engine.data.dte.DteResultSet.next(Dt eResultSet.java:200)
> at
> org.eclipse.birt.report.engine.executor.ListingElementExecut or.accessQuery(ListingElementExecutor.java:150)
> at
> org.eclipse.birt.report.engine.executor.TableItemExecutor.ex ecute(TableItemExecutor.java:159)
> at
> org.eclipse.birt.report.engine.executor.ReportExecutorVisito r.visitTableItem(ReportExecutorVisitor.java:205)
> at
> org.eclipse.birt.report.engine.ir.TableItemDesign.accept(Tab leItemDesign.java:69)
> at
> org.eclipse.birt.report.engine.executor.ReportExecutor.execu te(ReportExecutor.java:129)
> at
> org.eclipse.birt.report.engine.executor.ReportExecutor.execu te(ReportExecutor.java:89)
> at org.eclipse.birt.report.engine.api.impl.RunTask.doRun(RunTas k.java:202)
> ... 4 more
>
> Any idea what might be wrong here?
> I have been trying to get this working for several days now and it is
> quite frustrating. Please help.
>
> Thanks.
>
> -- Shanon
>
Re: ReportDocument generation problem w/2.1RC4 [message #169752 is a reply to message #169245] Tue, 13 June 2006 12:27 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: smacrt.sbcglobal.net

I used a query against a single ORACLE table using the format:

select * from SCHEMA_NAME.TABLE_NAME

Two TEXT columns from the resultset of this query were bound to my table.

Questions:

1. How do I get to the sample database provided in the distribution?

2. What database is this? Any pointers will be helpful.

3. In any case, if I use ORACLE, where do I specify my JDBC drivers?
Irrespective of whether my (standalone app) project classpath included the
JDBC driver or not, I still receive the same exception.
Re: ReportDocument generation problem w/2.1RC4 [message #169776 is a reply to message #169752] Tue, 13 June 2006 13:01 Go to previous messageGo to next message
Eclipse UserFriend
1&2 - The sample database is already in plugin format and its a derby
database.
If you are using the designer it should be the first option in the list.

3 - Did you copy your jdbc driver to
birt-runtime-2_1_0\ReportEngine\plugins\org.eclipse.birt.rep ort.data.oda.jdbc_2.1.0.N20060531-1258\drivers

In the designer there is a manage drivers button that will copy the driver
to the correct location for the designer.
If you are using the api you will need to copy this driver to the above
location.

Jason

"Shanon McArthur" <smacrt@sbcglobal.net> wrote in message
news:141d252152d321235fe3716d5bfa530f$1@www.eclipse.org...
>I used a query against a single ORACLE table using the format:
>
> select * from SCHEMA_NAME.TABLE_NAME
>
> Two TEXT columns from the resultset of this query were bound to my table.
>
> Questions:
>
> 1. How do I get to the sample database provided in the distribution?
>
> 2. What database is this? Any pointers will be helpful.
>
> 3. In any case, if I use ORACLE, where do I specify my JDBC drivers?
> Irrespective of whether my (standalone app) project classpath included the
> JDBC driver or not, I still receive the same exception.
>
Re: ReportDocument generation problem w/2.1RC4 [message #169798 is a reply to message #169776] Tue, 13 June 2006 13:38 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: smacrt.sbcglobal.net

The distribution already contains the ORACLE THIN ojdbc14.jar driver so
that wasn't a problem.
Has anybody got a tabular listing report working (i.e. rptdesign =>
rptdocument via API) using a resultset obtained from ORACLE?

In the meantime, I will experiment with the sample derby DB.

-- Shanon
Re: ReportDocument generation problem w/2.1RC4 [message #169882 is a reply to message #169776] Tue, 13 June 2006 17:42 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: smacrt.sbcglobal.net

My ORACLE query resultset contained 26,612 rows of data.
Appears as though the memory cache count holds 20,000 rows of data.
If the resultset contains > 20,000 rows of data, seems like rptdocument
generation fails with the exception I listed earlier.

Initially, the possible causes of error were:
1. Using ORACLE instead of DERBY
2. Using a large resultset i.e. > 20000 rows

I trimmed my query in ORACLE to generate < 20000 rows of data and it
worked great.

Seems like the problem exists for a large dataset > 20000 rows of data.
Has anybody tested generation of a large report?
Has this been fixed in a more recent nightly release?

Please let me know as this is a showstopper for us.

Thanks.

-- Shanon
Re: ReportDocument generation problem w/2.1RC4 [message #169990 is a reply to message #169882] Tue, 13 June 2006 20:32 Go to previous messageGo to next message
Eclipse UserFriend
Can you log this into bugzilla?

Jason

"Shanon McArthur" <smacrt@sbcglobal.net> wrote in message
news:d9b8a57ec66a2659c53b66a75de6425d$1@www.eclipse.org...
> My ORACLE query resultset contained 26,612 rows of data.
> Appears as though the memory cache count holds 20,000 rows of data.
> If the resultset contains > 20,000 rows of data, seems like rptdocument
> generation fails with the exception I listed earlier.
>
> Initially, the possible causes of error were:
> 1. Using ORACLE instead of DERBY
> 2. Using a large resultset i.e. > 20000 rows
>
> I trimmed my query in ORACLE to generate < 20000 rows of data and it
> worked great.
>
> Seems like the problem exists for a large dataset > 20000 rows of data.
> Has anybody tested generation of a large report?
> Has this been fixed in a more recent nightly release?
>
> Please let me know as this is a showstopper for us.
>
> Thanks.
>
> -- Shanon
>
Re: ReportDocument generation problem w/2.1RC4 [message #170020 is a reply to message #169990] Wed, 14 June 2006 02:01 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: smacrt.whocares.net

> Has anybody tested generation of a large report?
> Has this been fixed in a more recent nightly release?

In addition, I see sluggish performance with execution of large queries.
Are there any suggestions on how I can get rptdesign => rptdocument
generation to run faster for a simple listing report with a 400,000 row
resultset containing one computed column in addition to four other columns
(text, double, integer, text)?

Interestingly, when attempting to preview the results via the data set
editor, I see the results really fast. However, when previewing the report
in the viewer, generation takes a much longer time.

Please let me know; thanks.

-- Shanon
Re: ReportDocument generation problem w/2.1RC4 [message #170027 is a reply to message #169990] Wed, 14 June 2006 02:16 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: smacrt.whocares.com

Bug #147003 was filed.

Thanks.

-- Shanon
Re: ReportDocument generation problem w/2.1RC4 [message #170312 is a reply to message #170027] Wed, 14 June 2006 13:23 Go to previous messageGo to next message
Eclipse UserFriend
Thanks very much.
I see that this is fixed now.
Can you log one for performance?
Make sure you have stand alone query times and report times if possible.

Jason

"Shanon McArthur" <smacrt@whocares.com> wrote in message
news:540e4c3f7e4863fdf199cd0b814b28b4$1@www.eclipse.org...
> Bug #147003 was filed.
>
> Thanks.
>
> -- Shanon
>
Re: ReportDocument generation problem w/2.1RC4 [message #170364 is a reply to message #170312] Wed, 14 June 2006 14:47 Go to previous message
Eclipse UserFriend
Originally posted by: smacrt.sbcglobal.net

Bug #147101 was submitted to track performance sluggishness.

-- Shanon
Previous Topic:WebViewer 2.1RC4 to Tomcat displaying PDF
Next Topic:No Landscape orientation for HMTL print 2.1RC4
Goto Forum:
  


Current Time: Fri Aug 29 00:07:07 EDT 2025

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

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

Back to the top

Sign up to our Newsletter

A fresh new issue delivered monthly