Unable to finish a repair on Workflow Solution because database is involved in a database mirroring session or an availability group.

Products

• ServiceDesk
• IT Management Suite

Issue/Introduction

While running a repair on Workflow Solution with the Workflow MSI, it said that it finished successfully but there was an error message saying:

"Database integration strategy failed due to an error: The operation cannot be performed on database "ProcessManager" because it is involved in a database mirroring session or an availability group."

Environment

Workflow Solution 8.6, 8.7

Cause

The ProcessManager database is being mirrored to another SQL server for disaster recovery purposes. The database was configured to be in a high availability setup.

Resolution

Disable the mirroring or high availability for this server so that a repair can be performed. Once the repair is completed it can be reenable.