PMs don't run for all databases
after deleting a database, MC 2022 & earlier

There is a bug in the _multidbupdate stored procedure for MC 2022 and earlier.

If you disable/delete an ent database, the PMs for databases alphabetically after that will not generate PMs

To fix, we created this fix: add line 35 below to the Accruent stored procedure:

image.png

This will not affect you if you have only ever had one ent database per server

This will not affect you (other than you'll see errors in the log file) if the deleted database is alphabetically the last database.

This issue does not occur in MC 2025.