java.lang.NumberFormatException

Illegal TIME literal: Q2, 2005

Solutions on the web27

  • via Pentaho BI Platform Tracking by Deepak Paramanand, 1 year ago
    Illegal TIME literal: Q2, 2005
  • via Pentaho BI Platform Tracking by Paul Stoellberger, 1 year ago
    Illegal BOOLEAN literal: 0
  • via Pentaho BI Platform Tracking by Rob Fellows, 1 year ago
    Illegal BOOLEAN literal: 0
  • Stack trace

    • java.lang.NumberFormatException: Illegal TIME literal: Q2, 2005 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.<init>(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) at java.awt.EventDispatchThread.run(Unknown Source)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    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.