Console is not working correctly after upgrading from 9.0.1 to 10.0 (4224945)

After successfully upgrading to 10.0 most actions inside the Recovery Manager for AD console results in an error similar to: "sqlite3_statement_backend::prepare: no such column: Deleted." Additionally, the dropdown action does not expand the selection.

OR

The MMC starts with an error: "MMC has detected an error in a snap-in. It is recommended that you shut down and restart MMC"

WORKAROUND:

1. Open the folder C:\ProgramData\Quest\Recovery Manager for Active Directory\
2. Make a copy of the ERDiskAD.mdb file
3. Run the Powershell script attached to this KB

NOTE: If you have installed RMAD to a different location than the default (C:\Program Files) you will need to edit the Powershell script to match the path for where RMAD is installed:

1. Edit the script
2. Change $env:ProgramFiles on the third line to match the path where RMAD is installed. For example if RMAD is installed on E:\Program Files, modify the line to "E:\ProgramFiles\Quest\Recovery Manager for Active Directory Forest Edition\System.Data.SQLite.dll"

STATUS:

Pending a new 10.0 hotfix