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

book

Article ID: 140763

calendar_today

Updated On:

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.

Cause

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

Environment

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

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