Power Monitoring Expert Reconfigure Fails at Create Database steps

How can we help you today?

Issue
During a Reconfigure the PME Installer fails with an error at the Create Database Folder step. Upon looking at the logs there is an error similar to below mentioning a "database mirroring session or in an availability group"

"The operation cannot be performed on database "ION_Data" 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."

Resolution

This error occurs when the ALTER DATABASE command (used by PME to change or upgrade the database during a reconfigure) is executed on a database that has been added to a Database Mirroring session or an Availability Group.

- Database Mirroring is a high-availability feature in SQL Server that maintains two copies of a single database on different servers (called principal and mirror).
- Always ON Availability Group is a more advanced high-availability and disaster recovery solution introduced in SQL Server 2012.

See following links for further information:
Database Mirroring - https://learn.microsoft.com/en-us/sql/database-engine/database-mirroring/database-mirroring-sql-server?view=sql-server-ver17
Availability Group - https://learn.microsoft.com/en-us/sql/database-engine/availability-groups/windows/overview-of-always-on-availability-groups-sql-server?view=sql-server-ver17

As per the following FAQ PME does not support Database Mirroring or Always ON Availability Groups, but it is to the customer discretion if they use it - https://www.se.com/au/en/faqs/FA240200/

To resolve the issue of running the Reconfigure you must remove the four PME Databases (ION_Data, ION_Network, ION_System, Application Modules) from the Database Mirroring or Availability Group.

Once removed the Configure Database step of the Reconfigure can be continued.

If this does not resolve the issue please contact your local tech support team.