Load Data Warehouse job will fail when on a single object the combined length of the IDs of all custom attribute that are included in the Data Warehouse exceed 4000 characters. This issue is due to the limitation from Oracle on its 11G and lower versions, the limit will be at 8000 characters starting from Oracle 12C.
Applies to all supported PAS environments for specified releases.
Caused by CLRT-78443
Resolved in CA PPM 14.2 Generic Patch #7.
Resolved in CA PPM 14.3
Un-check some of the custom attributes for inclusion to the Data Warehouse and run the LDWH job again
Reference TEC1398937 : PPM 14.2 Generic Patch available to resolve reported issues
Reference CA PPM Resolved Defects Index for CA PPM 14.3
Release: ESPCLA99000-14.3-Clarity-Extended Support Plus