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.
Error in database query issued when this particular View configuration is run.
Observed in the r20.2.4 release of DX NetOps Performance Management
May be seen in earlier r20.2.x releases.
At this time the following work arounds will resolve the error.
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.