workbench error

[shivareddyk]

hi

can u explain abt this error...

Code:

com.tonbeller.jpivot.olap.model.OlapException: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [select NON EMPTY {[Currency.Currency].[All Currency]} ON COLUMNS, NON EMPTY {[Measures].[Total Income]} ON ROWS from [kpi-financial] ]com.tonbeller.jpivot.olap.model.OlapException: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [select NON EMPTY {[Currency.Currency].[All Currency]} ON COLUMNS,  NON EMPTY {[Measures].[Total Income]} ON ROWSfrom [kpi-financial]]	at com.tonbeller.jpivot.mondrian.MondrianModel.getResult(MondrianModel.java:295)	at com.tonbeller.jpivot.olap.model.OlapModelDecorator.getResult(OlapModelDecorator.java:54)	at com.tonbeller.jpivot.olap.model.CachingOlapModel.getResult(CachingOlapModel.java:48)	at com.tonbeller.jpivot.olap.model.OlapModelDecorator.getResult(OlapModelDecorator.java:54)	at sun.reflect.GeneratedMethodAccessor298.invoke(Unknown Source)	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)	at java.lang.reflect.Method.invoke(Unknown Source)	at javax.el.BeanELResolver.getValue(BeanELResolver.java:62)	at javax.el.CompositeELResolver.getValue(CompositeELResolver.java:53)	at org.apache.el.parser.AstValue.getValue(AstValue.java:97)	at org.apache.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:186)	at org.apache.jasper.runtime.PageContextImpl.proprietaryEvaluate(PageContextImpl.java:923)	at org.apache.jsp.WEB_002dINF.jsp.olap.viewOlap_jsp._jspx_meth_c_005fif_005f2(viewOlap_jsp.java:1639)	at org.apache.jsp.WEB_002dINF.jsp.olap.viewOlap_jsp._jspService(viewOlap_jsp.java:236)	at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)	at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)	at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:373)	at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:336)	at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)	at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)	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:118)	at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:52)	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:654)	at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:445)	at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:379)	at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:292)	at org.springframework.web.servlet.view.InternalResourceView.renderMergedOutputModel(InternalResourceView.java:142)	at org.springframework.web.servlet.view.AbstractView.render(AbstractView.java:247)	at org.springframework.web.servlet.DispatcherServlet.render(DispatcherServlet.java:1105)	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:841)	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:755)	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:396)	at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:350)	at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)	at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)	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:140)	at com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(RequestSynchronizer.java:127)	at com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:267)	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:86)	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264)	at org.acegisecurity.ui.switchuser.SwitchUserProcessingFilter.doFilter(SwitchUserProcessingFilter.java:335)	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)	at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107)	at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72)	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)	at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:110)	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)	at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125)	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)	at com.jaspersoft.jasperserver.api.metadata.user.service.impl.MetadataAuthenticationProcessingFilter.doFilter(MetadataAuthenticationProcessingFilter.java:136)	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)	at com.jaspersoft.jasperserver.war.util.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:97)	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)	at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:181)	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)	at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:165)	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)	at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:217)	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)	at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:165)	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)	at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:191)	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)	at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:148)	at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:90)	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:70)	at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:138)	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)	at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)	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:230)	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)	at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:179)	at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)	at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)	at java.lang.Thread.run(Unknown Source)Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [select NON EMPTY {[Currency.Currency].[All Currency]} ON COLUMNS,  NON EMPTY {[Measures].[Total Income]} ON ROWSfrom [kpi-financial]]	at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:755)	at mondrian.olap.Util.newInternal(Util.java:1083)	at mondrian.olap.Util.newError(Util.java:1099)	at mondrian.rolap.RolapConnection.execute(RolapConnection.java:438)	at com.tonbeller.jpivot.mondrian.MondrianModel.getResult(MondrianModel.java:269)	... 96 moreCaused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while loading segment; sql=[select sum((case when c.glcat='TCI' then  locbal else 0 end)) as `m0`, sum((case when c.glcat='IE' then locbal else 0 end)) as `m1` from `fact_gl` as `fact_gl`]	at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:755)	at mondrian.olap.Util.newInternal(Util.java:1083)	at mondrian.olap.Util.newError(Util.java:1099)	at mondrian.rolap.SqlStatement.handle(SqlStatement.java:204)	at mondrian.rolap.SqlStatement.execute(SqlStatement.java:138)	at mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:285)	at mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:246)	at mondrian.rolap.agg.Segment.load(Segment.java:354)	at mondrian.rolap.agg.Aggregation.load(Aggregation.java:164)	at mondrian.rolap.agg.AggregationManager.loadAggregation(AggregationManager.java:81)	at mondrian.rolap.FastBatchingCellReader$Batch.loadAggregation(FastBatchingCellReader.java:352)	at mondrian.rolap.FastBatchingCellReader.loadAggregations(FastBatchingCellReader.java:178)	at mondrian.rolap.RolapResult.executeBody(RolapResult.java:772)	at mondrian.rolap.RolapResult.<init>(RolapResult.java:390)	at mondrian.rolap.RolapConnection.execute(RolapConnection.java:410)	... 97 moreCaused by: java.sql.SQLException: Unknown column 'c.glcat' in 'field list'	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928)	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)	at com.mysql.jdbc.Connection.execSQL(Connection.java:2988)	at com.mysql.jdbc.Connection.execSQL(Connection.java:2917)	at com.mysql.jdbc.Statement.executeQuery(Statement.java:824)	at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:188)	at mondrian.rolap.SqlStatement.execute(SqlStatement.java:124)	... 107 more

[swood]

The custom SQL in your schema is not set up correctly, so the generated SQL from the OLAP engine is wrong.

 

Sherman

Jaspersoft

[hajar.hikmat]

I work with jasperAnalysis workbench to create my OLAP schema, and i got a succesful Mondrian connection with my MDX query. But when trying jasper report server to create my OLAP view i got the same error:

 

com.tonbeller.jpivot.olap.model.OlapException: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query

 

I am using jasper report server 5.0.0 and jasperAnalysis workbench 3.5.4

 

Thanks for help