org.pentaho.pms.core.exception.PentahoMetadataException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • 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)
    via by Will Gorman,
  • 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)
    via by Will Gorman,
    • 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)
    No Bugmate found.