PMO add-in install fails with error "Data Warehouse schema does not exist"

Products

• Clarity PPM On Premise

Issue/Introduction

Post Clarity and Jaspersoft upgrades, the installation of  PMO accelerator add-in (CSK) fails with error: 

"Unable to connect to the Data Warehouse...Data Warehouse schema does not exist"

This happens when running the below command:

admin content csk

The error in the logs is as follows:

Installation properties for CA PPM Accelerator: Program Management Office
ID: csk
reports.apply=false
package.addin.release=15.9.0
package.addin.version=15.9.0.0001
force=false
Unable to connect to the Data Warehouse
---------------------------------------------------------------------------------------------------------------------
Data Warehouse schema does not exist. Add-ins which are dependent on the Data Warehouse schema will not be installed.
---------------------------------------------------------------------------------------------------------------------
Failed to install content pack. ID: csk: Exiting the installation.
Failed to install content pack. ID: csk: Exiting the installation.
Error occurred: /apps/clarity/META-INF/content/xog/csk/install.xml:570: Exiting the installation.
Check admin.log or use -verbose for more information.

Environment

Release: Clarity 15.3 and higher

Cause

DataWarehouse is partially configured in the CSA. As referenced in Add-Ins and Integrations: 

Beginning with Release 15.3, the APM and PMO add-ins require the data warehouse. These add-ins include Jaspersoft Advanced Reporting content items. Before you install the PMO or APM add-ins in Release 15.3, verify that you have already installed the data warehouse. See Install and Configure the Data Warehouse in the English edition of the documentation. These add-ins include items that are based on the data warehouse schema. If the data warehouse schema is unavailable, the add-ins won't work. If the installation or upgrade script for these add-ins does not detect the data warehouse, it cannot continue and exits.

Resolution

Complete the Data Warehouse configuration in Clarity CSA, as this is a mandatory requirement for CSK installation.  

Also refer to: Configure the Datawarehouse