EPM - Upgrade will fail with the SQL database in AG (Always On) mode or in a Mirror configuration

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Announcements

Welcome Idira to LIVEcommunity!

Our community just got stronger! Explore new identity security resources, connect with experts, and discover more ways to learn and collaborate.

Meet Idira

Endpoint Privilege Manager (EPM) Articles
2 min read
L2 Linker
No ratings
Issue:
An upgrade will fail with errors like these in the installation log:
Action: DBUpgradeInst. 09:57:48 SqlInstTask: Changed database context to 'VFMNGDB5'. 
Action: DBUpgradeInst. 09:57:48 SqlInstTask: ERROR STATEMENT: ALTER DATABASE [VFMNGDB5] SET SINGLE_USER WITH ROLLBACK IMMEDIATE 
USE [VFMNGDB5] 

ERROR: The operation cannot be performed on database "VFMNGDB5" because it is involved in a database mirroring session or an availability group. Some operations are not allowed on a database that is participating in a database mirroring session or in an availability group. 
ALTER DATABASE statement failed. 
Action: DBUpgradeInst. 09:57:48 SqlInstTask: : ERROR (4392,5): ERROR: The operation cannot be performed on database "VFMNGDB5" because it is involved in a database mirroring session or an availability group. Some operations are not allowed on a database that is participating in a database mirroring session or in an availability group. 
ALTER DATABASE statement failed. 
Action 9:58:11: CustomAction.

Steps

Resolution:
The resolution is: 
- Disable the activated "Mirroring" or "Always On" features. 
- Run the upgrade 
- Turn back on the features. 

The EPM upgrade will not work with "Mirroring" or "Always On" features turned on. SYMPTOM:
During upgrade process a dialog message:
"The instruction at 0x8e2c5d90 referenced memory at 0x8e2c5d90. The memory could not be written"
Then, after clicking OK the upgrade fails
 
In the Server trace the following error message appears:
ERROR: The operation cannot be performed on database "VFMNGDB5" because it is involved in a database mirroring session or an availability group. Some operations are not allowed on a database that is participating in a database mirroring session or in an availability group.
ALTER DATABASE statement failed.
 
PROBLEM:
An activated "Mirroring" or "Always On" running on the EPM DB's. The upgrade process doesn't support DR\Redundancy features turning ON.

 

 
SOLUTION:
- Disable the activated "Mirroring" or "Always On" features.
- Run the upgrade
- Turn back on the features.
Rate this article:
  • 1017 Views
  • 0 comments
  • 0 Likes
Article Dashboard
Version history
Last Updated:
‎08-04-2020 09:58 AM
Updated by: