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:
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 "IFSTATS.item_id" must appear in the GROUP BY clause or be used in an aggregate function
[Vertica][VJDBC](2640) ERROR: Column "IFSTATS.item_id" must appear in the GROUP BY clause or be used in an aggregate function
[Vertica][VJDBC](2640) ERROR: Column "IFSTATS.item_id" must appear in the GROUP BY clause or be used in an aggregate function
Possible cause: RIBQuery passed in was semantically incorrect