Governor Limits in CA PPM

Document ID : KB000009826
Last Modified Date : 05/06/2018
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 now 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:\App\PPM\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. Please do not change the properties as these number are set for the optimum performance. 
  2. Each governor entry can be disabled using a -999 value in the governors.properties file, however we don't recomend to change the same.
  3. Changing the parameters in SAAS is not allowed.