SQLCODE=-601 upgrading HCIF from 7.13 to 7.22 on Pega 7.2.1
SummaryImporting R-A-P file to upgrade to
Healthcare Industry Foundation (HCIF) 7.22 fails trying to add index that already exists.
Error MessagesDatabase-General Problem executing SQL to update database schema -601 42710 DB2 SQL Error: SQLCODE=-601, SQLSTATE=42710, SQLERRMC=yourDataSchema.DATA_OC_IK_7CDFF;INDEX, DRIVER=3.69.24 DatabaseException caused by prior exception: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-601, SQLSTATE=42710, SQLERRMC=yourDataSchema.DATA_OC_IK_7CDFF;INDEX, DRIVER=3.69.24 | SQL Code: -601 | SQL State: 42710
Steps to ReproduceImport HCIF by upgrading from 7.13 to 7.22.
Root CauseA defect or configuration issue in the operating environment. There was another index on an internal table with same name as in framework.
ResolutionRename existing index and import the RAP again.
Published September 23, 2016 - Updated October 4, 2016