When you publish a small number of treatments to the Reporting Common Data Model (CDM) in SAS^® Customer Intelligence, performance might be slower than expected if the underlying database is Teradata.

Treatment details are bulk-loaded into the database using the Teradata Parallel Transporter (TPT). In versions of Teradata prior to 15.10, the TPT upload time is impacted by the lock in the Teradata dictionary (DBC.AccessRights) every time a data table or a TPT control table is created. For small amounts of data, this process can be time consuming.

Note: This problem is not an issue for Teradata 15.0.

Click the Hot Fix tab in this note to access the hot fix for this issue.

After you install the hot fix, you can disable the TPT bulk-loading process as follows:

1. Open the MarketingAutomation_autoexec_usermods.sas file, which is located on your SAS^® compute server tiers in the following directories (depending on your operating system):
    
   • For UNIX operating systems: SAS-configuration-directory/Lev1/Applications/SASCustomerIntelligence/
   
   
   • For Microsoft Windows operating systems: SAS-configuration-directory\Lev1\Applications\SASCustomerIntelligence\


2. Add the following options to the MarketingAutomation_autoexec_usermods.sas file:
   /* Ignore treatment upload option (TDT) */
   %global ci_tdt_use_upl_opts_tmt;
   %let ci_tdt_use_upl_opts_tmt = 0;
3. Restart your object spawners after you add the options above.

After you upgrade to Teradata 15.10 or later, these options are no longer be necessary and you should remove them.

Operating System and Release Information

A fix for this issue for SAS Marketing Automation 6.5 is available at: