org.pentaho.pms.core.exception.PentahoMetadataException: SqlOpenFormula.ERROR_0005 - Failed to parse formula TRUE();

Pentaho BI Platform Tracking | Will Gorman | 8 years ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded 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.pms.core.exception.PentahoMetadataException: SqlOpenFormula.ERROR_0005 - Failed to parse formula TRUE();
  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.pms.core.exception.PentahoMetadataException: SqlOpenFormula.ERROR_0005 - Failed to parse formula TRUE();

    Root Cause Analysis

    1. org.pentaho.pms.core.exception.PentahoMetadataException

      SqlOpenFormula.ERROR_0005 - Failed to parse formula TRUE();

      at org.pentaho.metadata.query.impl.sql.SqlOpenFormula.parseAndValidate()
    2. org.pentaho.metadata
      SqlGenerator.generateSql
      1. org.pentaho.metadata.query.impl.sql.SqlOpenFormula.parseAndValidate(SqlOpenFormula.java:235)
      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
    3. 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