Formula evaluation failed

For issues specific to openLCA release 1.7.x
Post Reply
maria
Posts: 1
Joined: 04 Apr 2018 12:47

Formula evaluation failed

Post by maria » 04 Apr 2018 13:53

Hello,
I am using openlca 1.7.0. I have downloaded openLCA LCIA methods v.1.5.7 from openLCA Nexus.
I imported the openLCA methods and these appear within Impact assessment methods folder. However, when I calculate any product systems, results are always a list of zeros for every item in the LCI.
I increased the maximal memory usage to 5000MB.

I copied examples from the log file.

Has anyone else had this problem?

Thanks
María


Time Thread Level Category Message

514857 ModalContext ERROR org.openlca.core.matrix.ExchangeCell Formula evaluation failed, exchange 327477

org.openlca.expressions.InterpreterException: Evaluation of expression ParentValue* machine_diesel_ratio failed: Unknown variable parentvalue at line 1, column 1

at org.openlca.expressions.Scope.eval(Scope.java:60)

at org.openlca.core.matrix.ExchangeCell.tryEval(ExchangeCell.java:39)

at org.openlca.core.matrix.ExchangeCell.eval(ExchangeCell.java:29)

at org.openlca.core.matrix.ExchangeMatrix.lambda$1(ExchangeMatrix.java:83)

at org.openlca.core.matrix.ExchangeMatrix.iterate(ExchangeMatrix.java:115)

at org.openlca.core.matrix.ExchangeMatrix.eval(ExchangeMatrix.java:82)

at org.openlca.core.matrix.Inventory.evalFormulas(Inventory.java:71)

at org.openlca.core.matrix.Inventory.createMatrix(Inventory.java:39)

at org.openlca.core.math.SystemCalculator.calculator(SystemCalculator.java:51)

at org.openlca.core.math.SystemCalculator.calculateContributions(SystemCalculator.java:37)

at org.openlca.app.editors.systems.CalculationWizard$Calculation.solve(Unknown Source)

at org.openlca.app.editors.systems.CalculationWizard$Calculation.run(Unknown Source)

at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:122)

Caused by: org.openlca.expressions.ExpressionException: Unknown variable parentvalue at line 1, column 1

at org.openlca.expressions.VariableFunction.evaluate(VariableFunction.java:38)

at org.openlca.expressions.OpMultiplication.evaluate(OpMultiplication.java:7)

at org.openlca.expressions.Scope.tryEval(Scope.java:71)

at org.openlca.expressions.Scope.eval(Scope.java:58)

... 12 more

514857 ModalContext ERROR org.openlca.core.matrix.ExchangeCell Formula evaluation failed, exchange 609750

org.openlca.expressions.InterpreterException: Evaluation of expression ParentValue* machine_diesel_ratio failed: Unknown variable parentvalue at line 1, column 1

at org.openlca.expressions.Scope.eval(Scope.java:60)

at org.openlca.core.matrix.ExchangeCell.tryEval(ExchangeCell.java:39)

at org.openlca.core.matrix.ExchangeCell.eval(ExchangeCell.java:29)

at org.openlca.core.matrix.ExchangeMatrix.lambda$1(ExchangeMatrix.java:83)

at org.openlca.core.matrix.ExchangeMatrix.iterate(ExchangeMatrix.java:115)

at org.openlca.core.matrix.ExchangeMatrix.eval(ExchangeMatrix.java:82)

at org.openlca.core.matrix.Inventory.evalFormulas(Inventory.java:71)

at org.openlca.core.matrix.Inventory.createMatrix(Inventory.java:39)

at org.openlca.core.math.SystemCalculator.calculator(SystemCalculator.java:51)

at org.openlca.core.math.SystemCalculator.calculateContributions(SystemCalculator.java:37)

at org.openlca.app.editors.systems.CalculationWizard$Calculation.solve(Unknown Source)

at org.openlca.app.editors.systems.CalculationWizard$Calculation.run(Unknown Source)

at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:122)

Caused by: org.openlca.expressions.ExpressionException: Unknown variable parentvalue at line 1, column 1

at org.openlca.expressions.VariableFunction.evaluate(VariableFunction.java:38)

at org.openlca.expressions.OpMultiplication.evaluate(OpMultiplication.java:7)

at org.openlca.expressions.Scope.tryEval(Scope.java:71)

at org.openlca.expressions.Scope.eval(Scope.java:58)

... 12 more

514858 ModalContext ERROR org.openlca.core.matrix.ExchangeCell Formula evaluation failed, exchange 553237

org.openlca.expressions.InterpreterException: Evaluation of expression (NGL_RP*1.64E-05 )/(density_natural_gas_liquids* amount_of_NGL_in_natural_gas) failed: Evaluation of variable amount_of_ngl_in_natural_gas failed: Lexical error at line 1, column 21. Encountered: "," (44), after : "" at line 1, column 50

at org.openlca.expressions.Scope.eval(Scope.java:60)

at org.openlca.core.matrix.ExchangeCell.tryEval(ExchangeCell.java:39)

at org.openlca.core.matrix.ExchangeCell.eval(ExchangeCell.java:29)

at org.openlca.core.matrix.ExchangeMatrix.lambda$1(ExchangeMatrix.java:83)

at org.openlca.core.matrix.ExchangeMatrix.iterate(ExchangeMatrix.java:115)

at org.openlca.core.matrix.ExchangeMatrix.eval(ExchangeMatrix.java:82)

at org.openlca.core.matrix.Inventory.evalFormulas(Inventory.java:71)

at org.openlca.core.matrix.Inventory.createMatrix(Inventory.java:39)

at org.openlca.core.math.SystemCalculator.calculator(SystemCalculator.java:51)

at org.openlca.core.math.SystemCalculator.calculateContributions(SystemCalculator.java:37)

at org.openlca.app.editors.systems.CalculationWizard$Calculation.solve(Unknown Source)

at org.openlca.app.editors.systems.CalculationWizard$Calculation.run(Unknown Source)

at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:122)

Caused by: org.openlca.expressions.ExpressionException: Evaluation of variable amount_of_ngl_in_natural_gas failed: Lexical error at line 1, column 21. Encountered: "," (44), after : "" at line 1, column 50

at org.openlca.expressions.VariableFunction.evaluate(VariableFunction.java:34)

at org.openlca.expressions.OpMultiplication.evaluate(OpMultiplication.java:10)

at org.openlca.expressions.OpDivision.evaluate(OpDivision.java:10)

at org.openlca.expressions.Scope.tryEval(Scope.java:71)

at org.openlca.expressions.Scope.eval(Scope.java:58)

... 12 more

aciroth
Posts: 750
Joined: 09 May 2010 23:28

Re: Formula evaluation failed

Post by aciroth » 05 Apr 2018 11:15

Hi Maria,
welcome -
as the log file says, a formula (or maybe more than one) is not following openLCA's specification and therefore the calculation does not work.
ParentValue* machine_diesel_ratio failed: Unknown variable parentvalue
You should fix these formula issues and then recalculate. You can find all issues for formulas if you validate the database (right-click, then validate, on the database). Note that capital letters are not recognised in formulas.

Hth,
Andreas

Post Reply

Who is online

Users browsing this forum: No registered users and 3 guests