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

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 | 

 

 

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