mondrian.olap.MondrianException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • 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
    via by Klaus Mende,
  • 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
    via by Klaus Mende,
  • db:: 3.42::jdbc DB2 multiple Connection in CRON pf
    via by Unknown author,
    • 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

    Users with the same issue

    Unknown visitor
    Unknown visitor1 times, last one,