Governor Limits in CA PPM

Document ID : KB000009826
Last Modified Date : 29/01/2019
Show Technical Document Details
Introduction:

How do I set CA PPM governor limits like Maximum XML Nodes, Export to Excel etc? 

Background:

In previous releases, these settings were stored in the properties.xml file, the database, and other hardcoded areas like System Options. Now governor settings are stored in a single governors.properties file located in <INSTALL_DIR>/config. Governor settings changed in the governors.properties are automatically detected by the application without a restart of the server. 

Environment:
CA PPM 15.x
Instructions:

Governor settings are now stored in a single governors.properties file located in <INSTALL_DIR>/config (example: C:\Clarity\config) 

If you edit the file you will see the content described below:

 

#Maximum Document upload Size

DMS_DOCUMENT_MAX_SIZE=20

#Maximum rows for Export to Excel

E2E_MAX_ROWS=25000

#Maximum row limit for Objects and NSQL Portlets

MAX_FETCH_LIMIT=50000

#Maximum GEL rows allowed

MAX_SQL_GEL_ROWS=100000

#Maximum tasks allowed in a timesheet

MAX_TIMESHEET_TASKS=250

#Maximum allowed XML nodes in a XOG read

MAX_XML_NODES=150000

#Maximum attributes allowed in a PFM Portfolio

PFM_LIMITS_MAX_INV_ATTRS=700

#Maximum roles allowed

PFM_LIMITS_MAX_ROLES=75

#Maximum rows for Export to Excel, application level setting

E2E_MAX_ROWS_APP=25000

#Timer for Export to Excel.

E2E_TIMER=600

#Maximum todos allowed per task

MAX_TODOS_PER_TASK=25

Additional Information:

Note:

  1. These numbers are set for optimal performance, please do not modify them without a significant reason, and test the changes on a Test environment before going to Production.
  2. Each governor entry can be disabled using a -999 value in the governors.properties file. This is only for testing purposes. To set this in a real-life environment is highly inadvisable and may lead to issues with the application.
  3. The change of the parameters in SAAS is only allowed with Service Management approval with business case/impact