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"

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.

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.