Support Article

SQLCODE=-601 upgrading HCIF from 7.13 to 7.22 on Pega 7.2.1

SA-28372

Summary



Importing R-A-P file to upgrade to Healthcare Industry Foundation (HCIF) 7.22 fails trying to add index that already exists.

Error Messages



Database-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 Reproduce



Import HCIF by upgrading from 7.13 to 7.22.


Root Cause



A defect or configuration issue in the operating environment. There was another index on an internal table with same name as in framework.

Resolution



Rename existing index and import the RAP again.

 

Published September 23, 2016 - Updated October 4, 2016

Have a question? Get answers now.

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