When running the ETL load job, Load_STG2DM_Prf_inventory_fact.sas, the following error might occur in the Load_STG2DM_Prf_inventory_fact.log:

ERROR: The length of the value of the macro variable T_SUBSET_LIST (a number greater than 65534) exceeds the maximum length (65534). The value has been truncated to 65534 characters.

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

You might encounter this issue 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 the fact data loads. In particular, this issue might occur when loading most or all of the fact data partitions in your data mart during the same fact data load.