<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>article EPM - Upgrade will fail with the SQL database in AG (Always On) mode or in a Mirror configuration in Endpoint Privilege Manager (EPM) Articles</title>
    <link>https://live.paloaltonetworks.com/t5/endpoint-privilege-manager-epm/epm-upgrade-will-fail-with-the-sql-database-in-ag-always-on-mode/ta-p/1430059</link>
    <description>Issue:&lt;BR /&gt;An upgrade will fail with errors like these in the installation log:&lt;BR /&gt;Action: DBUpgradeInst. 09:57:48 SqlInstTask: Changed database context to 'VFMNGDB5'.&amp;nbsp;&lt;BR /&gt;Action: DBUpgradeInst. 09:57:48 SqlInstTask: ERROR STATEMENT: ALTER DATABASE [VFMNGDB5] SET SINGLE_USER WITH ROLLBACK IMMEDIATE&amp;nbsp;&lt;BR /&gt;USE [VFMNGDB5]&amp;nbsp;&lt;BR /&gt;&lt;BR /&gt;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.&amp;nbsp;&lt;BR /&gt;ALTER DATABASE statement failed.&amp;nbsp;&lt;BR /&gt;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.&amp;nbsp;&lt;BR /&gt;ALTER DATABASE statement failed.&amp;nbsp;&lt;BR /&gt;Action 9:58:11: CustomAction.

&lt;H3&gt;Steps&lt;/H3&gt;
Resolution:&lt;BR /&gt;The resolution is:&amp;nbsp;&lt;BR /&gt;- Disable the activated "Mirroring" or "Always On" features.&amp;nbsp;&lt;BR /&gt;- Run the upgrade&amp;nbsp;&lt;BR /&gt;- Turn back on the features.&amp;nbsp;&lt;BR /&gt;&lt;BR /&gt;The EPM upgrade will not work with&amp;nbsp;"Mirroring" or "Always On" features turned on.

