Performance Center data aggregator health query failed

Products

• CA Infrastructure Management
• CA Performance Management - Usage and Administration
• DX NetOps

Issue/Introduction

In a newly installed DevOps environment the system health dashboards are blank and the following query failure is seen in the PCService.log:

Query failed. See the logs for details. (Query ID: e6b1236d-4652-4db6-8449-9a8355d1aa92)

I checked the logs in PCService.log and found this error in Performance Center:

SELECT .PollItem.DeviceID, .PollItem.LocalID, .PollItem.DevDisplayName, .Item.Name, .HeapSizeInBytes.Avg FROM CA.IM.DA.MF.NormalizedDataCollectorSystemStatisticsInfo.NRM_DA_DC_SYSTEM_STATS WHERE .Group.GroupID = '5480' AND .EndTime(300) > 1596619020 AND .EndTime(300) <= 1596633420 GROUPBY .PollItem.DeviceID, .PollItem.LocalID, .PollItem.DevDisplayName, .Item.Name ORDERBY .Item.Name ASC LIMIT 144
}}
ERROR | Model-Invoker-32         | 2020-08-05 09:17:37,773 | com.ca.im.portal.plugins.rib.models.RIBXYChartModel
      | RIB query failed
          Model ID/Type: {150004/RIBXYChartModel}
          Result status: {FAILED}
          Query ID: {8e76ebe9-a984-4004-91b8-12ee8e32035b}
          RIB source URL: {http://localhost:8581}
          Query: {SELECT .EndTime(300), .NRM_healthResponseTime.Sum, .NRM_enqueueCount.Sum, .NRM_dequeueCount.Sum, .Resolution.Returned FROM CA.IM.DA.MF.NormalizedDAActiveMQBrokerHealthInfo.NRM_DA_AMQ_BROKER_HEALTH WHERE .Group.GroupID = 53 AND .EndTime(300) > 1596619020 AND .EndTime(300) <= 1596633420 GROUPBY .EndTime(300) ORDERBY .EndTime(300) ASC}
          Reason: {
Error occurred while running a RIB query on Data Aggregator RIB Source. Query ID: RIBQuery_8e76ebe9_a984_4004_91b8_12ee8e32035b
  Possible reason: Failed preparing new query: The specified item is not valid.[Invalid group filter expression ".Group.GroupID = '5480'", item 5,480 is not a group.]
The specified item is not valid.[Invalid group filter expression ".Group.GroupID = '5480'", item 5,480 is not a group.]
  Query:
{
SELECT .EndTime(300), .NRM_healthResponseTime.Sum, .NRM_enqueueCount.Sum, .NRM_dequeueCount.Sum, .Resolution.Returned FROM CA.IM.DA.MF.NormalizedDAActiveMQBrokerHealthInfo.NRM_DA_AMQ_BROKER_HEALTH WHERE .Group.GroupID = '5480' AND .EndTime(300) > 1596619020 AND .EndTime(300) <= 1596633420 GROUPBY .EndTime(300) ORDERBY .EndTime(300) ASC
}}
ERROR | Model-Invoker-35         | 2020-08-05 09:17:37,776 | com.ca.im.portal.plugins.rib.models.RIBXYChartModel
      | RIB query failed
          Model ID/Type: {150002/RIBXYChartModel}
          Result status: {FAILED}
          Query ID: {1bf9393d-74bf-4bb5-935b-e047869cfec3}
          RIB source URL: {http://localhost:8581}

Cause

 The DA had to be re-installed but the DA data source was not first removed from the data source list

Environment

DevOps Performance Management 3.7

Resolution

Do the following to resolve the issue

• Add the "Delete Data Sources" to the role
  
  
• Delete and re-add the data aggregator data source

Again, this assumes the environment is blank and has has no devices added to the database.  If this is not the case please open an issue with support