Jasperanalysis error

[jayadevanm]

Hi,

I created a schema using workbench and tried a query there. It was working fine, When I tried it in Jasperanalysis, I started getting Cast errors. I kept taking away columns from my schema till I am left with the schema in the attached file. If I use only the string column, it works OK. The minute I try to drill down, I again get the errors. Sample errors..

1)

17:43:06,452  WARN AggTableManager,http-8080-Processor25:43 - : No Table found for fact name=BOOKING
17:43:40,863 ERROR RendererTag,http-8080-Processor25:165 - trouble rendering /analysis/datasources/N/table
java.lang.ClassCastException: java.math.BigDecimal
 

2)

17:43:41,271 ERROR JSErrorPage_jsp,http-8080-Processor25:349 -
javax.servlet.jsp.JspException: java.lang.ClassCastException: java.math.BigDecimal
3)

11:14:50,801  WARN AggTableManager,http-8080-Processor21:43 - : No Table found for fact name=BOOKING
11:14:58,851 ERROR RendererTag,http-8080-Processor25:165 - trouble rendering /analysis/views/N/table
java.lang.ClassCastException: java.sql.Date
 

4)

java.lang.ClassCastException: java.math.BigDecimal
        at mondrian.rolap.RolapMember.getName(RolapMember.java:477)
        at mondrian.olap.OlapElementBase.getCaption(OlapElementBase.java:82)
        at mondrian.olap.MemberBase.getCaption(MemberBase.java:115)
        at mondrian.rolap.RolapCubeMember.getCaption(RolapCubeMember.java:292)
        at com.tonbeller.jpivot.mondrian.MondrianMember.getLabel(MondrianMember.java:84)
        at com.tonbeller.jpivot.table.SpanBuilderImpl$RenderSwitch.visitMember(SpanBuilderImpl.java:332)
        at com.tonbeller.jpivot.mondrian.MondrianMember.accept(MondrianMember.java:166)
        at com.tonbeller.jpivot.table.SpanBuilderImpl.build(SpanBuilderImpl.java:365)
        at com.tonbeller.jpivot.table.SpanBuilderDecorator.build(SpanBuilderDecorator.java:34)
        at com.tonbeller.jpivot.table.navi.DrillExpandUI$DomDecorator.build(DrillExpandUI.java:105)
        at com.tonbeller.jpivot.table.SpanBuilderDecorator.build(SpanBuilderDecorator.java:34)
        at com.tonbeller.jpivot.table.navi.DrillExpandUI$DomDecorator.build(DrillExpandUI.java:105)
        at com.tonbeller.jpivot.table.SpanBuilderDecorator.build(SpanBuilderDecorator.java:34)
        at com.tonbeller.jpivot.table.navi.DrillExpandUI$DomDecorator.build(DrillExpandUI.java:105)
        at com.tonbeller.jpivot.table.SpanBuilderDecorator.build(SpanBuilderDecorator.java:34)
        at com.tonbeller.jpivot.table.navi.DrillExpandUI$DomDecorator.build(DrillExpandUI.java:105)
        at com.tonbeller.jpivot.table.SpanBuilderDecorator.build(SpanBuilderDecorator.java:34)
        at com.tonbeller.jpivot.table.navi.SortRankUI$DomDecorator.build(SortRankUI.java:178)
        at com.tonbeller.jpivot.table.AxisHeaderBuilderSupport.build(AxisHeaderBuilderSupport.java:63)
        at com.tonbeller.jpivot.table.AxisBuilderSupport.buildHeading(AxisBuilderSupport.java:258)
        at com.tonbeller.jpivot.table.ColumnAxisBuilderImpl.buildRow(ColumnAxisBuilderImpl.java:41)
        at com.tonbeller.jpivot.table.TableComponent.buildColumns1Dim(TableComponent.java:451)
        at com.tonbeller.jpivot.table.TableComponent.render2(TableComponent.java:347)
        at com.tonbeller.jpivot.table.TableComponent.render(TableComponent.java:306)
        at com.tonbeller.wcf.component.RendererTag.doEndTag(RendererTag.java:141)
        at org.apache.jsp.WEB_002dINF.jsp.olap.viewOlap_jsp._jspx_meth_wcf_render_4(viewOlap_jsp.java:3031)
        at org.apache.jsp.WEB_002dINF.jsp.olap.viewOlap_jsp._jspx_meth_c_if_12(viewOlap_jsp.java:2993)
        at org.apache.jsp.WEB_002dINF.jsp.olap.viewOlap_jsp._jspService(viewOlap_jsp.java:472)
        at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
        at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:334)
        at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
        at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
        at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:127)
        at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:56)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
        at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:672)
 

etc.

 

 

 

[jayadevanm]

Just in case this helps some one else - I managed to fix the problem. It had something to do with the nameColumn tags in xml schema (if we generate the schema using workbench). When we have those tags for data types other than strings, it gives different cast exceptions. Removing nameColumn gets rid of the error.

