2022-08-19 ACE Release Patch

On August 14, 2022, our monthly release was deployed.

Selecting debt_stats fields in Logic blocks was causing excessive slowness and that has been corrected.

We would also like to note that if you need to use debt_stats fields in custom SQL for your logic blocks, please consider the following guidance.

1. Do not populate the debt_stats table in the "Custom From" portion of the SQL

2. Do only include debt_stats by using a sub-select statement similar to the one below

Please be sure to construct your Logic Block custom SQL statements carefully to avoid problems that can impact the load on your ACE database.

In order to deploy the release, downtime of up to 10-15 minutes may be experienced.

We apologize for the inconvenience this may create, but please know that we are dedicated to taking corrective actions whenever appropriate.