GCP Refresh OData Model Job Failing

Products

• Clarity PPM SaaS

Issue/Introduction

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.

ODATA calls through an ODATA tool will also fail with errors similar to

"[42501][0] [DD Cloud OP][PostgreSQL JDBC Driver][PostgreSQL]permission denied for schema gpus123456pdwh. "

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.