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

Article Id: 4051

Status: Published

Updated On: 14-02-2018 07:55

Legacy Id: TEC613490

Products:

CLARITY PPM FOR ITG , CA Project & Portfolio Management , CLARITY PPM FEDERAL , CA Project & Portfolio Management SAAS , CA Identity Manager , CA Identity Governance , CA Identity Portal , STARTER PACK-CLARITY PPM

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