Global Collections are not populated for Spectrum Report Manager Group reports

Products

• CA Spectrum

Issue/Introduction

The list of Global Collections (GC) is not populated for Spectrum Report Manager (SRM) Group reports.

Environment

Release: Any
Component: Spectrum Report Manager/Jasper

Cause

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.

One or more of the Global Collections in the reporting database has a blank gc_name. To verify, do the following:

1. Log into the SRM system as the user that owns the Spectrum installation

2. If running on Windows, open a bash shell by running "bash -login"

3. cd to the $SPECROOT/mysql/bin directory

4. Enter the following command to log into mysql:

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

5. Enter the following command to check if there is a GC where the gc_name is not populated:

SELECT gc.gc_rec_ID, gc.gc_name FROM globalcollection gc WHERE EXISTS ( SELECT 1 FROM gcmodel gcm, model m WHERE gcm.gc_rec_ID = gc.gc_rec_ID AND gcm.model_key = m.model_key LIMIT 1 ) ORDER BY gc.gc_name; 

The following is an example of the output where gc_rec_ID is blank causing the issue to occur:

+-----------+---------------------------------------------+ 

| gc_rec_ID | gc_name | 

+-----------+---------------------------------------------+ 

| 288 | | 

| 182 | ABC 2.0 | 

| 199 | Aggregation Routers | 

| 347 | ANO-ENT-ALLDevices | 

| 216 | ANO-ENT-BACKBONE |

 

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.

To resolve the issue, run the following to manually populate the gc_name:

1. Log into the SRM system as the user that owns the Spectrum installation

2. If running on Windows, open a bash shell by running "bash -login"

3. cd to the $SPECROOT/mysql/bin directory

4. Enter the following command to log into mysql:

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

5. Enter the following command to populate a gc_name for the gc_rec_ID that is blank. The following uses the gc_rec_ID 288 from the previous mysql output above. Replace <BLANK> with the name of the GC:

update globalcollection set gc_name="<BLANK>" where gc_rec_id=288;