OData Model Job Failing after Database Refresh

book

Article ID: 130389

calendar_today

Updated On:

Products

Clarity PPM On Premise

Issue/Introduction

After a recent database refresh, the Refresh Data Warehouse OData Model job fails with the following error in the UI: 

Data Warehouse OData Model refresh failed: There was a problem creating the Model. The OData Model generation failed to find any entities. 

The bg-ca log will show the same message as well: 

ERROR 2019-04-01 21:58:01,161 [Dispatch Refresh Data Warehouse OData Model : bg (tenant=clarity)] niku.njs (clarity:admin:XXXX:Refresh Data Warehouse OData Model) Error executing job: 5044091
com.niku.union.reporting.odata.ODataServiceException: There was a problem creating the model.The OData Model generation failed to find any entities.

Environment

Release:
Component: ODEODT

Resolution

The necessary rights will need to be manually reapplied to the HDP (Hybrid Data Pipeline) read-only user by the SaaS DBA to allow the Refresh Data Warehouse OData Model job to complete successfully. 

If you encounter this error with this job, please open a case with Broadcom Support to get the issue addressed.