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.

How to correct the PRPC_Circumstance Index warning

Suggest edit Updated on September 10, 2021

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 TypeWarning Type
Rule-Performance
NamePRPC_CircumstanceIndexWarning
MessageCan'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)

Severity2

 

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.

Did you find this content helpful? YesNo

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