ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

NetOps Portal Upgrade fails due to email configuration via SsoConfig

book

Article ID: 239460

calendar_today

Updated On:

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)

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.

Environment

All supported DX NetOps Performance Management releases

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.