ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

DWH version is wrong (different from Clarity)

book

Article ID: 215830

calendar_today

Updated On:

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