Global Collections are not populated for Spectrum Report Manager Group reports

book

Article ID: 6967

calendar_today

Updated On:

Products

CA Spectrum

Issue/Introduction

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

<Please see attached file for image>

700410_1.png

Cause

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 -proot 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 |

 

Environment

Release: SDBSFO99000-10.2-Spectrum-Device Based Suite-Server FOC
Component:

Resolution

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 -proot 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; 

Attachments

1558703118848000006967_sktwi1f5rjvs16q5c.png get_app