mondrian.olap.MondrianException: Mondrian Error:Failed to parse query ' select NON EMPTY {[Measures].[TPost], [Measures].[km], [Measures].[amountTours], [Measures].[RUELPercIst]} ON COLUMNS, NON EMPTY Crossjoin({[Zeit_Dim.Kalender].[Alle].[2008]}, Crossjoin({[Orga-Einheit.Orga-Einheit].[all].[TNT Post BRD].[TNT Post R egioservice GmbH].[D├╝sseldorf], [Orga-Einheit.Orga-Einheit].[all].[TNT Post BRD].[TNT Post Regioservice GmbH].[K├Âln], [Orga-Einh eit.Orga-Einheit].[all].[TNT Post BRD].[TNT Post Regioservice GmbH].[Frankfurt], [Orga-Einheit.Orga-Einheit].[all].[TNT Post BRD]. [TNT Post Regioservice GmbH].[Wuppertal], [Orga-Einheit.Orga-Einheit].[all].[TNT Post BRD].[TNT Post Regioservice GmbH].[Ruhrgebie t], [Orga-Einheit.Orga-Einheit].[all].[TNT Post BRD].[TNT Post Regioservice GmbH].[Hamburg], [Orga-Einheit.Orga-Einheit].[all].[TN T Post BRD].[TNT Post Regioservice GmbH].[Stuttgart], [Orga-Einheit.Orga-Einheit].[all].[TNT Post BRD].[TNT Post Regioservice GmbH ].[Viersen], [Orga-Einheit.Orga-Einheit].[all].[TNT Post BRD].[TNT Post Zustellservice GmbH].[Helmstedt], [Orga-Einheit.Orga-Einhe it].[all].[TNT Post BRD].[Integrationsbetrieb ABL gGmbH].[Altena], [Orga-Einheit.Orga-Einheit].[all].[TNT Post BRD].[CBS City Brie fservice GmbH].[M├Ânchengladbach], [Orga-Einheit.Orga-Einheit].[all].[TNT Post BRD].[REGIO.ES GmbH].[Esslingen], [Orga-Einheit.Org a-Einheit].[all].[TNT Post BRD].[RIDAS GmbH].[Rostock], [Orga-Einheit.Orga-Einheit].[all].[TNT Post BRD].[RIDAS GmbH].[Schwerin]}, {[dim_vehicletype.vehicletype].[all], [dim_vehicletype.vehicletype].[all].[TNT Bike], [dim_vehicletype.vehicletype].[all].[TNT Sc ooter], [dim_vehicletype.vehicletype].[all].[TNT PKW], [dim_vehicletype.vehicletype].[all].[Eigen Bike], [dim_vehicletype.vehiclet ype].[all].[Eigen Scooter], [dim_vehicletype.vehicletype].[all].[Eigen PKW], [dim_vehicletype.vehicletype].[all].[Zu Fuss]})) ON R OWS from [CSR] '

Pentaho BI Platform Tracking | Dr. Arndt Schoenberg | 8 years ago
  1. 0

    Since 2.1 RC saving of analysis views doesn't work if the mdx query contains german umlauts (üöä...) e.g. .... ({[Orga-Einheit.Orga-Einheit].[all].[TNT Post BRD].[TNT Post Regioservice GmbH].[Düsseldorf] ... Loading the original view (created in 2.0) works fine. Saving the same query causes the following errors. It seems that the character coding changes 18:15:36,812 INFO [STDOUT] 18:15:36,812 WARN [SimpleOutputHandler] The value to be output is null. 18:15:39,109 ERROR [STDERR] Warning: Running an XSLT 1.0 stylesheet with an XSLT 2.0 processor 18:16:07,593 ERROR [STDERR] Warning: Running an XSLT 1.0 stylesheet with an XSLT 2.0 processor 18:16:07,906 ERROR [STDERR] Warning: Running an XSLT 1.0 stylesheet with an XSLT 2.0 processor 18:18:07,656 ERROR [STDERR] Warning: Running an XSLT 1.0 stylesheet with an XSLT 2.0 processor 18:19:07,890 INFO [STDOUT] 18:19:07,890 WARN [SimpleOutputHandler] The value to be output is null. 18:19:07,921 INFO [STDOUT] 18:19:07,921 ERROR [MondrianModel] Parse Failure mondrian.olap.MondrianException: Mondrian Error:Failed to parse query ' select NON EMPTY {[Measures].[TPost], [Measures].[km], [Measures].[amountTours], [Measures].[RUELPercIst]} ON COLUMNS, NON EMPTY Crossjoin({[Zeit_Dim.Kalender].[Alle].[2008]}, Crossjoin({[Orga-Einheit.Orga-Einheit].[all].[TNT Post BRD].[TNT Post R egioservice GmbH].[D├╝sseldorf], [Orga-Einheit.Orga-Einheit].[all].[TNT Post BRD].[TNT Post Regioservice GmbH].[K├Âln], [Orga-Einh eit.Orga-Einheit].[all].[TNT Post BRD].[TNT Post Regioservice GmbH].[Frankfurt], [Orga-Einheit.Orga-Einheit].[all].[TNT Post BRD]. [TNT Post Regioservice GmbH].[Wuppertal], [Orga-Einheit.Orga-Einheit].[all].[TNT Post BRD].[TNT Post Regioservice GmbH].[Ruhrgebie t], [Orga-Einheit.Orga-Einheit].[all].[TNT Post BRD].[TNT Post Regioservice GmbH].[Hamburg], [Orga-Einheit.Orga-Einheit].[all].[TN T Post BRD].[TNT Post Regioservice GmbH].[Stuttgart], [Orga-Einheit.Orga-Einheit].[all].[TNT Post BRD].[TNT Post Regioservice GmbH ].[Viersen], [Orga-Einheit.Orga-Einheit].[all].[TNT Post BRD].[TNT Post Zustellservice GmbH].[Helmstedt], [Orga-Einheit.Orga-Einhe it].[all].[TNT Post BRD].[Integrationsbetrieb ABL gGmbH].[Altena], [Orga-Einheit.Orga-Einheit].[all].[TNT Post BRD].[CBS City Brie fservice GmbH].[M├Ânchengladbach], [Orga-Einheit.Orga-Einheit].[all].[TNT Post BRD].[REGIO.ES GmbH].[Esslingen], [Orga-Einheit.Org a-Einheit].[all].[TNT Post BRD].[RIDAS GmbH].[Rostock], [Orga-Einheit.Orga-Einheit].[all].[TNT Post BRD].[RIDAS GmbH].[Schwerin]}, {[dim_vehicletype.vehicletype].[all], [dim_vehicletype.vehicletype].[all].[TNT Bike], [dim_vehicletype.vehicletype].[all].[TNT Sc ooter], [dim_vehicletype.vehicletype].[all].[TNT PKW], [dim_vehicletype.vehicletype].[all].[Eigen Bike], [dim_vehicletype.vehiclet ype].[all].[Eigen Scooter], [dim_vehicletype.vehicletype].[all].[Eigen PKW], [dim_vehicletype.vehicletype].[all].[Zu Fuss]})) ON R OWS from [CSR] ' at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:785) at mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:134) at mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:59) at com.tonbeller.jpivot.mondrian.MondrianModel.parseMDX(MondrianModel.java:579) at com.tonbeller.jpivot.mondrian.MondrianModel.initialize(MondrianModel.java:546) at com.tonbeller.jpivot.olap.model.OlapModelDecorator.initialize(OlapModelDecorator.java:132) at com.tonbeller.jpivot.tags.OlapModelProxy$MyState.initialize(OlapModelProxy.java:77) Original File was saved in ANSI Crossjoin({[Orga-Einheit.Orga-Einheit].[all].[TNT Post BRD].[TNT Post Regioservice GmbH].[D�orf], Saving from 2.1 creates UTF8 Crossjoin({[Orga-Einheit.Orga-Einheit].[all].[TNT Post BRD].[TNT Post Regioservice GmbH].[Düsseldorf], I think readiing / checking of UTF8 causes the error

    Pentaho BI Platform Tracking | 8 years ago | Dr. Arndt Schoenberg
    mondrian.olap.MondrianException: Mondrian Error:Failed to parse query ' select NON EMPTY {[Measures].[TPost], [Measures].[km], [Measures].[amountTours], [Measures].[RUELPercIst]} ON COLUMNS, NON EMPTY Crossjoin({[Zeit_Dim.Kalender].[Alle].[2008]}, Crossjoin({[Orga-Einheit.Orga-Einheit].[all].[TNT Post BRD].[TNT Post R egioservice GmbH].[D├╝sseldorf], [Orga-Einheit.Orga-Einheit].[all].[TNT Post BRD].[TNT Post Regioservice GmbH].[K├Âln], [Orga-Einh eit.Orga-Einheit].[all].[TNT Post BRD].[TNT Post Regioservice GmbH].[Frankfurt], [Orga-Einheit.Orga-Einheit].[all].[TNT Post BRD]. [TNT Post Regioservice GmbH].[Wuppertal], [Orga-Einheit.Orga-Einheit].[all].[TNT Post BRD].[TNT Post Regioservice GmbH].[Ruhrgebie t], [Orga-Einheit.Orga-Einheit].[all].[TNT Post BRD].[TNT Post Regioservice GmbH].[Hamburg], [Orga-Einheit.Orga-Einheit].[all].[TN T Post BRD].[TNT Post Regioservice GmbH].[Stuttgart], [Orga-Einheit.Orga-Einheit].[all].[TNT Post BRD].[TNT Post Regioservice GmbH ].[Viersen], [Orga-Einheit.Orga-Einheit].[all].[TNT Post BRD].[TNT Post Zustellservice GmbH].[Helmstedt], [Orga-Einheit.Orga-Einhe it].[all].[TNT Post BRD].[Integrationsbetrieb ABL gGmbH].[Altena], [Orga-Einheit.Orga-Einheit].[all].[TNT Post BRD].[CBS City Brie fservice GmbH].[M├Ânchengladbach], [Orga-Einheit.Orga-Einheit].[all].[TNT Post BRD].[REGIO.ES GmbH].[Esslingen], [Orga-Einheit.Org a-Einheit].[all].[TNT Post BRD].[RIDAS GmbH].[Rostock], [Orga-Einheit.Orga-Einheit].[all].[TNT Post BRD].[RIDAS GmbH].[Schwerin]}, {[dim_vehicletype.vehicletype].[all], [dim_vehicletype.vehicletype].[all].[TNT Bike], [dim_vehicletype.vehicletype].[all].[TNT Sc ooter], [dim_vehicletype.vehicletype].[all].[TNT PKW], [dim_vehicletype.vehicletype].[all].[Eigen Bike], [dim_vehicletype.vehiclet ype].[all].[Eigen Scooter], [dim_vehicletype.vehicletype].[all].[Eigen PKW], [dim_vehicletype.vehicletype].[all].[Zu Fuss]})) ON R OWS from [CSR] '
  2. 0

    Since 2.1 RC saving of analysis views doesn't work if the mdx query contains german umlauts (üöä...) e.g. .... ({[Orga-Einheit.Orga-Einheit].[all].[TNT Post BRD].[TNT Post Regioservice GmbH].[Düsseldorf] ... Loading the original view (created in 2.0) works fine. Saving the same query causes the following errors. It seems that the character coding changes 18:15:36,812 INFO [STDOUT] 18:15:36,812 WARN [SimpleOutputHandler] The value to be output is null. 18:15:39,109 ERROR [STDERR] Warning: Running an XSLT 1.0 stylesheet with an XSLT 2.0 processor 18:16:07,593 ERROR [STDERR] Warning: Running an XSLT 1.0 stylesheet with an XSLT 2.0 processor 18:16:07,906 ERROR [STDERR] Warning: Running an XSLT 1.0 stylesheet with an XSLT 2.0 processor 18:18:07,656 ERROR [STDERR] Warning: Running an XSLT 1.0 stylesheet with an XSLT 2.0 processor 18:19:07,890 INFO [STDOUT] 18:19:07,890 WARN [SimpleOutputHandler] The value to be output is null. 18:19:07,921 INFO [STDOUT] 18:19:07,921 ERROR [MondrianModel] Parse Failure mondrian.olap.MondrianException: Mondrian Error:Failed to parse query ' select NON EMPTY {[Measures].[TPost], [Measures].[km], [Measures].[amountTours], [Measures].[RUELPercIst]} ON COLUMNS, NON EMPTY Crossjoin({[Zeit_Dim.Kalender].[Alle].[2008]}, Crossjoin({[Orga-Einheit.Orga-Einheit].[all].[TNT Post BRD].[TNT Post R egioservice GmbH].[D├╝sseldorf], [Orga-Einheit.Orga-Einheit].[all].[TNT Post BRD].[TNT Post Regioservice GmbH].[K├Âln], [Orga-Einh eit.Orga-Einheit].[all].[TNT Post BRD].[TNT Post Regioservice GmbH].[Frankfurt], [Orga-Einheit.Orga-Einheit].[all].[TNT Post BRD]. [TNT Post Regioservice GmbH].[Wuppertal], [Orga-Einheit.Orga-Einheit].[all].[TNT Post BRD].[TNT Post Regioservice GmbH].[Ruhrgebie t], [Orga-Einheit.Orga-Einheit].[all].[TNT Post BRD].[TNT Post Regioservice GmbH].[Hamburg], [Orga-Einheit.Orga-Einheit].[all].[TN T Post BRD].[TNT Post Regioservice GmbH].[Stuttgart], [Orga-Einheit.Orga-Einheit].[all].[TNT Post BRD].[TNT Post Regioservice GmbH ].[Viersen], [Orga-Einheit.Orga-Einheit].[all].[TNT Post BRD].[TNT Post Zustellservice GmbH].[Helmstedt], [Orga-Einheit.Orga-Einhe it].[all].[TNT Post BRD].[Integrationsbetrieb ABL gGmbH].[Altena], [Orga-Einheit.Orga-Einheit].[all].[TNT Post BRD].[CBS City Brie fservice GmbH].[M├Ânchengladbach], [Orga-Einheit.Orga-Einheit].[all].[TNT Post BRD].[REGIO.ES GmbH].[Esslingen], [Orga-Einheit.Org a-Einheit].[all].[TNT Post BRD].[RIDAS GmbH].[Rostock], [Orga-Einheit.Orga-Einheit].[all].[TNT Post BRD].[RIDAS GmbH].[Schwerin]}, {[dim_vehicletype.vehicletype].[all], [dim_vehicletype.vehicletype].[all].[TNT Bike], [dim_vehicletype.vehicletype].[all].[TNT Sc ooter], [dim_vehicletype.vehicletype].[all].[TNT PKW], [dim_vehicletype.vehicletype].[all].[Eigen Bike], [dim_vehicletype.vehiclet ype].[all].[Eigen Scooter], [dim_vehicletype.vehicletype].[all].[Eigen PKW], [dim_vehicletype.vehicletype].[all].[Zu Fuss]})) ON R OWS from [CSR] ' at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:785) at mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:134) at mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:59) at com.tonbeller.jpivot.mondrian.MondrianModel.parseMDX(MondrianModel.java:579) at com.tonbeller.jpivot.mondrian.MondrianModel.initialize(MondrianModel.java:546) at com.tonbeller.jpivot.olap.model.OlapModelDecorator.initialize(OlapModelDecorator.java:132) at com.tonbeller.jpivot.tags.OlapModelProxy$MyState.initialize(OlapModelProxy.java:77) Original File was saved in ANSI Crossjoin({[Orga-Einheit.Orga-Einheit].[all].[TNT Post BRD].[TNT Post Regioservice GmbH].[D�orf], Saving from 2.1 creates UTF8 Crossjoin({[Orga-Einheit.Orga-Einheit].[all].[TNT Post BRD].[TNT Post Regioservice GmbH].[Düsseldorf], I think readiing / checking of UTF8 causes the error

    Pentaho BI Platform Tracking | 8 years ago | Dr. Arndt Schoenberg
    mondrian.olap.MondrianException: Mondrian Error:Failed to parse query ' select NON EMPTY {[Measures].[TPost], [Measures].[km], [Measures].[amountTours], [Measures].[RUELPercIst]} ON COLUMNS, NON EMPTY Crossjoin({[Zeit_Dim.Kalender].[Alle].[2008]}, Crossjoin({[Orga-Einheit.Orga-Einheit].[all].[TNT Post BRD].[TNT Post R egioservice GmbH].[D├╝sseldorf], [Orga-Einheit.Orga-Einheit].[all].[TNT Post BRD].[TNT Post Regioservice GmbH].[K├Âln], [Orga-Einh eit.Orga-Einheit].[all].[TNT Post BRD].[TNT Post Regioservice GmbH].[Frankfurt], [Orga-Einheit.Orga-Einheit].[all].[TNT Post BRD]. [TNT Post Regioservice GmbH].[Wuppertal], [Orga-Einheit.Orga-Einheit].[all].[TNT Post BRD].[TNT Post Regioservice GmbH].[Ruhrgebie t], [Orga-Einheit.Orga-Einheit].[all].[TNT Post BRD].[TNT Post Regioservice GmbH].[Hamburg], [Orga-Einheit.Orga-Einheit].[all].[TN T Post BRD].[TNT Post Regioservice GmbH].[Stuttgart], [Orga-Einheit.Orga-Einheit].[all].[TNT Post BRD].[TNT Post Regioservice GmbH ].[Viersen], [Orga-Einheit.Orga-Einheit].[all].[TNT Post BRD].[TNT Post Zustellservice GmbH].[Helmstedt], [Orga-Einheit.Orga-Einhe it].[all].[TNT Post BRD].[Integrationsbetrieb ABL gGmbH].[Altena], [Orga-Einheit.Orga-Einheit].[all].[TNT Post BRD].[CBS City Brie fservice GmbH].[M├Ânchengladbach], [Orga-Einheit.Orga-Einheit].[all].[TNT Post BRD].[REGIO.ES GmbH].[Esslingen], [Orga-Einheit.Org a-Einheit].[all].[TNT Post BRD].[RIDAS GmbH].[Rostock], [Orga-Einheit.Orga-Einheit].[all].[TNT Post BRD].[RIDAS GmbH].[Schwerin]}, {[dim_vehicletype.vehicletype].[all], [dim_vehicletype.vehicletype].[all].[TNT Bike], [dim_vehicletype.vehicletype].[all].[TNT Sc ooter], [dim_vehicletype.vehicletype].[all].[TNT PKW], [dim_vehicletype.vehicletype].[all].[Eigen Bike], [dim_vehicletype.vehiclet ype].[all].[Eigen Scooter], [dim_vehicletype.vehicletype].[all].[Eigen PKW], [dim_vehicletype.vehicletype].[all].[Zu Fuss]})) ON R OWS from [CSR] '
  3. 0

    Mondrian 4.1.1.0 - Issue

    GitHub | 2 years ago | sanjayraja
    mondrian.xmla.XmlaException: Mondrian Error:XMLA MDX parse failed
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Error loading pentaho cube using saiku

    Stack Overflow | 3 years ago | haki
    mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while loading plugin class 'org.saiku.plugin.PentahoDataSourceResolver'
  6. 0

    JDBC connection error while using mondrian

    Stack Overflow | 3 years ago | Dhanish Jose
    mondrian.olap.MondrianException: Mondrian Error:Internal error: Connect string '@mondrian.webapp.connectString@=; Catalog='null'' must contain either 'Jdbc' or 'DataSource'

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

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. mondrian.olap.MondrianException

      Mondrian Error:Failed to parse query ' select NON EMPTY {[Measures].[TPost], [Measures].[km], [Measures].[amountTours], [Measures].[RUELPercIst]} ON COLUMNS, NON EMPTY Crossjoin({[Zeit_Dim.Kalender].[Alle].[2008]}, Crossjoin({[Orga-Einheit.Orga-Einheit].[all].[TNT Post BRD].[TNT Post R egioservice GmbH].[D├╝sseldorf], [Orga-Einheit.Orga-Einheit].[all].[TNT Post BRD].[TNT Post Regioservice GmbH].[K├Âln], [Orga-Einh eit.Orga-Einheit].[all].[TNT Post BRD].[TNT Post Regioservice GmbH].[Frankfurt], [Orga-Einheit.Orga-Einheit].[all].[TNT Post BRD]. [TNT Post Regioservice GmbH].[Wuppertal], [Orga-Einheit.Orga-Einheit].[all].[TNT Post BRD].[TNT Post Regioservice GmbH].[Ruhrgebie t], [Orga-Einheit.Orga-Einheit].[all].[TNT Post BRD].[TNT Post Regioservice GmbH].[Hamburg], [Orga-Einheit.Orga-Einheit].[all].[TN T Post BRD].[TNT Post Regioservice GmbH].[Stuttgart], [Orga-Einheit.Orga-Einheit].[all].[TNT Post BRD].[TNT Post Regioservice GmbH ].[Viersen], [Orga-Einheit.Orga-Einheit].[all].[TNT Post BRD].[TNT Post Zustellservice GmbH].[Helmstedt], [Orga-Einheit.Orga-Einhe it].[all].[TNT Post BRD].[Integrationsbetrieb ABL gGmbH].[Altena], [Orga-Einheit.Orga-Einheit].[all].[TNT Post BRD].[CBS City Brie fservice GmbH].[M├Ânchengladbach], [Orga-Einheit.Orga-Einheit].[all].[TNT Post BRD].[REGIO.ES GmbH].[Esslingen], [Orga-Einheit.Org a-Einheit].[all].[TNT Post BRD].[RIDAS GmbH].[Rostock], [Orga-Einheit.Orga-Einheit].[all].[TNT Post BRD].[RIDAS GmbH].[Schwerin]}, {[dim_vehicletype.vehicletype].[all], [dim_vehicletype.vehicletype].[all].[TNT Bike], [dim_vehicletype.vehicletype].[all].[TNT Sc ooter], [dim_vehicletype.vehicletype].[all].[TNT PKW], [dim_vehicletype.vehicletype].[all].[Eigen Bike], [dim_vehicletype.vehiclet ype].[all].[Eigen Scooter], [dim_vehicletype.vehicletype].[all].[Eigen PKW], [dim_vehicletype.vehicletype].[all].[Zu Fuss]})) ON R OWS from [CSR] '

      at mondrian.resource.MondrianResource$_Def0.ex()
    2. mondrian.resource
      MondrianResource$_Def0.ex
      1. mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:785)
      1 frame
    3. mondrian.olap
      ConnectionBase.parseQuery
      1. mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:134)
      2. mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:59)
      2 frames
    4. com.tonbeller.jpivot
      OlapModelProxy$MyState.initialize
      1. com.tonbeller.jpivot.mondrian.MondrianModel.parseMDX(MondrianModel.java:579)
      2. com.tonbeller.jpivot.mondrian.MondrianModel.initialize(MondrianModel.java:546)
      3. com.tonbeller.jpivot.olap.model.OlapModelDecorator.initialize(OlapModelDecorator.java:132)
      4. com.tonbeller.jpivot.tags.OlapModelProxy$MyState.initialize(OlapModelProxy.java:77)
      4 frames