RIB queries sent to the CA Performance Center (CAPC) system fail with error

Article Id: 37994
Status: Published
Updated On: 29-04-2020 11:55
Legacy Id: TEC1035525
Products:
CA Infrastructure Management CA Infrastructure Management CA Performance Management - Usage and Administration
Issue/Introduction:

RIB queries sent to the Performance Center system fail with error. For example, the first RIB query shown below is for all percentile metrics, which is successful. The second query is for all core metrics which is also successful. The third query is for a combination of core and percentile metrics which fails.


Successful:

http://<CAPC host>:8481/dm/rib/query/SELECT .PollItem.ID, .UtilizationOut.Pct2,.UtilizationIn.Pct2, .UtilizationOut.95Pct,.UtilizationIn.95Pct FROM CA.IM.DA.MF.NormalizedPortInfo.IFSTATS WHERE .Group.GroupID = <ID> AND .EndTime(300) > <startTime> AND .EndTime(300) <= <endTime> GROUPBY .PollItem.ID ORDERBY .PollItem.ID DESC

Successful:

http://<CAPC host>:8481/dm/rib/query/SELECT .PollItem.ID, .UtilizationOut.Avg,.UtilizationIn.Avg, .UtilizationOut.Max,.UtilizationIn.Max FROM CA.IM.DA.MF.NormalizedPortInfo.IFSTATS WHERE .Group.GroupID = <ID> AND .EndTime(300) > <startTime> AND .EndTime(300) <= <endTime> GROUPBY .PollItem.ID ORDERBY .PollItem.ID DESC

Fail:

http://<CAPC host>:8481/dm/rib/query/SELECT .PollItem.ID, .UtilizationOut.Avg,.UtilizationOut.Max,.UtilizationOut.95Pct FROM CA.IM.DA.MF.NormalizedPortInfo.IFSTATS WHERE .Group.GroupID = <ID> AND .EndTime(300) > <startTime> AND .EndTime(300) <= <endTime> GROUPBY .PollItem.ID ORDERBY .PollItem.ID DESC

*Where:

<ID>        = The ID of the group in question
<startTime> = A UTC time stamp
<endTime>   = A UTC time stamp


The following errors are returned in the browser:

Error occurred while running a RIB query on Data Aggregator RIB Source.
nested exception is java.sql.SQLSyntaxErrorException: [Vertica][VJDBC](2640)
ERROR: Column &quot;IFSTATS.item_id&quot; must appear in the GROUP BY clause or be used in an aggregate function
[Vertica][VJDBC](2640) ERROR: Column &quot;IFSTATS.item_id&quot; must appear in the GROUP BY clause or be used in an aggregate function
[Vertica][VJDBC](2640) ERROR: Column &quot;IFSTATS.item_id&quot; must appear in the GROUP BY clause or be used in an aggregate function
Possible cause: RIBQuery passed in was semantically incorrect

Cause:

When attempting to combine core and percentile metrics, there are actually a couple of RIB queries that are being generated (one for percentiles and one for the core metrics) and the result sets cannot be combined and rendered in the view.

Environment:

CAPM 2.x, 3.x

Resolution:

This is functioning as designed. RIB queries cannot combine percentile metric queries with other core metrics.