CA PPM: Why some Saved filters, Saved Job Parameters, Saved Report Parameters are removed with the upgrade to 14.2?

Document ID : KB000031727
Last Modified Date : 10/08/2018
Show Technical Document Details
Introduction:

Problem:

After upgrading saved filters were deleted. Why are some Saved filters, Saved Job Parameters, Saved Report Parameters removed with the upgrade to 14.2?

The removal was caused by another change: CLRT-76562. That fix included a script in the 14.2 upgrade that deletes from cmn_attribute_value_sets, with its purpose being to remove entries for duplicate job schedules.

The problem caused by CLRT-76562 is that data is being deleted when it shouldn't be. Any Saved Filters, Saved Job Parameters, Saved Report Parameters that are named the same regardless of which user created it will get deleted leaving only one left over.

Steps to Reproduce:

  1. In version 13.3 have different users create Saved Filter with the same NAME in multiple part of Clarity (project list, resource list, portlets, etc).  Also, have the user create Saved Job Parameters, Saved Report Parameters.
  2. Perform the upgrade to 14.2.
  3. Check the Save filters, Saved Job Parameters, Saved Report Parameters.

Expected Result: Saved filters, Saved Job Parameters, Saved Report Parameters should exist after the upgrade

Actual Result: All are deleted but one of them (the one with the minimum ID).

Environment:

Applies to all supported PAS environments for specified releases.

Cause:

CLRT-78822 is caused by CLRT-76562 (reference technical article below)

Resolution:

CLRT-78822 is resolved in CA PPM 14.3

Workaround:

This is not a preventative workaround nor is it possible post-upgrade to recover the lost data unless there is access to a pre-upgrade backup of the database/table.

This workaround is possible if applied proactively during the upgrade process. It consists of two queries, the first should be applied before upgrading to CA Clarity PPM 14.2 and above, the second query should be applied after the upgrade is complete:

-- before upgrade - Oracle: Backup the table

create table cavs_bak as select * from cmn_attribute_value_sets
 
-- before upgrade - MSSQL: Backup the table
select *
into cavs_bak
from cmn_attribute_value_sets
  
-- after upgrade - for Oracle or MSSQL: Restore or insert the data from the backup table
insert into cmn_attribute_value_sets
select * from cavs_bak
where id in (
 select distinct cav.attribute_set_id
  from cmn_attribute_values cav
  left join cmn_attribute_value_sets cavs
  on cav.attribute_set_id = cavs.id
  where cavs.id is null )
and business_object_id is null

Additional Information:

Reference TEC1048796 : System Error when deleting more than one cancelled job

Reference CA PPM Resolved Defects Index for CA PPM 14.3

 

Instructions:
Please Update This Required Field