search cancel

dwh_res_obs_mapping table missing active resources with OBS

book

Article ID: 254661

calendar_today

Updated On:

Products

Clarity PPM SaaS

Issue/Introduction

Active resources assigned to OBS are still missing from dwh_res_obs_mapping even after running the Load DWH job (full load)

Cause

Resource Adaptor job does updates to the resource records. The adaptor job was running parallely with the Load DWH job. If resource records are being updated while the Load DWH runs, there is a possibility that the specific resource record will not be updated in the OBS mapping table. 

Resolution

Please ensure not to run the Resource adaptor and Load DWH job paralelly.