When you run the ETL load job, DI_ETL_Geo_Prod_purge, the following error might occur in the DI_ETL_Geo_Prod_purge job log:

ERROR: The text expression length (a number greater than 65534) exceeds maximum length (65534). The text expression has been truncated to 65534 characters. 

This issue occurs when the length of string exceeds the maximum length (65,534 bytes) that a SAS^® macro variable can hold. The macro variable (PART_LIST) that is used in the DI_ETL_Geo_Prod_purge job stores the concatenated names of all partition tables.

This issue might occur when you have a very high number of fact data partitions. (Note that this is an uncommon scenario.) However, due to the flexibility in building the data hierarchy—which can result in a very high number of fact table partitions—this issue might occur at some point when you submit the purge job.