PM - Limitation for number of charts in reports

Products

• CA Infrastructure Management
• CA Performance Management - Usage and Administration
• DX NetOps

Issue/Introduction

There is a limit of 225 for charts in reports/dashboards and we would need to increase this number

Environment

Any

Resolution

There is a property named "OnDemand.MaxTotalChartSelected.Limit" that will help increase the limit. Please perform the following steps:

1.- Navigate to /opt/CA/MySql/bin directory in CAPC

2.- Change to "mysql" user and access the db:
[[email protected] bin]# su mysql
bash-4.2$ ./mysql -uroot -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1520
Server version: 5.7.31-enterprise-commercial-advanced MySQL Enterprise Server - Advanced Edition (Commercial)

Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

3.- Change the db to use netqosportal:
mysql> use netqosportal;
Database changed

4.- Run the following query to add the attribute "OnDemand.MaxTotalChartSelected.Limit" and the new value (eg: 270):
mysql> replace into netqosportal.general values ('OnDemand.MaxTotalChartSelected.Limit', '270');
Query OK, 1 row affected (0.00 sec)

5.- Wait for some minutes and see if the attribute is now visible in:
http://CAPC_hostname:8181/pc/center/admin/debug/attrs 

This should have increased the chart limit.

Additional Information

DX PM and present more than 225 charts
https://community.broadcom.com/enterprisesoftware/communities/community-home/digestviewer/viewthread?MessageKey=0892635d