Your Load Data Warehouse (DWH) job is failing on a custom lookup, could be with one of the errors below:
The lookup might not be having a proper query to work with DWH, how can you find out which attribute an object it is on, to disable the lookup from DWH?
Release: All Supported Releases
Component: Clarity Data Warehouse
ERROR: THERE WERE ERRORS DURING LOOKUP JOB EXECUTION FOR THE TABLE - DWH_LKP_TEST_VAL_00
Lookup table is DWH_LKP_ TEST_VAL _00
select object_name as Object_id, column_name as Attribute_code, lookup_type as Lookup_id
select clt.id, clov.id, oca.id,
oca.object_name, oca.internal_name, oca.column_name, oca.data_type,
oca.partition_code, oca.is_multivalued, oca.default_value, oca.derived_object_code,oca.internal_name
from cmn_lookup_types clt
join cmn_list_of_values clov
on clt.lookup_type = clov.lookup_type_code
and clov.is_system = 0
join odf_custom_attributes oca
on oca.lookup_type = clt.lookup_type
and clt.lookup_type like '%TEST_VAL%'
group by object_name, column_name, lookup_type
order by object_name, lookup_type
To discuss the issue on the Communities, please connect here: Tech Tip: Load Data Warehouse is failing on a custom lookup, how to find out which attribute to disable?