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 19, 2016 - Updated July 27, 2016

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.