Clarity PPM: Refresh ODATA Model job completes with WARNING

Products

• CLARITY PPM FOR ITG
• CLARITY PPM FEDERAL
• Clarity PPM SaaS - Application
• Clarity PPM On Premise

Issue/Introduction

There are several pages of missing views. Although the job completes, there is an issue retrieving the views from a tool such as PowerBI.

The example error is shown:

Message    3/18/19 9:13 AM    
OData V2 Model refresh initiated...
Job Started    3/18/19 9:13 AM    
Message    3/18/19 9:13 AM    
Refreshing Data Warehouse OData Model...
Message    3/18/19 9:17 AM    
OData V2 Model refresh is completed.
Warning    3/18/19 9:17 AM    
DWH_INV_PER_FACTS_F_V:Table does not exist
Message    3/18/19 9:17 AM    
V2 data source updated successfully in OData Service Server.
Warning    3/18/19 9:17 AM    
DWH_RIM_RISK_NOTES_V:Table does not exist
Warning    3/18/19 9:17 AM    
DWH_RIM_RISK_ACTIONS_V:Table does not exist
Warning    3/18/19 9:17 AM    
DWH_RIM_ISSUE_NOTES_V:Table does not exist
Warning    3/18/19 9:17 AM    
DWH_RIM_RISK_AI_ASSIGNEES_V:Table does not exist
.
.
.

 

Cause

There is an issue with the behind-the-scenes job called the Refresh Grant Database job. This SaaS job grants rights to the Hybrid Data Pipeline (HDP) login.
It will have the same rights as the DWH user. 

 

Environment

Release:
Component: ODDWH

Resolution

Please contact the Support team to have the DBA team check the HDP vs the DWH
and to grant the view rights to the HDP user.