mondrian.olap.MondrianException: Mondrian Error:Failed to parse query ' select NON EMPTY {[Measures].[COUNT of NL_ALL_SUBSCRIPTIONS.I_TOPIC_ID]} ON columns, NON EMPTY {([ZEIT.ZEIT].[ALL ZEIT], [THEMA.THEMA].[ALL THEMA])} ON rows from [NL_ALL] '

Pentaho BI Platform Tracking | Klaus Mende | 9 years ago
  1. 0

    Error in Mondrian component of BI-Server 1.6 GA (PCI MySQL) by using Data from DB2 9.5. 2008-04-16 19:27:21,183 ERROR [com.tonbeller.jpivot.mondrian.MondrianModel] Parse Failure mondrian.olap.MondrianException: Mondrian Error:Failed to parse query ' select NON EMPTY {[Measures].[COUNT of NL_ALL_SUBSCRIPTIONS.I_TOPIC_ID]} ON COLUMNS, NON EMPTY Hierarchize(Union(Crossjoin({[ZEIT.ZEIT].[ALL ZEIT]}, {[THEMA.THEMA].[ALL THEMA]}), Crossjoin({[ZEIT.ZEIT].[ALL ZEIT]}, [THEMA.THEMA].[ALL THEMA].Children))) ON ROWS from [NL_ALL] Description: I have created a cube with cube-Designer 0.7.2 an published it to the server. By using the xaction out of the solution-directorie, the console shows the errors (look at error-log 1, below) So I tried a new identical cube with the same data against a MySQL-DB. Everything works fine. Ok, there are some errors (ERROR [STDERR] Warning: Running an XSLT 1.0 stylesheet with an XSLT 2.0 processor), but it works! I read the threads in the community forum, where Julian dicribes the problems with the case-sensitivity in relationship with DB2. I corrected the cubedefiniton to uppercase. No effects. So at last I tried out an other MDX-statement, which I created with Jpivot and the running MySQL-Example. Again Error (see error-log 2 below) Can there be a bug in the parser? Thanks for helping me. (I didn´t find an opportunity to upload the cube-schema and xactions. So if you need them, please send me a mail) Klaus Mende PRORATIO GmbH kmende@proratio.de Error log 1: 2008-04-16 19:20:06,561 INFO [STDOUT] , failed (com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -440, SQLSTATE: 42884, SQLERRMC: UCASE;FUNCTION)SqlMemberSource.getMemberChildren: executing sql [select "NL_ALL_SUBSCRIPTIONS"."NL_Y_M_CREATED" as "c0" from "MVBBI"."NL_ALL_SUBSCRIPTIONS" as "NL_ALL_SUBSCRIPTIONS" where UCASE("NL_ALL_SUBSCRIPTIONS"."NL_Y_M_CREATED") = UCASE('THEMA.THEMA') group by "NL_ALL_SUBSCRIPTIONS"."NL_Y_M_CREATED" order by "NL_ALL_SUBSCRIPTIONS"."NL_Y_M_CREATED" ASC] 2008-04-16 19:20:06,812 INFO [STDOUT] , exec+fetch 251 ms, 0 rows 2008-04-16 19:20:06,812 ERROR [com.tonbeller.jpivot.mondrian.MondrianModel] Parse Failure mondrian.olap.MondrianException: Mondrian Error:Failed to parse query ' select NON EMPTY {[Measures].[COUNT of NL_ALL_SUBSCRIPTIONS.I_TOPIC_ID]} ON columns, NON EMPTY {([ZEIT.ZEIT].[ALL ZEIT], [THEMA.THEMA].[ALL THEMA])} ON rows from [NL_ALL] ' at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:755) at mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:77) at mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:59) at com.tonbeller.jpivot.mondrian.MondrianModel.parseMDX(MondrianModel.java:528) at com.tonbeller.jpivot.mondrian.MondrianModel.initialize(MondrianModel.java:495) at com.tonbeller.jpivot.olap.model.OlapModelDecorator.initialize(OlapModelDecorator.java:132) at com.tonbeller.jpivot.tags.OlapModelProxy$MyState.initialize(OlapModelProxy.java:77) at com.tonbeller.jpivot.tags.StackStateManager.initializeAndShow(StackStateManager.java:76) at com.tonbeller.jpivot.tags.OlapModelProxy.initializeAndShow(OlapModelProxy.java:160) at com.tonbeller.jpivot.tags.OlapModelTag.doEndTag(OlapModelTag.java:81) at org.apache.jsp.jsp.Pivot_jsp._jspService(Pivot_jsp.java:789) 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:387) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266) 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 org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264) 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.ui.switchuser.SwitchUserProcessingFilter.doFilter(SwitchUserProcessingFilter.java:335) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.pentaho.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:76) 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 org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:142) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.pentaho.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:164) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:178) 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 org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:108) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.pentaho.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:130) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:193) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:81) 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:98) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:139) at com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(RequestSynchronizer.java:127) at com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:263) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.core.system.SystemStatusFilter.doFilter(SystemStatusFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.ui.servlet.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:112) 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.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433) at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104) 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:241) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:580) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) at java.lang.Thread.run(Unknown Source) Caused by: mondrian.olap.MondrianException: Mondrian Error:Error while parsing MDX statement ' select NON EMPTY {[Measures].[COUNT of NL_ALL_SUBSCRIPTIONS.I_TOPIC_ID]} ON columns, NON EMPTY {([ZEIT.ZEIT].[ALL ZEIT], [THEMA.THEMA].[ALL THEMA])} ON rows from [NL_ALL] ' at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:755) at mondrian.olap.Parser.parseInternal(Parser.java:755) at mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:74) ... 77 more Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: while building member cache; sql=[select "NL_ALL_SUBSCRIPTIONS"."NL_Y_M_CREATED" as "c0" from "MVBBI"."NL_ALL_SUBSCRIPTIONS" as "NL_ALL_SUBSCRIPTIONS" where UCASE("NL_ALL_SUBSCRIPTIONS"."NL_Y_M_CREATED") = UCASE('THEMA.THEMA') group by "NL_ALL_SUBSCRIPTIONS"."NL_Y_M_CREATED" order by "NL_ALL_SUBSCRIPTIONS"."NL_Y_M_CREATED" ASC] at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:755) at mondrian.olap.Util.newInternal(Util.java:1175) at mondrian.olap.Util.newError(Util.java:1191) at mondrian.rolap.SqlStatement.handle(SqlStatement.java:208) 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.SqlMemberSource.getMemberChildren2(SqlMemberSource.java:711) at mondrian.rolap.SqlMemberSource.getMemberChildren(SqlMemberSource.java:641) at mondrian.rolap.SqlMemberSource.getMemberChildren(SqlMemberSource.java:616) at mondrian.rolap.SmartMemberReader.readMemberChildren(SmartMemberReader.java:280) at mondrian.rolap.SmartMemberReader.getMemberChildren(SmartMemberReader.java:245) at mondrian.rolap.SmartMemberReader.getMemberChildren(SmartMemberReader.java:212) at mondrian.rolap.RolapSchemaReader.internalGetMemberChildren(RolapSchemaReader.java:151) at mondrian.rolap.RolapSchemaReader.lookupMemberChildByName(RolapSchemaReader.java:322) at mondrian.olap.Util.lookupHierarchyRootMember(Util.java:916) at mondrian.olap.HierarchyBase.lookupChild(HierarchyBase.java:121) at mondrian.olap.DimensionBase.lookupChild(DimensionBase.java:102) at mondrian.olap.CubeBase.lookupChild(CubeBase.java:115) at mondrian.rolap.RolapCube.lookupChild(RolapCube.java:2221) at mondrian.rolap.RolapSchemaReader.getElementChild(RolapSchemaReader.java:254) at mondrian.olap.Util.lookupCompound(Util.java:576) at mondrian.rolap.RolapSchemaReader.lookupCompound(RolapSchemaReader.java:303) at mondrian.olap.DelegatingSchemaReader.lookupCompound(DelegatingSchemaReader.java:105) at mondrian.olap.Query$QuerySchemaReader.lookupCompound(Query.java:1542) at mondrian.olap.Query$QuerySchemaReader.lookupCompound(Query.java:1509) at mondrian.olap.Util.lookup(Util.java:733) at mondrian.olap.Id.accept(Id.java:111) at mondrian.olap.Query$StackValidator.validate(Query.java:1208) at mondrian.olap.fun.FunUtil.resolveFunArgs(FunUtil.java:1751) at mondrian.mdx.UnresolvedFunCall.accept(UnresolvedFunCall.java:91) at mondrian.olap.Query$StackValidator.validate(Query.java:1208) at mondrian.olap.fun.FunUtil.resolveFunArgs(FunUtil.java:1751) at mondrian.mdx.UnresolvedFunCall.accept(UnresolvedFunCall.java:91) at mondrian.olap.Query$StackValidator.validate(Query.java:1208) at mondrian.olap.QueryAxis.resolve(QueryAxis.java:201) at mondrian.olap.Query$StackValidator.validate(Query.java:1268) at mondrian.olap.Query.resolve(Query.java:570) at mondrian.olap.Query.resolve(Query.java:425) at mondrian.olap.Query.<init>(Query.java:220) at mondrian.olap.Query.<init>(Query.java:180) at mondrian.olap.Parser.makeQuery(Parser.java:846) at mondrian.olap.CUP$Parser$actions.CUP$Parser$do_action(Parser.java:1679) at mondrian.olap.Parser.do_action(Parser.java:680) at java_cup.runtime.lr_parser.parse(lr_parser.java:569) at mondrian.olap.Parser.parseInternal(Parser.java:750) ... 78 more Caused by: com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -440, SQLSTATE: 42884, SQLERRMC: UCASE;FUNCTION at com.ibm.db2.jcc.b.hh.c(hh.java:1662) at com.ibm.db2.jcc.b.hh.d(hh.java:1650) at com.ibm.db2.jcc.b.hh.a(hh.java:1219) at com.ibm.db2.jcc.c.db.g(db.java:139) at com.ibm.db2.jcc.c.db.a(db.java:39) at com.ibm.db2.jcc.c.t.a(t.java:34) at com.ibm.db2.jcc.c.sb.f(sb.java:142) at com.ibm.db2.jcc.b.hh.n(hh.java:1190) at com.ibm.db2.jcc.b.hh.a(hh.java:1902) at com.ibm.db2.jcc.b.hh.a(hh.java:491) at com.ibm.db2.jcc.b.hh.executeQuery(hh.java:475) at org.jboss.resource.adapter.jdbc.WrappedStatement.executeQuery(WrappedStatement.java:171) at mondrian.rolap.SqlStatement.execute(SqlStatement.java:124) ... 119 more 2008-04-16 19:20:06,827 ERROR [com.tonbeller.jpivot.mondrian.MondrianModel] DB2 SQL error: SQLCODE: -440, SQLSTATE: 42884, SQLERRMC: UCASE;FUNCTION 2008-04-16 19:20:06,827 ERROR [com.tonbeller.jpivot.tags.OlapModelProxy] com.tonbeller.jpivot.olap.model.OlapException: DB2 SQL error: SQLCODE: -440, SQLSTATE: 42884, SQLERRMC: UCASE;FUNCTION at com.tonbeller.jpivot.mondrian.MondrianModel.initialize(MondrianModel.java:499) at com.tonbeller.jpivot.olap.model.OlapModelDecorator.initialize(OlapModelDecorator.java:132) at com.tonbeller.jpivot.tags.OlapModelProxy$MyState.initialize(OlapModelProxy.java:77) at com.tonbeller.jpivot.tags.StackStateManager.initializeAndShow(StackStateManager.java:76) at com.tonbeller.jpivot.tags.OlapModelProxy.initializeAndShow(OlapModelProxy.java:160) at com.tonbeller.jpivot.tags.OlapModelTag.doEndTag(OlapModelTag.java:81) at org.apache.jsp.jsp.Pivot_jsp._jspService(Pivot_jsp.java:789) 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:387) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266) 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 org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264) 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.ui.switchuser.SwitchUserProcessingFilter.doFilter(SwitchUserProcessingFilter.java:335) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.pentaho.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:76) 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 org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:142) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.pentaho.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:164) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:178) 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 org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:108) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.pentaho.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:130) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:193) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:81) 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:98) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:139) at com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(RequestSynchronizer.java:127) at com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:263) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.core.system.SystemStatusFilter.doFilter(SystemStatusFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.ui.servlet.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:112) 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.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433) at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104) 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:241) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:580) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) at java.lang.Thread.run(Unknown Source) 2008-04-16 19:20:06,827 ERROR [com.tonbeller.jpivot.tags.OlapModelTag] com.tonbeller.jpivot.olap.model.OlapException: DB2 SQL error: SQLCODE: -440, SQLSTATE: 42884, SQLERRMC: UCASE;FUNCTION at com.tonbeller.jpivot.mondrian.MondrianModel.initialize(MondrianModel.java:499) at com.tonbeller.jpivot.olap.model.OlapModelDecorator.initialize(OlapModelDecorator.java:132) at com.tonbeller.jpivot.tags.OlapModelProxy$MyState.initialize(OlapModelProxy.java:77) at com.tonbeller.jpivot.tags.StackStateManager.initializeAndShow(StackStateManager.java:76) at com.tonbeller.jpivot.tags.OlapModelProxy.initializeAndShow(OlapModelProxy.java:160) at com.tonbeller.jpivot.tags.OlapModelTag.doEndTag(OlapModelTag.java:81) at org.apache.jsp.jsp.Pivot_jsp._jspService(Pivot_jsp.java:789) 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:387) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266) 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 org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264) 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.ui.switchuser.SwitchUserProcessingFilter.doFilter(SwitchUserProcessingFilter.java:335) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.pentaho.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:76) 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 org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:142) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.pentaho.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:164) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:178) 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 org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:108) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.pentaho.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:130) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:193) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:81) 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:98) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:139) at com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(RequestSynchronizer.java:127) at com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:263) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.core.system.SystemStatusFilter.doFilter(SystemStatusFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.ui.servlet.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:112) 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.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433) at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104) 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:241) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:580) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) at java.lang.Thread.run(Unknown Source) 2008-04-16 19:20:06,827 ERROR [STDERR] javax.servlet.jsp.JspException: com.tonbeller.jpivot.olap.model.OlapException: DB2 SQL error: SQLCODE: -440, SQLSTATE: 42884, SQLERRMC: UCASE;FUNCTION 2008-04-16 19:20:06,827 ERROR [STDERR] at com.tonbeller.jpivot.tags.OlapModelTag.doEndTag(OlapModelTag.java:86) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.apache.jsp.jsp.Pivot_jsp._jspService(Pivot_jsp.java:789) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) 2008-04-16 19:20:06,827 ERROR [STDERR] at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:387) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266) 2008-04-16 19:20:06,827 ERROR [STDERR] at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:110) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.acegisecurity.ui.switchuser.SwitchUserProcessingFilter.doFilter(SwitchUserProcessingFilter.java:335) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) 2008-04-16 19:20:06,827 ERROR [STDERR] at com.pentaho.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:76) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:142) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) 2008-04-16 19:20:06,827 ERROR [STDERR] at com.pentaho.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:164) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:178) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:217) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:108) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) 2008-04-16 19:20:06,827 ERROR [STDERR] at com.pentaho.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:130) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:193) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:81) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:148) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) 2008-04-16 19:20:06,827 ERROR [STDERR] at com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:139) 2008-04-16 19:20:06,827 ERROR [STDERR] at com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(RequestSynchronizer.java:127) 2008-04-16 19:20:06,827 ERROR [STDERR] at com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:263) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.pentaho.core.system.SystemStatusFilter.doFilter(SystemStatusFilter.java:53) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.pentaho.ui.servlet.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:112) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:179) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:241) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:580) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) 2008-04-16 19:20:06,827 ERROR [STDERR] at java.lang.Thread.run(Unknown Source) 2008-04-16 19:20:06,827 ERROR [STDERR] Caused by: com.tonbeller.jpivot.olap.model.OlapException: DB2 SQL error: SQLCODE: -440, SQLSTATE: 42884, SQLERRMC: UCASE;FUNCTION 2008-04-16 19:20:06,827 ERROR [STDERR] at com.tonbeller.jpivot.mondrian.MondrianModel.initialize(MondrianModel.java:499) 2008-04-16 19:20:06,827 ERROR [STDERR] at com.tonbeller.jpivot.olap.model.OlapModelDecorator.initialize(OlapModelDecorator.java:132) 2008-04-16 19:20:06,827 ERROR [STDERR] at com.tonbeller.jpivot.tags.OlapModelProxy$MyState.initialize(OlapModelProxy.java:77) 2008-04-16 19:20:06,827 ERROR [STDERR] at com.tonbeller.jpivot.tags.StackStateManager.initializeAndShow(StackStateManager.java:76) 2008-04-16 19:20:06,827 ERROR [STDERR] at com.tonbeller.jpivot.tags.OlapModelProxy.initializeAndShow(OlapModelProxy.java:160) 2008-04-16 19:20:06,827 ERROR [STDERR] at com.tonbeller.jpivot.tags.OlapModelTag.doEndTag(OlapModelTag.java:81) 2008-04-16 19:20:06,827 ERROR [STDERR] ... 69 more Error log 2: 2008-04-16 19:27:21,183 INFO [STDOUT] SqlMemberSource.getMemberChildren: executing sql [select "NL_ALL_SUBSCRIPTIONS"."NL_Y_M_CREATED" as "c0" from "MVBBI"."NL_ALL_SUBSCRIPTIONS" as "NL_ALL_SUBSCRIPTIONS" where UCASE("NL_ALL_SUBSCRIPTIONS"."NL_Y_M_CREATED") = UCASE('THEMA.THEMA') group by "NL_ALL_SUBSCRIPTIONS"."NL_Y_M_CREATED" order by "NL_ALL_SUBSCRIPTIONS"."NL_Y_M_CREATED" ASC] 2008-04-16 19:27:21,183 INFO [STDOUT] , exec+fetch 0 ms, 0 rows 2008-04-16 19:27:21,183 ERROR [com.tonbeller.jpivot.mondrian.MondrianModel] Parse Failure mondrian.olap.MondrianException: Mondrian Error:Failed to parse query ' select NON EMPTY {[Measures].[COUNT of NL_ALL_SUBSCRIPTIONS.I_TOPIC_ID]} ON COLUMNS, NON EMPTY Hierarchize(Union(Crossjoin({[ZEIT.ZEIT].[ALL ZEIT]}, {[THEMA.THEMA].[ALL THEMA]}), Crossjoin({[ZEIT.ZEIT].[ALL ZEIT]}, [THEMA.THEMA].[ALL THEMA].Children))) ON ROWS from [NL_ALL] ' at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:755) at mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:77) at mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:59) at com.tonbeller.jpivot.mondrian.MondrianModel.parseMDX(MondrianModel.java:528) at com.tonbeller.jpivot.mondrian.MondrianModel.initialize(MondrianModel.java:495) at com.tonbeller.jpivot.olap.model.OlapModelDecorator.initialize(OlapModelDecorator.java:132) at com.tonbeller.jpivot.tags.OlapModelProxy$MyState.initialize(OlapModelProxy.java:77) at com.tonbeller.jpivot.tags.StackStateManager.initializeAndShow(StackStateManager.java:76) at com.tonbeller.jpivot.tags.OlapModelProxy.initializeAndShow(OlapModelProxy.java:160) at com.tonbeller.jpivot.tags.OlapModelTag.doEndTag(OlapModelTag.java:81) at org.apache.jsp.jsp.Pivot_jsp._jspService(Pivot_jsp.java:789) 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:387) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266) 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 org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264) 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.ui.switchuser.SwitchUserProcessingFilter.doFilter(SwitchUserProcessingFilter.java:335) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.pentaho.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:76) 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 org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:142) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.pentaho.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:164) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:178) 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 org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:108) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.pentaho.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:130) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:193) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:81) 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:98) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:139) at com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(RequestSynchronizer.java:127) at com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:263) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.core.system.SystemStatusFilter.doFilter(SystemStatusFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.ui.servlet.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:112) 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.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433) at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104) 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:241) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:580) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) at java.lang.Thread.run(Unknown Source) Caused by: mondrian.olap.MondrianException: Mondrian Error:Error while parsing MDX statement ' select NON EMPTY {[Measures].[COUNT of NL_ALL_SUBSCRIPTIONS.I_TOPIC_ID]} ON COLUMNS, NON EMPTY Hierarchize(Union(Crossjoin({[ZEIT.ZEIT].[ALL ZEIT]}, {[THEMA.THEMA].[ALL THEMA]}), Crossjoin({[ZEIT.ZEIT].[ALL ZEIT]}, [THEMA.THEMA].[ALL THEMA].Children))) ON ROWS from [NL_ALL] ' at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:755) at mondrian.olap.Parser.parseInternal(Parser.java:755) at mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:74) ... 77 more Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: while building member cache; sql=[select "NL_ALL_SUBSCRIPTIONS"."NL_Y_M_CREATED" as "c0" from "MVBBI"."NL_ALL_SUBSCRIPTIONS" as "NL_ALL_SUBSCRIPTIONS" where UCASE("NL_ALL_SUBSCRIPTIONS"."NL_Y_M_CREATED") = UCASE('THEMA.THEMA') group by "NL_ALL_SUBSCRIPTIONS"."NL_Y_M_CREATED" order by "NL_ALL_SUBSCRIPTIONS"."NL_Y_M_CREATED" ASC] at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:755) at mondrian.olap.Util.newInternal(Util.java:1175) at mondrian.olap.Util.newError(Util.java:1191) at mondrian.rolap.SqlStatement.handle(SqlStatement.java:208) 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.SqlMemberSource.getMemberChildren2(SqlMemberSource.java:711) at mondrian.rolap.SqlMemberSource.getMemberChildren(SqlMemberSource.java:641) at mondrian.rolap.SqlMemberSource.getMemberChildren(SqlMemberSource.java:616) at mondrian.rolap.SmartMemberReader.readMemberChildren(SmartMemberReader.java:280) at mondrian.rolap.SmartMemberReader.getMemberChildren(SmartMemberReader.java:245) at mondrian.rolap.SmartMemberReader.getMemberChildren(SmartMemberReader.java:212) at mondrian.rolap.RolapSchemaReader.internalGetMemberChildren(RolapSchemaReader.java:151) at mondrian.rolap.RolapSchemaReader.lookupMemberChildByName(RolapSchemaReader.java:322) at mondrian.olap.Util.lookupHierarchyRootMember(Util.java:916) at mondrian.olap.HierarchyBase.lookupChild(HierarchyBase.java:121) at mondrian.olap.DimensionBase.lookupChild(DimensionBase.java:102) at mondrian.olap.CubeBase.lookupChild(CubeBase.java:115) at mondrian.rolap.RolapCube.lookupChild(RolapCube.java:2221) at mondrian.rolap.RolapSchemaReader.getElementChild(RolapSchemaReader.java:254) at mondrian.olap.Util.lookupCompound(Util.java:576) at mondrian.rolap.RolapSchemaReader.lookupCompound(RolapSchemaReader.java:303) at mondrian.olap.DelegatingSchemaReader.lookupCompound(DelegatingSchemaReader.java:105) at mondrian.olap.Query$QuerySchemaReader.lookupCompound(Query.java:1542) at mondrian.olap.Query$QuerySchemaReader.lookupCompound(Query.java:1509) at mondrian.olap.Util.lookup(Util.java:733) at mondrian.olap.Id.accept(Id.java:111) at mondrian.olap.Query$StackValidator.validate(Query.java:1208) at mondrian.olap.fun.FunUtil.resolveFunArgs(FunUtil.java:1751) at mondrian.mdx.UnresolvedFunCall.accept(UnresolvedFunCall.java:91) at mondrian.olap.Query$StackValidator.validate(Query.java:1208) at mondrian.olap.fun.FunUtil.resolveFunArgs(FunUtil.java:1751) at mondrian.mdx.UnresolvedFunCall.accept(UnresolvedFunCall.java:91) at mondrian.olap.Query$StackValidator.validate(Query.java:1208) at mondrian.olap.fun.FunUtil.resolveFunArgs(FunUtil.java:1751) at mondrian.mdx.UnresolvedFunCall.accept(UnresolvedFunCall.java:91) at mondrian.olap.Query$StackValidator.validate(Query.java:1208) at mondrian.olap.fun.FunUtil.resolveFunArgs(FunUtil.java:1751) at mondrian.mdx.UnresolvedFunCall.accept(UnresolvedFunCall.java:91) at mondrian.olap.Query$StackValidator.validate(Query.java:1208) at mondrian.olap.QueryAxis.resolve(QueryAxis.java:201) at mondrian.olap.Query$StackValidator.validate(Query.java:1268) at mondrian.olap.Query.resolve(Query.java:570) at mondrian.olap.Query.resolve(Query.java:425) at mondrian.olap.Query.<init>(Query.java:220) at mondrian.olap.Query.<init>(Query.java:180) at mondrian.olap.Parser.makeQuery(Parser.java:846) at mondrian.olap.CUP$Parser$actions.CUP$Parser$do_action(Parser.java:1679) at mondrian.olap.Parser.do_action(Parser.java:680) at java_cup.runtime.lr_parser.parse(lr_parser.java:569) at mondrian.olap.Parser.parseInternal(Parser.java:750) ... 78 more Caused by: com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -440, SQLSTATE: 42884, SQLERRMC: UCASE;FUNCTION at com.ibm.db2.jcc.b.hh.c(hh.java:1662) at com.ibm.db2.jcc.b.hh.d(hh.java:1650) at com.ibm.db2.jcc.b.hh.a(hh.java:1219) at com.ibm.db2.jcc.c.db.g(db.java:139) at com.ibm.db2.jcc.c.db.a(db.java:39) at com.ibm.db2.jcc.c.t.a(t.java:34) at com.ibm.db2.jcc.c.sb.f(sb.java:142) at com.ibm.db2.jcc.b.hh.n(hh.java:1190) at com.ibm.db2.jcc.b.hh.a(hh.java:1902) at com.ibm.db2.jcc.b.hh.a(hh.java:491) at com.ibm.db2.jcc.b.hh.executeQuery(hh.java:475) at org.jboss.resource.adapter.jdbc.WrappedStatement.executeQuery(WrappedStatement.java:171) at mondrian.rolap.SqlStatement.execute(SqlStatement.java:124) ... 125 more 2008-04-16 19:27:21,199 ERROR [com.tonbeller.jpivot.mondrian.MondrianModel] DB2 SQL error: SQLCODE: -440, SQLSTATE: 42884, SQLERRMC: UCASE;FUNCTION 2008-04-16 19:27:21,199 ERROR [com.tonbeller.jpivot.tags.OlapModelProxy] com.tonbeller.jpivot.olap.model.OlapException: DB2 SQL error: SQLCODE: -440, SQLSTATE: 42884, SQLERRMC: UCASE;FUNCTION at com.tonbeller.jpivot.mondrian.MondrianModel.initialize(MondrianModel.java:499) at com.tonbeller.jpivot.olap.model.OlapModelDecorator.initialize(OlapModelDecorator.java:132) at com.tonbeller.jpivot.tags.OlapModelProxy$MyState.initialize(OlapModelProxy.java:77) at com.tonbeller.jpivot.tags.StackStateManager.initializeAndShow(StackStateManager.java:76) at com.tonbeller.jpivot.tags.OlapModelProxy.initializeAndShow(OlapModelProxy.java:160) at com.tonbeller.jpivot.tags.OlapModelTag.doEndTag(OlapModelTag.java:81) at org.apache.jsp.jsp.Pivot_jsp._jspService(Pivot_jsp.java:789) 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:387) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266) 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 org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264) 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.ui.switchuser.SwitchUserProcessingFilter.doFilter(SwitchUserProcessingFilter.java:335) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.pentaho.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:76) 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 org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:142) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.pentaho.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:164) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:178) 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 org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:108) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.pentaho.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:130) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:193) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:81) 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:98) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:139) at com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(RequestSynchronizer.java:127) at com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:263) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.core.system.SystemStatusFilter.doFilter(SystemStatusFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.ui.servlet.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:112) 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.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433) at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104) 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:241) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:580) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) at java.lang.Thread.run(Unknown Source) 2008-04-16 19:27:21,199 ERROR [com.tonbeller.jpivot.tags.OlapModelTag] com.tonbeller.jpivot.olap.model.OlapException: DB2 SQL error: SQLCODE: -440, SQLSTATE: 42884, SQLERRMC: UCASE;FUNCTION at com.tonbeller.jpivot.mondrian.MondrianModel.initialize(MondrianModel.java:499) at com.tonbeller.jpivot.olap.model.OlapModelDecorator.initialize(OlapModelDecorator.java:132) at com.tonbeller.jpivot.tags.OlapModelProxy$MyState.initialize(OlapModelProxy.java:77) at com.tonbeller.jpivot.tags.StackStateManager.initializeAndShow(StackStateManager.java:76) at com.tonbeller.jpivot.tags.OlapModelProxy.initializeAndShow(OlapModelProxy.java:160) at com.tonbeller.jpivot.tags.OlapModelTag.doEndTag(OlapModelTag.java:81) at org.apache.jsp.jsp.Pivot_jsp._jspService(Pivot_jsp.java:789) 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:387) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266) 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 org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264) 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.ui.switchuser.SwitchUserProcessingFilter.doFilter(SwitchUserProcessingFilter.java:335) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.pentaho.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:76) 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 org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:142) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.pentaho.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:164) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:178) 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 org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:108) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.pentaho.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:130) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:193) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:81) 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:98) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:139) at com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(RequestSynchronizer.java:127) at com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:263) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.core.system.SystemStatusFilter.doFilter(SystemStatusFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.ui.servlet.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:112) 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.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433) at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104) 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:241) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:580) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) at java.lang.Thread.run(Unknown Source) 2008-04-16 19:27:21,199 ERROR [STDERR] javax.servlet.jsp.JspException: com.tonbeller.jpivot.olap.model.OlapException: DB2 SQL error: SQLCODE: -440, SQLSTATE: 42884, SQLERRMC: UCASE;FUNCTION 2008-04-16 19:27:21,199 ERROR [STDERR] at com.tonbeller.jpivot.tags.OlapModelTag.doEndTag(OlapModelTag.java:86) 2008-04-16 19:27:21,199 ERROR [STDERR] at org.apache.jsp.jsp.Pivot_jsp._jspService(Pivot_jsp.java:789) 2008-04-16 19:27:21,199 ERROR [STDERR] at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) 2008-04-16 19:27:21,199 ERROR [STDERR] at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) 2008-04-16 19:27:21,199 ERROR [STDERR] at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:387) 2008-04-16 19:27:21,199 ERROR [STDERR] at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320) 2008-04-16 19:27:21,199 ERROR [STDERR] at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266) 2008-04-16 19:27:21,199 ERROR [STDERR] at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) 2008-04-16 19:27:21,199 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) 2008-04-16 19:27:21,199 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) 2008-04-16 19:27:21,199 ERROR [STDERR] at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264) 2008-04-16 19:27:21,199 ERROR [STDERR] at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107) 2008-04-16 19:27:21,199 ERROR [STDERR] at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72) 2008-04-16 19:27:21,199 ERROR [STDERR] at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) 2008-04-16 19:27:21,199 ERROR [STDERR] at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:110) 2008-04-16 19:27:21,199 ERROR [STDERR] at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) 2008-04-16 19:27:21,199 ERROR [STDERR] at org.acegisecurity.ui.switchuser.SwitchUserProcessingFilter.doFilter(SwitchUserProcessingFilter.java:335) 2008-04-16 19:27:21,199 ERROR [STDERR] at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) 2008-04-16 19:27:21,199 ERROR [STDERR] at com.pentaho.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:76) 2008-04-16 19:27:21,199 ERROR [STDERR] at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) 2008-04-16 19:27:21,199 ERROR [STDERR] at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125) 2008-04-16 19:27:21,199 ERROR [STDERR] at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) 2008-04-16 19:27:21,199 ERROR [STDERR] at org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:142) 2008-04-16 19:27:21,199 ERROR [STDERR] at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) 2008-04-16 19:27:21,199 ERROR [STDERR] at com.pentaho.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:164) 2008-04-16 19:27:21,199 ERROR [STDERR] at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) 2008-04-16 19:27:21,199 ERROR [STDERR] at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:178) 2008-04-16 19:27:21,199 ERROR [STDERR] at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) 2008-04-16 19:27:21,199 ERROR [STDERR] at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:217) 2008-04-16 19:27:21,199 ERROR [STDERR] at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) 2008-04-16 19:27:21,199 ERROR [STDERR] at org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:108) 2008-04-16 19:27:21,214 ERROR [STDERR] at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) 2008-04-16 19:27:21,214 ERROR [STDERR] at com.pentaho.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:130) 2008-04-16 19:27:21,214 ERROR [STDERR] at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) 2008-04-16 19:27:21,214 ERROR [STDERR] at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:193) 2008-04-16 19:27:21,214 ERROR [STDERR] at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) 2008-04-16 19:27:21,214 ERROR [STDERR] at org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:81) 2008-04-16 19:27:21,214 ERROR [STDERR] at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) 2008-04-16 19:27:21,214 ERROR [STDERR] at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:148) 2008-04-16 19:27:21,214 ERROR [STDERR] at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98) 2008-04-16 19:27:21,214 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) 2008-04-16 19:27:21,214 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) 2008-04-16 19:27:21,214 ERROR [STDERR] at com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:139) 2008-04-16 19:27:21,214 ERROR [STDERR] at com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(RequestSynchronizer.java:127) 2008-04-16 19:27:21,214 ERROR [STDERR] at com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:263) 2008-04-16 19:27:21,214 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) 2008-04-16 19:27:21,214 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) 2008-04-16 19:27:21,214 ERROR [STDERR] at org.pentaho.core.system.SystemStatusFilter.doFilter(SystemStatusFilter.java:53) 2008-04-16 19:27:21,214 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) 2008-04-16 19:27:21,214 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) 2008-04-16 19:27:21,214 ERROR [STDERR] at org.pentaho.ui.servlet.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:112) 2008-04-16 19:27:21,214 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) 2008-04-16 19:27:21,214 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) 2008-04-16 19:27:21,214 ERROR [STDERR] at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96) 2008-04-16 19:27:21,214 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) 2008-04-16 19:27:21,214 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) 2008-04-16 19:27:21,214 ERROR [STDERR] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230) 2008-04-16 19:27:21,214 ERROR [STDERR] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) 2008-04-16 19:27:21,214 ERROR [STDERR] at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:179) 2008-04-16 19:27:21,214 ERROR [STDERR] at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433) 2008-04-16 19:27:21,214 ERROR [STDERR] at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84) 2008-04-16 19:27:21,214 ERROR [STDERR] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) 2008-04-16 19:27:21,214 ERROR [STDERR] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104) 2008-04-16 19:27:21,214 ERROR [STDERR] at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157) 2008-04-16 19:27:21,214 ERROR [STDERR] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) 2008-04-16 19:27:21,214 ERROR [STDERR] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:241) 2008-04-16 19:27:21,214 ERROR [STDERR] at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844) 2008-04-16 19:27:21,214 ERROR [STDERR] at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:580) 2008-04-16 19:27:21,214 ERROR [STDERR] at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) 2008-04-16 19:27:21,214 ERROR [STDERR] at java.lang.Thread.run(Unknown Source) 2008-04-16 19:27:21,214 ERROR [STDERR] Caused by: com.tonbeller.jpivot.olap.model.OlapException: DB2 SQL error: SQLCODE: -440, SQLSTATE: 42884, SQLERRMC: UCASE;FUNCTION 2008-04-16 19:27:21,214 ERROR [STDERR] at com.tonbeller.jpivot.mondrian.MondrianModel.initialize(MondrianModel.java:499) 2008-04-16 19:27:21,214 ERROR [STDERR] at com.tonbeller.jpivot.olap.model.OlapModelDecorator.initialize(OlapModelDecorator.java:132) 2008-04-16 19:27:21,214 ERROR [STDERR] at com.tonbeller.jpivot.tags.OlapModelProxy$MyState.initialize(OlapModelProxy.java:77) 2008-04-16 19:27:21,214 ERROR [STDERR] at com.tonbeller.jpivot.tags.StackStateManager.initializeAndShow(StackStateManager.java:76) 2008-04-16 19:27:21,214 ERROR [STDERR] at com.tonbeller.jpivot.tags.OlapModelProxy.initializeAndShow(OlapModelProxy.java:160) 2008-04-16 19:27:21,214 ERROR [STDERR] at com.tonbeller.jpivot.tags.OlapModelTag.doEndTag(OlapModelTag.java:81) 2008-04-16 19:27:21,214 ERROR [STDERR] ... 69 more

    Pentaho BI Platform Tracking | 9 years ago | Klaus Mende
    mondrian.olap.MondrianException: Mondrian Error:Failed to parse query ' select NON EMPTY {[Measures].[COUNT of NL_ALL_SUBSCRIPTIONS.I_TOPIC_ID]} ON columns, NON EMPTY {([ZEIT.ZEIT].[ALL ZEIT], [THEMA.THEMA].[ALL THEMA])} ON rows from [NL_ALL] '
  2. 0

    Error in Mondrian component of BI-Server 1.6 GA (PCI MySQL) by using Data from DB2 9.5. 2008-04-16 19:27:21,183 ERROR [com.tonbeller.jpivot.mondrian.MondrianModel] Parse Failure mondrian.olap.MondrianException: Mondrian Error:Failed to parse query ' select NON EMPTY {[Measures].[COUNT of NL_ALL_SUBSCRIPTIONS.I_TOPIC_ID]} ON COLUMNS, NON EMPTY Hierarchize(Union(Crossjoin({[ZEIT.ZEIT].[ALL ZEIT]}, {[THEMA.THEMA].[ALL THEMA]}), Crossjoin({[ZEIT.ZEIT].[ALL ZEIT]}, [THEMA.THEMA].[ALL THEMA].Children))) ON ROWS from [NL_ALL] Description: I have created a cube with cube-Designer 0.7.2 an published it to the server. By using the xaction out of the solution-directorie, the console shows the errors (look at error-log 1, below) So I tried a new identical cube with the same data against a MySQL-DB. Everything works fine. Ok, there are some errors (ERROR [STDERR] Warning: Running an XSLT 1.0 stylesheet with an XSLT 2.0 processor), but it works! I read the threads in the community forum, where Julian dicribes the problems with the case-sensitivity in relationship with DB2. I corrected the cubedefiniton to uppercase. No effects. So at last I tried out an other MDX-statement, which I created with Jpivot and the running MySQL-Example. Again Error (see error-log 2 below) Can there be a bug in the parser? Thanks for helping me. (I didn´t find an opportunity to upload the cube-schema and xactions. So if you need them, please send me a mail) Klaus Mende PRORATIO GmbH kmende@proratio.de Error log 1: 2008-04-16 19:20:06,561 INFO [STDOUT] , failed (com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -440, SQLSTATE: 42884, SQLERRMC: UCASE;FUNCTION)SqlMemberSource.getMemberChildren: executing sql [select "NL_ALL_SUBSCRIPTIONS"."NL_Y_M_CREATED" as "c0" from "MVBBI"."NL_ALL_SUBSCRIPTIONS" as "NL_ALL_SUBSCRIPTIONS" where UCASE("NL_ALL_SUBSCRIPTIONS"."NL_Y_M_CREATED") = UCASE('THEMA.THEMA') group by "NL_ALL_SUBSCRIPTIONS"."NL_Y_M_CREATED" order by "NL_ALL_SUBSCRIPTIONS"."NL_Y_M_CREATED" ASC] 2008-04-16 19:20:06,812 INFO [STDOUT] , exec+fetch 251 ms, 0 rows 2008-04-16 19:20:06,812 ERROR [com.tonbeller.jpivot.mondrian.MondrianModel] Parse Failure mondrian.olap.MondrianException: Mondrian Error:Failed to parse query ' select NON EMPTY {[Measures].[COUNT of NL_ALL_SUBSCRIPTIONS.I_TOPIC_ID]} ON columns, NON EMPTY {([ZEIT.ZEIT].[ALL ZEIT], [THEMA.THEMA].[ALL THEMA])} ON rows from [NL_ALL] ' at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:755) at mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:77) at mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:59) at com.tonbeller.jpivot.mondrian.MondrianModel.parseMDX(MondrianModel.java:528) at com.tonbeller.jpivot.mondrian.MondrianModel.initialize(MondrianModel.java:495) at com.tonbeller.jpivot.olap.model.OlapModelDecorator.initialize(OlapModelDecorator.java:132) at com.tonbeller.jpivot.tags.OlapModelProxy$MyState.initialize(OlapModelProxy.java:77) at com.tonbeller.jpivot.tags.StackStateManager.initializeAndShow(StackStateManager.java:76) at com.tonbeller.jpivot.tags.OlapModelProxy.initializeAndShow(OlapModelProxy.java:160) at com.tonbeller.jpivot.tags.OlapModelTag.doEndTag(OlapModelTag.java:81) at org.apache.jsp.jsp.Pivot_jsp._jspService(Pivot_jsp.java:789) 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:387) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266) 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 org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264) 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.ui.switchuser.SwitchUserProcessingFilter.doFilter(SwitchUserProcessingFilter.java:335) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.pentaho.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:76) 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 org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:142) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.pentaho.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:164) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:178) 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 org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:108) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.pentaho.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:130) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:193) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:81) 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:98) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:139) at com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(RequestSynchronizer.java:127) at com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:263) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.core.system.SystemStatusFilter.doFilter(SystemStatusFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.ui.servlet.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:112) 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.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433) at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104) 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:241) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:580) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) at java.lang.Thread.run(Unknown Source) Caused by: mondrian.olap.MondrianException: Mondrian Error:Error while parsing MDX statement ' select NON EMPTY {[Measures].[COUNT of NL_ALL_SUBSCRIPTIONS.I_TOPIC_ID]} ON columns, NON EMPTY {([ZEIT.ZEIT].[ALL ZEIT], [THEMA.THEMA].[ALL THEMA])} ON rows from [NL_ALL] ' at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:755) at mondrian.olap.Parser.parseInternal(Parser.java:755) at mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:74) ... 77 more Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: while building member cache; sql=[select "NL_ALL_SUBSCRIPTIONS"."NL_Y_M_CREATED" as "c0" from "MVBBI"."NL_ALL_SUBSCRIPTIONS" as "NL_ALL_SUBSCRIPTIONS" where UCASE("NL_ALL_SUBSCRIPTIONS"."NL_Y_M_CREATED") = UCASE('THEMA.THEMA') group by "NL_ALL_SUBSCRIPTIONS"."NL_Y_M_CREATED" order by "NL_ALL_SUBSCRIPTIONS"."NL_Y_M_CREATED" ASC] at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:755) at mondrian.olap.Util.newInternal(Util.java:1175) at mondrian.olap.Util.newError(Util.java:1191) at mondrian.rolap.SqlStatement.handle(SqlStatement.java:208) 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.SqlMemberSource.getMemberChildren2(SqlMemberSource.java:711) at mondrian.rolap.SqlMemberSource.getMemberChildren(SqlMemberSource.java:641) at mondrian.rolap.SqlMemberSource.getMemberChildren(SqlMemberSource.java:616) at mondrian.rolap.SmartMemberReader.readMemberChildren(SmartMemberReader.java:280) at mondrian.rolap.SmartMemberReader.getMemberChildren(SmartMemberReader.java:245) at mondrian.rolap.SmartMemberReader.getMemberChildren(SmartMemberReader.java:212) at mondrian.rolap.RolapSchemaReader.internalGetMemberChildren(RolapSchemaReader.java:151) at mondrian.rolap.RolapSchemaReader.lookupMemberChildByName(RolapSchemaReader.java:322) at mondrian.olap.Util.lookupHierarchyRootMember(Util.java:916) at mondrian.olap.HierarchyBase.lookupChild(HierarchyBase.java:121) at mondrian.olap.DimensionBase.lookupChild(DimensionBase.java:102) at mondrian.olap.CubeBase.lookupChild(CubeBase.java:115) at mondrian.rolap.RolapCube.lookupChild(RolapCube.java:2221) at mondrian.rolap.RolapSchemaReader.getElementChild(RolapSchemaReader.java:254) at mondrian.olap.Util.lookupCompound(Util.java:576) at mondrian.rolap.RolapSchemaReader.lookupCompound(RolapSchemaReader.java:303) at mondrian.olap.DelegatingSchemaReader.lookupCompound(DelegatingSchemaReader.java:105) at mondrian.olap.Query$QuerySchemaReader.lookupCompound(Query.java:1542) at mondrian.olap.Query$QuerySchemaReader.lookupCompound(Query.java:1509) at mondrian.olap.Util.lookup(Util.java:733) at mondrian.olap.Id.accept(Id.java:111) at mondrian.olap.Query$StackValidator.validate(Query.java:1208) at mondrian.olap.fun.FunUtil.resolveFunArgs(FunUtil.java:1751) at mondrian.mdx.UnresolvedFunCall.accept(UnresolvedFunCall.java:91) at mondrian.olap.Query$StackValidator.validate(Query.java:1208) at mondrian.olap.fun.FunUtil.resolveFunArgs(FunUtil.java:1751) at mondrian.mdx.UnresolvedFunCall.accept(UnresolvedFunCall.java:91) at mondrian.olap.Query$StackValidator.validate(Query.java:1208) at mondrian.olap.QueryAxis.resolve(QueryAxis.java:201) at mondrian.olap.Query$StackValidator.validate(Query.java:1268) at mondrian.olap.Query.resolve(Query.java:570) at mondrian.olap.Query.resolve(Query.java:425) at mondrian.olap.Query.<init>(Query.java:220) at mondrian.olap.Query.<init>(Query.java:180) at mondrian.olap.Parser.makeQuery(Parser.java:846) at mondrian.olap.CUP$Parser$actions.CUP$Parser$do_action(Parser.java:1679) at mondrian.olap.Parser.do_action(Parser.java:680) at java_cup.runtime.lr_parser.parse(lr_parser.java:569) at mondrian.olap.Parser.parseInternal(Parser.java:750) ... 78 more Caused by: com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -440, SQLSTATE: 42884, SQLERRMC: UCASE;FUNCTION at com.ibm.db2.jcc.b.hh.c(hh.java:1662) at com.ibm.db2.jcc.b.hh.d(hh.java:1650) at com.ibm.db2.jcc.b.hh.a(hh.java:1219) at com.ibm.db2.jcc.c.db.g(db.java:139) at com.ibm.db2.jcc.c.db.a(db.java:39) at com.ibm.db2.jcc.c.t.a(t.java:34) at com.ibm.db2.jcc.c.sb.f(sb.java:142) at com.ibm.db2.jcc.b.hh.n(hh.java:1190) at com.ibm.db2.jcc.b.hh.a(hh.java:1902) at com.ibm.db2.jcc.b.hh.a(hh.java:491) at com.ibm.db2.jcc.b.hh.executeQuery(hh.java:475) at org.jboss.resource.adapter.jdbc.WrappedStatement.executeQuery(WrappedStatement.java:171) at mondrian.rolap.SqlStatement.execute(SqlStatement.java:124) ... 119 more 2008-04-16 19:20:06,827 ERROR [com.tonbeller.jpivot.mondrian.MondrianModel] DB2 SQL error: SQLCODE: -440, SQLSTATE: 42884, SQLERRMC: UCASE;FUNCTION 2008-04-16 19:20:06,827 ERROR [com.tonbeller.jpivot.tags.OlapModelProxy] com.tonbeller.jpivot.olap.model.OlapException: DB2 SQL error: SQLCODE: -440, SQLSTATE: 42884, SQLERRMC: UCASE;FUNCTION at com.tonbeller.jpivot.mondrian.MondrianModel.initialize(MondrianModel.java:499) at com.tonbeller.jpivot.olap.model.OlapModelDecorator.initialize(OlapModelDecorator.java:132) at com.tonbeller.jpivot.tags.OlapModelProxy$MyState.initialize(OlapModelProxy.java:77) at com.tonbeller.jpivot.tags.StackStateManager.initializeAndShow(StackStateManager.java:76) at com.tonbeller.jpivot.tags.OlapModelProxy.initializeAndShow(OlapModelProxy.java:160) at com.tonbeller.jpivot.tags.OlapModelTag.doEndTag(OlapModelTag.java:81) at org.apache.jsp.jsp.Pivot_jsp._jspService(Pivot_jsp.java:789) 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:387) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266) 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 org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264) 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.ui.switchuser.SwitchUserProcessingFilter.doFilter(SwitchUserProcessingFilter.java:335) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.pentaho.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:76) 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 org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:142) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.pentaho.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:164) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:178) 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 org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:108) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.pentaho.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:130) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:193) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:81) 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:98) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:139) at com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(RequestSynchronizer.java:127) at com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:263) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.core.system.SystemStatusFilter.doFilter(SystemStatusFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.ui.servlet.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:112) 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.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433) at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104) 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:241) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:580) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) at java.lang.Thread.run(Unknown Source) 2008-04-16 19:20:06,827 ERROR [com.tonbeller.jpivot.tags.OlapModelTag] com.tonbeller.jpivot.olap.model.OlapException: DB2 SQL error: SQLCODE: -440, SQLSTATE: 42884, SQLERRMC: UCASE;FUNCTION at com.tonbeller.jpivot.mondrian.MondrianModel.initialize(MondrianModel.java:499) at com.tonbeller.jpivot.olap.model.OlapModelDecorator.initialize(OlapModelDecorator.java:132) at com.tonbeller.jpivot.tags.OlapModelProxy$MyState.initialize(OlapModelProxy.java:77) at com.tonbeller.jpivot.tags.StackStateManager.initializeAndShow(StackStateManager.java:76) at com.tonbeller.jpivot.tags.OlapModelProxy.initializeAndShow(OlapModelProxy.java:160) at com.tonbeller.jpivot.tags.OlapModelTag.doEndTag(OlapModelTag.java:81) at org.apache.jsp.jsp.Pivot_jsp._jspService(Pivot_jsp.java:789) 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:387) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266) 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 org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264) 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.ui.switchuser.SwitchUserProcessingFilter.doFilter(SwitchUserProcessingFilter.java:335) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.pentaho.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:76) 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 org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:142) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.pentaho.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:164) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:178) 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 org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:108) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.pentaho.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:130) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:193) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:81) 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:98) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:139) at com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(RequestSynchronizer.java:127) at com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:263) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.core.system.SystemStatusFilter.doFilter(SystemStatusFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.ui.servlet.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:112) 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.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433) at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104) 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:241) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:580) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) at java.lang.Thread.run(Unknown Source) 2008-04-16 19:20:06,827 ERROR [STDERR] javax.servlet.jsp.JspException: com.tonbeller.jpivot.olap.model.OlapException: DB2 SQL error: SQLCODE: -440, SQLSTATE: 42884, SQLERRMC: UCASE;FUNCTION 2008-04-16 19:20:06,827 ERROR [STDERR] at com.tonbeller.jpivot.tags.OlapModelTag.doEndTag(OlapModelTag.java:86) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.apache.jsp.jsp.Pivot_jsp._jspService(Pivot_jsp.java:789) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) 2008-04-16 19:20:06,827 ERROR [STDERR] at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:387) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266) 2008-04-16 19:20:06,827 ERROR [STDERR] at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:110) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.acegisecurity.ui.switchuser.SwitchUserProcessingFilter.doFilter(SwitchUserProcessingFilter.java:335) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) 2008-04-16 19:20:06,827 ERROR [STDERR] at com.pentaho.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:76) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:142) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) 2008-04-16 19:20:06,827 ERROR [STDERR] at com.pentaho.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:164) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:178) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:217) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:108) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) 2008-04-16 19:20:06,827 ERROR [STDERR] at com.pentaho.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:130) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:193) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:81) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:148) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) 2008-04-16 19:20:06,827 ERROR [STDERR] at com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:139) 2008-04-16 19:20:06,827 ERROR [STDERR] at com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(RequestSynchronizer.java:127) 2008-04-16 19:20:06,827 ERROR [STDERR] at com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:263) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.pentaho.core.system.SystemStatusFilter.doFilter(SystemStatusFilter.java:53) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.pentaho.ui.servlet.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:112) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:179) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:241) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:580) 2008-04-16 19:20:06,827 ERROR [STDERR] at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) 2008-04-16 19:20:06,827 ERROR [STDERR] at java.lang.Thread.run(Unknown Source) 2008-04-16 19:20:06,827 ERROR [STDERR] Caused by: com.tonbeller.jpivot.olap.model.OlapException: DB2 SQL error: SQLCODE: -440, SQLSTATE: 42884, SQLERRMC: UCASE;FUNCTION 2008-04-16 19:20:06,827 ERROR [STDERR] at com.tonbeller.jpivot.mondrian.MondrianModel.initialize(MondrianModel.java:499) 2008-04-16 19:20:06,827 ERROR [STDERR] at com.tonbeller.jpivot.olap.model.OlapModelDecorator.initialize(OlapModelDecorator.java:132) 2008-04-16 19:20:06,827 ERROR [STDERR] at com.tonbeller.jpivot.tags.OlapModelProxy$MyState.initialize(OlapModelProxy.java:77) 2008-04-16 19:20:06,827 ERROR [STDERR] at com.tonbeller.jpivot.tags.StackStateManager.initializeAndShow(StackStateManager.java:76) 2008-04-16 19:20:06,827 ERROR [STDERR] at com.tonbeller.jpivot.tags.OlapModelProxy.initializeAndShow(OlapModelProxy.java:160) 2008-04-16 19:20:06,827 ERROR [STDERR] at com.tonbeller.jpivot.tags.OlapModelTag.doEndTag(OlapModelTag.java:81) 2008-04-16 19:20:06,827 ERROR [STDERR] ... 69 more Error log 2: 2008-04-16 19:27:21,183 INFO [STDOUT] SqlMemberSource.getMemberChildren: executing sql [select "NL_ALL_SUBSCRIPTIONS"."NL_Y_M_CREATED" as "c0" from "MVBBI"."NL_ALL_SUBSCRIPTIONS" as "NL_ALL_SUBSCRIPTIONS" where UCASE("NL_ALL_SUBSCRIPTIONS"."NL_Y_M_CREATED") = UCASE('THEMA.THEMA') group by "NL_ALL_SUBSCRIPTIONS"."NL_Y_M_CREATED" order by "NL_ALL_SUBSCRIPTIONS"."NL_Y_M_CREATED" ASC] 2008-04-16 19:27:21,183 INFO [STDOUT] , exec+fetch 0 ms, 0 rows 2008-04-16 19:27:21,183 ERROR [com.tonbeller.jpivot.mondrian.MondrianModel] Parse Failure mondrian.olap.MondrianException: Mondrian Error:Failed to parse query ' select NON EMPTY {[Measures].[COUNT of NL_ALL_SUBSCRIPTIONS.I_TOPIC_ID]} ON COLUMNS, NON EMPTY Hierarchize(Union(Crossjoin({[ZEIT.ZEIT].[ALL ZEIT]}, {[THEMA.THEMA].[ALL THEMA]}), Crossjoin({[ZEIT.ZEIT].[ALL ZEIT]}, [THEMA.THEMA].[ALL THEMA].Children))) ON ROWS from [NL_ALL] ' at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:755) at mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:77) at mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:59) at com.tonbeller.jpivot.mondrian.MondrianModel.parseMDX(MondrianModel.java:528) at com.tonbeller.jpivot.mondrian.MondrianModel.initialize(MondrianModel.java:495) at com.tonbeller.jpivot.olap.model.OlapModelDecorator.initialize(OlapModelDecorator.java:132) at com.tonbeller.jpivot.tags.OlapModelProxy$MyState.initialize(OlapModelProxy.java:77) at com.tonbeller.jpivot.tags.StackStateManager.initializeAndShow(StackStateManager.java:76) at com.tonbeller.jpivot.tags.OlapModelProxy.initializeAndShow(OlapModelProxy.java:160) at com.tonbeller.jpivot.tags.OlapModelTag.doEndTag(OlapModelTag.java:81) at org.apache.jsp.jsp.Pivot_jsp._jspService(Pivot_jsp.java:789) 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:387) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266) 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 org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264) 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.ui.switchuser.SwitchUserProcessingFilter.doFilter(SwitchUserProcessingFilter.java:335) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.pentaho.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:76) 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 org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:142) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.pentaho.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:164) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:178) 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 org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:108) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.pentaho.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:130) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:193) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:81) 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:98) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:139) at com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(RequestSynchronizer.java:127) at com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:263) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.core.system.SystemStatusFilter.doFilter(SystemStatusFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.ui.servlet.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:112) 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.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433) at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104) 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:241) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:580) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) at java.lang.Thread.run(Unknown Source) Caused by: mondrian.olap.MondrianException: Mondrian Error:Error while parsing MDX statement ' select NON EMPTY {[Measures].[COUNT of NL_ALL_SUBSCRIPTIONS.I_TOPIC_ID]} ON COLUMNS, NON EMPTY Hierarchize(Union(Crossjoin({[ZEIT.ZEIT].[ALL ZEIT]}, {[THEMA.THEMA].[ALL THEMA]}), Crossjoin({[ZEIT.ZEIT].[ALL ZEIT]}, [THEMA.THEMA].[ALL THEMA].Children))) ON ROWS from [NL_ALL] ' at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:755) at mondrian.olap.Parser.parseInternal(Parser.java:755) at mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:74) ... 77 more Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: while building member cache; sql=[select "NL_ALL_SUBSCRIPTIONS"."NL_Y_M_CREATED" as "c0" from "MVBBI"."NL_ALL_SUBSCRIPTIONS" as "NL_ALL_SUBSCRIPTIONS" where UCASE("NL_ALL_SUBSCRIPTIONS"."NL_Y_M_CREATED") = UCASE('THEMA.THEMA') group by "NL_ALL_SUBSCRIPTIONS"."NL_Y_M_CREATED" order by "NL_ALL_SUBSCRIPTIONS"."NL_Y_M_CREATED" ASC] at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:755) at mondrian.olap.Util.newInternal(Util.java:1175) at mondrian.olap.Util.newError(Util.java:1191) at mondrian.rolap.SqlStatement.handle(SqlStatement.java:208) 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.SqlMemberSource.getMemberChildren2(SqlMemberSource.java:711) at mondrian.rolap.SqlMemberSource.getMemberChildren(SqlMemberSource.java:641) at mondrian.rolap.SqlMemberSource.getMemberChildren(SqlMemberSource.java:616) at mondrian.rolap.SmartMemberReader.readMemberChildren(SmartMemberReader.java:280) at mondrian.rolap.SmartMemberReader.getMemberChildren(SmartMemberReader.java:245) at mondrian.rolap.SmartMemberReader.getMemberChildren(SmartMemberReader.java:212) at mondrian.rolap.RolapSchemaReader.internalGetMemberChildren(RolapSchemaReader.java:151) at mondrian.rolap.RolapSchemaReader.lookupMemberChildByName(RolapSchemaReader.java:322) at mondrian.olap.Util.lookupHierarchyRootMember(Util.java:916) at mondrian.olap.HierarchyBase.lookupChild(HierarchyBase.java:121) at mondrian.olap.DimensionBase.lookupChild(DimensionBase.java:102) at mondrian.olap.CubeBase.lookupChild(CubeBase.java:115) at mondrian.rolap.RolapCube.lookupChild(RolapCube.java:2221) at mondrian.rolap.RolapSchemaReader.getElementChild(RolapSchemaReader.java:254) at mondrian.olap.Util.lookupCompound(Util.java:576) at mondrian.rolap.RolapSchemaReader.lookupCompound(RolapSchemaReader.java:303) at mondrian.olap.DelegatingSchemaReader.lookupCompound(DelegatingSchemaReader.java:105) at mondrian.olap.Query$QuerySchemaReader.lookupCompound(Query.java:1542) at mondrian.olap.Query$QuerySchemaReader.lookupCompound(Query.java:1509) at mondrian.olap.Util.lookup(Util.java:733) at mondrian.olap.Id.accept(Id.java:111) at mondrian.olap.Query$StackValidator.validate(Query.java:1208) at mondrian.olap.fun.FunUtil.resolveFunArgs(FunUtil.java:1751) at mondrian.mdx.UnresolvedFunCall.accept(UnresolvedFunCall.java:91) at mondrian.olap.Query$StackValidator.validate(Query.java:1208) at mondrian.olap.fun.FunUtil.resolveFunArgs(FunUtil.java:1751) at mondrian.mdx.UnresolvedFunCall.accept(UnresolvedFunCall.java:91) at mondrian.olap.Query$StackValidator.validate(Query.java:1208) at mondrian.olap.fun.FunUtil.resolveFunArgs(FunUtil.java:1751) at mondrian.mdx.UnresolvedFunCall.accept(UnresolvedFunCall.java:91) at mondrian.olap.Query$StackValidator.validate(Query.java:1208) at mondrian.olap.fun.FunUtil.resolveFunArgs(FunUtil.java:1751) at mondrian.mdx.UnresolvedFunCall.accept(UnresolvedFunCall.java:91) at mondrian.olap.Query$StackValidator.validate(Query.java:1208) at mondrian.olap.QueryAxis.resolve(QueryAxis.java:201) at mondrian.olap.Query$StackValidator.validate(Query.java:1268) at mondrian.olap.Query.resolve(Query.java:570) at mondrian.olap.Query.resolve(Query.java:425) at mondrian.olap.Query.<init>(Query.java:220) at mondrian.olap.Query.<init>(Query.java:180) at mondrian.olap.Parser.makeQuery(Parser.java:846) at mondrian.olap.CUP$Parser$actions.CUP$Parser$do_action(Parser.java:1679) at mondrian.olap.Parser.do_action(Parser.java:680) at java_cup.runtime.lr_parser.parse(lr_parser.java:569) at mondrian.olap.Parser.parseInternal(Parser.java:750) ... 78 more Caused by: com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -440, SQLSTATE: 42884, SQLERRMC: UCASE;FUNCTION at com.ibm.db2.jcc.b.hh.c(hh.java:1662) at com.ibm.db2.jcc.b.hh.d(hh.java:1650) at com.ibm.db2.jcc.b.hh.a(hh.java:1219) at com.ibm.db2.jcc.c.db.g(db.java:139) at com.ibm.db2.jcc.c.db.a(db.java:39) at com.ibm.db2.jcc.c.t.a(t.java:34) at com.ibm.db2.jcc.c.sb.f(sb.java:142) at com.ibm.db2.jcc.b.hh.n(hh.java:1190) at com.ibm.db2.jcc.b.hh.a(hh.java:1902) at com.ibm.db2.jcc.b.hh.a(hh.java:491) at com.ibm.db2.jcc.b.hh.executeQuery(hh.java:475) at org.jboss.resource.adapter.jdbc.WrappedStatement.executeQuery(WrappedStatement.java:171) at mondrian.rolap.SqlStatement.execute(SqlStatement.java:124) ... 125 more 2008-04-16 19:27:21,199 ERROR [com.tonbeller.jpivot.mondrian.MondrianModel] DB2 SQL error: SQLCODE: -440, SQLSTATE: 42884, SQLERRMC: UCASE;FUNCTION 2008-04-16 19:27:21,199 ERROR [com.tonbeller.jpivot.tags.OlapModelProxy] com.tonbeller.jpivot.olap.model.OlapException: DB2 SQL error: SQLCODE: -440, SQLSTATE: 42884, SQLERRMC: UCASE;FUNCTION at com.tonbeller.jpivot.mondrian.MondrianModel.initialize(MondrianModel.java:499) at com.tonbeller.jpivot.olap.model.OlapModelDecorator.initialize(OlapModelDecorator.java:132) at com.tonbeller.jpivot.tags.OlapModelProxy$MyState.initialize(OlapModelProxy.java:77) at com.tonbeller.jpivot.tags.StackStateManager.initializeAndShow(StackStateManager.java:76) at com.tonbeller.jpivot.tags.OlapModelProxy.initializeAndShow(OlapModelProxy.java:160) at com.tonbeller.jpivot.tags.OlapModelTag.doEndTag(OlapModelTag.java:81) at org.apache.jsp.jsp.Pivot_jsp._jspService(Pivot_jsp.java:789) 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:387) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266) 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 org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264) 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.ui.switchuser.SwitchUserProcessingFilter.doFilter(SwitchUserProcessingFilter.java:335) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.pentaho.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:76) 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 org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:142) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.pentaho.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:164) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:178) 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 org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:108) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.pentaho.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:130) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:193) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:81) 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:98) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:139) at com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(RequestSynchronizer.java:127) at com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:263) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.core.system.SystemStatusFilter.doFilter(SystemStatusFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.ui.servlet.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:112) 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.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433) at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104) 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:241) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:580) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) at java.lang.Thread.run(Unknown Source) 2008-04-16 19:27:21,199 ERROR [com.tonbeller.jpivot.tags.OlapModelTag] com.tonbeller.jpivot.olap.model.OlapException: DB2 SQL error: SQLCODE: -440, SQLSTATE: 42884, SQLERRMC: UCASE;FUNCTION at com.tonbeller.jpivot.mondrian.MondrianModel.initialize(MondrianModel.java:499) at com.tonbeller.jpivot.olap.model.OlapModelDecorator.initialize(OlapModelDecorator.java:132) at com.tonbeller.jpivot.tags.OlapModelProxy$MyState.initialize(OlapModelProxy.java:77) at com.tonbeller.jpivot.tags.StackStateManager.initializeAndShow(StackStateManager.java:76) at com.tonbeller.jpivot.tags.OlapModelProxy.initializeAndShow(OlapModelProxy.java:160) at com.tonbeller.jpivot.tags.OlapModelTag.doEndTag(OlapModelTag.java:81) at org.apache.jsp.jsp.Pivot_jsp._jspService(Pivot_jsp.java:789) 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:387) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266) 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 org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264) 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.ui.switchuser.SwitchUserProcessingFilter.doFilter(SwitchUserProcessingFilter.java:335) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.pentaho.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:76) 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 org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:142) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.pentaho.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:164) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:178) 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 org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:108) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.pentaho.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:130) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:193) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:81) 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:98) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:139) at com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(RequestSynchronizer.java:127) at com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:263) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.core.system.SystemStatusFilter.doFilter(SystemStatusFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.ui.servlet.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:112) 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.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433) at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104) 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:241) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:580) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) at java.lang.Thread.run(Unknown Source) 2008-04-16 19:27:21,199 ERROR [STDERR] javax.servlet.jsp.JspException: com.tonbeller.jpivot.olap.model.OlapException: DB2 SQL error: SQLCODE: -440, SQLSTATE: 42884, SQLERRMC: UCASE;FUNCTION 2008-04-16 19:27:21,199 ERROR [STDERR] at com.tonbeller.jpivot.tags.OlapModelTag.doEndTag(OlapModelTag.java:86) 2008-04-16 19:27:21,199 ERROR [STDERR] at org.apache.jsp.jsp.Pivot_jsp._jspService(Pivot_jsp.java:789) 2008-04-16 19:27:21,199 ERROR [STDERR] at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) 2008-04-16 19:27:21,199 ERROR [STDERR] at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) 2008-04-16 19:27:21,199 ERROR [STDERR] at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:387) 2008-04-16 19:27:21,199 ERROR [STDERR] at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320) 2008-04-16 19:27:21,199 ERROR [STDERR] at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266) 2008-04-16 19:27:21,199 ERROR [STDERR] at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) 2008-04-16 19:27:21,199 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) 2008-04-16 19:27:21,199 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) 2008-04-16 19:27:21,199 ERROR [STDERR] at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264) 2008-04-16 19:27:21,199 ERROR [STDERR] at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107) 2008-04-16 19:27:21,199 ERROR [STDERR] at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72) 2008-04-16 19:27:21,199 ERROR [STDERR] at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) 2008-04-16 19:27:21,199 ERROR [STDERR] at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:110) 2008-04-16 19:27:21,199 ERROR [STDERR] at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) 2008-04-16 19:27:21,199 ERROR [STDERR] at org.acegisecurity.ui.switchuser.SwitchUserProcessingFilter.doFilter(SwitchUserProcessingFilter.java:335) 2008-04-16 19:27:21,199 ERROR [STDERR] at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) 2008-04-16 19:27:21,199 ERROR [STDERR] at com.pentaho.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:76) 2008-04-16 19:27:21,199 ERROR [STDERR] at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) 2008-04-16 19:27:21,199 ERROR [STDERR] at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125) 2008-04-16 19:27:21,199 ERROR [STDERR] at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) 2008-04-16 19:27:21,199 ERROR [STDERR] at org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:142) 2008-04-16 19:27:21,199 ERROR [STDERR] at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) 2008-04-16 19:27:21,199 ERROR [STDERR] at com.pentaho.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:164) 2008-04-16 19:27:21,199 ERROR [STDERR] at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) 2008-04-16 19:27:21,199 ERROR [STDERR] at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:178) 2008-04-16 19:27:21,199 ERROR [STDERR] at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) 2008-04-16 19:27:21,199 ERROR [STDERR] at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:217) 2008-04-16 19:27:21,199 ERROR [STDERR] at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) 2008-04-16 19:27:21,199 ERROR [STDERR] at org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:108) 2008-04-16 19:27:21,214 ERROR [STDERR] at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) 2008-04-16 19:27:21,214 ERROR [STDERR] at com.pentaho.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:130) 2008-04-16 19:27:21,214 ERROR [STDERR] at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) 2008-04-16 19:27:21,214 ERROR [STDERR] at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:193) 2008-04-16 19:27:21,214 ERROR [STDERR] at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) 2008-04-16 19:27:21,214 ERROR [STDERR] at org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:81) 2008-04-16 19:27:21,214 ERROR [STDERR] at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) 2008-04-16 19:27:21,214 ERROR [STDERR] at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:148) 2008-04-16 19:27:21,214 ERROR [STDERR] at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98) 2008-04-16 19:27:21,214 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) 2008-04-16 19:27:21,214 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) 2008-04-16 19:27:21,214 ERROR [STDERR] at com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:139) 2008-04-16 19:27:21,214 ERROR [STDERR] at com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(RequestSynchronizer.java:127) 2008-04-16 19:27:21,214 ERROR [STDERR] at com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:263) 2008-04-16 19:27:21,214 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) 2008-04-16 19:27:21,214 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) 2008-04-16 19:27:21,214 ERROR [STDERR] at org.pentaho.core.system.SystemStatusFilter.doFilter(SystemStatusFilter.java:53) 2008-04-16 19:27:21,214 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) 2008-04-16 19:27:21,214 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) 2008-04-16 19:27:21,214 ERROR [STDERR] at org.pentaho.ui.servlet.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:112) 2008-04-16 19:27:21,214 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) 2008-04-16 19:27:21,214 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) 2008-04-16 19:27:21,214 ERROR [STDERR] at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96) 2008-04-16 19:27:21,214 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) 2008-04-16 19:27:21,214 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) 2008-04-16 19:27:21,214 ERROR [STDERR] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230) 2008-04-16 19:27:21,214 ERROR [STDERR] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) 2008-04-16 19:27:21,214 ERROR [STDERR] at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:179) 2008-04-16 19:27:21,214 ERROR [STDERR] at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433) 2008-04-16 19:27:21,214 ERROR [STDERR] at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84) 2008-04-16 19:27:21,214 ERROR [STDERR] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) 2008-04-16 19:27:21,214 ERROR [STDERR] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104) 2008-04-16 19:27:21,214 ERROR [STDERR] at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157) 2008-04-16 19:27:21,214 ERROR [STDERR] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) 2008-04-16 19:27:21,214 ERROR [STDERR] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:241) 2008-04-16 19:27:21,214 ERROR [STDERR] at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844) 2008-04-16 19:27:21,214 ERROR [STDERR] at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:580) 2008-04-16 19:27:21,214 ERROR [STDERR] at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) 2008-04-16 19:27:21,214 ERROR [STDERR] at java.lang.Thread.run(Unknown Source) 2008-04-16 19:27:21,214 ERROR [STDERR] Caused by: com.tonbeller.jpivot.olap.model.OlapException: DB2 SQL error: SQLCODE: -440, SQLSTATE: 42884, SQLERRMC: UCASE;FUNCTION 2008-04-16 19:27:21,214 ERROR [STDERR] at com.tonbeller.jpivot.mondrian.MondrianModel.initialize(MondrianModel.java:499) 2008-04-16 19:27:21,214 ERROR [STDERR] at com.tonbeller.jpivot.olap.model.OlapModelDecorator.initialize(OlapModelDecorator.java:132) 2008-04-16 19:27:21,214 ERROR [STDERR] at com.tonbeller.jpivot.tags.OlapModelProxy$MyState.initialize(OlapModelProxy.java:77) 2008-04-16 19:27:21,214 ERROR [STDERR] at com.tonbeller.jpivot.tags.StackStateManager.initializeAndShow(StackStateManager.java:76) 2008-04-16 19:27:21,214 ERROR [STDERR] at com.tonbeller.jpivot.tags.OlapModelProxy.initializeAndShow(OlapModelProxy.java:160) 2008-04-16 19:27:21,214 ERROR [STDERR] at com.tonbeller.jpivot.tags.OlapModelTag.doEndTag(OlapModelTag.java:81) 2008-04-16 19:27:21,214 ERROR [STDERR] ... 69 more

    Pentaho BI Platform Tracking | 9 years ago | Klaus Mende
    mondrian.olap.MondrianException: Mondrian Error:Failed to parse query ' select NON EMPTY {[Measures].[COUNT of NL_ALL_SUBSCRIPTIONS.I_TOPIC_ID]} ON columns, NON EMPTY {([ZEIT.ZEIT].[ALL ZEIT], [THEMA.THEMA].[ALL THEMA])} ON rows from [NL_ALL] '
  3. Speed up your debug routine!

    Automated exception search integrated into your IDE

  4. 0

    Portal to 6.0.1.3 Database transfer fail in action-add-constraints

    Google Groups | 9 years ago | Gustavo Rojas
    com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704, SQLERRMC: CUSTOMIZATION.APPLICATION_ROLE
  5. 0

    Re: Portal 6.0 trasfering the databases from Cloudscape to DB2 --- running long time

    Google Groups | 10 years ago | gabrie...@sdhc.k12.fl.us
    com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -471, SQLSTATE: 55023, SQLERRMC: SYSIBM.SQLTABLES;00E7900C

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. com.ibm.db2.jcc.b.SqlException

      DB2 SQL error: SQLCODE: -440, SQLSTATE: 42884, SQLERRMC: UCASE;FUNCTION

      at com.ibm.db2.jcc.b.hh.c()
    2. com.ibm.db2
      hh.executeQuery
      1. com.ibm.db2.jcc.b.hh.c(hh.java:1662)
      2. com.ibm.db2.jcc.b.hh.d(hh.java:1650)
      3. com.ibm.db2.jcc.b.hh.a(hh.java:1219)
      4. com.ibm.db2.jcc.c.db.g(db.java:139)
      5. com.ibm.db2.jcc.c.db.a(db.java:39)
      6. com.ibm.db2.jcc.c.t.a(t.java:34)
      7. com.ibm.db2.jcc.c.sb.f(sb.java:142)
      8. com.ibm.db2.jcc.b.hh.n(hh.java:1190)
      9. com.ibm.db2.jcc.b.hh.a(hh.java:1902)
      10. com.ibm.db2.jcc.b.hh.a(hh.java:491)
      11. com.ibm.db2.jcc.b.hh.executeQuery(hh.java:475)
      11 frames
    3. JBoss Application Server Connector
      WrappedStatement.executeQuery
      1. org.jboss.resource.adapter.jdbc.WrappedStatement.executeQuery(WrappedStatement.java:171)
      1 frame
    4. mondrian.rolap
      RolapSchemaReader.lookupMemberChildByName
      1. mondrian.rolap.SqlStatement.execute(SqlStatement.java:124)
      2. mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:285)
      3. mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:246)
      4. mondrian.rolap.SqlMemberSource.getMemberChildren2(SqlMemberSource.java:711)
      5. mondrian.rolap.SqlMemberSource.getMemberChildren(SqlMemberSource.java:641)
      6. mondrian.rolap.SqlMemberSource.getMemberChildren(SqlMemberSource.java:616)
      7. mondrian.rolap.SmartMemberReader.readMemberChildren(SmartMemberReader.java:280)
      8. mondrian.rolap.SmartMemberReader.getMemberChildren(SmartMemberReader.java:245)
      9. mondrian.rolap.SmartMemberReader.getMemberChildren(SmartMemberReader.java:212)
      10. mondrian.rolap.RolapSchemaReader.internalGetMemberChildren(RolapSchemaReader.java:151)
      11. mondrian.rolap.RolapSchemaReader.lookupMemberChildByName(RolapSchemaReader.java:322)
      11 frames
    5. mondrian.olap
      CubeBase.lookupChild
      1. mondrian.olap.Util.lookupHierarchyRootMember(Util.java:916)
      2. mondrian.olap.HierarchyBase.lookupChild(HierarchyBase.java:121)
      3. mondrian.olap.DimensionBase.lookupChild(DimensionBase.java:102)
      4. mondrian.olap.CubeBase.lookupChild(CubeBase.java:115)
      4 frames
    6. mondrian.rolap
      RolapSchemaReader.getElementChild
      1. mondrian.rolap.RolapCube.lookupChild(RolapCube.java:2221)
      2. mondrian.rolap.RolapSchemaReader.getElementChild(RolapSchemaReader.java:254)
      2 frames
    7. mondrian.olap
      Util.lookupCompound
      1. mondrian.olap.Util.lookupCompound(Util.java:576)
      1 frame
    8. mondrian.rolap
      RolapSchemaReader.lookupCompound
      1. mondrian.rolap.RolapSchemaReader.lookupCompound(RolapSchemaReader.java:303)
      1 frame
    9. mondrian.olap
      Query$StackValidator.validate
      1. mondrian.olap.DelegatingSchemaReader.lookupCompound(DelegatingSchemaReader.java:105)
      2. mondrian.olap.Query$QuerySchemaReader.lookupCompound(Query.java:1542)
      3. mondrian.olap.Query$QuerySchemaReader.lookupCompound(Query.java:1509)
      4. mondrian.olap.Util.lookup(Util.java:733)
      5. mondrian.olap.Id.accept(Id.java:111)
      6. mondrian.olap.Query$StackValidator.validate(Query.java:1208)
      6 frames
    10. mondrian.olap.fun
      FunUtil.resolveFunArgs
      1. mondrian.olap.fun.FunUtil.resolveFunArgs(FunUtil.java:1751)
      1 frame
    11. mondrian.mdx
      UnresolvedFunCall.accept
      1. mondrian.mdx.UnresolvedFunCall.accept(UnresolvedFunCall.java:91)
      1 frame
    12. mondrian.olap
      Query$StackValidator.validate
      1. mondrian.olap.Query$StackValidator.validate(Query.java:1208)
      1 frame
    13. mondrian.olap.fun
      FunUtil.resolveFunArgs
      1. mondrian.olap.fun.FunUtil.resolveFunArgs(FunUtil.java:1751)
      1 frame
    14. mondrian.mdx
      UnresolvedFunCall.accept
      1. mondrian.mdx.UnresolvedFunCall.accept(UnresolvedFunCall.java:91)
      1 frame
    15. mondrian.olap
      Parser.do_action
      1. mondrian.olap.Query$StackValidator.validate(Query.java:1208)
      2. mondrian.olap.QueryAxis.resolve(QueryAxis.java:201)
      3. mondrian.olap.Query$StackValidator.validate(Query.java:1268)
      4. mondrian.olap.Query.resolve(Query.java:570)
      5. mondrian.olap.Query.resolve(Query.java:425)
      6. mondrian.olap.Query.<init>(Query.java:220)
      7. mondrian.olap.Query.<init>(Query.java:180)
      8. mondrian.olap.Parser.makeQuery(Parser.java:846)
      9. mondrian.olap.CUP$Parser$actions.CUP$Parser$do_action(Parser.java:1679)
      10. mondrian.olap.Parser.do_action(Parser.java:680)
      10 frames
    16. Xalan Java
      lr_parser.parse
      1. java_cup.runtime.lr_parser.parse(lr_parser.java:569)
      1 frame
    17. mondrian.olap
      ConnectionBase.parseQuery
      1. mondrian.olap.Parser.parseInternal(Parser.java:750)
      2. mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:74)
      3. mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:59)
      3 frames
    18. com.tonbeller.jpivot
      OlapModelTag.doEndTag
      1. com.tonbeller.jpivot.mondrian.MondrianModel.parseMDX(MondrianModel.java:528)
      2. com.tonbeller.jpivot.mondrian.MondrianModel.initialize(MondrianModel.java:495)
      3. com.tonbeller.jpivot.olap.model.OlapModelDecorator.initialize(OlapModelDecorator.java:132)
      4. com.tonbeller.jpivot.tags.OlapModelProxy$MyState.initialize(OlapModelProxy.java:77)
      5. com.tonbeller.jpivot.tags.StackStateManager.initializeAndShow(StackStateManager.java:76)
      6. com.tonbeller.jpivot.tags.OlapModelProxy.initializeAndShow(OlapModelProxy.java:160)
      7. com.tonbeller.jpivot.tags.OlapModelTag.doEndTag(OlapModelTag.java:81)
      7 frames
    19. org.apache.jsp
      Pivot_jsp._jspService
      1. org.apache.jsp.jsp.Pivot_jsp._jspService(Pivot_jsp.java:789)
      1 frame
    20. GWT dev
      HttpJspBase.service
      1. org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
      1 frame
    21. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
      1 frame
    22. GWT dev
      JspServlet.service
      1. org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:387)
      2. org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
      3. org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
      3 frames
    23. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
      1 frame
    24. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      2 frames
    25. Acegi Security Core
      FilterChainProxy$VirtualFilterChain.doFilter
      1. org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264)
      2. org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107)
      3. org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72)
      4. org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
      5. org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:110)
      6. org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
      7. org.acegisecurity.ui.switchuser.SwitchUserProcessingFilter.doFilter(SwitchUserProcessingFilter.java:335)
      8. org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
      8 frames
    26. com.pentaho.security
      SecurityStartupFilter.doFilter
      1. com.pentaho.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:76)
      1 frame
    27. Acegi Security Core
      FilterChainProxy$VirtualFilterChain.doFilter
      1. org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
      2. org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125)
      3. org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
      4. org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:142)
      5. org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
      5 frames
    28. com.pentaho.security
      RequestParameterAuthenticationFilter.doFilter
      1. com.pentaho.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:164)
      1 frame
    29. Acegi Security Core
      FilterChainProxy$VirtualFilterChain.doFilter
      1. org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
      2. org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:178)
      3. org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
      4. org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:217)
      5. org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
      6. org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:108)
      7. org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
      7 frames
    30. com.pentaho.security
      HttpSessionReuseDetectionFilter.doFilter
      1. com.pentaho.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:130)
      1 frame
    31. Acegi Security Core
      FilterToBeanProxy.doFilter
      1. org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
      2. org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:193)
      3. org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
      4. org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:81)
      5. org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
      6. org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:148)
      7. org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98)
      7 frames
    32. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      2 frames
    33. com.tonbeller.wcf
      RequestFilter.doFilter
      1. com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:139)
      2. com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(RequestSynchronizer.java:127)
      3. com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:263)
      3 frames
    34. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      2 frames
    35. org.pentaho.core
      SystemStatusFilter.doFilter
      1. org.pentaho.core.system.SystemStatusFilter.doFilter(SystemStatusFilter.java:53)
      1 frame
    36. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      2 frames
    37. org.pentaho.ui
      SetCharacterEncodingFilter.doFilter
      1. org.pentaho.ui.servlet.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:112)
      1 frame
    38. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      2 frames
    39. JBoss Application Server Tomcat
      ReplyHeaderFilter.doFilter
      1. org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
      1 frame
    40. Glassfish Core
      StandardContextValve.invoke
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      3. org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
      4. org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
      4 frames
    41. JBoss Application Server Tomcat
      SecurityAssociationValve.invoke
      1. org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:179)
      1 frame
    42. Glassfish Core
      AuthenticatorBase.invoke
      1. org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433)
      1 frame
    43. JBoss Application Server Tomcat
      JaccContextValve.invoke
      1. org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
      1 frame
    44. Glassfish Core
      ErrorReportValve.invoke
      1. org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
      2. org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
      2 frames
    45. JBoss Application Server Tomcat
      CachedConnectionValve.invoke
      1. org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
      1 frame
    46. Glassfish Core
      CoyoteAdapter.service
      1. org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
      2. org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:241)
      2 frames
    47. Grizzly HTTP
      JIoEndpoint$Worker.run
      1. org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
      2. org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:580)
      3. org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
      3 frames
    48. Java RT
      Thread.run
      1. java.lang.Thread.run(Unknown Source)
      1 frame