Global Collections are not populated for Spectrum Report Manager Group reports

Document ID : KB000006967
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

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

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 |

 

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;