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.