When you publish the same campaign more than once to the Common Data Model in SAS Customer Intelligence, the publishing process might fail. When this happens, the following error message is generated:

This error suggests that the publishing process is trying to insert the same row again into the CI_CAMP_PAGE_DATE_UDF table with a new PROCESSED_DTTM column.

The expected behavior is that the process should update the existing row with a new PROCESSED_DTTM column.

The same issue might also occur for these tables:

• CI_CAMP_PAGE_DATE_UDF
• CI_CAMP_PAGE_CHAR_UDF
• CI_CAMP_PAGE_NUM_UDF

When you encounter this issue, make sure that the format that is defined in the ci_cdm_ddl_xxx.sas scripts (located in the SASHOME\SASFoundation\9.4\cicsvr\sasmisc directory) is the same as the format in your database.

For example, if your scripts use the VARCHAR format but the database uses NVARCHAR, you might need to change format in the scripts to the NVARCHAR format to match the database.

After the modification, you need to re-generate the tables.

Operating System and Release Information