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

Pentaho BI Platform Tracking | Will Gorman | 7 years ago
  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 | 7 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 | 7 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 | 7 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 | 7 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