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

Document ID : KB000004051
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

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.

Environment:
CA PPM 13.3
Cause:

This is due to bug 

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