org.pentaho.reporting.libraries.formula.parser.FormulaParseException: Extra content

Pentaho BI Platform Tracking | Will Gorman | 8 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    This is due to the definition of row level security in the steel-wheels metadata model. Here is the stack trace: 11:39:50,015 ERROR [SqlOpenFormula] an exception occurred org.pentaho.reporting.libraries.formula.parser.FormulaParseException: Extra content at org.pentaho.reporting.libraries.formula.parser.FormulaParser.parse(FormulaParser.java:64) at org.pentaho.reporting.libraries.formula.Formula.<init>(Formula.java:57) at org.pentaho.metadata.query.impl.sql.SqlOpenFormula.parseAndValidate(SqlOpenFormula.java:227) at org.pentaho.metadata.query.impl.sql.SqlGenerator.getSQL(SqlGenerator.java:394) at org.pentaho.metadata.query.impl.sql.SqlGenerator.generateSql(SqlGenerator.java:350) at org.pentaho.platform.plugin.action.pentahometadata.MetadataQueryComponent.executeSqlPhysicalModel(MetadataQueryComponent.java:365) at org.pentaho.platform.plugin.action.pentahometadata.MetadataQueryComponent.execute(MetadataQueryComponent.java:237) at org.pentaho.platform.plugin.action.pentahometadata.MQLRelationalDataComponent.executeAction(MQLRelationalDataComponent.java:111) at org.pentaho.platform.engine.services.solution.ComponentBase.execute(ComponentBase.java:463) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeComponent(RuntimeContext.java:1331) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeAction(RuntimeContext.java:1298) at org.pentaho.platform.engine.services.runtime.RuntimeContext.performActions(RuntimeContext.java:1216) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeLoop(RuntimeContext.java:1165) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:1045) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:938) at org.pentaho.platform.engine.services.solution.SolutionEngine.executeInternal(SolutionEngine.java:413) at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:316) at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:201) 11:39:50,031 ERROR [MetadataQueryComponent] error org.pentaho.pms.core.exception.PentahoMetadataException: SqlOpenFormula.ERROR_0005 - Failed to parse formula TRUE(); at org.pentaho.metadata.query.impl.sql.SqlOpenFormula.parseAndValidate(SqlOpenFormula.java:235) at org.pentaho.metadata.query.impl.sql.SqlGenerator.getSQL(SqlGenerator.java:394) at org.pentaho.metadata.query.impl.sql.SqlGenerator.generateSql(SqlGenerator.java:350) at org.pentaho.platform.plugin.action.pentahometadata.MetadataQueryComponent.executeSqlPhysicalModel(MetadataQueryComponent.java:365) at org.pentaho.platform.plugin.action.pentahometadata.MetadataQueryComponent.execute(MetadataQueryComponent.java:237) at org.pentaho.platform.plugin.action.pentahometadata.MQLRelationalDataComponent.executeAction(MQLRelationalDataComponent.java:111) at org.pentaho.platform.engine.services.solution.ComponentBase.execute(ComponentBase.java:463) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeComponent(RuntimeContext.java:1331) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeAction(RuntimeContext.java:1298) at org.pentaho.platform.engine.services.runtime.RuntimeContext.performActions(RuntimeContext.java:1216) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeLoop(RuntimeContext.java:1165) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:1045) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:938) at org.pentaho.platform.engine.services.solution.SolutionEngine.executeInternal(SolutionEngine.java:413) at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:316) at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:201)

    Pentaho BI Platform Tracking | 8 years ago | Will Gorman
    org.pentaho.reporting.libraries.formula.parser.FormulaParseException: Extra content
  2. 0

    This is due to the definition of row level security in the steel-wheels metadata model. Here is the stack trace: 11:39:50,015 ERROR [SqlOpenFormula] an exception occurred org.pentaho.reporting.libraries.formula.parser.FormulaParseException: Extra content at org.pentaho.reporting.libraries.formula.parser.FormulaParser.parse(FormulaParser.java:64) at org.pentaho.reporting.libraries.formula.Formula.<init>(Formula.java:57) at org.pentaho.metadata.query.impl.sql.SqlOpenFormula.parseAndValidate(SqlOpenFormula.java:227) at org.pentaho.metadata.query.impl.sql.SqlGenerator.getSQL(SqlGenerator.java:394) at org.pentaho.metadata.query.impl.sql.SqlGenerator.generateSql(SqlGenerator.java:350) at org.pentaho.platform.plugin.action.pentahometadata.MetadataQueryComponent.executeSqlPhysicalModel(MetadataQueryComponent.java:365) at org.pentaho.platform.plugin.action.pentahometadata.MetadataQueryComponent.execute(MetadataQueryComponent.java:237) at org.pentaho.platform.plugin.action.pentahometadata.MQLRelationalDataComponent.executeAction(MQLRelationalDataComponent.java:111) at org.pentaho.platform.engine.services.solution.ComponentBase.execute(ComponentBase.java:463) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeComponent(RuntimeContext.java:1331) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeAction(RuntimeContext.java:1298) at org.pentaho.platform.engine.services.runtime.RuntimeContext.performActions(RuntimeContext.java:1216) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeLoop(RuntimeContext.java:1165) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:1045) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:938) at org.pentaho.platform.engine.services.solution.SolutionEngine.executeInternal(SolutionEngine.java:413) at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:316) at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:201) 11:39:50,031 ERROR [MetadataQueryComponent] error org.pentaho.pms.core.exception.PentahoMetadataException: SqlOpenFormula.ERROR_0005 - Failed to parse formula TRUE(); at org.pentaho.metadata.query.impl.sql.SqlOpenFormula.parseAndValidate(SqlOpenFormula.java:235) at org.pentaho.metadata.query.impl.sql.SqlGenerator.getSQL(SqlGenerator.java:394) at org.pentaho.metadata.query.impl.sql.SqlGenerator.generateSql(SqlGenerator.java:350) at org.pentaho.platform.plugin.action.pentahometadata.MetadataQueryComponent.executeSqlPhysicalModel(MetadataQueryComponent.java:365) at org.pentaho.platform.plugin.action.pentahometadata.MetadataQueryComponent.execute(MetadataQueryComponent.java:237) at org.pentaho.platform.plugin.action.pentahometadata.MQLRelationalDataComponent.executeAction(MQLRelationalDataComponent.java:111) at org.pentaho.platform.engine.services.solution.ComponentBase.execute(ComponentBase.java:463) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeComponent(RuntimeContext.java:1331) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeAction(RuntimeContext.java:1298) at org.pentaho.platform.engine.services.runtime.RuntimeContext.performActions(RuntimeContext.java:1216) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeLoop(RuntimeContext.java:1165) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:1045) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:938) at org.pentaho.platform.engine.services.solution.SolutionEngine.executeInternal(SolutionEngine.java:413) at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:316) at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:201)

    Pentaho BI Platform Tracking | 8 years ago | Will Gorman
    org.pentaho.reporting.libraries.formula.parser.FormulaParseException: Extra content
  3. 0

    Repro: Try this as a repro path: Create a new dashboard, new chart, MQL query editor: Add Buy Price to details and conditions ... but do not give condition any more information (leaving it invalid). Then hit preview... There is no information given to the user regarding what went wrong, just a stack trace in the server console and an empty preview window. 05:04:54,109 ERROR [SqlOpenFormula] an exception occurred org.pentaho.reporting.libraries.formula.parser.FormulaParseException: Encountered "<EOF>" at line 1, column 41. Was expecting: "(" ... at org.pentaho.reporting.libraries.formula.parser.FormulaParser.generateParseException(FormulaParser.java:48) at org.pentaho.reporting.libraries.formula.parser.GeneratedFormulaParser.jj_consume_token(GeneratedFormulaParser .java:509) at org.pentaho.reporting.libraries.formula.parser.GeneratedFormulaParser.getLValue(GeneratedFormulaParser.java:1 69) at org.pentaho.reporting.libraries.formula.parser.GeneratedFormulaParser.startTail(GeneratedFormulaParser.java:1 12) at org.pentaho.reporting.libraries.formula.parser.GeneratedFormulaParser.getExpression(GeneratedFormulaParser.ja va:70) at org.pentaho.reporting.libraries.formula.parser.FormulaParser.parse(FormulaParser.java:61) at org.pentaho.reporting.libraries.formula.Formula.<init>(Formula.java:57) at org.pentaho.metadata.query.impl.sql.SqlOpenFormula.parseAndValidate(SqlOpenFormula.java:227) at org.pentaho.metadata.query.impl.sql.SqlGenerator.getSQL(SqlGenerator.java:389) at org.pentaho.metadata.query.impl.sql.SqlGenerator.generateSql(SqlGenerator.java:350) at org.pentaho.platform.plugin.action.pentahometadata.MetadataQueryComponent.executeSqlPhysicalModel(MetadataQue ryComponent.java:365) at org.pentaho.platform.plugin.action.pentahometadata.MetadataQueryComponent.execute(MetadataQueryComponent.java :237) at org.pentaho.charteditor.server.MetadataServlet.getPreviewData(MetadataServlet.java:197) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:527) at org.pentaho.platform.web.servlet.GwtRpcPluginProxyServlet.processCall(GwtRpcPluginProxyServlet.java:125) at com.google.gwt.user.server.rpc.RemoteServiceServlet.doPost(RemoteServiceServlet.java:86) at javax.servlet.http.HttpServlet.service(HttpServlet.java:710) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378) at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:10 9) 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.pentaho.platform.web.http.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:85) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFi lter.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.pentaho.platform.web.http.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenti cationFilter.java:169) 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.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:278) 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.logout.LogoutFilter.doFilterHttp(LogoutFilter.java:89) 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.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilt er.java:134) ...more

    Pentaho BI Platform Tracking | 8 years ago | Gretchen Moran
    org.pentaho.reporting.libraries.formula.parser.FormulaParseException: Encountered "<EOF>" at line 1, column 41. Was expecting: "(" ...
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Repro: Try this as a repro path: Create a new dashboard, new chart, MQL query editor: Add Buy Price to details and conditions ... but do not give condition any more information (leaving it invalid). Then hit preview... There is no information given to the user regarding what went wrong, just a stack trace in the server console and an empty preview window. 05:04:54,109 ERROR [SqlOpenFormula] an exception occurred org.pentaho.reporting.libraries.formula.parser.FormulaParseException: Encountered "<EOF>" at line 1, column 41. Was expecting: "(" ... at org.pentaho.reporting.libraries.formula.parser.FormulaParser.generateParseException(FormulaParser.java:48) at org.pentaho.reporting.libraries.formula.parser.GeneratedFormulaParser.jj_consume_token(GeneratedFormulaParser .java:509) at org.pentaho.reporting.libraries.formula.parser.GeneratedFormulaParser.getLValue(GeneratedFormulaParser.java:1 69) at org.pentaho.reporting.libraries.formula.parser.GeneratedFormulaParser.startTail(GeneratedFormulaParser.java:1 12) at org.pentaho.reporting.libraries.formula.parser.GeneratedFormulaParser.getExpression(GeneratedFormulaParser.ja va:70) at org.pentaho.reporting.libraries.formula.parser.FormulaParser.parse(FormulaParser.java:61) at org.pentaho.reporting.libraries.formula.Formula.<init>(Formula.java:57) at org.pentaho.metadata.query.impl.sql.SqlOpenFormula.parseAndValidate(SqlOpenFormula.java:227) at org.pentaho.metadata.query.impl.sql.SqlGenerator.getSQL(SqlGenerator.java:389) at org.pentaho.metadata.query.impl.sql.SqlGenerator.generateSql(SqlGenerator.java:350) at org.pentaho.platform.plugin.action.pentahometadata.MetadataQueryComponent.executeSqlPhysicalModel(MetadataQue ryComponent.java:365) at org.pentaho.platform.plugin.action.pentahometadata.MetadataQueryComponent.execute(MetadataQueryComponent.java :237) at org.pentaho.charteditor.server.MetadataServlet.getPreviewData(MetadataServlet.java:197) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:527) at org.pentaho.platform.web.servlet.GwtRpcPluginProxyServlet.processCall(GwtRpcPluginProxyServlet.java:125) at com.google.gwt.user.server.rpc.RemoteServiceServlet.doPost(RemoteServiceServlet.java:86) at javax.servlet.http.HttpServlet.service(HttpServlet.java:710) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378) at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:10 9) 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.pentaho.platform.web.http.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:85) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFi lter.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.pentaho.platform.web.http.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenti cationFilter.java:169) 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.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:278) 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.logout.LogoutFilter.doFilterHttp(LogoutFilter.java:89) 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.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilt er.java:134) ...more

    Pentaho BI Platform Tracking | 8 years ago | Gretchen Moran
    org.pentaho.reporting.libraries.formula.parser.FormulaParseException: Encountered "<EOF>" at line 1, column 41. Was expecting: "(" ...

    Root Cause Analysis

    1. org.pentaho.reporting.libraries.formula.parser.FormulaParseException

      Extra content

      at org.pentaho.reporting.libraries.formula.parser.FormulaParser.parse()
    2. org.pentaho.reporting
      Formula.<init>
      1. org.pentaho.reporting.libraries.formula.parser.FormulaParser.parse(FormulaParser.java:64)
      2. org.pentaho.reporting.libraries.formula.Formula.<init>(Formula.java:57)
      2 frames
    3. org.pentaho.metadata
      SqlGenerator.generateSql
      1. org.pentaho.metadata.query.impl.sql.SqlOpenFormula.parseAndValidate(SqlOpenFormula.java:227)
      2. org.pentaho.metadata.query.impl.sql.SqlGenerator.getSQL(SqlGenerator.java:394)
      3. org.pentaho.metadata.query.impl.sql.SqlGenerator.generateSql(SqlGenerator.java:350)
      3 frames
    4. org.pentaho.platform
      SolutionEngine.execute
      1. org.pentaho.platform.plugin.action.pentahometadata.MetadataQueryComponent.executeSqlPhysicalModel(MetadataQueryComponent.java:365)
      2. org.pentaho.platform.plugin.action.pentahometadata.MetadataQueryComponent.execute(MetadataQueryComponent.java:237)
      3. org.pentaho.platform.plugin.action.pentahometadata.MQLRelationalDataComponent.executeAction(MQLRelationalDataComponent.java:111)
      4. org.pentaho.platform.engine.services.solution.ComponentBase.execute(ComponentBase.java:463)
      5. org.pentaho.platform.engine.services.runtime.RuntimeContext.executeComponent(RuntimeContext.java:1331)
      6. org.pentaho.platform.engine.services.runtime.RuntimeContext.executeAction(RuntimeContext.java:1298)
      7. org.pentaho.platform.engine.services.runtime.RuntimeContext.performActions(RuntimeContext.java:1216)
      8. org.pentaho.platform.engine.services.runtime.RuntimeContext.executeLoop(RuntimeContext.java:1165)
      9. org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:1045)
      10. org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:938)
      11. org.pentaho.platform.engine.services.solution.SolutionEngine.executeInternal(SolutionEngine.java:413)
      12. org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:316)
      13. org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:201)
      13 frames