Not able to pull the report more than 250 count in CAPM

Document ID : KB000115701
Last Modified Date : 24/09/2018
Show Technical Document Details
Issue:

I need to see more than 250 results in my on-demand reports.

but when I try to increase the limit, I get an error:
The number entered exceeds the allowable value for this setting (250)

Environment:
CAPM 3.x
Cause:

This value is controlled by the setting:

OnDemand.MaxTotalTableSelected.Limit

This setting is not available in the PC options section by default and will need to be manually added to the table ‘general’ in mysql.

Resolution:
  1. On the PC host, login to mysql

mysql netqosportal -unetqos -pnetqos

 

add the new value to the table:

insert into general values ('OnDemand.MaxTotalTableSelected.Limit', '250');

 

mysql> insert into general values ('OnDemand.MaxTotalTableSelected.Limit', '250');

Query OK, 1 row affected (0.00 sec)

  1. Now login to these 2 pages in PC:

http://<capc_hostname>:8181/pc/center/admin/debug/attrs

http://<capc_hostname>:8481/dm/admin/debug/attrs

 

and see the new value:

(it takes about 3 minutes or so to update and add the new value)

  1. Edit it to your needs but as the values increase so does the load on your system resources.

Timeout for this query is 1m50sec

CA does not test above 1000,

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