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

Bug 313065

Summary: [Automation][Regression]Crosstab in library does not work
Product: z_Archived Reporter: Wen Lin <wlin>
Component: BIRTAssignee: Rick Lu <rlu>
Status: CLOSED FIXED QA Contact:
Severity: normal    
Priority: P3 CC: mwu, rlu, yjiang
Version: 2.6.0   
Target Milestone: 2.6.0 RC2   
Hardware: PC   
OS: Windows XP   
Whiteboard:
Attachments:
Description Flags
report design
none
library none

Description Wen Lin CLA 2010-05-17 01:28:43 EDT 
Created attachment 168677 [details]
report design

Description:
  Exception was thrown out while previewing a report using a cube in a library.

Test Build:
BIRT2.6.0 v20100517-0630

Step to reproduce:

1. Use the report attahced
2. Preview it in web viewer

Error log:
Caused by: org.eclipse.birt.report.item.crosstab.core.CrosstabException: Crosstab row area contains null dimension definition or the specific dimension "cube.Group1" does not exist in associated cube.
   at org.eclipse.birt.report.item.crosstab.core.re.CrosstabQueryUtil.addEdgeDefinition(CrosstabQueryUtil.java:304)
   at org.eclipse.birt.report.item.crosstab.core.re.CrosstabQueryUtil.createCubeQuery(CrosstabQueryUtil.java:162)
   at org.eclipse.birt.report.item.crosstab.core.re.CrosstabReportItemQuery.createReportQueries(CrosstabReportItemQuery.java:82)
   at org.eclipse.birt.report.engine.data.dte.ReportQueryBuilder$QueryBuilderVisitor.visitExtendedItem(ReportQueryBuilder.java:689)
... 65 more
Comment 1 Wen Lin CLA 2010-05-17 01:29:23 EDT 
Created attachment 168678 [details]
library
Comment 2 Mingxia Wu CLA 2010-05-17 06:04:14 EDT 
EVERE: Crosstab row area contains null dimension definition or the specific dimension "cube.Group1" does not exist in associated cube. org.eclipse.birt.report.item.crosstab.core.CrosstabException: Crosstab row area contains null dimension definition or the specific dimension "cube.Group1" does not exist in associated cube. org.eclipse.birt.report.engine.api.EngineException: Crosstab row area contains null dimension definition or the specific dimension "cube.Group1" does not exist in associated cube.
	at org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1215)
	at org.eclipse.birt.report.engine.data.dte.ReportQueryBuilder$QueryBuilderVisitor.visitExtendedItem(ReportQueryBuilder.java:693)
	at org.eclipse.birt.report.engine.ir.ExtendedItemDesign.accept(ExtendedItemDesign.java:45)
	at org.eclipse.birt.report.engine.data.dte.ReportQueryBuilder.build(ReportQueryBuilder.java:256)
	at org.eclipse.birt.report.engine.data.dte.ReportQueryBuilder.build(ReportQueryBuilder.java:237)
	at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.prepare(AbstractDataEngine.java:178)
	at org.eclipse.birt.report.engine.executor.ReportExecutor.execute(ReportExecutor.java:123)
	at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportExecutor.execute(WrappedReportExecutor.java:60)
	at org.eclipse.birt.report.engine.internal.executor.emitter.ReportEmitterExecutor.execute(ReportEmitterExecutor.java:77)
	at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportExecutor.execute(WrappedReportExecutor.java:60)
	at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplciateReportExecutor.execute(SuppressDuplciateReportExecutor.java:42)
	at org.eclipse.birt.report.engine.presentation.ReportDocumentBuilder.build(ReportDocumentBuilder.java:234)
	at org.eclipse.birt.report.engine.api.impl.RunTask.doRun(RunTask.java:252)
	at org.eclipse.birt.report.engine.api.impl.RunTask.run(RunTask.java:111)
	at com.actuate.reportapi.engine.birt.ReportGenerationTask.runTask(Unknown Source)
	at com.actuate.reportapi.engine.birt.ReportGenerationTask.generateReport(Unknown Source)
	at com.actuate.reportapi.engine.ReportGenerationTaskBase.doTask(Unknown Source)
	at com.actuate.reportapi.engine.Task.execute(Unknown Source)
	at com.actuate.reportapi.enginemanager.ThreadPool$ControlRunnable.run(Unknown Source)
	at java.lang.Thread.run(Unknown Source)
Caused by: org.eclipse.birt.report.item.crosstab.core.CrosstabException: Crosstab row area contains null dimension definition or the specific dimension "cube.Group1" does not exist in associated cube.
	at org.eclipse.birt.report.item.crosstab.core.re.CrosstabQueryUtil.addEdgeDefinition(CrosstabQueryUtil.java:304)
	at org.eclipse.birt.report.item.crosstab.core.re.CrosstabQueryUtil.createCubeQuery(CrosstabQueryUtil.java:162)
	at org.eclipse.birt.report.item.crosstab.core.re.CrosstabReportItemQuery.createReportQueries(CrosstabReportItemQuery.java:82)
	at org.eclipse.birt.report.engine.data.dte.ReportQueryBuilder$QueryBuilderVisitor.visitExtendedItem(ReportQueryBuilder.java:689)
	... 18 more
Comment 3 Rick Lu CLA 2010-05-18 21:58:36 EDT 
Fixed in HEAD and 2.5.x.
Comment 4 Wen Lin CLA 2010-05-20 03:15:52 EDT 
Verified in v20100520-0630