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.
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.
Release : 10.3
Component : Spectrum Reporting