When upgrading Clarity PPM from 15.7.0 to 15.7.1, the upgrade fails with a unique constraint error.
This is caused by DE52836
Upgrading to 15.7.1
If you hit this issue, before re-trying the upgrade please follow steps below:
1. Download the attached file to the PPM file directory
2. Stop services
3. Apply the DB Patch
use the dbpatch command to execute the attached file
dbpatch -install -apply -file <file_path>
Example : dbpatch -install -apply -file PREUPGRADE_FIX_BAD_PICKLIST_CONTEXT_CODES.xml <your file path>
The above should take care of the failure you encountered at upgrading time.
4. Restart the upgrade to 15.7.1