Importing SAS Customer Intelligence response definitions by using SPK files might result in incorrect counts on the Response. Consider the following scenario:

• You create a response definition in one environment (for example, your test environment).
• You use an SPK file to import that response definition to another environment (for example, the production environment).
• In the production environment, you use this imported response definition and create values in the CI_RESPONSE table.
• Then you change the response definition in the test environment, and you re-import the SPK file again to the production environment.

When the counts on the Response node are updated, the node returns 0 counts.

This issue happens because re-importing the SPK file creates a new RESPONSE_SK value in the CI_RESPONSE table. However, it keeps the same RESPONSE_CD and RESPONSE_NM values, as shown below:

When you then update the counts on the Response node in the production environment, the node returns 0 counts because the macro code does not factor in that a new RESPONSE_SK is available. This incorrect count results from having two RESPONSE_SK values (91 and 96) for the same response, as shown in the previous display. When this occurs, the SASCustIntelCore6.x.log file looks similar to the following:

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

Operating System and Release Information

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

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