Support Article
SQL error during rules upgrade process
SA-25781
Summary
When running an upgrade from PRPC 6.x to Pega 7.x, the upgrade fails with the below error in the upgrade logs during the rules schema upgrade.
Error Messages
[java] WARNING: Failed to execute SQL in file oracledate02760.sql
[java] Throwable occurred: java.sql.SQLException: ORA-30556: either functional or bitmap join index is defined on the column to be modified
[...]
[java] WARNING: Statement: ALTER TABLE RulesSchemaName.pr4_rule_vw MODIFY pxInsName VARCHAR2(193)
Steps to Reproduce
Upgrade the Rules schema.
Root Cause
A defect or configuration issue in the operating environment. A functional index is defined on column RulesSchemaName.pr4_rule_vw.pxInsName. A functional index on a column stops Oracle from altering its type or length.
Resolution
Make the following change to the operating environment:
1) Revert to the backup taken before starting the upgrade.
2) Drop the functional index on column PEGA_RULES.pr4_rule_vw.pxInsName.
3) Run the upgrade again.
Published July 27, 2016 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.