Clarity PPM: Refresh ODATA Model job completes with WARNING

Article Id: 129908
Status: Published
Updated On: 22-03-2019 10:54
Products:
CLARITY PPM FOR ITG , Clarity PPM On Premise , CLARITY PPM FEDERAL , Clarity PPM SaaS , Clarity PPM SaaS - Application , 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.