Clarity: Ideas are not visible in Clarity UI after upgrade to 13.3 in MSSQL or Upgrade to 13.3 fails in ORACLE

Products

• CA Identity Manager
• CA Identity Governance
• CA Identity Portal
• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

Problem: After upgrading to CA PPM 13.3:

In Oracle, the upgrade fails with a unique constraint message.  In MSSQL, upgrade is successful but ideas will not be visible after upgrade.

Cause

This is due to bug 

Environment

CA PPM 13.3

Resolution

Description:

After upgrading to Clarity 13.3:

In Oracle, the upgrade fails with a unique constraint message. 
In MSSQL, upgrade is successful but ideas will not be visible after upgrade.

Solution:

This is caused by corrupted records in the PRJ_OBS_ASSOCIATIONS table created prior to the upgrade.

Reference TEC612565 for further information on the data corruption in the PRJ_OBS_ASSOCIATIONS table

This issue is tracked for resolution as CLRT-74224 and its fixed in CA PPM 14.3