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}
The spectrum data source is out of synch with CAPC.
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.