Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.
Bug 211553 - CrosstabException when preview attached report.[01][1102]
Summary: CrosstabException when preview attached report.[01][1102]
Status: CLOSED FIXED
Alias: None
Product: z_Archived
Classification: Eclipse Foundation
Component: BIRT (show other bugs)
Version: 2.2.2   Edit
Hardware: PC Windows XP
: P3 major (vote)
Target Milestone: 2.3.0 M4   Edit
Assignee: Rick Lu CLA
QA Contact:
URL:
Whiteboard: Autoed
Keywords:
: 211701 (view as bug list)
Depends on: 211724
Blocks:
  Show dependency tree
 
Reported: 2007-11-30 01:06 EST by Liwen Chen CLA
Modified: 2009-07-23 06:55 EDT (History)
2 users (show)

See Also:


Attachments
LIBRARY file (68.83 KB, application/octet-stream)
2007-11-30 01:07 EST, Liwen Chen CLA
no flags Details
report design (68.83 KB, application/octet-stream)
2007-11-30 01:37 EST, Liwen Chen CLA
no flags Details
report design (4.89 KB, application/octet-stream)
2007-11-30 01:38 EST, Liwen Chen CLA
no flags Details

Note You need to log in before you can comment on or make changes to this bug.
Description Liwen Chen CLA 2007-11-30 01:06:09 EST
Description:
CrosstabException when preview attached report.
Build number:2.2.2.v20071130

Steps to reproduce:
1. Get attached library and report.
2. Preview report.

Expected result:
Display two crosstab with same data

Actual result:
Fail to display the second xtab. Second xtab is copied from the first xtab.

Error log:
ReportDesign (id = 1): 
- Crosstab row area contains null level defintion or the specific level "Group1/year" doest not exist in associated cube. 
Crosstab row area contains null level defintion or the specific level "Group1/year" doest not exist in associated cube. ( 1 time(s) )
detail : org.eclipse.birt.report.item.crosstab.core.CrosstabException: Crosstab row area contains null level defintion or the specific level "Group1/year" doest not exist in associated cube. at org.eclipse.birt.report.item.crosstab.core.util.CrosstabQueryUtil.createCubeQuery(CrosstabQueryUtil.java:162) at org.eclipse.birt.report.item.crosstab.core.re.CrosstabReportItemQuery.createReportQueries(CrosstabReportItemQuery.java:89) at org.eclipse.birt.report.engine.data.dte.ReportQueryBuilder$QueryBuilderVisitor.visitExtendedItem(ReportQueryBuilder.java:612) at org.eclipse.birt.report.engine.ir.ExtendedItemDesign.accept(ExtendedItemDesign.java:45) at org.eclipse.birt.report.engine.data.dte.ReportQueryBuilder.build(ReportQueryBuilder.java:251) at org.eclipse.birt.report.engine.data.dte.ReportQueryBuilder.build(ReportQueryBuilder.java:233) at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.prepare(AbstractDataEngine.java:136) at org.eclipse.birt.report.engine.executor.ReportExecutor.execute(ReportExecutor.java:94) at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportExecutor.execute(WrappedReportExecutor.java:59) at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplciateReportExecutor.execute(SuppressDuplciateReportExecutor.java:51) at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportExecutor.execute(WrappedReportExecutor.java:59) at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:138) at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:68) at org.eclipse.birt.report.service.ReportEngineService.runAndRenderReport(Unknown Source) at org.eclipse.birt.report.service.ReportEngineService.runAndRenderReport(Unknown Source) at org.eclipse.birt.report.service.BirtViewerReportService.runAndRenderReport(Unknown Source) at org.eclipse.birt.report.service.actionhandler.BirtRunAndRenderActionHandler.__execute(Unknown Source) at org.eclipse.birt.report.service.actionhandler.AbstractBaseActionHandler.execute(Unknown Source) at org.eclipse.birt.report.presentation.aggregation.layout.EngineFragment.doService(Unknown Source) at org.eclipse.birt.report.presentation.aggregation.AbstractBaseFragment.service(Unknown Source) at org.eclipse.birt.report.servlet.BirtEngineServlet.__doGet(Unknown Source) at org.eclipse.birt.report.servlet.BaseReportEngineServlet.doGet(Unknown Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:740) at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at org.eclipse.birt.report.filter.ViewerFilter.doFilter(Unknown Source) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2422) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.eclipse.tomcat.internal.EclipseErrorReportValve.invoke(EclipseErrorReportValve.java:153) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:199) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:828) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:700) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:584) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683) at java.lang.Thread.run(Thread.java:595)
Comment 1 Liwen Chen CLA 2007-11-30 01:07:41 EST
Created attachment 84136 [details]
LIBRARY file
Comment 2 Liwen Chen CLA 2007-11-30 01:37:28 EST
Created attachment 84137 [details]
report design
Comment 3 Liwen Chen CLA 2007-11-30 01:38:37 EST
Created attachment 84138 [details]
report design
Comment 4 Zhiqiang Qian CLA 2007-12-05 01:22:10 EST
*** Bug 211701 has been marked as a duplicate of this bug. ***
Comment 5 Zhiqiang Qian CLA 2007-12-23 22:09:12 EST
fixed.
Comment 6 Liwen Chen CLA 2007-12-25 21:58:10 EST
Blocked by 213865
Comment 7 Liwen Chen CLA 2007-12-28 20:50:21 EST
Verify in build 2.3.0.v20071229.
I copy and paste the first xtab and then preview, but get the same exception.
So reopen it.
Comment 8 Zhiqiang Qian CLA 2007-12-28 21:47:13 EST
This is still the copying issue. The copied level name remains "group1/year", if changed to "cube.group1/year", it works.
Comment 9 Rick Lu CLA 2008-01-01 22:10:58 EST
When copy/paste, the library namespace was missed. Fixed.
Comment 10 Liwen Chen CLA 2008-01-03 01:03:58 EST
Verify in build 2.3.0.v20080103