mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [select NON EMPTY {[Date of Sale].[All Date of Sales].[2005].[Q2, 2005]} ON COLUMNS from [Sales] ]

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Samebug tips

Do you know how to solve this issue? Write a tip to help other users and build your expert profile.

Solutions on the web

via Pentaho BI Platform Tracking by Deepak Paramanand, 1 year ago
Mondrian Error:Internal error: Error while executing query [select NON EMPTY {[Date of Sale].[All Date of Sales].[2005].[Q2, 2005]} ON COLUMNS from [Sales] ]
via Pentaho BI Platform Tracking by ajit_joglekar, 1 year ago
Mondrian Error:Internal error: Po pulating member cache with members for [[D1].[Name]]; sql=[select `D1`.`name` as `c0` from `D1` as `D1` group by `D1`.`n ame` order by `D1`.`name` ASC]
via Pentaho BI Platform Tracking by eduandrade, 11 months ago
Mondrian Error:Internal error: Error while executing query [select {[Measures].[MaxOverMeasure]} ON COLUMNS, {[Employees].[All Employees], [Employees].[All Employees].Children} ON ROWS from [HR] ]
via pentaho.com by Unknown author, 2 years ago
Mondrian Error:Internal error: Error while executing query [select NON EMPTY {[Measures].[NumDeOpsPGAH2008q1]} ON COLUMNS, NON EMPTY Crossjoin(Hierarchize(Union(Union({[Per�*odos].[Per�*odos Todos]}, [Per�*odos].[Per�*odos Todos].Children), [Per
via Pentaho BI Platform Tracking by Julian Hyde, 1 year ago
Mondrian Error:Internal error: Error while loading segment; sql=[select "store"."store_state" as "c0", "agg_c_14_sales_fact_1997"."the_year" as "c1", "agg_c_14_sales_fact_1997"."quarter" as "c2", sum("agg_c_14_sales_fact_1997"."unit_sales") as "m0
via Pentaho BI Platform Tracking by Julian Hyde, 1 year ago
Mondrian Error:Internal error: Error while loading segment; sql=[select "store"."store_state" as "c0", "agg_c_14_sales_fact_1997"."the_year" as "c1", "agg_c_14_sales_fact_1997"."quarter" as "c2", sum("agg_c_14_sales_fact_1997"."unit_sales") as "m0
mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [select NON EMPTY {[Date of Sale].[All Date of Sales].[2005].[Q2, 2005]} ON COLUMNS from [Sales] ]
at mondrian.spi.impl.JdbcDialectImpl.quoteTimeLiteral(JdbcDialectImpl.java:370)
at mondrian.spi.Dialect$Datatype$6.quoteValue(Dialect.java:720)
at mondrian.spi.impl.JdbcDialectImpl.quote(JdbcDialectImpl.java:619)
at mondrian.rolap.agg.ValueColumnPredicate.toSql(ValueColumnPredicate.java:163)
at mondrian.rolap.agg.ListColumnPredicate.toSql(ListColumnPredicate.java:293)
at mondrian.rolap.RolapStar$Column.createInExpr(RolapStar.java:1276)
at mondrian.rolap.agg.AbstractQuerySpec.nonDistinctGenerateSql(AbstractQuerySpec.java:98)
at mondrian.rolap.agg.AbstractQuerySpec.generateSqlQuery(AbstractQuerySpec.java:169)
at mondrian.rolap.agg.AggregationManager.generateSql(AggregationManager.java:229)
at mondrian.rolap.agg.SegmentLoader.createExecuteSql(SegmentLoader.java:337)
at mondrian.rolap.agg.SegmentLoader.load(SegmentLoader.java:75)
at mondrian.rolap.agg.Aggregation.load(Aggregation.java:171)
at mondrian.rolap.agg.AggregationManager.loadAggregation(AggregationManager.java:89)
at mondrian.rolap.FastBatchingCellReader$Batch.loadAggregation(FastBatchingCellReader.java:493)
at mondrian.rolap.FastBatchingCellReader$Batch.loadAggregation(FastBatchingCellReader.java:430)
at mondrian.rolap.FastBatchingCellReader.loadAggregation(FastBatchingCellReader.java:206)
at mondrian.rolap.FastBatchingCellReader.loadAggregations(FastBatchingCellReader.java:187)
at mondrian.rolap.RolapResult.executeBody(RolapResult.java:792)
at mondrian.rolap.RolapResult.(RolapResult.java:414)
at mondrian.rolap.RolapConnection.execute(RolapConnection.java:560)
at mondrian.gui.QueryPanel.executeButtonActionPerformed(QueryPanel.java:235)
at mondrian.gui.QueryPanel.access$100(QueryPanel.java:53)
at mondrian.gui.QueryPanel$3.actionPerformed(QueryPanel.java:176)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)

Users with the same issue

You are the first who have seen this exception. Write a tip to help other users and build your expert profile.

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.