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

book

Article ID: 37994

calendar_today

Updated On:

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.