Support Article
Script error dropping index on update to DB2/zOS 7.1.7
SA-5538
Summary
The Pega 7.1.7 update script encountered an error when trying to drop an index, PR4_RULE_VW_PK.
Error Messages
INFO: DROP INDEX PEGA71R.PR4_RULE_VW_PK
Dec 04, 2014 9:58:02 AM com.pega.pegarules.install.SQLLoader writeMessage
WARNING: Failed to execute SQL in file db2zos00250.sql
Dec 04, 2014 9:58:02 AM com.pega.pegarules.install.SQLLoader writeMessage
WARNING: Statement: DROP INDEX PEGA71R.PR4_RULE_VW_PK
Dec 04, 2014 9:58:02 AM com.pega.pegarules.install.SQLLoader writeMessage
INFO:
Encountered a SQL Exception, clean schema before running again.
Steps to Reproduce
Update from DB2/zOS Pega 7.1.6 to Pega 7.1.7.
Root Cause
A defect in Pegasystems’ code or rules
Resolution
Apply HFix-20502.
Published December 8, 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.