This article shows you how to clear the DBStatus field after an Edit Set Failure and how to allow a restore of the database when receiving the message Commit in Progress.
1. Launch SQL Server Management Studio and run the following query.
UPDATE HEATDb SET DBStatus = ''2. Restore the database to a point prior to the Edit Set failure