OBS Records missing in the DWH_RES_OBS_MAPPING Table

Products

• Clarity PPM On Premise

Issue/Introduction

After creating a custom Manager OBS to be used by the Resource Object, assigning specific OBS units to different resources, and running the Load Data Warehouse job, the DWH_RES_OBS_MAPPING table is missing records associated to this OBS. 

Environment

Release : 15.6.1

Component : CA PPM DATA WAREHOUSE

Cause

This issue will occur if the DWH_RES_OBS_MAPPING_V view in the PPM schema has records with a null LAST_UPDATED_DATE. The record will exists this PPM view with this null date, but then does not make it into the equivalent table in the Data Warehouse (DWH_RES_OBS_MAPPING). Null values for the LAST_UPDATED_DATE column in this view will occur if there are skipped OBS levels in the specific resource's OBS unit. 

Example of an OBS unit with a skipped level: 

Custom OBS: A\B\C\D\E

The expectation is that: 

A is Level 1

B is Level 2

C is Level 3

D is Level 4

E is Level 5

However, querying the PRJ_OBS_UNITS table in the PPM schema, it will become apparent that the above expectation is not the case:

A is Level 1

B is Level 2

C is Level 3

D is Level 5

E is Level 6

Notice here that Level 4 is skipped.

Skipped levels in the OBS structure usually occur if partial updates are made to the OBS using XOG. The way that the OBS updates should be made to avoid this issue is to xog out the entire OBS unit hierarchy, make the necessary updates, and xog the entire OBS unit hierarchy back in with this update. 

Resolution

The best way to correct the skipped OBS levels that are currently contributing to this issue with missing records in the DWH_RES_OBS_MAPPING table is to XOG out the entire OBS structure and without making any changes XOG it back in. This will correct the null values in the DWH_RES_OBS_MAPPING_V view in the PPM schema and will insert the missing records in the corresponding DWH_RES_OBS_MAPPING table once the Load Data Warehouse job runs. 

Additional Information

https://knowledge.broadcom.com/external/article?articleId=254661