Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

Properties are not Optimized warning when UDFs are disabled



Applications built on PegaRULES (for example, the Pega Smart Adjust) that contain unexposed properties and disabled UDFs (User Defined Functions) display the below performance warning.
In this use case, there are many report definitions that refer unexposed or unoptimized properties as a column source or in report filter criteria.

Error Messages

Properties are not Optimized. Displaying them may result in poor performance.

Steps to Reproduce


Root Cause

This is working as per Pega product design. When the environments have UDFs disabled, unexposed properties may fail to run.


To expose properties and populate database columns using the Property Optimization tool, refer to the procedure in this help file: Exposing properties and populating database columns using the Property Optimization tool

After performing schema changes that expose a property as a database table column, update rows in a PegaRULES database table by using the Column Populator utility. Refer to this PDN article for more information: Database column population using the Column Populator utility

The Column Populator utility can also be run using command line. This is useful in environments where the Optimize for Reporting option is unavailable from the UI.
For more information, refer How to use the Column Populator utility in PRPC 6.x to Pega 7.1.9

Additional reference, Working with the PegaRULES database — Using the Database Column Populator utility

To find the list of unexposed properties from the Guardrails Landing Page, navigate to Designer Studio > Application > Guardrails > Warning Details.

  • Warning Type is Performance
  • Warning Name is Not Optimized for reporting or filtering
  • Rule Type is Report Definition

Below is an example of the Warning details in an application.

Published April 28, 2018 - Updated December 2, 2021

Was this useful?

0% found this useful

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us