DWH version is wrong (different from Clarity)

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

The DWH shows the version is different from Clarity. They are mismatched. How do I get this version fixed?

Environment

Release : Any

Component : CA PPM INTEGRATIONS & INSTALLATIONS

Resolution

Please follow the steps below: 

1. Drop the current DWH schema 

2. Restore a new DWH schema, using the backup from $clarity/database/backups

For Oracle this would be: dwh_oracle_base, for MSSQL dwh_mssql_base

We suggest to use the same schema name to make things simple.

This folder contains the blank backups for the same version of Clarity. 

3. Once this is completed, ensure the DBLINK is set up by connecting the CSA - Server - Data Warehouse and clicking twice on Save

4. Restart services