Data Warehouse (DWH) Incremental Job is failing while populating the DWH_LKP_OBS_UNIT table. Excerpt of error:
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
Release : 15.5.1
Component : Data Warehouse (DWH)
This is caused by an OBS UNIT having a null name. To find the impacted OBS UNIT, run the below query on the PPM schema.
select * from DWH_LKP_OBS_UNIT_V where OBS_UNIT is null.
After identifying the problematic OBS Unit, log in to the application and modify it's name.
If the above doesn't help, see: