Using a Multi Valued Lookup (MVL) with many values could cause the Load Data Warehouse job to fail (with PostgreSQL database).
Steps to Reproduce:
Expected Results: Job compltes successfully.
Actual Results: Job fails. Error shown:
MVL Load PG - An error occurred executing this job entry :
Couldn't execute SQL: CALL DWH_CMN_MVL_LOAD(P_LAST_LOAD_DATE => to_timestamp('1910/01/01 00:00:00', 'yyyy/MM/dd HH24:mi:ss')::timestamp, P_FULL_RELOAD => 'Y'::text);
ERROR: ENCOUNTERED EXCEPTION WHILE UPDATING DWH_INV_PROJECT.value too long for type character varying(4000)
Where: PL/pgSQL function dwh_cmn_mvl_load(timestamp without time zone,text) line 141 at RAISE
Release : 16.0.1
Component : Clarity Data Warehouse
This issue has been reported to Engineering as DE64917.
This issue is fixed in Clarity 16.0.3.
As there are some external limitations on why there could be no more than 4000 characters, the fix will allow the DWH to continue working, but only the records that fit into these limits will be copied to the DWH.