The following error message might occur in the SASMarketingAutomationCore.log file when you publish a campaign:

2013-09-05 11:04:21,115 ERROR [5b5bf54e29a6b559:3d9c65ef:140eb9bc184:-7937][sasdemo] 
analytics.crm.cm.ejb.ExportPostProcessor - Error in the stored process or a called macro - Vendor Code: 
100000, Message: Macro[MAPXT]. SYSDBRC=[547] and SYSDBMSG=[OLEDB: ICommand::Execute failed. : The statement 
has been terminated.: The INSERT statement conflicted with the FOREIGN KEY constraint "PKG_X_TREAT_FK3". The 
conflict occurred in database "SASCDM", table "dbo.CI_CELL_PACKAGE", column 'CELL_PACKAGE_SK'. ]., MA Return 
Code: 838, MA Return Message: Macro[MAPXT]. SYSDBRC=[547] and SYSDBMSG=[OLEDB: ICommand::Execute failed. : The 
statement has been terminated.: The INSERT statement conflicted with the FOREIGN KEY 
constraint "PKG_X_TREAT_FK3". The conflict occurred in database "SASCDM", table "dbo.CI_CELL_PACKAGE", 
column 'CELL_PACKAGE_SK'. ], SAS Return Code: 100000

If you see this error, make sure that the ci_cdm_load_codes.sas script executed successfully.

This step is documented in the SAS Marketing Automation Administrator’s Guide, "Chapter 8, Implementing the Common Data Model, Prepopulate the Lookup Tables."

You can find the ci_cdm_load_codes.sas script at the following locations:

• Under Windows: !sasroot\ma\sasmisc
• Under UNIX: !sasroot/misc/ma

Beginning with SAS Marketing Automation 6.x you can find the ci_cdm_load_codes.sas script at the following locations:

• Under Windows: !sasroot\SASFoundation\9.4\cicsvr\sasmisc
• Under UNIX: !sasroot/SASFoundation/9.4/misc/cicsvr

After you execute the SAS^® script, verify that all these lookup tables contain values:

• Populate CI_CAMPAIGN_STATUS
• Populate CI_CHANNEL
• Populate CI_COMMUNICATION_STATUS
• Populate CI_CONTACT_HISTORY_STATUS
• Populate CI_CONTROL_GROUP_TYPE
• Populate CI_RESPONSE_TYPE
• Populate CI_RESPONSE
• Populate CI_CAMPAIGN_TYPE
• Populate CI_CHANGE_TYPE
• Populate CI_CAMPAIGN_GROUP_TYPE
• Populate CI_CAMPAIGN_GROUP_STATUS
• Populate CI_COMMUNICATION_RECURR_TYPE

Operating System and Release Information