[swood]

Did you try setting the type of the column?

 

Sherman

Jaspersoft

[jayadevanm]

Yes. I had set the type of the column in all cases. You are referring to the "type" part in this snippet, right?

column="MONTH_NAME" nameColumn="MONTH_NAME" type="String"

[german_faiella]

I have a similar issue, so I would like to know if you found the solution.

The following MDX works in Mondrian Schema Workbench (3.2.1.13885 y 2.3.2.9247) and returns the expected results:

select NON EMPTY {[Measures].[importe]} ON COLUMNS,
  NON EMPTY {[CuentaContable].[All CuentaContables].Children} ON ROWS
from [Contabilidad]
where [Asiento].[1011]

Axis #0:
{[Asiento].[1011]}
Axis #1:
{[Measures].[importe]}
Axis #2:
{[CuentaContable].[1-ACTIVO]}
{[CuentaContable].[2-PASIVO]}
{[CuentaContable].[3-PATRIMONIO NETO]}
{[CuentaContable].[4-RESULTADOS]}
{[CuentaContable].[5-CUENTAS DE MOVIMIENTO]}
Row #0: 314,026,177.13
Row #1: 207,303,696.04
Row #2: 4,554,708.91
Row #3: 60,452,787.56
Row #4: 256,080,113.49
 

But when I executed the same MDX in JasperServer CP 4.0.0 it returns the error "HTTP 404 - /jasperserver/WEB_INF/jsp/modules/modules/system/errorPage.jsp".

Analizing the error log, I found the following exception:

2011-09-25 21:25:13,359 DEBUG mdx,http-8080-7:589 - 7: select NON EMPTY {[Measures].[importe]} ON COLUMNS,
  NON EMPTY {[CuentaContable].[All CuentaContables]} ON ROWS
from [Contabilidad]
where [Asiento].[1011]

2011-09-25 21:25:13,359 DEBUG sql,http-8080-7:133 - 1970: Segment.load: executing sql [select "GDF_FACT_ASIENTOS"."EJERCICIO" as "c0", sum("GDF_FACT_ASIENTOS"."IMPORTE") as "m0" from "GDF"."GDF_FACT_ASIENTOS" "GDF_FACT_ASIENTOS" where "GDF_FACT_ASIENTOS"."EJERCICIO" = '1011' group by "GDF_FACT_ASIENTOS"."EJERCICIO"]
2011-09-25 21:25:19,234 DEBUG sql,http-8080-7:195 - 1970: , exec 5875 ms
2011-09-25 21:25:19,250 DEBUG sql,http-8080-7:256 - 1970: , exec+fetch 5891 ms, 0 rows
2011-09-25 21:25:19,265 DEBUG mdx,http-8080-7:628 - 7: exec: 5906 ms
2011-09-25 21:25:25,468 DEBUG mdx,http-8080-7:589 - 8: select NON EMPTY {[Measures].[importe]} ON COLUMNS,
  NON EMPTY Hierarchize(Union({[CuentaContable].[All CuentaContables]}, [CuentaContable].[All CuentaContables].Children)) ON ROWS
from [Contabilidad]
where [Asiento].[1011]

