Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.
Bug 345058 - Report with a datacube works fine in designer, doesn't work in birt-viewer
Summary: Report with a datacube works fine in designer, doesn't work 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 Windows 7
: P3 major (vote)
Target Milestone: ---   Edit
Assignee: Birt-Chart-inbox@eclipse.org CLA
QA Contact: Liwen Chen CLA
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-05-07 14:52 EDT by Sergei Rahouski CLA
Modified: 2011-08-24 01:59 EDT (History)
2 users (show)

See Also:

Attachments
Report generating the error (50.68 KB, application/octet-stream)
2011-05-07 14:53 EDT, Sergei Rahouski CLA 		no flags Details
report simulating orders (48.73 KB, application/octet-stream)
2011-08-23 05:34 EDT, Liwen Chen CLA 		no flags Details
View All Add an attachment (proposed patch, testcase, etc.)

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:52:55 EDT 
Build Identifier: 2.6.2

Opening report gives the following error in tomcat6 logs.

Caused by: java.io.FileNotFoundException: /olap/cube_Data Cube
        at org.eclipse.birt.core.archive.compound.ArchiveFileV3.openEntry(ArchiveFileV3.java:101)
        at org.eclipse.birt.core.archive.compound.ArchiveFile.openEntry(ArchiveFile.java:393)
        at org.eclipse.birt.core.archive.compound.ArchiveReader.getStream(ArchiveReader.java:91)
        at org.eclipse.birt.data.engine.olap.data.document.RADocumentManager.openDocumentObject(RADocumentManager.java:74)
        at org.eclipse.birt.data.engine.olap.data.impl.Cube.load(Cube.java:156)
        at org.eclipse.birt.data.engine.olap.data.api.CubeQueryExecutorHelper.loadCube(CubeQueryExecutorHelper.java:165)
        at org.eclipse.birt.data.engine.olap.impl.query.CubeQueryResults.loadCube(CubeQueryResults.java:370)
        at org.eclipse.birt.data.engine.olap.impl.query.CubeQueryResults.createCursor(CubeQueryResults.java:288)

Reproducible: Always

Steps to Reproduce:
1. Deploy attached report 
2. Open in web browser
3. See empty error page and the error in tomcat6 logs
Comment 1 Sergei Rahouski CLA 2011-05-07 14:53:42 EDT 
Created attachment 195013 [details]
Report generating the error
Comment 2 Liwen Chen CLA 2011-08-23 05:33:08 EDT 
Hi Sergei,

Since I don't have your data, I created a report using my data with similar structure.It works both in designer preview and tomcat6 environment.I attached the report.

When run report with frameset servlet, birt will generate a temp document file to save structure and data.
The exception you attached often means that the cube generation failed during generate the temp document file.

Can you try with run or preview servlet? 
I mean using url like 
http://host:8080/birt/run?__report=orders.rptdesign
http://host:8080/birt/preview?__report=orders.rptdesign

Are you using a large amount of data? Could you try to design a report using birt sample DB to reproduce this issue?

Thanks.
Comment 3 Liwen Chen CLA 2011-08-23 05:34:39 EDT 
Created attachment 201980 [details]
report simulating orders
Comment 4 Sergei Rahouski CLA 2011-08-23 10:38:47 EDT 
I believe I've resolved the issue on my server by creating missing temporary directory.
Comment 5 Liwen Chen CLA 2011-08-24 01:58:29 EDT 
Thanks for the reply.

I will set the bug as Fixed.
Comment 6 Xiaoying Gu CLA 2011-08-24 01:59:12 EDT 
fixed.