How to Set Governor Limits in 15.6

book

Article ID: 9826

calendar_today

Updated On:

Products

Clarity PPM On Premise

Issue/Introduction

  • How can governor limits such as Maximum XML Nodes, Export to Excel, etc be set?
  • In previous releases, these settings were stored in the properties.xml file, the database, and other hardcoded areas like System Options, where is this now able to be changed?

Environment

Clarity 15.6
On Premise Customers

Resolution

It's recommended to review the recommended limits at Governor Settings (Maximum Data Limits). Increasing the limits above the defined recommendations can impact to performance.

  • Governor settings are stored in a single governors.properties file located in <INSTALL_DIR>/config (example: C:\Clarity\config) 
  • On-premise customers edit this file based on the content they need to change.
  • Governor settings changed in the governors.properties are automatically detected by the application without a restart of the server. 

#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

For versions 15.6.1 and higher, see Increasing Max XML Nodes (Or Other Governor Limit) in 15.6.1 and higher