Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.
Bug 345057 - Report gives an error running in birt-viewer
Summary: Report gives an error running in birt-viewer
Status: RESOLVED FIXED
Alias: None
Product: z_Archived
Classification: Eclipse Foundation
Component: BIRT (show other bugs)
Version: 2.6.2   Edit
Hardware: PC Linux
: P3 major (vote)
Target Milestone: ---   Edit
Assignee: Birt-Data-inbox@eclipse.org CLA
QA Contact: Liwen Chen CLA
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-05-07 14:48 EDT by Sergei Rahouski CLA
Modified: 2012-06-28 05:07 EDT (History)
4 users (show)

See Also:


Attachments
Broken report file in 2.6.2 (48.48 KB, application/octet-stream)
2011-05-07 14:49 EDT, Sergei Rahouski CLA
no flags Details
Report results (451.46 KB, text/html)
2011-05-10 11:33 EDT, Sergei Rahouski CLA
no flags Details
csv data source, library and report (14.47 KB, application/zip)
2011-08-25 01:53 EDT, Liwen Chen CLA
no flags Details

Note You need to log in before you can comment on or make changes to this bug.
Description Sergei Rahouski CLA 2011-05-07 14:48:53 EDT
Build Identifier: 2.6.2

Table (id = 325):
- Can not load the report query: 325. Errors occurred when generating the report document for the report element with ID 325.
Error.ReportQueryLoadingError2 ( 1 time(s) )
detail : org.eclipse.birt.report.engine.api.EngineException: Can not load the report query: 325. Errors occurred when generating the report document for the report element with ID 325.
	at org.eclipse.birt.report.engine.data.dte.DataPresentationEngine.doExecuteQuery(DataPresentationEngine.java:164)
	at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:265)
	at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1890)
	at org.eclipse.birt.report.engine.internal.document.v4.ReportItemExecutor.executeQuery(ReportItemExecutor.java:412)
	at org.eclipse.birt.report.engine.internal.document.v4.TableItemExecutor.doExecute(TableItemExecutor.java:72)
	at org.eclipse.birt.report.engine.internal.document.v4.ReportItemExecutor.execute(ReportItemExecutor.java:294)
	at org.eclipse.birt.report.engine.internal.document.v4.ContainerExecutor.prepareChildExecutor(ContainerExecutor.java:226)
	at org.eclipse.birt.report.engine.internal.document.v4.ContainerExecutor.hasNextChild(ContainerExecutor.java:110)
	at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.hasNextChild(WrappedReportItemExecutor.java:86)
	at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.hasNextChild(WrappedReportItemExecutor.java:86)
	at org.eclipse.birt.report.engine.api.impl.RenderTask$ReportExecutorWrapper.hasNextChild(RenderTask.java:780)
	at org.eclipse.birt.report.engine.layout.html.HTMLPageLM$1.hasNextChild(HTMLPageLM.java:68)
	at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:62)

Reproducible: Always

Steps to Reproduce:
1. Deploy  attached report in the birt-viewer
2. Open the report in browser
3. See the error
Comment 1 Sergei Rahouski CLA 2011-05-07 14:49:47 EDT
Created attachment 195012 [details]
Broken report file in 2.6.2

The report works fine in Eclipse BIRT Designer.
Comment 2 Xiaoying Gu CLA 2011-05-09 02:43:34 EDT
I can not build your data source in my environment.

Could you please generate report document in designer and attached here for me to investigate?
Comment 3 Sergei Rahouski CLA 2011-05-09 10:30:40 EDT
Would you like to see HTML version of the report generated in designer?
Comment 4 Xiaoying Gu CLA 2011-05-10 03:48:07 EDT
(In reply to comment #3)
> Would you like to see HTML version of the report generated in designer?

Yes, you can attach the html report first. I will see if I can build the data source locally to reproduce this issue.
Comment 5 Sergei Rahouski CLA 2011-05-10 11:33:45 EDT
Created attachment 195232 [details]
Report results

Attached the HTML report output.
Comment 6 batkamanoka CLA 2011-05-10 16:49:28 EDT
This might help:
Ran into the same problem, then tried to downgrade to 2.5.2, after downgrade I've got an invalid username/password. After I fixed the connection, 2.5.2 was working. Later just out of curiousity tried 2.6.2 again, and it worked. I don't want to rush to conclusions but it seems that the error handling is the issue - never the less is a bug...
Comment 7 Sergei Rahouski CLA 2011-05-10 17:29:22 EDT
We might be using library file generated prior 2.6.2 . Would that cause the issue? ... It works for 7 other reports tho.
Comment 8 Sergei Rahouski CLA 2011-06-17 17:40:35 EDT
The error only happens in /frameset mode if I hit /run or /preview actions in ViewServlet the report generates properly.
Comment 9 Liwen Chen CLA 2011-08-24 22:39:57 EDT
Hi Sergei,

Can you attach the library file?
We can check whether the library file has compatibility issue or some other issue.

Thanks.
Comment 10 Liwen Chen CLA 2011-08-25 01:53:27 EDT
I extract your data out and use it to create library and reportdesign, put them under birt deployed in tomcat.
The report can work.

I will attach them here.
Comment 11 Liwen Chen CLA 2011-08-25 01:53:51 EDT
Created attachment 202120 [details]
csv data source, library and report
Comment 12 Xiaoying Gu CLA 2011-08-28 22:59:17 EDT
set Fixed.
Please reopen it when the issue still exists