britebyte
06-01-2012, 06:35 PM
Can anyone see an issue with the formula below? I cannot so I am wondering if libformula has a maximum length on the formula definition.
IF(OR([RIGHTSE1] = "Performer" ; [RIGHTSF1] = "Artiste interprète";[RIGHTSE2] = "Performer" ; [RIGHTSF2] ="Artiste interprète"; [RIGHTSE3] = "Perfomer" ; [RIGHTSF3] = "Artiste interprète"; [RIGHTSE4] = "Performer" ; [RIGHTSF4] = "Artiste interprète"; [RIGHTSE5] = "Performer" ; [RIGHTSF5] = "Artiste interprète"); "performer";"")
I get the error below - strangely in evaluating the equal function:
2012/06/01 18:27:40 - Formula 2.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : Unexpected error
2012/06/01 18:27:40 - Formula 2.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : org.pentaho.di.core.exception.KettleValueException:
2012/06/01 18:27:40 - Formula 2.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : org.pentaho.reporting.libraries.formula.EvaluationException: LibFormulaErrorValue{errorCode=522, errorMessage=NA}
2012/06/01 18:27:40 - Formula 2.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : LibFormulaErrorValue{errorCode=522, errorMessage=NA}
2012/06/01 18:27:40 - Formula 2.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) :
2012/06/01 18:27:40 - Formula 2.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : at org.pentaho.di.trans.steps.formula.Formula.calcFields(Formula.java:230)
2012/06/01 18:27:40 - Formula 2.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : at org.pentaho.di.trans.steps.formula.Formula.processRow(Formula.java:97)
2012/06/01 18:27:40 - Formula 2.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : at org.pentaho.di.trans.step.RunThread.run(RunThread.java:40)
2012/06/01 18:27:40 - Formula 2.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : at java.lang.Thread.run(Thread.java:722)
2012/06/01 18:27:40 - Formula 2.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : Caused by: org.pentaho.reporting.libraries.formula.EvaluationException: LibFormulaErrorValue{errorCode=522, errorMessage=NA}
2012/06/01 18:27:40 - Formula 2.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : at org.pentaho.reporting.libraries.formula.EvaluationException.getInstance(EvaluationException.java:70)
2012/06/01 18:27:40 - Formula 2.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : at org.pentaho.reporting.libraries.formula.operators.EqualOperator.evaluate(EqualOperator.java:54)
2012/06/01 18:27:40 - Formula 2.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : at org.pentaho.reporting.libraries.formula.lvalues.Term.evaluate(Term.java:63)
2012/06/01 18:27:40 - Formula 2.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : at org.pentaho.reporting.libraries.formula.lvalues.FormulaFunction$FormulaParameterCallback.get(FormulaFunction.java:66)
2012/06/01 18:27:40 - Formula 2.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : at org.pentaho.reporting.libraries.formula.lvalues.FormulaFunction$FormulaParameterCallback.getType(FormulaFunction.java:117)
2012/06/01 18:27:40 - Formula 2.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : at org.pentaho.reporting.libraries.formula.function.logical.OrFunction.evaluate(OrFunction.java:60)
2012/06/01 18:27:40 - Formula 2.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : at org.pentaho.reporting.libraries.formula.lvalues.FormulaFunction.evaluate(FormulaFunction.java:223)
2012/06/01 18:27:40 - Formula 2.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : at org.pentaho.reporting.libraries.formula.lvalues.FormulaFunction$FormulaParameterCallback.get(FormulaFunction.java:66)
2012/06/01 18:27:40 - Formula 2.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : at org.pentaho.reporting.libraries.formula.lvalues.FormulaFunction$FormulaParameterCallback.getType(FormulaFunction.java:117)
2012/06/01 18:27:40 - Formula 2.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : at org.pentaho.reporting.libraries.formula.function.logical.IfFunction.evaluate(IfFunction.java:58)
2012/06/01 18:27:40 - Formula 2.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : at org.pentaho.reporting.libraries.formula.lvalues.FormulaFunction.evaluate(FormulaFunction.java:223)
2012/06/01 18:27:40 - Formula 2.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : at org.pentaho.di.trans.steps.formula.Formula.calcFields(Formula.java:145)
IF(OR([RIGHTSE1] = "Performer" ; [RIGHTSF1] = "Artiste interprète";[RIGHTSE2] = "Performer" ; [RIGHTSF2] ="Artiste interprète"; [RIGHTSE3] = "Perfomer" ; [RIGHTSF3] = "Artiste interprète"; [RIGHTSE4] = "Performer" ; [RIGHTSF4] = "Artiste interprète"; [RIGHTSE5] = "Performer" ; [RIGHTSF5] = "Artiste interprète"); "performer";"")
I get the error below - strangely in evaluating the equal function:
2012/06/01 18:27:40 - Formula 2.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : Unexpected error
2012/06/01 18:27:40 - Formula 2.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : org.pentaho.di.core.exception.KettleValueException:
2012/06/01 18:27:40 - Formula 2.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : org.pentaho.reporting.libraries.formula.EvaluationException: LibFormulaErrorValue{errorCode=522, errorMessage=NA}
2012/06/01 18:27:40 - Formula 2.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : LibFormulaErrorValue{errorCode=522, errorMessage=NA}
2012/06/01 18:27:40 - Formula 2.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) :
2012/06/01 18:27:40 - Formula 2.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : at org.pentaho.di.trans.steps.formula.Formula.calcFields(Formula.java:230)
2012/06/01 18:27:40 - Formula 2.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : at org.pentaho.di.trans.steps.formula.Formula.processRow(Formula.java:97)
2012/06/01 18:27:40 - Formula 2.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : at org.pentaho.di.trans.step.RunThread.run(RunThread.java:40)
2012/06/01 18:27:40 - Formula 2.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : at java.lang.Thread.run(Thread.java:722)
2012/06/01 18:27:40 - Formula 2.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : Caused by: org.pentaho.reporting.libraries.formula.EvaluationException: LibFormulaErrorValue{errorCode=522, errorMessage=NA}
2012/06/01 18:27:40 - Formula 2.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : at org.pentaho.reporting.libraries.formula.EvaluationException.getInstance(EvaluationException.java:70)
2012/06/01 18:27:40 - Formula 2.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : at org.pentaho.reporting.libraries.formula.operators.EqualOperator.evaluate(EqualOperator.java:54)
2012/06/01 18:27:40 - Formula 2.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : at org.pentaho.reporting.libraries.formula.lvalues.Term.evaluate(Term.java:63)
2012/06/01 18:27:40 - Formula 2.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : at org.pentaho.reporting.libraries.formula.lvalues.FormulaFunction$FormulaParameterCallback.get(FormulaFunction.java:66)
2012/06/01 18:27:40 - Formula 2.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : at org.pentaho.reporting.libraries.formula.lvalues.FormulaFunction$FormulaParameterCallback.getType(FormulaFunction.java:117)
2012/06/01 18:27:40 - Formula 2.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : at org.pentaho.reporting.libraries.formula.function.logical.OrFunction.evaluate(OrFunction.java:60)
2012/06/01 18:27:40 - Formula 2.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : at org.pentaho.reporting.libraries.formula.lvalues.FormulaFunction.evaluate(FormulaFunction.java:223)
2012/06/01 18:27:40 - Formula 2.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : at org.pentaho.reporting.libraries.formula.lvalues.FormulaFunction$FormulaParameterCallback.get(FormulaFunction.java:66)
2012/06/01 18:27:40 - Formula 2.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : at org.pentaho.reporting.libraries.formula.lvalues.FormulaFunction$FormulaParameterCallback.getType(FormulaFunction.java:117)
2012/06/01 18:27:40 - Formula 2.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : at org.pentaho.reporting.libraries.formula.function.logical.IfFunction.evaluate(IfFunction.java:58)
2012/06/01 18:27:40 - Formula 2.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : at org.pentaho.reporting.libraries.formula.lvalues.FormulaFunction.evaluate(FormulaFunction.java:223)
2012/06/01 18:27:40 - Formula 2.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : at org.pentaho.di.trans.steps.formula.Formula.calcFields(Formula.java:145)