Refresh Data Warehouse OData Model Job Fails With Error: role "cppmXXXXdbi_ro_role" does not exist

Products

• Clarity PPM SaaS

Issue/Introduction

The Log page error details show:

Data Warehouse OData Model refresh failed: 
SQL error code: 0
Error message: ERROR: role "<schema>dbi_ro_role" does not exist
  Where: SQL statement " GRANT SELECT ON dwh_lkp_investment_status TO <host>DBI_RO_ROLE"
PL/pgSQL function cmn_refresh_rouser_permissions(text,text) line 21 at EXECUTE
Executed:
call CMN_REFRESH_ROUSER_PERMISSIONS(?,?)
Derived from statement:
<?xml version="1.0" encoding="UTF-8"?>
<statement sortColumnPath="/data/header/sortInfo/@sortColumn" sortDirectionPath="/data/header/sortInfo/@sortDirection" slicePath="/data/header/pagination/sliceInfo/@slice" sliceSizePath="/data/header/pagination/sliceInfo/@sliceSize" inputSource="map" xmlns="http://schemas.niku.com/2002/pmd">
  <sql dbVendor="oracle" tsvTemplateAttrCode="">
    <text>
          {call CMN_REFRESH_ROUSER_PERMISSIONS(?,?)}
        </text>
    <param name="dwh_ro_user_name" type="string" direction="IN" expressionListDelimiter=","/>
    <param name="dwh_ro_role" type="string" direction="IN" expressionListDelimiter=","/>
  </sql>

Environment

Release : 16.1.1

Resolution

Please contact the support team to check the role privileges.