The information in this article applies to product: e-Work 6.x
Issue
As stated in the product documentation, the valid range of values for the priority of a folder (%Priority) is 0 - 9. However, it's possible to create a formula that will evaluate to an invalid value. For example, a loopback action may execute the following each time it is completed: %Priority:=%Priority-1. Given enough iterations, this will evaluate to a value other than 0 - 9, and undefined behavior may result.
With Oracle, an error message similar to the following may be written to the Windows application event log:
Database exception while trying to update active alerts. Operation: ExecuteSQL. Code: -1. Description: ORA-01438: value larger than specified precision allows for this column
Resolution
- It is the responsibility of the procedure developer to ensure that %Priority is not assigned an invalid value.
