Script execution failure; Database Transaction Rollback caused unexpected or hard to track error

When a Script execution fails an unexpected or hard to track error message may be shown.

This occurs in the following scenario:

• There are nested levels of Database Transactions.
• A Database Transaction begins a rollback.
• Another script is then executed.
• For example, there is a nested script, i.e. one script calls another script, or a Business Layer method that calls a script, e.g. Income Distribution Execute commits a finBatch which in turn fires a script.
• This normally occurs because return values have not been tested and when a script should exit it continues processing.