DWH version is wrong (different from Clarity)
search cancel

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

Environment

Release : Any

Resolution

  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, PostgreSQL dwh_postgres_base
    • Use the same schema name 
    • 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

Note: Rebuilding the DWH schema can be done if you are not using DWH Trending. If you do, recreating the schema will remove the trending information