Clarity:Projects and Ideas Filter Views are Missing after Upgrade from 15.6.1 to 15.7

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

1. Login to Clarity using version Clarity 15.6.1 
2. Navigate to Modern UX and go to Project and Ideas Grid View
3. Create and Save some Views with Filters, for example 'My Approved Projects' and 'My Rejected Projects', 
   do same for Ideas 'Ideas toApprove' and 'My Unapproved Ideas' 
4. Upgrade Clarity 15.6.1 to 15.7
5. Navigate back to New UX -> Projects and Ideas
6. Notice View are present but Filters are missing 

Cause

This is a caused due to defect DE51322 and fixed in 15.7.1 

Environment

Release: 15.6.1

Component: PPMENV

Resolution

If you are on Clarity 15.6.1 and planning to upgrade to 15.7 then follow the below instruction.

1. Stop all the clarity services 
2. Execute the command dbPatch -install
   -file <Path to TEMP_ODF_UI_VIEW_SETTINGS.xml> -apply (This will create a Temp table in your clarity schema)
3. Execute the command dbPatch -install -file <Path to PRE_UPGRADE_SAVED_VIEWS.xml> -apply (This will take the backup of the Project and Idea View and keep it in the Temp table)
4. Start the upgrade of clarity and ensure it completes successfully 
5. Execute the command dbPatch -install -file <Path to
   POSTUPGRADE_SAVED_VIEWS.xml> -apply (This will copy the restored Project and Idea View to the main table)

Note: The above steps are only required when you are upgrading from 15.6.1 to 15.7 and if you are On Demand (SAAS) customer we will take care of this issue