NetOps Portal Upgrade fails due to email configuration via SsoConfig
search cancel

NetOps Portal Upgrade fails due to email configuration via SsoConfig


Article ID: 239460


Updated On:


CA Performance Management - Usage and Administration DX NetOps


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)


All supported DX NetOps Performance Management releases


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.


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.