How to correct the PRPC_CircumstanceIndex rule warning for circumstance definition rules
Summary
Remediate this high-priority warning before using the rule in a production environment. 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.
This condition prevents circumstance-related reporting; it does not affect the runtime performance of your application.
Rule Type | Warning Type | |
---|---|---|
Rule-Circumstance-Definition | Logic | |
Name | PRPC_CircumstanceIndex | |
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 any rule qualified by a circumstance and probably occurred because the Process Commander database account does not have alter privileges. For information about setting up these privileges see KB 25318 How to provide CREATE TABLE and ALTER TABLE database privileges in an Admin database account.