Support Article
Insufficient privileges error occurs when importing Product rule
SA-57164
Summary
Insufficient privileges error occurs when importing the Product rule file after installing Pega Customer Service for Healthcare (CSHC) 7.4 on Pega 7.4.
Error Messages
Error occured while trying to add Index columns for an property
com.pega.pegarules.pub.database.DatabaseException: Database-General Problem executing SQL to update database schema 1031 42000 ORA-01031: insufficient privileges
DatabaseException caused by prior exception: java.sql.SQLSyntaxErrorException: ORA-01031: insufficient privileges
| SQL Code: 1031 | SQL State: 42000
Steps to Reproduce
- Import the Product rule file.
- Download and manually apply all SQL.
- Continue with the Product rule import.
Root Cause
A defect in Pegasystems’ code or rules.
Circumstance definition rules included in the Product rule added a column to the database table.
Resolution
Perform the following local-change:
Manually add the below columns to the pr_index_circumstance_def table.
- CaseTypeProgression VARCHAR(32)
- CPMInteractionType VARCHAR(32)
- HCCustomerType VARCHAR(32)
- InteractionType VARCHAR(32)
- IsExistingOpportunityInd VARCHAR(5)
- IsRequestFromOpportunity VARCHAR(5)
- MarketSegment VARCHAR(32)
- PxCurrentRuleBundle VARCHAR(32)
- PyCallType VARCHAR(32)
- SurveyDeliveryType VARCHAR(32)
- UsePlanDrivenFlow VARCHAR(5)
Published May 13, 2018 - Updated December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.