2011-09-25 21:25:25,906 DEBUG sql,http-8080-7:133 - 1971: Segment.load: executing sql [select "GDF_FACT_ASIENTOS"."EJERCICIO" as "c0", sum("GDF_FACT_ASIENTOS"."IMPORTE") as "m0" from "GDF"."GDF_FACT_ASIENTOS" "GDF_FACT_ASIENTOS" where "GDF_FACT_ASIENTOS"."EJERCICIO" = '1011' group by "GDF_FACT_ASIENTOS"."EJERCICIO"]
2011-09-25 21:25:29,203 DEBUG sql,http-8080-7:195 - 1971: , exec 3297 ms
2011-09-25 21:25:29,203 DEBUG sql,http-8080-7:256 - 1971: , exec+fetch 3297 ms, 0 rows
2011-09-25 21:25:29,203 DEBUG sql,http-8080-7:133 - 1972: Segment.load: executing sql [select "GDF_DIM_CTAS_CONTABLES"."CUENTA" as "c0", "GDF_FACT_ASIENTOS"."EJERCICIO" as "c1", sum("GDF_FACT_ASIENTOS"."IMPORTE") as "m0" from "GDF"."GDF_DIM_CTAS_CONTABLES" "GDF_DIM_CTAS_CONTABLES", "GDF"."GDF_FACT_ASIENTOS" "GDF_FACT_ASIENTOS" where "GDF_FACT_ASIENTOS"."CTA_CONTABLE" = "GDF_DIM_CTAS_CONTABLES"."CUENTA" and "GDF_FACT_ASIENTOS"."EJERCICIO" = '1011' group by "GDF_DIM_CTAS_CONTABLES"."CUENTA", "GDF_FACT_ASIENTOS"."EJERCICIO"]
2011-09-25 21:25:32,750 DEBUG sql,http-8080-7:195 - 1972: , exec 3547 ms
2011-09-25 21:25:32,765 DEBUG sql,http-8080-7:256 - 1972: , exec+fetch 3562 ms, 0 rows
2011-09-25 21:25:32,875 DEBUG mdx,http-8080-7:628 - 8: exec: 7407 ms
2011-09-25 21:25:32,906 ERROR RendererTag,http-8080-7:165 - trouble rendering /analysis/views/ResumenContable/table
java.lang.ClassCastException: mondrian.rolap.SqlMemberSource$RolapParentChildMemberNoClosure cannot be cast to mondrian.rolap.RolapCalculatedMember
 at mondrian.rolap.RolapCell.replaceTrivialCalcMember(RolapCell.java:231)
 at mondrian.rolap.RolapCell.getMembersForDrillThrough(RolapCell.java:214)
 at mondrian.rolap.RolapCell.canDrillThrough(RolapCell.java:146)
 at com.tonbeller.jpivot.mondrian.MondrianDrillThrough.canDrillThrough(MondrianDrillThrough.java:61)
 at com.tonbeller.jpivot.table.navi.DrillThroughUI.canDrillThrough(DrillThroughUI.java:275)
 at com.tonbeller.jpivot.table.navi.DrillThroughUI$DomDecorator.build(DrillThroughUI.java:156)
 at com.tonbeller.jpivot.table.CellBuilderDecorator.build(CellBuilderDecorator.java:31)
 at com.tonbeller.jpivot.excel.ExcelCellBuilderDecorator.build(ExcelCellBuilderDecorator.java:43)
 at com.tonbeller.jpivot.table.TableComponent.buildCells(TableComponent.java:685)
 at com.tonbeller.jpivot.table.TableComponent.buildRows2Dim(TableComponent.java:670)
 at com.tonbeller.jpivot.table.TableComponent.render2(TableComponent.java:359)
 at com.tonbeller.jpivot.table.TableComponent.render(TableComponent.java:310)
 at com.tonbeller.wcf.component.RendererTag.doEndTag(RendererTag.java:141)
 at org.apache.jsp.WEB_002dINF.jsp.modules.olap.viewOlap_jsp._jspx_meth_wcf_005frender_005f4(viewOlap_jsp.java:3802)
 at org.apache.jsp.WEB_002dINF.jsp.modules.olap.viewOlap_jsp._jspx_meth_c_005fif_005f12(viewOlap_jsp.java:3758)
 at org.apache.jsp.WEB_002dINF.jsp.modules.olap.viewOlap_jsp._jspService(viewOlap_jsp.java:543)
 at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
 at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)
 at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
 at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
 at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:127)
 at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:56)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
 at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
 at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436)
 at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)
 at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)
 at org.springframework.web.servlet.view.InternalResourceView.renderMergedOutputModel(InternalResourceView.java:236)
 at org.springframework.web.servlet.view.AbstractView.render(AbstractView.java:257)
 at org.springframework.web.servlet.DispatcherServlet.render(DispatcherServlet.java:1183)
 at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:902)
 at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:807)
 at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:571)
 at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:511)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
 at com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:141)
 at com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(RequestSynchronizer.java:127)
 at com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:281)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
 at com.jaspersoft.jasperserver.war.common.UploadMultipartFilter.doFilter(UploadMultipartFilter.java:83)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
 at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378)
 at com.jaspersoft.jasperserver.war.security.JSSwitchUserProcessingFilter.doFilterHttp(JSSwitchUserProcessingFilter.java:154)
 at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
 at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
 at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109)
 at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
 at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
 at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101)
 at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
 at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
 at org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105)
 at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
 at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
 at com.jaspersoft.jasperserver.api.metadata.user.service.impl.MetadataAuthenticationProcessingFilter.doFilter(MetadataAuthenticationProcessingFilter.java:139)
 at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
 at com.jaspersoft.jasperserver.war.util.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:97)
 at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
 at org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174)
 at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
 at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
 at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:184)
 at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
 at org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:277)
 at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
 at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
 at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:184)
 at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
 at com.jaspersoft.jasperserver.api.logging.filter.BasicLoggingFilter.doFilter(BasicLoggingFilter.java:53)
 at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
 at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235)
 at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
 at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
 at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:175)
 at org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
 at com.jaspersoft.jasperserver.war.util.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:67)
 at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236)
 at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
 at com.jaspersoft.jasperserver.war.security.CrossScriptingFilter.doFilter(CrossScriptingFilter.java:49)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
 at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:558)
 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
 at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:859)
 at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:579)
 at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1555)
 at java.lang.Thread.run(Thread.java:619)
 

Could you give me a glue for solve the issue?

Thank you very much! German

Code:

select NON EMPTY {[Measures].[importe]} ON COLUMNS,  NON EMPTY {[CuentaContable].[All CuentaContables].Children} ON ROWSfrom [Contabilidad]where [Asiento].[1011]