Clarity PPM - Access Rights information for Custom Investment Types not being loaded into DWH

book

Article ID: 192237

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

Steps To Reproduce:
1. Create a Custom Investment Type object (Administration -> Objects -> New -> Object Extension = Investment Extension)
2. Navigate to the Modern UX and create a few instances of the object created in Step 1
3. Navigate to Administration -> Resources -> <Search for the account being used>. Provide Global Rights to it over the newly created object
4. Run Load Data Warehouse full load job. Wait till its completion.
5. Run the following query on the PPM Schema. Notice that the ID of the object defined in step 1 is listed:
 SELECT DISTINCT
  global_right
 FROM
  dwh_sec_global_right_v;
6. Run the following query on the DWH Schema. Notice that the ID of the object defined in step 1 is NOT listed:
 SELECT DISTINCT
  global_right
 FROM
  dwh_sec_global_right; 

Expected Result: Custom Investment Types are listed in Step 6
Actual Result: Custom Investment Types are not listed in Step 6

Cause

The steps here miss running the "Load Data Warehouse Access Rights" job. This job is responsible for porting access rights from PPM schema to DWH schema.

Environment

Version: 15.8.0

Resolution

Run the "Load Data Warehouse Access Rights" job.