Clarity : DWH Incremental job Failing while populating DWH_LKP_OBS_UNIT

Article Id: 194430
Status: Published
Updated On: 06-07-2020 05:44
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.