For multi-valued lookups if you remove a value from an instance so now it is blank, the Load Data Warehouse job will fail with error:
"cannot insert NULL into ("SCHEMADWH"."DWH_CMN_MV_LOOKUP"."LOOKUP_VALUE_KEY")"
Steps to Reproduce:
Expected Result: The Load Data Warehouse job completes successfully.
Actual Result: The Load Data Warehouse job fails with the error " cannot insert NULL into ("SCHEMADWH"."DWH_CMN_MV_LOOKUP"."LOOKUP_VALUE_KEY") "
Caused by CLRT-79697
Records are not being removed from associated tables when the multi-valued lookup instance value is removed. The value needed for the Load Data Warehouse job is now null which cannot be inserted into the DWH. Therefore the job fails.
Targeted for next major release.
Add a value back to the blank instance or create another value in the lookup such as 'N/A' which can be used in place of the blank values.
You can run this query on the ppm schema to find the null values:
select * from dwh_odf_multi_valued_lookups_v where lookup_value_key is null