Support Article
Properties are not Optimized warning when UDFs are disabled
Summary
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
UnknownRoot Cause
This is working as per Pega product design. When the environments have UDFs disabled, unexposed properties may fail to run.
Resolution
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
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.