search cancel

Global Collections list is empty in JasperReports after initialized the reporting database

book

Article ID: 133781

calendar_today

Updated On:

Products

CA Spectrum

Issue/Introduction

After initialized the reporting database and fully synchronized it, the Global Collections list is empty in JasperReports - by Group


The Enable Security is False in the Spectrum Report Manager Preferences.


Environment

Release : 10.3

Component : Spectrum Reporting

Cause

Run the following MySQL query on the OneClick + SRM machine to list the Global Collections list:


select distinct gc.gc_rec_ID, gc.gc_name from globalcollection gc inner join model m on m.mtype_h=66676 and m.model_name=gc.gc_name inner join reporting.v_security_string_accessibility_by_landscape sec on (m.landscape_h=sec.landscape_h) and (m.security_string=sec.security_string) ORDER BY gc_rec_ID DESC; 



If it is empty, run the following MySQL query where the security string filter is removed:


select distinct gc.gc_rec_ID, gc.gc_name from globalcollection gc inner join model m on m.mtype_h=66676 and m.model_name=gc.gc_name ORDER BY gc_rec_ID DESC; 



If there are Global Collections names in the secondary query, then it looks like the v_security_string_accessibility_by_landscape table is not properly populated.

Resolution

Stop and start the Spectrum Tomcat service.

Attachments