View query failures after Performance Management upgrade
Article ID: 143991
Updated On:
Products
Issue/Introduction
Upgraded Performance Management. After the upgrade reports are failing with query failures.
Views show red bar query failures that state:
- "Invalid RIB query syntax. See logs for details. (Query ID: <QueryID_string>)"
Using RIB debug for a sample failing View we see the following error messages. From the PCService.log file we see:
ERROR | qtp983597447-245 | 2020-01-22 19:57:33,872 | com.ca.im.portal.plugins.rib.models.RIBTableModel
| RIB query failed
Model ID/Type: {1000099/RIBGroupScoreCardModel}
Result status: {ERROR_INVALID_QUERY_SYNTAX}
Query ID: {975f668e-5521-4034-a965-bf39392cceb6}
RIB source URL: {http://localhost:8481/dm/rib}
Query: {SELECT .Group.GroupID, .PctTimeinGreenAvailableState.Avg, .PctTimeinRednotAvailableState.Avg, .PctTimeinEnabledState.Avg, .PctTimeinBlueUnknownState.Avg, .Resolution.Returned, .Resolution.Returned FROM CA.IM.DA.MF.NormalizedPoolConnectionPoolMemberInfo.NRM_POOL_CONN_POOL_MEMBER WHERE ((.Group.GroupID = 1)) AND .EndTime(60) > 1579737420 AND .EndTime(60) <= 1579741020 GROUPBY .Group.GroupID ORDERBY .PctTimeinGreenAvailableState.Avg DESC LIMIT 100}
Reason: {RIB Query is invalid!
Query: {SELECT .Group.GroupID, .PctTimeinGreenAvailableState.Avg, .PctTimeinRednotAvailableState.Avg, .PctTimeinEnabledState.Avg, .PctTimeinBlueUnknownState.Avg, .Resolution.Returned, .Resolution.Returned FROM CA.IM.DA.MF.NormalizedPoolConnectionPoolMemberInfo.NRM_POOL_CONN_POOL_MEMBER WHERE ((.Group.GroupID = 1)) AND .EndTime(60) > 1579737420 AND .EndTime(60) <= 1579741020 GROUPBY .Group.GroupID ORDERBY .PctTimeinGreenAvailableState.Avg DESC LIMIT 100}
In the SELECT section of query, the following fields could not be found as part of the RIB table "CA.IM.DA.MF.NormalizedPoolConnectionPoolMemberInfo.NRM_POOL_CONN_POOL_MEMBER":
.PctTimeinGreenAvailableState.Avg
.PctTimeinRednotAvailableState.Avg
.PctTimeinEnabledState.Avg
.PctTimeinBlueUnknownState.Avg
}
In the DMService.log we see this message for each field listed in the PCService.log message.
WARN | qtp1672924993-193 | 2020-01-22 19:57:33,869 | com.ca.im.rib.engine.query.results.FieldAnnotator
| Unknown select field ID found in query.
Bad field ID: {.pcttimeingreenavailablestate.avg}
QueryID: {975f668e-5521-4034-a965-bf39392cceb6}
Query: {SELECT .Group.GroupID, .PctTimeinGreenAvailableState.Avg, .PctTimeinRednotAvailableState.Avg, .PctTimeinEnabledState.Avg, .PctTimeinBlueUnknownState.Avg, .Resolution.Returned, .Resolution.Returned FROM CA.IM.DA.MF.NormalizedPoolConnectionPoolMemberInfo.NRM_POOL_CONN_POOL_MEMBER WHERE ((.Group.GroupID = 1)) AND .EndTime(60) > 1579737420 AND .EndTime(60) <= 1579741020 GROUPBY .Group.GroupID ORDERBY .PctTimeinGreenAvailableState.Avg DESC LIMIT 100}
Environment
All supported Performance Management releases
Cause
These errors indicate that the RIB details PC retreived from the DA post upgrade are missing the metrics the Views are seeking data for.
The reason it can't find those metrics is because they were overwritten by the upgrade.
The metrics had been edited via the UI Certification customization tools. There are known older defects when that was done where the changes are made to the default Certifications where they should be made via extension functionality, or as a full custom Certification.
As a result, when upgrading the default Certification is reset with a current new copy, overwriting the customers UI based changes.
Resolution
To resolve this, identify the Metric Family that should support the missing metrics. Update the Metric Families extension to properly customize the Certification and prevent further upgrade overwrites.
Additional Information
Feedback
