NetOps Portal Upgrade fails due to email configuration via SsoConfig

Products

• CA Performance Management - Usage and Administration
• DX NetOps

Issue/Introduction

Product upgrade 20.2.8  to 21.2.9

At some point in this environments past email was configured on Portal using the SsoConfig script instead of the web UI.

This is seen when we run the following mysql query on the Portal netqosportal MySql DB. If the UI was utilized to enable email configurations we'd see Priority 0 (default) change from false to true. Only the SsoConfig tool would trigger the Priority 1 (Remote Value) entry being added.

mysql> select * from netqosportal.performance_center_properties WHERE PropName='NpcSmtpEnabled' AND PropValue IS NOT NULL;
+----------------+----------+-----------+---------+------------+
| PropName       | Priority | PropValue | Deleted | UpdatedOn  |
+----------------+----------+-----------+---------+------------+
| NpcSmtpEnabled |        0 | false     | N       | 1506010747 |
| NpcSmtpEnabled |        1 | true      | N       | 1539674104 |
+----------------+----------+-----------+---------+------------+
2 rows in set (0.00 sec)

Environment

All supported DX NetOps Performance Management releases

Cause

Enabling email configuration using SsoConfig instead of Portal web UI.

This is an unexpected configuration that shouldn't be present. The install fails due to inability to handle the configuration that shouldn't exist.

Resolution

To resolve this complete the following steps.

1. Open a MySql prompt on the PC Portal server using (default path shown):
   1. /opt/CA/PerformanceCenter/MySql/bin -uroot -p netqosportal
2. Run the following to update the default Priority 0 value from false to true.
   1. update performance_center_properties set PropValue='true', UpdatedOn=UNIX_TIMESTAMP() where PropName='NpcSmtpEnabled' and Priority=0;
3. Run the following to remove the unwanted Remote Value setting set with Priority 1.
   1. delete from performance_center_properties where PropName='NpcSmtpEnabled' and Priority=1;
4. Exit the MySql prompt.
5. Run the installation again.