Support Article
Error occurs in the logs
SA-49403
Summary
Error occurs in the logs on installing Healthcare Industry Foundation (HCIF).
Error Messages
Error occurred 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 Rule-Admin-Product (RAP) file
- Download and manually apply all SQL, and then continue with the RAP import
Root Cause
A defect in Pegasystems’ code or rules. The RAP file includes circumstance definition rules which adds a column to the database table.
Resolution
Perform the following local-change:Add the below columns to the pr_index_circumstance_def table:
DENIALTYPE VARCHAR2(32)
VERSIONID VARCHAR2(32)
PXUSERIDENTIFIER VARCHAR2(32)
TYPE VARCHAR2(32)
Published February 21, 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.