Not Able to delete Check out rules with some Pega 7.1.7
Not able to delete check out rules for the below Pega instance with version Pega 7.1.7.
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.
A defect or configuration issue in the operating environment.
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.
Published October 15, 2015 - Updated October 8, 2020
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.