Clarity : DWH Incremental job Failing while populating DWH_LKP_OBS_UNIT

Products

• Clarity PPM On Premise

Issue/Introduction

DWH Incremental Job is failing while population DWH_LKP_OBS_UNIT table.

Cause

V_SQL_TEXT := 'MERGE INTO DWH_LKP_OBS_UNIT TGT USING ......

[CA Clarity][Oracle JDBC Driver][Oracle]ORA-20100: ENCOUNTERED EXCEPTION IN DWH_DIM_LOAD (DWH_LKP_OBS_UNIT). SQLERRM : ORA-01407: cannot update ("PPM_DWH"."DWH_LKP_OBS_UNIT"."OBS_UNIT") to NULL
ORA-06512: at line 24

 

 

Environment

Release : 15.5.1

Component : CA PPM APPLICATION

Resolution

This is caused by a OBS UNIT having a null name. Find out the issue causing OBS Unit by running the below query on PPM schema.

 

select * from DWH_LKP_OBS_UNIT_V where OBS_UNIT is null.

 

After identifying the problematic OBS Unit, login to the application and modify it's name.