On-Demand Reports generate error in DX NetOps Performance Management

Products

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

Issue/Introduction

DX NetOps Performance Management On-Demand Reports generate error.

Created an On-Demand Report from Reports->On-Demand Report Templates which generates a red bar error in the Performance Center web UI.

On-Demand Report set to "Table per Item with Multiple Metrics" and Metric Calculate Level 'by Component' fails with error.

On-Demand Report for unsynchronized Component Items fails with error.

The following report configuration will reproduce the issue. The Metric Family and Metric selected to reproduce this must be for a Component Item not synchronized to Performance Center. Common examples of these are CPU, Memory and Disk or Partition Component Items and their metrics.

A sample if the error that would be seen is:

At the same time in the (default path) /opt/CA/PerformanceCenter/PC/logs/PCService.log file we would see an error like this.

ERROR | Model-Invoker-39         | 2020-12-28 13:18:29,232 | com.ca.im.portal.plugins.rib.models.RIBTableModel
      | RIB query failed
          Model ID/Type: {1000284/RIBTableModelMultiItem}
          Result status: {ERROR_UNSUPPORTED_QUERY_SYNTAX}
          Query ID: {564c486e-df36-45a6-af12-2d8f9a54e5fd}
          RIB source URL: {http://localhost:8581}
          Query: {SELECT .PollItem.DeviceID, .PollItem.DevName, CA.IM.DA.MF.NormalizedGenericDiskInfo.NRM_GENERIC_DISK.DiskStorageUtilization.Avg, .Resolution.Returned FROM CA.IM.DA.MF.NormalizedGenericDiskInfo.NRM_GENERIC_DISK WHERE (.Group.GroupID = 1) AND .EndTime(60) > 1609175880 AND .EndTime(60) <= 1609179480 GROUPBY .PollItem.DeviceID, .PollItem.DevName ORDERBY .Item.Name ASC LIMIT 60}
          Reason: {
Error occurred while running a RIB query on Data Aggregator RIB Source. Query ID: RIBQuery_564c486e_df36_45a6_af12_2d8f9a54e5fd
  Exception thrown: PreparedStatementCallback; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: [Vertica][VJDBC](2640) ERROR: Column "i.item_name" must appear in the GROUP BY clause or be used in an aggregate function
[Vertica][VJDBC](2640) ERROR: Column "i.item_name" must appear in the GROUP BY clause or be used in an aggregate function
[Vertica][VJDBC](2640) ERROR: Column "i.item_name" must appear in the GROUP BY clause or be used in an aggregate function
  Possible cause: RIBQuery passed in was semantically incorrect.

Cause

Error in database query issued when this particular View configuration is run.

Environment

Observed in the r20.2.4 release of DX NetOps Performance Management

May be seen in earlier r20.2.x releases.

Resolution

At this time the following work arounds will resolve the error.

• Set the View Type to anything other than "Table per Item with Multiple Metrics".
• Set the Metrics and/or items to target items and metrics for items synchronized to Performance Center such as Devices, Interfaces or RTT test items.
• Set the Metric Calculate Level to anything other than 'by Component'.
  • Using 'by Device' or 'by Group' prevents the error and the report will work.
  • Note if using 'by Group' the Group targeted must contain the parent device item that hosts the targeted Component Item data.

Defect DE488755 will resolve this issue in the r20.2.7 release of DX NetOps Performance Management. Upgrade to that release when available to resolve this.