Clarity: Upgrade to 15.7.1 fails with a Picklist Context Unique Constraint Violation Error

book

Article ID: 143700

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

When upgrading Clarity PPM from 15.7.0 to 15.7.1, the upgrade fails with a unique constraint error.

install.log states:

21/20 5:03 PM (ExecTask) com.ca.clarity.jdbc.oraclebase.ddc: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-00001: unique constraint (ODF_PICKLIST_CONTEXTS_U1) violated
1/21/20 5:03 PM (ExecTask) ORA-06512: at line 2

....

1/21/20 5:03 PM (ExecTask)             BEGIN
1/21/20 5:03 PM (ExecTask)                 update ODF_PICKLIST_CONTEXTS
1/21/20 5:03 PM (ExecTask)                 set code = reverse(substr(reverse(code), 1, instr(reverse(code), '::') - 1))
1/21/20 5:03 PM (ExecTask)                 where code like 'undefined::%';
1/21/20 5:03 PM (ExecTask)             END;
1/21/20 5:03 PM (ExecTask)    

Cause

This is caused by DE52836

Environment

Upgrading to 15.7.1

Resolution

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

    Command:

    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

 

Attachments

1579863839875__PREUPGRADE_FIX_BAD_PICKLIST_CONTEXT_CODES.xml get_app