search cancel

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

book

Article ID: 238511

calendar_today

Updated On:

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'?>
    <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