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

book

Article ID: 222983

calendar_today

Updated On:

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."

Cause

The ProcessManager database is being mirrored to another SQL server for disaster recovery purposes. The customer has this database in a high availability setup.

Environment

ServiceDesk Solution 8.5, 8.6
Workflow Solution 8.5, 8.6

Resolution

They need to disable the mirroring or high availability for this server so they can perform the repair. Once that is done they can reenable it.

Attachments