Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

Bug 345057

Summary: Report gives an error running in birt-viewer
Product: z_Archived Reporter: Sergei Rahouski <rogovskiy>
Component: BIRTAssignee: Birt-Data-inbox <Birt-Data-inbox>
Status: RESOLVED FIXED QA Contact: Liwen Chen <lchen>
Severity: major    
Priority: P3 CC: batkamanoka, bluesoldier, java4raju, lchen
Version: 2.6.2   
Target Milestone: ---   
Hardware: PC   
OS: Linux   
See Also: https://bugs.eclipse.org/bugs/show_bug.cgi?id=297325
Whiteboard:
Attachments:
Description Flags
Broken report file in 2.6.2
none
Report results
none
csv data source, library and report none

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