The SAS Digital Marketing response table or opt-out table might lose information. This might occur when the SAS Digital Marketing response table or opt-out table is held in SAS^® data sets or in SAS/SHARE^® software, which cannot handle concurrent updates. If a high volume of responses or opt-outs are received at the same time, the table can become locked and can be incorrectly re-created. The newly created response or opt-out table is then populated with new data, but the original table of data is lost.

To work around this issue, hold the SAS Digital Marketing response table and opt-out table in another database that is capable of handling concurrent updates.

The advanced server property PreventDDL is available from a hot fix from SAS Digital Marketing 5.3. You can also use the property to prevent the SAS data set or SAS/SHARE table from being re-created. However, this does not resolve the locking issue. Subsequent updates that are locked fail to update the table and the response or opt-out table is lost. For further information about using the PreventDDL property, see SAS Note 43762 "The SAS^® Digital Marketing response table is vulnerable to malicious corruption".

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

A hot fix for SAS Digital Marketing 5.3 is available upon request from SAS Technical Support.

Once the hot fix is applied, the SAS data set or SAS/SHARE table will not be re-created, thereby losing the original data. However, applying the hot fix does not resolve the locking problem. You should use an alternative database to redress this issue.

Operating System and Release Information

A fix for this issue for SAS Digital Marketing 5.4_M1 is available at:

A fix for this issue for SAS Digital Marketing 5.41 is available at: