TEST Odata is broken after the refresh - returns a 500 error for every table

Products

• Clarity PPM SaaS

Issue/Introduction

The login works, but when requesting any table, the following exception is returned

<?xml version='1.0' encoding='utf-8'?>

<error xmlns="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata">

    <code>222206303</code>

    <message lang="en-US">An error has occurred while accessing the data source: sc12345tdatasource</message>

    <innererror>[42501][0] [DD Cloud OP][PostgreSQL JDBC Driver][PostgreSQL]permission denied for schema sc12345tdwh. </innererror>

</error>

Cause

The Read Only user used by the Hybrid Data Pipeline / ODATA service lost their GRANT to the Data Warehouse Schema

Environment

Release : 16.0.1

Component : Clarity Data Warehouse / Odata

Resolution

Please contact Broadcom Support to have the DBA check the database permissions for the Odata readonly database role1