How to correct the PRPC_Circumstance Index warning
Summary
Remediate this high-priority warning before using the rule in a production environment.
In v5.4 sp2 or greater, use the Download High Priority Warnings option in the Application Preflight tool to research all high-priority warnings in your application. As a best practice, perform the preflight check before you lock a RuleSet version.
Note: This condition prevents circumstance-related reporting and does not affect the runtime performance of your application.
| Rule Type | Warning Type | |
|---|---|---|
| Rule- | Performance | |
| Name | PRPC_CircumstanceIndexWarning | |
| Message | Can't create Circumstance Index because the following column(s) can't be created: <column name(s)>
alter table pr_index_circumstance_def ADD <column name><data type> | |
| Details | (Database-specific message explaining reason for warning condition.) | |
| Example | Can't create Circumstance Index because the following column(s) can't be created: Formula, LongDescription. alter table pr_index_circumstance_def ADD Formula VARCHAR(32) ADD LongDescription VARCHAR(32) | |
| Severity | 2 | |
Suggested Approach
Columns could not be added to the circumstance index table (pr_index_circumstance-def).. This warning can appear on a circumstance definition rule and probably occurred because the PegaRULES database account does not have alter privileges.
For information about setting up these privileges see How to provide CREATE TABLE and ALTER TABLE database privileges in an Admin database account.
This condition prevents circumstance-related reporting and does not affect the runtime performance of your application.