HCIF 7.21.1 install fails with duplicate value for index error
The Healthcare Industry Foundation (HCIF) 7.21.1 install fails in Pega 7.2.1 when following the installation guide.
SQLState 23505, Error code -803: com.ibm.websphere.ce.cm.DuplicateKeyException: One or more values in the INSERT statement, UPDATE statement, or foreign key update caused by a DELETE statement are not valid because the primary key, unique constraint or unique index identified by "1" constrains table "DATA.PR_OTHER" from having duplicate values for the index key.. SQLCODE=-803, SQLSTATE=23505, DRIVER=3.64.106
Steps to Reproduce
Import the HCIF archive as per the steps in the installation manual.
Root CauseThe installation was not being performed onto a clean system.
Content from a previous instance of HCIF was present.
Data instances from the previous installation of HCIF had the same primary key as the current installation, causing the unique index violation.
The steps provided in the HCIF upgrade manual should be used instead of the installation manual when installing onto a system that has a previous version of HCIF already installed.
Find the appropriate upgrade guide here: https://pdn.pega.com/products/healthcare-industry-foundation-hcif
0% found this useful