Spectrum GC groups are not appearing in CABI JasperServer report parameter entry fields

Products

• CA Spectrum
• DX NetOps

Issue/Introduction

After upgrading Spectrum from from 21.2.x to 22.2.x, Spectrum Global Collections (GC) groups are not appearing in CABI JasperServer report parameter entry fields for generating Reports:

Environment

DX NetOps Spectrum Release : 22.2

Cause

Observed that Tenant-ID is not updated for each Model in SRM Model table by executing the following in SRM MySQL DB to verify, (Most of them are default value -1):

mysql> select model_name,security_string,tenant_id from model where model_name like '%PPO%';

+-------------------------+-----------------+-----------+
| model_name              | security_string | tenant_id |
+-------------------------+-----------------+-----------+
| MY_WAN Links            | Spec_Sec        |         3 |
| MY_Switch Ports         | Spec_Sec        |         3 |
| MY_Security_Devices_New | Spec_Sec        |         3 |
| MY_Security_Devices     | Spec_Sec        |         3 |
| MY_Networks             | Spec_Sec        |         3 |
| MY_Security_Devices_Old | Spec_Sec        |        -1 |
+-------------------------+-----------------+-----------+
7 rows in set (0.08 sec)

Resolution

Execute tenant re-map as per:

TechDocs : DX NetOps Spectrum 22.2 : SRM Multitenancy Support

This should update the Tenant_IDs for the GCs. 

Then restart Spectrum OneClick MySQL service which will start synching SRM with JasperServer. After this, GC should be displayed in the parameter entry fields