Upgrade fails on CMN_SEC_SAML_CONFIGS_U3

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

When upgrading to 15.9.1+ from 15.9.0 the upgrade fails with error:

5/06/21 1:08 PM (ExecTask) Process - table: CMN_SEC_CERTS.xml

5/06/21 1:08 PM (ExecTask) org.postgresql.util.PSQLException: ERROR: could not create unique index "cmn_sec_saml_configs_u3"

5/06/21 1:08 PM (ExecTask)   Detail: Key (entity_id)=(https://servername:port/niku/nu) is duplicated.

5/06/21 1:08 PM (ExecTask) Process - table: CMN_SEC_SAML_CONFIGS.xml         at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

Environment

Release : 15.9.1+

Component : CA PPM INTEGRATIONS & INSTALLATIONS

Resolution

This happens if the environment was enabled for SAML and there are more than 1 entries in CMN_SEC_SAML_CONFIGS for the same Entity ID. A new unique index CMN_SEC_SAML_CONFIGS_U3 that enforces a unique value in Entity ID has been added in 15.9.1

1. Review the entries in CMN_SEC_SAML_CONFIGS

2. If any complete duplicates on all rows, delete them

3. If similar entries only, with same Entity ID for different IDP, then modify the Entity ID as follows

• Update directly in table CMN_SEC_SAML_CONFIGS
• Change from https://ppmURL/niku/nu to https://ppmURL/

4. Restart the upgrade

5. After upgrade you may have to reset the value back in the table