Skip to main content

 –

Removing the optimized status from a property

Suggest edit Updated on August 25, 2021

Deoptimize a property that you previously optimized to completely clear the optimized property from a database schema. A deleted optimized property falsely retains its optimized status through its property-optimization log associations upon its recreation, and Pega Platform cannot optimize the property again. Deoptimize the property to completely clear its status from the schema and table in order to optimize the property again.

Before you begin: Complete the following actions before deoptimizing a property:
  • Note the name and class of the property that you want to deoptimize. You need the name of the property and its class to locate its unused column and property optimization log association.
  • Delete the property that you want to remove from your database schema. For more information, see Deleting a data object.

    To view schema suggestions and apply changes to a schema, your access group must have the ViewAndOptimizeSchema privilege and set the dynamic system setting database/AutoDBSchemaChangesmust to true.

  1. Drop the column containing the deleted property using the Optimize Schema wizard:
    1. In the header of Dev Studio, click ConfigureSystemDatabaseOptimize Schema.
    2. In the Select Database list, select the database schema that contains the table and column of the property that you deleted.
    3. Select View the unused columns.
    4. Select the column associated with the property that you deleted.
    5. Click Proceed with Changes to apply the selected optimizations.
    6. Click Submit.
  2. Remove the property optimization log association from the deleted property:
    1. In the navigation pane of Dev Studio, click AppClasses, and enter Log-System-PropertyOptimization in the Search field.
    2. In the Criteria section, in the Key Contains field, enter the property name and its class name in the following format: <propertyName>!<className>.
    3. Select the resulting property.
    4. In the Edit Log-System-PropertyOptimization window, select Delete.
    Result: You removed the optimization from the property. If you need to, you can now recreate the property without its optimized status.
Did you find this content helpful? YesNo

100% found this useful

Have a question? Get answers now.

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

Ready to crush complexity?

Experience the benefits of Pega Community when you log in.

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

Pega.com is not optimized for Internet Explorer. For the optimal experience, please use:

Close Deprecation Notice
Contact us