Hi Swapnil,
If you are familiar with MySQL command line, you can run the following queries to narrow down this issue.
1. Open a bash shell on the SRM (Spectrum Report Manager) machine
2. Navigate to $SPECROOT/mysql/bin directory
3. Run: ./mysql --defaults-file=../my-spectrum.cnf -uroot -proot reporting
4. Run the following MySQL query:
SELECT gc.gc_rec_id, gc.gc_name FROM globalcollection gc WHERE EXISTS ( SELECT 1 FROM gcmodel gcm, model m, v_security_string_accessibility_by_landscape v WHERE gcm.gc_rec_id = gc.gc_rec_id AND gcm.model_key = m.model_key AND m.landscape_h = v.landscape_h LIMIT 1 ) ORDER BY gc.gc_name;
If the Global Collections are listed, then run the next query - Note: The 'spectrum' account in the query below is the Spectrum Install Owner account, replace it with your Spectrum installation account:
SELECT gc.gc_rec_id, gc.gc_name FROM globalcollection gc WHERE EXISTS ( SELECT 1 FROM gcmodel gcm, model m, v_security_string_accessibility_by_landscape v WHERE gcm.gc_rec_id = gc.gc_rec_id AND gcm.model_key = m.model_key AND m.landscape_h = v.landscape_h AND m.security_string = v.security_string AND v.user_name = 'spectrum' LIMIT 1 ) ORDER BY gc.gc_name;
If the Global Collection are listed, then take note of WKP_ProxyUserSecurity account (in the InfoView parameter page) and run the MySQL query above with that account (replace the spectrum account with the WKP_ProxyUserSecurity account):
If the Global Collections are not listed, there is a possible issue with Security String. Try restarting the Spectrum Tomcat service.
Thanks,
Silvio