&lt;STRONG style="color: rgb(51, 51, 51);font-size: 14px;"&gt;&lt;U style=""&gt;&lt;FONT face="Verdana, Helvetica, sans-serif"&gt;SYMPTOM:&lt;/FONT&gt;&lt;/U&gt;&lt;/STRONG&gt;
&lt;DIV&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;&lt;FONT color="#333333"&gt;During upgrade process a dialog message:&lt;/FONT&gt;&lt;/FONT&gt;&lt;/DIV&gt;
&lt;DIV&gt;&lt;FONT face="Courier, monospace" size="2"&gt;&lt;FONT color="#333333" style=""&gt;"The instruction at 0x8e2c5d90 referenced memory at&amp;nbsp;&lt;/FONT&gt;&lt;SPAN style="color: rgb(51, 51, 51);"&gt;0x8e2c5d90. The memory could not be written"&lt;/SPAN&gt;&lt;/FONT&gt;&lt;/DIV&gt;
&lt;DIV&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;&lt;SPAN style="color: rgb(51, 51, 51);"&gt;Then, after clicking OK the upgrade fails&lt;/SPAN&gt;&lt;/FONT&gt;&lt;/DIV&gt;
&lt;DIV&gt;&amp;nbsp;&lt;/DIV&gt;
&lt;DIV&gt;&lt;FONT color="#333333"&gt;&lt;SPAN style="font-family: Arial, sans-serif;font-size: 14px;"&gt;&lt;SPAN style="font-weight: bold;"&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;&lt;SPAN style="font-weight: 400;"&gt;In the Server trace the following error message appears:&lt;/SPAN&gt;&lt;/FONT&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/FONT&gt;&lt;/DIV&gt;
&lt;DIV&gt;
&lt;DIV style=""&gt;&lt;FONT face="Courier, monospace"&gt;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.&lt;/FONT&gt;&lt;/DIV&gt;
&lt;DIV style=""&gt;&lt;FONT face="Courier, monospace"&gt;ALTER DATABASE statement failed.&lt;/FONT&gt;&lt;/DIV&gt;
&lt;DIV&gt;&amp;nbsp;&lt;/DIV&gt;
&lt;DIV&gt;&lt;STRONG style="color: rgb(51, 51, 51);font-size: 14px;"&gt;&lt;U style=""&gt;&lt;FONT face="Verdana, Helvetica, sans-serif"&gt;PROBLEM:&lt;/FONT&gt;&lt;/U&gt;&lt;/STRONG&gt;&lt;/DIV&gt;
&lt;DIV&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;An&amp;nbsp;activated "Mirroring" or "Always On" running on the EPM DB's.&amp;nbsp;The upgrade process doesn't support DR\Redundancy features turning ON.&lt;/FONT&gt;&lt;/DIV&gt;
&lt;P class="MsoPlainText"&gt;&amp;nbsp;&lt;/P&gt;
&lt;DIV&gt;&amp;nbsp;&lt;/DIV&gt;
&lt;DIV&gt;&lt;STRONG style="color: rgb(51, 51, 51);font-size: 14px;"&gt;&lt;U style=""&gt;&lt;STRONG style=""&gt;&lt;FONT face="Verdana, Helvetica, sans-serif"&gt;SOLUTION:&lt;/FONT&gt;&lt;/STRONG&gt;&lt;/U&gt;&lt;/STRONG&gt;
&lt;DIV&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;- Disable the activated&amp;nbsp;"Mirroring" or "Always On"&amp;nbsp;features.&lt;/FONT&gt;&lt;/DIV&gt;
&lt;DIV&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;- Run the upgrade&lt;/FONT&gt;&lt;/DIV&gt;
&lt;/DIV&gt;
&lt;/DIV&gt;
&lt;DIV&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2" style=""&gt;- Turn back on the features.&lt;/FONT&gt;&lt;/DIV&gt;</description>
    <pubDate>Tue, 04 Aug 2020 16:58:00 GMT</pubDate>
    <dc:creator>CyberArkAlumni</dc:creator>
    <dc:date>2020-08-04T16:58:00Z</dc:date>
    <item>
      <title>EPM - Upgrade will fail with the SQL database in AG (Always On) mode or in a Mirror configuration</title>
      <link>https://live.paloaltonetworks.com/t5/endpoint-privilege-manager-epm/epm-upgrade-will-fail-with-the-sql-database-in-ag-always-on-mode/ta-p/1430059</link>
      <description>Issue:&lt;BR /&gt;An upgrade will fail with errors like these in the installation log:&lt;BR /&gt;Action: DBUpgradeInst. 09:57:48 SqlInstTask: Changed database context to 'VFMNGDB5'.&amp;nbsp;&lt;BR /&gt;Action: DBUpgradeInst. 09:57:48 SqlInstTask: ERROR STATEMENT: ALTER DATABASE [VFMNGDB5] SET SINGLE_USER WITH ROLLBACK IMMEDIATE&amp;nbsp;&lt;BR /&gt;USE [VFMNGDB5]&amp;nbsp;&lt;BR /&gt;&lt;BR /&gt;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.&amp;nbsp;&lt;BR /&gt;ALTER DATABASE statement failed.&amp;nbsp;&lt;BR /&gt;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.&amp;nbsp;&lt;BR /&gt;ALTER DATABASE statement failed.&amp;nbsp;&lt;BR /&gt;Action 9:58:11: CustomAction.

&lt;H3&gt;Steps&lt;/H3&gt;
Resolution:&lt;BR /&gt;The resolution is:&amp;nbsp;&lt;BR /&gt;- Disable the activated "Mirroring" or "Always On" features.&amp;nbsp;&lt;BR /&gt;- Run the upgrade&amp;nbsp;&lt;BR /&gt;- Turn back on the features.&amp;nbsp;&lt;BR /&gt;&lt;BR /&gt;The EPM upgrade will not work with&amp;nbsp;"Mirroring" or "Always On" features turned on.

