ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

DE498693 - VSQL error msg in PC log when sorting report.

book

Article ID: 213396

calendar_today

Updated On:

Products

CA Performance Management - Usage and Administration

Issue/Introduction

This happens when I try to sort by errors/sec

This is the error logged in PC log:

ERROR | qtp1329606019-101027     | 2021-03-26 04:52:57,749 | com.ca.im.portal.plugins.rib.models.RIBTableModel

      | RIB query failed

          Model ID/Type: {1000073/RIBTableModel}

          Result status: {ERROR_UNSUPPORTED_QUERY_SYNTAX}

          Query ID: {554d104f-6f3f-4db9-a70d-7f57bf11fc6e}

          RIB source URL: {http://localhost:8581}

          Query: {SELECT .PollItem.DeviceID, .PollItem.ID, .Item.DisplayName, .UtilizationIn.95Pct, .BitsIn.AvgRate, .BitsPerSecondIn.Max, .ErrorsIn.AvgRate, .SpeedIn.Avg, .Resolution.Returned FROM CA.IM.DA.MF.NormalizedPortInfo.IFSTATS WHERE .Group.GroupID = 816123 AND .EndTime(3600) > 1616306400 AND .EndTime(3600) <= 1616911140 GROUPBY .PollItem.DeviceID, .PollItem.ID, .Item.DisplayName ORDERBY .ErrorsIn.AvgRate ASC, .PollItem.DeviceID ASC LIMIT 500}

          Reason: {

Error occurred while running a RIB query on Data Aggregator RIB Source. Query ID: RIBQuery_554d104f_6f3f_4db9_a70d_7f57bf11fc6e

  Exception thrown: PreparedStatementCallback; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: [Vertica][VJDBC](2640) ERROR: Column "IFSTATS.im_errorsin" must appear in the GROUP BY clause or be used in an aggregate function

Environment

Release : 19.3

Component : IM Data Aggregator

Resolution

DE498693 has been logged with engineering and will be fixed in a future release. 

Workaround: 
If you use Error In Total Rate (instead Error In Average Rate) and Bit In Total Rate (instead of Bit In Average Rate) the view will work.