SAS^® Marketing Automation might write the following warning to the stored process server log when it publishes to the common data model:

WARNING: The current setting of the DIRECT_EXE libname option will not allow this SQL 
statement to be passed directly to the DBMS for processing

This behavior is triggered if you set the following macro variable in an autocall macro:

SYS_SQL_IP_SPEEDO=YES

This macro variable, in combination with the SAS option DBIDIRECTEXEC, enables SAS to pass SQL update statements to a database for execution.

The MAPublish process performs several SQL update calls. Although the macro variable SYS_SQL_IP_SPEEDO and the option DBIDIRECTEXEC are set in autocall macros, SAS ignores the SYS_SQL_IP_SPEEDO macro variable if it is set in the autocall macro. The SQL code is not passed to the database, which forces SAS to bring the data back to SAS and execute the SQL locally. Bringing the data back to SAS slows the MAPublish process and might also create deadlock situations.

To work around this problem, set the following two options in the Stored Process autoexec_usermods.sas file:

 
options dbidirectexec;
%let SYS_SQL_IP_SPEEDO=YES;

Operating System and Release Information