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

'Optimize for reporting' does not auto populate exposed columns

SA-79224

Summary



In the DEV environment, four new columns in two database tables are exposed using the 'Optimize for reporting' option and data is populated to these columns.
On adding columns to the SIT and UAT databases, the databases are modified and columns are added correctly. However, values do not display in the report definition. The values are visible in the work object in the Clipboard. On entering a work object and saving it, data displays in the report definition for these work objects.


Error Messages



Not Applicable


Steps to Reproduce



Not Applicable


Root Cause



In the DEV environment, properties were optimized using Pega Designer Studio which executed the column population by default and populated the previous data.
However, in the SIT and UAT databases, a column was just created in the database tables, and which did not execute the column population. Therefore, though the property is exposed, the previous data is not populated in this exposed column.



Resolution



Perform either of the following local-changes:
  1. Execute the column population using prpcutils.

    Follow the instructions provided in the link: https://community1.pega.com/sites/pdn.pega.com/files/help_v74/procomhelpmain.htm#engine/database/tools/eng-cp-running-tsk.htm#Populating_properties_by_using_a_direct_connection_to_the_database

     
  2. Execute the RecreateIndexesForClass activity manually.

Published 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