Reports do not display data - No Records found

Products

• CA Spectrum

Issue/Introduction

Availability reports stop displaying data

Cause

The JasperServer thinks SRM Multitenancy is enabled, hence it is adding the following in the MySQL query: m.tenant_id=NULL

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 and m.tenant_id=NULL ORDER BY gc_rec_ID DESC;

SELECT 
 outagetype.outage_desc, 
 entity.entity_id,
 entity.entity_name, 
 outagetype.outage_type as Outage_outage_type, 
 devicemodel.IP, 
 vendor.vendor_name,
 devicemodel.device_type, 
 modeloutage.end_time, 
 modeloutage.start_time,
 modeloutage_notes.notes, 
 modeloutage.outage_type as ModelOutage_outage_type, 
 devicemodel.model_h
 FROM   reporting.entity entity INNER JOIN reporting.devicemodel devicemodel ON entity.current_model_key=devicemodel.model_key  and tenant_id=null AND entity_id IN ('25121') LEFT OUTER JOIN reporting.modeloutage modeloutage ON entity.current_model_key=modeloutage.model_key  AND ((modeloutage.start_time IS  NULL ) OR (modeloutage.outage_type=0) OR (modeloutage.start_time<'2019-03-01 00:00:00' AND ((modeloutage.end_time IS  NULL ) OR (modeloutage.end_time>'2019-03-07 10:48:59.236000'))) OR ((modeloutage.start_time>='2019-03-01 00:00:00' AND modeloutage.start_time<'2019-03-07 10:48:59.236000')) OR ((modeloutage.end_time>='2019-03-01 00:00:00' AND modeloutage.end_time<'2019-03-07 10:48:59.236000'))) INNER JOIN reporting.vendor vendor ON devicemodel.vendor=vendor.vendor 
  LEFT OUTER JOIN reporting.outagetype outagetype ON modeloutage.outage_type=outagetype.outage_type LEFT OUTER JOIN reporting.modeloutage_notes modeloutage_notes ON modeloutage.model_outage_ID=modeloutage_notes.model_outage_ID
 ORDER BY entity.entity_id, modeloutage.start_time;

Environment

CA Spectrum 10.3.0 and JasperReports 6.4.3

Resolution

1. Go to Spectrum WEB GUI -> Administration page -> Report Manager -> SRM Multitenant Configuration
2. Uncheck the "Enable Multitenancy Support" checkbox and save the change.
3. Then in Jasper Integration, save the change.