Increasing Governor Limits in Clarity

Products

• Clarity PPM On Premise
• Clarity PPM SaaS
• STARTER PACK-CLARITY PPM

Issue/Introduction

How can the governor limits, such as the Max XML Nodes, be increased in Clarity PPM 15.6.1 or higher releases?

Current settings: 

#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

Cause

Governor limits are stored in the database starting Clarity PPM 15.6.1, but direct database updates are not supported.

Environment

Clarity 15.6.1 or higher.

Resolution

Governor limits have a current limit, a default limit (out of the box value), and a critical limit (maximum value). It is not possible to increase the current limit past the critical limit.

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

If you are an On Premise Customer:

There are new admin commands to modify the default governor limit settings.

 

For example, to modify the Max XML Nodes limit from current / default of 150,000 to 200,000 nodes, execute this command:

admin governors -set MAX_XML_NODES 200000

The full list of Governor Settings and Admin Commands can be found in the links in the Additional Information section.

 

If you are a SaaS (On Demand) Customer:

The governor limits are set to the most optimal values, and are not changed in SaaS.

 

 

A restart of APP and NSA services is necessary for the new value to take effect.

 

Additional Information

For versions prior to 15.6.1, see KB: How to Set Governor Limits in 15.6 and lower
Please make sure that the displayed version for the below documentation links match the Clarity version you are using:

• Governor Settings (Maximum Data Limits)
• New! Clarity PPM 15.6.1 Governor Limits Stored in the PPM Database  (check 'New Admin Commands' section)