CA Infrastructure ManagementCA Performance Management - Usage and Administration
Issue/Introduction
since we have upgraded to the lastest version of CAPM (3.7.0.355) our RIB queries are failing on the "AS" part.
Rib Example: SELECT .EndTime(300) AS ts, .PollItem.DevName AS device, .Item.Name AS cpu, .Utilization.Max AS cpuUtil FROM CA.IM.DA.MF.NormalizedCPUInfo.NRM_CPUSTATS WHERE .EndTime(300) >= 1558702136 AND .EndTime(300) <= 1558703036 AND .Utilization.Max >= 90 GROUPBY .PollItem.DevName, .Item.Name, .EndTime(300) ORDERBY .PollItem.DevName ASC, .Item.Name ASC, .EndTime(300) ASC
Environment
Release : 3.7
Component : IM Data Aggregator
Cause
A change made in 3.7 has altred this functionality in SQL.
Resolution
Broadcom will fix this functionality change in a future build of CAPM.
The temporary work-around is to edit the RIB calls you are making to not use the ‘AS’ function until we can get this fixed in a future build.