&lt;STRONG style="color: rgb(51, 51, 51);font-size: 14px;"&gt;&lt;U style=""&gt;&lt;FONT face="Verdana, Helvetica, sans-serif"&gt;SYMPTOM:&lt;/FONT&gt;&lt;/U&gt;&lt;/STRONG&gt;
&lt;DIV&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;&lt;FONT color="#333333"&gt;During upgrade process a dialog message:&lt;/FONT&gt;&lt;/FONT&gt;&lt;/DIV&gt;
&lt;DIV&gt;&lt;FONT face="Courier, monospace" size="2"&gt;&lt;FONT color="#333333" style=""&gt;"The instruction at 0x8e2c5d90 referenced memory at&amp;nbsp;&lt;/FONT&gt;&lt;SPAN style="color: rgb(51, 51, 51);"&gt;0x8e2c5d90. The memory could not be written"&lt;/SPAN&gt;&lt;/FONT&gt;&lt;/DIV&gt;
&lt;DIV&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;&lt;SPAN style="color: rgb(51, 51, 51);"&gt;Then, after clicking OK the upgrade fails&lt;/SPAN&gt;&lt;/FONT&gt;&lt;/DIV&gt;
&lt;DIV&gt;&amp;nbsp;&lt;/DIV&gt;
&lt;DIV&gt;&lt;FONT color="#333333"&gt;&lt;SPAN style="font-family: Arial, sans-serif;font-size: 14px;"&gt;&lt;SPAN style="font-weight: bold;"&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;&lt;SPAN style="font-weight: 400;"&gt;In the Server trace the following error message appears:&lt;/SPAN&gt;&lt;/FONT&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/FONT&gt;&lt;/DIV&gt;
&lt;DIV&gt;
&lt;DIV style=""&gt;&lt;FONT face="Courier, monospace"&gt;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.&lt;/FONT&gt;&lt;/DIV&gt;
&lt;DIV style=""&gt;&lt;FONT face="Courier, monospace"&gt;ALTER DATABASE statement failed.&lt;/FONT&gt;&lt;/DIV&gt;
&lt;DIV&gt;&amp;nbsp;&lt;/DIV&gt;
&lt;DIV&gt;&lt;STRONG style="color: rgb(51, 51, 51);font-size: 14px;"&gt;&lt;U style=""&gt;&lt;FONT face="Verdana, Helvetica, sans-serif"&gt;PROBLEM:&lt;/FONT&gt;&lt;/U&gt;&lt;/STRONG&gt;&lt;/DIV&gt;
&lt;DIV&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;An&amp;nbsp;activated "Mirroring" or "Always On" running on the EPM DB's.&amp;nbsp;The upgrade process doesn't support DR\Redundancy features turning ON.&lt;/FONT&gt;&lt;/DIV&gt;
&lt;P class="MsoPlainText"&gt;&amp;nbsp;&lt;/P&gt;
&lt;DIV&gt;&amp;nbsp;&lt;/DIV&gt;
&lt;DIV&gt;&lt;STRONG style="color: rgb(51, 51, 51);font-size: 14px;"&gt;&lt;U style=""&gt;&lt;STRONG style=""&gt;&lt;FONT face="Verdana, Helvetica, sans-serif"&gt;SOLUTION:&lt;/FONT&gt;&lt;/STRONG&gt;&lt;/U&gt;&lt;/STRONG&gt;
&lt;DIV&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;- Disable the activated&amp;nbsp;"Mirroring" or "Always On"&amp;nbsp;features.&lt;/FONT&gt;&lt;/DIV&gt;
&lt;DIV&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2"&gt;- Run the upgrade&lt;/FONT&gt;&lt;/DIV&gt;
&lt;/DIV&gt;
&lt;/DIV&gt;
&lt;DIV&gt;&lt;FONT face="Verdana, Helvetica, sans-serif" size="2" style=""&gt;- Turn back on the features.&lt;/FONT&gt;&lt;/DIV&gt;</description>
      <pubDate>Tue, 04 Aug 2020 16:58:00 GMT</pubDate>
      <guid>https://live.paloaltonetworks.com/t5/endpoint-privilege-manager-epm/epm-upgrade-will-fail-with-the-sql-database-in-ag-always-on-mode/ta-p/1430059</guid>
      <dc:creator>CyberArkAlumni</dc:creator>
      <dc:date>2020-08-04T16:58:00Z</dc:date>
    </item>
  </channel>
</rss>

