Got this error message when trying to create a report from a Spectrum Global Collection:Query failed.

book

Article ID: 206419

calendar_today

Updated On:

Products

CA Performance Management - Usage and Administration

Issue/Introduction

Got this error message when trying to create a report from a Spectrum Global Collection:

Query failed. See the logs for details. (Query ID: 6452f2f1-b685-480e-bc77-81e4bd8ba9c1)

If we search PCService.log for that query number, we see this error:

ERROR | qtp2128544227-25911      | 2021-01-08 12:32:58,884 | com.ca.im.portal.plugins.rib.models.RIBTableModel               

      | RIB query failed

          Model ID/Type: {1000014/RIBTableModel}

          Result status: {FAILED}

          Query ID: {6452f2f1-b685-480e-bc77-81e4bd8ba9c1}

          RIB source URL: {http://DA-HOST:8581/rib}

          Query: {SELECT .Item.DisplayName, .PollItem.ID, .Availability.Avg FROM CA.IM.DA.MF.NormalizedAvailabilityInfo.AVAIL WHERE .Group.GroupID = 2328380 AND .DeviceType.Type = 'device' AND (.DeviceType.Subtype = 'router' OR .DeviceType.Subtype = 'switch') AND .EndTime(60) > 1610123520 AND .EndTime(60) <= 1610127120 GROUPBY .PollItem.ID, .Item.DisplayName ORDERBY .Availability.Avg ASC, .PollItem.ID ASC LIMIT 100}

          Reason: {Global item ID: 0 missing from performance center item cache. Expected to find a local data source translation for Data source ID: 3}

Cause

The spectrum data source is out of synch with CAPC.

Environment

Release : 20.2

Component : IM Reporting / Admin / Configuration

Resolution

Run a full resynch on the spectrum data source in CAPC.

Note: a full resynch can be resource intensive and it may be best to run this off-hours.

Retest the report.