SRM is missing NCM config detail

Products

• CA Spectrum
• DX NetOps

Issue/Introduction

SRM is processing NCM buckets but is missing NCM config data so the configs that are in SRM are out of date.  There are scripts that data mine the configs and if the config needs to be updated from what is seen in the SRM data, it will be. There are configs that have been updated that are not showing in the ncm_config table of SRM.

Environment

Release : 20.2

Component : Spectrum Reporting

Cause

Massive amounts of text in the config change event which is 0x82105a.  There were devices with over 50,000 lines of text in the event between the config detail and the event also includes the policies that are in violation as well as compliance.

Resolution

NOTE: Starting from DX NetOps Spectrum 21.2.4, the default root password for MySql is "MySqlR00t". For DX NetOps Spectrum versions prior to 21.2.4, the default root password is "root". In the following MySql commands, replace <PASSWD> with the root password for your DX NetOps Spectrum version.

This is tentatively scheduled to be fixed in NetOps release 20.2.7 due out in March of 2021:

32369198  - SRM is missing NCM config detail

You will also need to increase the SRM db mysql table for this text:

- Log into the SRM system as the user that owns the Spectrum installation

- If on Windows, start a bash shell by running "bash -login"

- cd to the $SPECROOT/mysql/bin directory and enter the following command to log into mysq;

./mysql --defaults-file=../my-spectrum.cnf -uroot -p<PASSWD> reporting;\

- Run the following two commands at the mysql prompt:

alter table ncm_config modify violated_policies varchar(100000);
alter table ncm_config modify compliant_policies  varchar(100000);

- Enter quit at the mysql prompt to exit mysql