Submit a ticketCall us

Announcing NCM 7.7
With NCM 7.7, you can examine the rules that make up an access control list for a Cisco ASA device. Then you can apply filters to display only rules that meet the specified criteria, order the rules by line number or by the hit count, and much more.
See new features and improvements.

Home > Success Center > Network Performance Monitor (NPM) > Data is not available for custom SQL or SWQL charts after upgrading to NPM 12

Data is not available for custom SQL or SWQL charts after upgrading to NPM 12

Updated June 16, 2017

Overview

This article describes an issue where a number of custom reports do not return data after upgrading to NPM 12.
An error related to data grouping is displayed when editing the report. The chart does not return any data when data grouping for values is set.

Environment

NPM 12

Cause 

The Data Grouping option is available in NPM 11.5 and earlier versions and is responsible for customizing group data into a chart series.
For example, an SQL or SWQL query in the data source returns historical data for several objects and you want to display the chart per object. In this case, you need to specify the column name to group the chart data (such as NodeID). If you need to group the chart data by NodeID, set the legend to Node Name and select the Caption column if it exists. 

This is also available in NPM 12 but you will need to specify the grouping to be able to create a report with a custom chart resource and SQL data source.

Resolution

Add a dummy column to return the same value for all rows and then select the column in the Data Grouping option.

 

Last modified
21:13, 15 Jun 2017

Tags

Classifications

Public