SA-14883

Summary

Not able to delete check out rules for the below Pega instance with version Pega 7.1.7.

Error Messages

Error message: Fail:Database-Config-KeyPropertyNotExposed Index-CustomFields pxIndexPurpose

Steps to Reproduce

1. Access that particular instance.
2. Go to Check outs.
3.Try to discard the checkout.

Root Cause

A defect or configuration issue in the operating environment. 

Resolution

Perform the following local-change: 

Note: Ensure to have a database backup before performing local-change steps. 

To resolve "cannot check in rules" behaviour, perform below steps:

1.Stop the server.
2.Drop the existing table with name 'pr_index_customfields'.
3.Run the DDL statements for 'pr_index_customfields' from the generated install DDL script for PRPC 7.1.7.
4.Run below statement to add PYFREQUENTSAYINGCATEGORY column
5.alter table PRPC717.pr_index_customfields add column PYFREQUENTSAYINGCATEGORY VARCHAR(253);
6.Provide all privileges.
7.Restart the server.

Later to recover data, perform 'revalidate and save' for the following classes to retrieve the data in table.

• Rule-Obj-Class
• Rule-Application