Invalid Expression Error

The Invalid Expression error is issued in the following situations:

Division by '0' (zero): you are trying to divide by 0.

Fix the expression that has this division by 0.

Non-terminated 'Text' literal: you are not handling a Text literal properly.

Fix this Text literal in your expression.

Element <element> does not exist in the expression Scope: the syntax of the expression is correct, but it's using an element that either does not exist in the eSpace or is not available in the expression scope.

Check the Scope tree of your expression and select the desired element from there.

Syntax error caused by unexpected <element> in expression: the syntax of the expression is not correct. For example, you are not using an operator correctly: MyVar = + VarAux + 2.
Expecting <element> instead of <element>: the syntax of the expression is not correct. For example, if you do not end a function call properly, with a right-parenthesis: MyFunction(3, 'Sweet'.

Check your expression to validate its operands, operators, and variables.

Parameter 'parameter' in function 'function' is mandatory and must be specified: you are invoking a function with no argument for a mandatory parameter.

Check the Built-in function or the User Function definition, to validate which input parameters are mandatory.

Too many arguments specified for function '<function>': you have mapped more arguments in the function you're using than the number of parameters that it actually has or; you're using at least one named parameter that "advanced" the position of the corresponding argument so the continuous arguments exceed the available number of parameters in the function.

Check the Built-in function or the User Function definition to validate its arguments and the function calls syntax.

Too many levels of nested function calls: you are invoking functions within function arguments successively, exceeding the maximum number of levels (20) of nesting allowed.

Replace some of the function calls by variables where their value has been previously assigned invoking the necessary function, in the action flow.

Unexpected argument named '<parameter>' in function '<function>' call: the syntax of the expression is correct, but it has an argument for a parameter that does not exist in your function. Probably you've deleted this parameter from the function and have not "clean up" your expression yet.

Check the Built-in function or the User Function definition, to validate its arguments or; in case you've actually deleted a parameter, fix the expression errors.

Argument named '<parameter>' was specified more than once in function '<function>' call: you have mapped more than one argument in the function call to the same parameter.

Check whether you're using the same name more than once or if you'd already mapped the argument by position and then used its name again, in the function call.

'<function>' function cannot be executed in the database, so it can't receive any attributes from the aggregate as parameter: you are using a user-function or built-in function that does not exist in the database.

Change the function to use a parameter from outside the aggregate.

Clicking the symbol will take you directly to the invalid expression.