Increase row count for on-demand reports with in NetOps Portal

Products

• CA Performance Management - Usage and Administration
• DX NetOps

Issue/Introduction

I created an on-demand report, but there is a limitation, we can see only 250 rows but I need more than that.

Is there a way to increase the limit or any other method?

 

Environment

DX NetOps Performance Management  - All supported releases

Resolution

1. Log in to the NetOps Portal Linux shell

2. Run the following command
mysql -unetqos -p<password> ----> this will connect you to mysql   (The password is whatever was set by the user during installation/upgrade)

3. Now run the following command
replace INTO netqosportal.general(Attribute,Value) VALUES ('OnDemand.MaxTotalTableSelected.Limit', 500);

4. Ensure the value is set properly:
select * from netqosportal.general where attribute like 'OnDemand.MaxTotalTableSelected.Limit';

5. Restart the NetOps Portal console service

systemctl stop caperfcenter_console
systemctl start caperfcenter_console

 

May need to clear browser cache to get the changes working, especially on chrome based browsers

Additional Information

Note: It will consume more memory in the DA/DM/NetOps Portal to store the RIB call results for more than 1000 rows, and this will affect performance at all other levels.

The higher you set the row limit, the more resources are used as you run it against more items. Be careful not to raise the value too high to avoid performance issues.

The above steps should be used with caution

NOTE :: The general table parameter can be increased: 'OnDemand.MaxTotalChartSelected.Limit'
BUT only allows up to 5000 rows (that is the current maximum row count for all tables, including inventory).