Formula Execution Errors

Fast formula execution errors occur when a problem arises while a formula is running. Typically, data-related issues cause these errors either in the formula or in the application database.

Formula Execution Errors

Here's some of the formula execution errors.

Formula Execution Error

Description

Uninitialized Variable

When the formula compiler can't fully determine if a variable or context is initialized, it generates a code to test if the variable is initialized.

When the formula runs, the code displays an error if the variable or context isn't initialized.

Divide by Zero

Raised when a numeric value is divided by zero.

No Data Found

Raised when a non-array type database item unexpectedly fails to return any data. If the database item can't return data, then it should provide a default value.

You can specify a default value using a DEFAULT statement. An error in formula function code can also cause this error message.

Too Many Rows

Raised when a non-array type database item unexpectedly returns more than a single row of data. The cause is an incorrect assumption made about how the data is being accessed.

An error in the formula function code can also cause this error message.

NULL Data Found

Raised when a database item unexpectedly returns a NULL data value. If the database item can return a NULL value, then it provides a default value.

Note:

Some database items can't return a NULL value. If the database items can return a NULL value, then you can provide a default value for that database item.

Value Exceeded Allowable Range

Raised for a number of reasons, such as exceeding the maximum allowable length of a string.

Invalid Number

Raised when a formula attempts to convert a nonnumeric string to a number.

User Defined Function Error

Raised from within a formula function. The error message text is provided as part of the formula error message.

External Function Call Error

A formula function returns an error, but doesn't provide any additional information to the formula code. The function may have sent error information to the logging destination for the executing code.

Function Returned NULL Value

A formula function returns a NULL value.

Too Many Iterations

A single WHILE loop, or a combination of WHILE loops has exceeded the maximum number of permitted iterations. This error is raised to terminate loops that can never end, which indicates a programming error within the formula.

Array Data Value Not Set

The formula tries to access an array index that has no data value. This error occurs in the formula code.

Invalid Type Parameter for WSA_EXISTS

You specify an invalid data type in the WSA_EXISTS call.

Incorrect Data Type For Stored Item

When retrieving an item using WSA_GET, the actual data type doesn't match that of the stored item. This error occurs within the calling formula.

Called Formula Not Found

The called formula isn't found when attempting to call a formula from a formula. This error may occur due to an issue in the calling formula, or because of installation issues.

Recursive Formula Call

An attempt was made to call a formula from itself. The call could be made directly or indirectly from another called formula. Calling a formula in a recursive manner isn't permitted.

Input Data Has Different Types in Called and Calling Formulas

When calling a formula from a formula, the input data type within the called formula doesn't match the data type specified in the calling formula.

Output Has Different Types In Called and Calling Formulas

When calling a formula from a formula, the output data type within the called formula doesn't match the data type specified in the calling formula.

Too Many Formula Calls

When a formula calls another formula in its text, resulting in a hierarchy. The maximum depth of the hierarchy is 10.