How to clear the DBStatus Field after Edit Set Failure

Version 1

    Details

    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.


    Resolution

    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