java.lang.NumberFormatException: Illegal TIME literal: Q2, 2005

Pentaho BI Platform Tracking | Deepak Paramanand | 8 years ago
  1. 0

    I have set up a Private Dimension Date of Sale as part a Cube Sales of the standard Waremart.xml as <Cube name="Sales" cache="true" enabled="true"> <Table name="RT_SALESALL" schema="WAREMART"> </Table> <DimensionUsage source="Customer" name="Customer" foreignKey="CUST_ID"> </DimensionUsage> <DimensionUsage source="Product" name="Product" foreignKey="PROD_ID"> </DimensionUsage> <DimensionUsage source="Term" name="Payment Method" foreignKey="TERMS_ID"> </DimensionUsage> <DimensionUsage source="Promotion" name="Promotion" foreignKey="PROMO_ID"> </DimensionUsage> <Dimension type="TimeDimension" foreignKey="DATE_ID" name="Date of Sale"> <Hierarchy hasAll="true" primaryKey="DAY_ID"> <Table name="RT_TIMEBASE" schema="WAREMART"> </Table> <Level name="Year" table="RT_TIMEBASE" column="YEAR_NAME" ordinalColumn="YEAR_ID" type="String" uniqueMembers="true" levelType="TimeYears" hideMemberIf="IfBlankName"> </Level> <Level name="Quarter" table="RT_TIMEBASE" column="QUARTER_NAME" ordinalColumn="QUARTER_ID" type="Time" uniqueMembers="true" levelType="TimeQuarters" hideMemberIf="IfBlankName"> </Level> <Level name="Month" table="RT_TIMEBASE" column="MONTH_NAME" ordinalColumn="MONTH_ID" type="String" uniqueMembers="true" levelType="TimeMonths" hideMemberIf="IfBlankName"> </Level> <Level name="Week" table="RT_TIMEBASE" column="WEEK_DESC" ordinalColumn="WEEK_ID" type="Time" uniqueMembers="true" levelType="TimeWeeks" hideMemberIf="IfBlankName"> </Level> <Level name="Day" table="RT_TIMEBASE" column="DAY_NAME" ordinalColumn="DAY_ID" type="Time" uniqueMembers="true" levelType="TimeDays" hideMemberIf="IfBlankName"> </Level> </Hierarchy> </Dimension> <Dimension type="TimeDimension" foreignKey="DATE_ID" name="Date of First Shipment"> <Hierarchy hasAll="true" primaryKey="DAY_ID"> <Table name="RT_TIMEBASE" schema="WAREMART"> </Table> <Level name="Year" table="RT_TIMEBASE" column="YEAR_NAME" type="String" uniqueMembers="true" levelType="TimeYears" hideMemberIf="IfBlankName"> </Level> <Level name="Quarter" table="RT_TIMEBASE" column="QUARTER_NAME" type="Time" uniqueMembers="true" levelType="TimeQuarters" hideMemberIf="IfBlankName"> </Level> <Level name="Month" table="RT_TIMEBASE" column="MONTH_NAME" type="String" uniqueMembers="true" levelType="TimeMonths" hideMemberIf="IfBlankName"> </Level> <Level name="Week" table="RT_TIMEBASE" column="WEEK_DESC" type="Time" uniqueMembers="true" levelType="TimeWeeks" hideMemberIf="IfBlankName"> </Level> <Level name="Day" table="RT_TIMEBASE" column="DAY_NAME" type="Time" uniqueMembers="true" levelType="TimeDays" hideMemberIf="IfBlankName"> </Level> </Hierarchy> </Dimension> <Dimension type="TimeDimension" foreignKey="SHP_COMPLETE_DTE" name="Date Shipment Complete"> <Hierarchy hasAll="true" primaryKey="DAY_ID"> <Table name="RT_TIMEBASE" schema="WAREMART"> </Table> <Level name="Year" table="RT_TIMEBASE" column="YEAR_NAME" type="Time" uniqueMembers="true" levelType="TimeYears" hideMemberIf="IfBlankName"> </Level> <Level name="Quarter" table="RT_TIMEBASE" column="QUARTER_NAME" type="Time" uniqueMembers="true" levelType="TimeQuarters" hideMemberIf="IfBlankName"> </Level> <Level name="Month" table="RT_TIMEBASE" column="MONTH_NAME" type="String" uniqueMembers="false" levelType="TimeMonths" hideMemberIf="IfBlankName"> </Level> <Level name="Week" table="RT_TIMEBASE" column="WEEK_DESC" type="Time" uniqueMembers="true" levelType="TimeWeeks" hideMemberIf="IfBlankName"> </Level> <Level name="Day" table="RT_TIMEBASE" column="DAY_NAME" type="Time" uniqueMembers="true" levelType="TimeDays" hideMemberIf="IfBlankName"> </Level> </Hierarchy> </Dimension> <DimensionUsage source="Gender" name="Customer Gender" foreignKey="CUST_ID"> </DimensionUsage> <DimensionUsage source="Education" name="Customer Education Level" foreignKey="CUST_ID"> </DimensionUsage> <DimensionUsage source="Time" name="Time" caption="Date of Product Sale" foreignKey="DATE_ID"> </DimensionUsage> <Measure name="Unit Sales" column="PRICE" datatype="Numeric" formatString="$ ###," aggregator="sum" visible="true"> </Measure> <Measure name="Quantity" column="QTY" datatype="Numeric" formatString="###," aggregator="sum" visible="true"> </Measure> <Measure name="Dollar Sales" column="TOTAL" datatype="Numeric" formatString="$ ###," aggregator="sum" visible="true"> </Measure> </Cube> Here the Quarters are in the form Q2, 2005 etc. When i run the query : select {[Date of Sale].[Quarter].[Q2, 2005]} on columns from Sales i get the error : 2009-04-27 17:36:05,843 ERROR [mondrian.gui.QueryPanel] 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.resource.MondrianResource$_Def0.ex(MondrianResource.java:811) at mondrian.olap.Util.newInternal(Util.java:1472) at mondrian.olap.Util.newError(Util.java:1488) at mondrian.rolap.RolapConnection.execute(RolapConnection.java:589) 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) Caused by: 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) ... 28 more 2009-04-27 17:36:05,843 ERROR [mondrian.gui.QueryPanel] 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) on the schema workbench. The Pentaho server doesnt even report this error. What is wrong with my schema file?

    Pentaho BI Platform Tracking | 8 years ago | Deepak Paramanand
    java.lang.NumberFormatException: Illegal TIME literal: Q2, 2005
  2. 0

    this happens in olap4j when i try to do cube.lookupMember(...) Caused by: org.olap4j.OlapException: Unable to find a member with name [[Has coffee bar], [1]] The above is an example from foodmart + MondrianOlap4j I'm using the lookup method to find specific members: Member lookupMember(List<IdentifierSegment> nameParts) throws OlapException; For some reason this doesn't work for that member and I think thats related to the name being 1 / 0 Not sure why this is happening... The member is definitely there! In another query where the members of that dimension are included i also get the following exception (HSQLD + foodmart) thats why i think its related!?: java.lang.NumberFormatException: Illegal BOOLEAN literal: 0 at mondrian.spi.impl.JdbcDialectImpl.quoteBooleanLiteral(JdbcDialectImpl.java:371) at mondrian.spi.Dialect$Datatype$4.quoteValue(Dialect.java:810) at mondrian.spi.impl.JdbcDialectImpl.quote(JdbcDialectImpl.java:665) at mondrian.rolap.agg.ValueColumnPredicate.toSql(ValueColumnPredicate.java:165) at mondrian.rolap.RolapStar$Column.createInExpr(RolapStar.java:1340) at mondrian.rolap.agg.AbstractQuerySpec.nonDistinctGenerateSql(AbstractQuerySpec.java:102) at mondrian.rolap.agg.DrillThroughQuerySpec.generateSqlQuery(DrillThroughQuerySpec.java:132) at mondrian.rolap.agg.AggregationManager.getDrillThroughSql(AggregationManager.java:132) at mondrian.rolap.RolapCell.getDrillThroughSQL(RolapCell.java:101) at mondrian.rolap.RolapCell.drillThroughInternal(RolapCell.java:289) at mondrian.olap4j.MondrianOlap4jCell.drillThroughInternal(MondrianOlap4jCell.java:156) at mondrian.olap4j.MondrianOlap4jStatement.executeQuery2(MondrianOlap4jStatement.java:89)

    Pentaho BI Platform Tracking | 6 years ago | Paul Stoellberger
    java.lang.NumberFormatException: Illegal BOOLEAN literal: 0
  3. 0

    When a boolean field from monetDB is placed on a report with another level, an error is displayed (see stack trace below). If you only put the boolean level on the report you see a 0 as its displayed value. You can repro this easiest by using Instaview. Create a project from the CSV template. use the attached csv file as input. Once it's done processing, create an analyzer view with Country and Vote as rows. You don't need instaview to reproduce it, it just gets your env set up the quickest to demonstrate the problem. java.lang.RuntimeException: java.util.concurrent.ExecutionException: java.lang.RuntimeException: java.lang.NumberFormatException: Illegal BOOLEAN literal: 0 at com.pentaho.analyzer.report.ReportRequestService.get(SourceFile:219) at com.pentaho.analyzer.content.controller.rk.yf(SourceFile:156) at com.pentaho.analyzer.content.controller.px.px(SourceFile:210) at com.pentaho.analyzer.content.AnalyzerContentGenerator.createContent(SourceFile:171) at org.pentaho.platform.web.http.api.resources.GeneratorStreamingOutput.generateContent(GeneratorStreamingOutput.java:234) at org.pentaho.platform.web.http.api.resources.GeneratorStreamingOutput.write(GeneratorStreamingOutput.java:161) at org.pentaho.platform.web.http.api.resources.GeneratorStreamingOutputProvider.writeTo(GeneratorStreamingOutputProvider.java:54) at org.pentaho.platform.web.http.api.resources.GeneratorStreamingOutputProvider.writeTo(GeneratorStreamingOutputProvider.java:33) at com.sun.jersey.spi.container.ContainerResponse.write(ContainerResponse.java:306) at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1479) at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1391) at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1381) at com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:416) at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:538) at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:716) at org.pentaho.platform.web.servlet.JAXRSServlet.service(JAXRSServlet.java:108) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.pentaho.platform.web.servlet.JAXRSServlet.service(JAXRSServlet.java:113) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1166) at org.pentaho.platform.web.http.filters.PentahoWebContextFilter.doFilter(PentahoWebContextFilter.java:172) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) at org.pentaho.platform.web.http.filters.PentahoRequestContextFilter.doFilter(PentahoRequestContextFilter.java:87) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378) at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109) at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.pentaho.platform.web.http.filters.HttpSessionPentahoSessionIntegrationFilter.doFilter(HttpSessionPentahoSessionIntegrationFilter.java:263) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.wrapper.SecurityContextHolderAwareRequestFilter.doFilterHttp(SecurityContextHolderAwareRequestFilter.java:91) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:175) at org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) at org.pentaho.platform.web.http.filters.SystemStatusFilter.doFilter(SystemStatusFilter.java:55) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) at org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:114) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) at org.pentaho.platform.web.http.filters.WebappRootForwardingFilter.doFilter(WebappRootForwardingFilter.java:70) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:388) at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216) at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182) at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765) at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:418) at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114) at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152) at org.mortbay.jetty.Server.handle(Server.java:326) at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:536) at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:930) at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:747) at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:218) at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:405) at org.mortbay.jetty.bio.SocketConnector$Connection.run(SocketConnector.java:228) at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582) Caused by: java.util.concurrent.ExecutionException: java.lang.RuntimeException: java.lang.NumberFormatException: Illegal BOOLEAN literal: 0 at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:262) at java.util.concurrent.FutureTask.get(FutureTask.java:119) at com.pentaho.analyzer.report.ReportRequestService.get(SourceFile:175) ... 68 more Caused by: java.lang.RuntimeException: java.lang.NumberFormatException: Illegal BOOLEAN literal: 0 at com.pentaho.analyzer.service.impl.AnalysisAreaManager.executeQuery(SourceFile:323) at com.pentaho.analyzer.report.ReportManagerImpl.parseAndExecuteMDX(SourceFile:308) at com.pentaho.analyzer.report.ReportManagerImpl.runReport(SourceFile:140) at com.pentaho.analyzer.report.ReportManagerImpl.runReport(SourceFile:110) at com.pentaho.analyzer.report.ReportRequestService$2.yf(SourceFile:275) at com.pentaho.analyzer.report.ReportRequestService$2.call(SourceFile:270) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) at java.util.concurrent.FutureTask.run(FutureTask.java:166) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:722) Caused by: java.lang.NumberFormatException: Illegal BOOLEAN literal: 0 at mondrian.spi.impl.JdbcDialectImpl.quoteBooleanLiteral(JdbcDialectImpl.java:415) at mondrian.spi.Dialect$Datatype$4.quoteValue(Dialect.java:904) at mondrian.spi.impl.JdbcDialectImpl.quote(JdbcDialectImpl.java:709) at mondrian.rolap.agg.ValueColumnPredicate.toSql(ValueColumnPredicate.java:160) at mondrian.rolap.agg.ListColumnPredicate.toSql(ListColumnPredicate.java:312) at mondrian.rolap.RolapStar$Column.createInExpr(RolapStar.java:1074) at mondrian.rolap.agg.AbstractQuerySpec.nonDistinctGenerateSql(AbstractQuerySpec.java:105) at mondrian.rolap.agg.AbstractQuerySpec.generateSqlQuery(AbstractQuerySpec.java:201) at mondrian.rolap.agg.AggregationManager.generateSql(AggregationManager.java:320) at mondrian.rolap.agg.SegmentLoader.createExecuteSql(SegmentLoader.java:562) at mondrian.rolap.agg.SegmentLoader.loadImpl(SegmentLoader.java:196) at mondrian.rolap.agg.SegmentLoader.access$000(SegmentLoader.java:52) at mondrian.rolap.agg.SegmentLoader$SegmentLoadCommand.call(SegmentLoader.java:167) at mondrian.rolap.agg.SegmentLoader$SegmentLoadCommand.call(SegmentLoader.java:141) ... 5 more

    Pentaho BI Platform Tracking | 3 years ago | Rob Fellows
    java.lang.RuntimeException: java.util.concurrent.ExecutionException: java.lang.RuntimeException: java.lang.NumberFormatException: Illegal BOOLEAN literal: 0
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    When a boolean field from monetDB is placed on a report with another level, an error is displayed (see stack trace below). If you only put the boolean level on the report you see a 0 as its displayed value. You can repro this easiest by using Instaview. Create a project from the CSV template. use the attached csv file as input. Once it's done processing, create an analyzer view with Country and Vote as rows. You don't need instaview to reproduce it, it just gets your env set up the quickest to demonstrate the problem. java.lang.RuntimeException: java.util.concurrent.ExecutionException: java.lang.RuntimeException: java.lang.NumberFormatException: Illegal BOOLEAN literal: 0 at com.pentaho.analyzer.report.ReportRequestService.get(SourceFile:219) at com.pentaho.analyzer.content.controller.rk.yf(SourceFile:156) at com.pentaho.analyzer.content.controller.px.px(SourceFile:210) at com.pentaho.analyzer.content.AnalyzerContentGenerator.createContent(SourceFile:171) at org.pentaho.platform.web.http.api.resources.GeneratorStreamingOutput.generateContent(GeneratorStreamingOutput.java:234) at org.pentaho.platform.web.http.api.resources.GeneratorStreamingOutput.write(GeneratorStreamingOutput.java:161) at org.pentaho.platform.web.http.api.resources.GeneratorStreamingOutputProvider.writeTo(GeneratorStreamingOutputProvider.java:54) at org.pentaho.platform.web.http.api.resources.GeneratorStreamingOutputProvider.writeTo(GeneratorStreamingOutputProvider.java:33) at com.sun.jersey.spi.container.ContainerResponse.write(ContainerResponse.java:306) at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1479) at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1391) at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1381) at com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:416) at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:538) at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:716) at org.pentaho.platform.web.servlet.JAXRSServlet.service(JAXRSServlet.java:108) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.pentaho.platform.web.servlet.JAXRSServlet.service(JAXRSServlet.java:113) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1166) at org.pentaho.platform.web.http.filters.PentahoWebContextFilter.doFilter(PentahoWebContextFilter.java:172) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) at org.pentaho.platform.web.http.filters.PentahoRequestContextFilter.doFilter(PentahoRequestContextFilter.java:87) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378) at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109) at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.pentaho.platform.web.http.filters.HttpSessionPentahoSessionIntegrationFilter.doFilter(HttpSessionPentahoSessionIntegrationFilter.java:263) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.wrapper.SecurityContextHolderAwareRequestFilter.doFilterHttp(SecurityContextHolderAwareRequestFilter.java:91) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:175) at org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) at org.pentaho.platform.web.http.filters.SystemStatusFilter.doFilter(SystemStatusFilter.java:55) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) at org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:114) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) at org.pentaho.platform.web.http.filters.WebappRootForwardingFilter.doFilter(WebappRootForwardingFilter.java:70) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:388) at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216) at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182) at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765) at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:418) at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114) at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152) at org.mortbay.jetty.Server.handle(Server.java:326) at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:536) at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:930) at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:747) at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:218) at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:405) at org.mortbay.jetty.bio.SocketConnector$Connection.run(SocketConnector.java:228) at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582) Caused by: java.util.concurrent.ExecutionException: java.lang.RuntimeException: java.lang.NumberFormatException: Illegal BOOLEAN literal: 0 at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:262) at java.util.concurrent.FutureTask.get(FutureTask.java:119) at com.pentaho.analyzer.report.ReportRequestService.get(SourceFile:175) ... 68 more Caused by: java.lang.RuntimeException: java.lang.NumberFormatException: Illegal BOOLEAN literal: 0 at com.pentaho.analyzer.service.impl.AnalysisAreaManager.executeQuery(SourceFile:323) at com.pentaho.analyzer.report.ReportManagerImpl.parseAndExecuteMDX(SourceFile:308) at com.pentaho.analyzer.report.ReportManagerImpl.runReport(SourceFile:140) at com.pentaho.analyzer.report.ReportManagerImpl.runReport(SourceFile:110) at com.pentaho.analyzer.report.ReportRequestService$2.yf(SourceFile:275) at com.pentaho.analyzer.report.ReportRequestService$2.call(SourceFile:270) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) at java.util.concurrent.FutureTask.run(FutureTask.java:166) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:722) Caused by: java.lang.NumberFormatException: Illegal BOOLEAN literal: 0 at mondrian.spi.impl.JdbcDialectImpl.quoteBooleanLiteral(JdbcDialectImpl.java:415) at mondrian.spi.Dialect$Datatype$4.quoteValue(Dialect.java:904) at mondrian.spi.impl.JdbcDialectImpl.quote(JdbcDialectImpl.java:709) at mondrian.rolap.agg.ValueColumnPredicate.toSql(ValueColumnPredicate.java:160) at mondrian.rolap.agg.ListColumnPredicate.toSql(ListColumnPredicate.java:312) at mondrian.rolap.RolapStar$Column.createInExpr(RolapStar.java:1074) at mondrian.rolap.agg.AbstractQuerySpec.nonDistinctGenerateSql(AbstractQuerySpec.java:105) at mondrian.rolap.agg.AbstractQuerySpec.generateSqlQuery(AbstractQuerySpec.java:201) at mondrian.rolap.agg.AggregationManager.generateSql(AggregationManager.java:320) at mondrian.rolap.agg.SegmentLoader.createExecuteSql(SegmentLoader.java:562) at mondrian.rolap.agg.SegmentLoader.loadImpl(SegmentLoader.java:196) at mondrian.rolap.agg.SegmentLoader.access$000(SegmentLoader.java:52) at mondrian.rolap.agg.SegmentLoader$SegmentLoadCommand.call(SegmentLoader.java:167) at mondrian.rolap.agg.SegmentLoader$SegmentLoadCommand.call(SegmentLoader.java:141) ... 5 more

    Pentaho BI Platform Tracking | 3 years ago | Rob Fellows
    java.lang.RuntimeException: java.util.concurrent.ExecutionException: java.lang.RuntimeException: java.lang.NumberFormatException: Illegal BOOLEAN literal: 0
  6. 0

    this happens in olap4j when i try to do cube.lookupMember(...) Caused by: org.olap4j.OlapException: Unable to find a member with name [[Has coffee bar], [1]] The above is an example from foodmart + MondrianOlap4j I'm using the lookup method to find specific members: Member lookupMember(List<IdentifierSegment> nameParts) throws OlapException; For some reason this doesn't work for that member and I think thats related to the name being 1 / 0 Not sure why this is happening... The member is definitely there! In another query where the members of that dimension are included i also get the following exception (HSQLD + foodmart) thats why i think its related!?: java.lang.NumberFormatException: Illegal BOOLEAN literal: 0 at mondrian.spi.impl.JdbcDialectImpl.quoteBooleanLiteral(JdbcDialectImpl.java:371) at mondrian.spi.Dialect$Datatype$4.quoteValue(Dialect.java:810) at mondrian.spi.impl.JdbcDialectImpl.quote(JdbcDialectImpl.java:665) at mondrian.rolap.agg.ValueColumnPredicate.toSql(ValueColumnPredicate.java:165) at mondrian.rolap.RolapStar$Column.createInExpr(RolapStar.java:1340) at mondrian.rolap.agg.AbstractQuerySpec.nonDistinctGenerateSql(AbstractQuerySpec.java:102) at mondrian.rolap.agg.DrillThroughQuerySpec.generateSqlQuery(DrillThroughQuerySpec.java:132) at mondrian.rolap.agg.AggregationManager.getDrillThroughSql(AggregationManager.java:132) at mondrian.rolap.RolapCell.getDrillThroughSQL(RolapCell.java:101) at mondrian.rolap.RolapCell.drillThroughInternal(RolapCell.java:289) at mondrian.olap4j.MondrianOlap4jCell.drillThroughInternal(MondrianOlap4jCell.java:156) at mondrian.olap4j.MondrianOlap4jStatement.executeQuery2(MondrianOlap4jStatement.java:89)

    Pentaho BI Platform Tracking | 6 years ago | Paul Stoellberger
    java.lang.NumberFormatException: Illegal BOOLEAN literal: 0

    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. java.lang.NumberFormatException

      Illegal TIME literal: Q2, 2005

      at mondrian.spi.impl.JdbcDialectImpl.quoteTimeLiteral()
    2. mondrian.spi.impl
      JdbcDialectImpl.quoteTimeLiteral
      1. mondrian.spi.impl.JdbcDialectImpl.quoteTimeLiteral(JdbcDialectImpl.java:370)
      1 frame
    3. mondrian.spi
      Dialect$Datatype$6.quoteValue
      1. mondrian.spi.Dialect$Datatype$6.quoteValue(Dialect.java:720)
      1 frame
    4. mondrian.spi.impl
      JdbcDialectImpl.quote
      1. mondrian.spi.impl.JdbcDialectImpl.quote(JdbcDialectImpl.java:619)
      1 frame
    5. mondrian.rolap.agg
      ListColumnPredicate.toSql
      1. mondrian.rolap.agg.ValueColumnPredicate.toSql(ValueColumnPredicate.java:163)
      2. mondrian.rolap.agg.ListColumnPredicate.toSql(ListColumnPredicate.java:293)
      2 frames
    6. mondrian.rolap
      RolapStar$Column.createInExpr
      1. mondrian.rolap.RolapStar$Column.createInExpr(RolapStar.java:1276)
      1 frame
    7. mondrian.rolap.agg
      AggregationManager.loadAggregation
      1. mondrian.rolap.agg.AbstractQuerySpec.nonDistinctGenerateSql(AbstractQuerySpec.java:98)
      2. mondrian.rolap.agg.AbstractQuerySpec.generateSqlQuery(AbstractQuerySpec.java:169)
      3. mondrian.rolap.agg.AggregationManager.generateSql(AggregationManager.java:229)
      4. mondrian.rolap.agg.SegmentLoader.createExecuteSql(SegmentLoader.java:337)
      5. mondrian.rolap.agg.SegmentLoader.load(SegmentLoader.java:75)
      6. mondrian.rolap.agg.Aggregation.load(Aggregation.java:171)
      7. mondrian.rolap.agg.AggregationManager.loadAggregation(AggregationManager.java:89)
      7 frames
    8. mondrian.rolap
      RolapConnection.execute
      1. mondrian.rolap.FastBatchingCellReader$Batch.loadAggregation(FastBatchingCellReader.java:493)
      2. mondrian.rolap.FastBatchingCellReader$Batch.loadAggregation(FastBatchingCellReader.java:430)
      3. mondrian.rolap.FastBatchingCellReader.loadAggregation(FastBatchingCellReader.java:206)
      4. mondrian.rolap.FastBatchingCellReader.loadAggregations(FastBatchingCellReader.java:187)
      5. mondrian.rolap.RolapResult.executeBody(RolapResult.java:792)
      6. mondrian.rolap.RolapResult.<init>(RolapResult.java:414)
      7. mondrian.rolap.RolapConnection.execute(RolapConnection.java:560)
      7 frames
    9. mondrian.gui
      QueryPanel$3.actionPerformed
      1. mondrian.gui.QueryPanel.executeButtonActionPerformed(QueryPanel.java:235)
      2. mondrian.gui.QueryPanel.access$100(QueryPanel.java:53)
      3. mondrian.gui.QueryPanel$3.actionPerformed(QueryPanel.java:176)
      3 frames
    10. Java RT
      EventDispatchThread.run
      1. javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
      2. javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
      3. javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
      4. javax.swing.DefaultButtonModel.setPressed(Unknown Source)
      5. javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
      6. java.awt.Component.processMouseEvent(Unknown Source)
      7. javax.swing.JComponent.processMouseEvent(Unknown Source)
      8. java.awt.Component.processEvent(Unknown Source)
      9. java.awt.Container.processEvent(Unknown Source)
      10. java.awt.Component.dispatchEventImpl(Unknown Source)
      11. java.awt.Container.dispatchEventImpl(Unknown Source)
      12. java.awt.Component.dispatchEvent(Unknown Source)
      13. java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
      14. java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
      15. java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
      16. java.awt.Container.dispatchEventImpl(Unknown Source)
      17. java.awt.Window.dispatchEventImpl(Unknown Source)
      18. java.awt.Component.dispatchEvent(Unknown Source)
      19. java.awt.EventQueue.dispatchEvent(Unknown Source)
      20. java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
      21. java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
      22. java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
      23. java.awt.EventDispatchThread.pumpEvents(Unknown Source)
      24. java.awt.EventDispatchThread.pumpEvents(Unknown Source)
      25. java.awt.EventDispatchThread.run(Unknown Source)
      25 frames