NetOps Portal Reports fail showing an Invalid RIB query syntax error.

Products

• CA Performance Management - Usage and Administration
• DX NetOps

Issue/Introduction

Reports are failing and listing an error in the UI like:

Invalid RIB query syntax. See logs for details. (Query ID: ff842756-0036-4e9b-8bbd-5993842650ab)

Looking within the logs as the error mentions, specifically the (default path shown) /opt/CA/PerformanceCenter/PC/logs/PCService.log, you will find another error like:

ERROR | Model-Invoker-33         | 2020-10-12 11:38:12,877 | com.ca.im.portal.plugins.rib.models.RIBMultiChartModel
      | RIB query failed
          Model ID/Type: {1000254/RIBMultiChartModel}
          Result status: {ERROR_INVALID_QUERY_SYNTAX}
          Query ID: {ff842756-0036-4e9b-8bbd-5993842650ab}
          RIB source URL: {http://localhost:8481/dm/rib}
          Query: {SELECT .PollItem.ID, .PollItem.DevName, .PollItem.DeviceID, .Item.Name, .AssignedPoolConnections.Avg FROM CA.IM.DA.MF.NormalizedVirtualConnectionSSLInfo.NRM_SSL_VIRTUAL_CONNECTION WHERE (.Group.GroupID = 493516) AND .EndTime(300) > 1602513480 AND .EndTime(300) <= 1602517080 GROUPBY .PollItem.ID, .PollItem.DevName, .PollItem.DeviceID, .Item.Name ORDERBY .AssignedPoolConnections.Avg DESC LIMIT 384}
          Reason: {RIB Query is invalid!
  Query: {SELECT .PollItem.ID, .PollItem.DevName, .PollItem.DeviceID, .Item.Name, .AssignedPoolConnections.Avg FROM CA.IM.DA.MF.NormalizedVirtualConnectionSSLInfo.NRM_SSL_VIRTUAL_CONNECTION WHERE (.Group.GroupID = 493516) AND .EndTime(300) > 1602513480 AND .EndTime(300) <= 1602517080 GROUPBY .PollItem.ID, .PollItem.DevName, .PollItem.DeviceID, .Item.Name ORDERBY .AssignedPoolConnections.Avg DESC LIMIT 384}
In the SELECT section of query, the following fields could not be found as part of the RIB table "CA.IM.DA.MF.NormalizedVirtualConnectionSSLInfo.NRM_SSL_VIRTUAL_CONNECTION":

Environment

All supported Performance Management releases

Cause

Portal cache is out of date or stale.

Resolution

To resolve this issue regenerate the PC Portal ribcache. To do so take these steps:

1. Stop the four PC Portal services on the Portal server:
   1. Stop caperfcenter_console
   2. Stop caperfcenter_devicemanager
   3. Stop caperfcenter_eventmanager
   4. Stop caperfcenter_sso
2. Either rename or remove /tmp/ribcache
3. Start the four PC Portal services on the Portal server:
   1. Start caperfcenter_sso
   2. Start caperfcenter_eventmanager
   3. Start caperfcenter_devicemanager
   4. Start caperfcenter_console

The ribcache is rebuilt when the services are restarted.

Additional Information

Did this take place just after an upgrade?

• Ensure all certifications and extensions are correctly located on the Data Aggregator.
  • Are the ones from the errors available from DA /typecatalog URLs?
• Are the Certifications involved custom or modified from default?
  • View query failures after Performance Management upgrade