Version mismatch between Clarity and Data Warehouse schema

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

There is a version mismatch between Clarity and Data Warehouse. This may cause issues after/during upgrade or when running Load Data Warehouse jobs

How to rectify a version mismatch for the two databases

Environment

Release : All Supported Clarity releases

Resolution

Confirm the versions do not match:

1. Run this query on your DWH schema and check the results:
   select * from cmn_dwh_install_history order by installed_date desc
2. Compare to the Clarity database with query:
   select * from cmn_install_history order by installed_date desc
3. If that the versions do not match, this should be corrected

Correct DWH version mismatch:

Option 1:

1. Use a blank DWH schema to replace the existing DWH schema
2. The blank schema is on the Clarity server under $clarity\database\backups
3. Recreate the DB LINK after restoring it

Option 2:

1. Take a backup of an existing Data Warehouse that's on same version ( i.e. Prod)
2. Restore to lower environment DWH by replacing the existing schema
3. Recreate the DB LINK

After fixing the mismatch:

• Run the jobs:
  • Load Data Warehouse -Full
  • Load Data Warehouse - Access Rights

Additional Information

If you have a patch applied on Clarity then after restoring the blank DWH database, run the following command on the Clarity application server to have the patch from Clarity apply to Data Warehouse:

admin db dwh-upgrade -Dupgrade.phase=maintenance

If you are on a base version of Clarity and do not have any patches applied then DO NOT run this command