9.20 Scheduled PRD's are EMPTY or missing source entries

book

Article ID: 142752

calendar_today

Updated On:

Products

NIMSOFT PROBES DX Infrastructure Management

Issue/Introduction

Post upgrade to 9.20, Scheduled reports are blank or have missing sources. 

 

Cause

The problem is usually with duplicate records for same source/qos/target with ci_metric_id as NULL in s_qos_data table.After removing the older records where ci_metric_id = NULL  for these metrics and  recreating PRD reports, the scheduled reports will came up with needed source data.

Environment

Release : 9.2.0

ump_reportscheduler_920_HF2

Resolution

Apply hotfix ump_reportscheduler_920_HF2

Check the s_qos_data table for duplicate entries for the same source/qos/target with ci_metric_id NULL. 

Query to check for duplicate entries:
select * from s_qos_data where ci_metric_id is NULL and probe = 'cdm'  

Query to remove duplicate entries (Take a proper backup and engage a DBA before running)
delete from s_qos_data where ci_metric_id is NULL and probe = 'cdm'  

Once duplicate entries are removed, you should be able to see missing sources.

Additional Information

Hotfix Download:

https://techdocs.broadcom.com/us/product-content/recommended-reading/technical-document-index/ca-unified-infrastructure-management-hotfix-index.html?r=2&r=1