Refresh Data Warehouse OData Model Job failing with "Unable to connect to OData Service Server due to invalid credentials."

Products

• Clarity PPM SaaS

Issue/Introduction

We are receiving the following error when the "Refresh Data Warehouse OData Model" job runs. It returns the following error:

Data Warehouse OData Model refresh failed: Unable to connect to OData Service Server due to invalid credentials.

Environment

Release : All supported releases with OData user on the SaaS side

Cause

This issue can happen if there is an issue with the SaaS Odata user or DB permissions

Resolution

Please contact Broadcom support for assistance for resolution of this issue:

1. SAAS team may need to recreate the OData User and run the Refresh Odata job.

2. DBA to verify proper permissions are set up for Odata