SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 44745: SAS® Digital Marketing responses might generate a unique constraint error and fail to update the SAS® Customer Intelligence response history table

DetailsHotfixAboutRate It

SAS Digital Marketing might trigger an error similar to the following in the SASCustIntelReporting5.3.log:

Macro[MACDIRHE] Error inserting responses in to Response History target table.  SQLXRC=[-1] and 
SQLXMSG=[ORA-00001: violation of unique constraint(CDM_DK.CI_DK_B_CUST_RESP_HIST_PK) ]. Check the 
log for details.

When this error occurs, the SAS Customer Intelligence response history table is not updated with the SAS Digital Marketing responses.

There is no workaround for this problem.

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

Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Digital MarketingMicrosoft Windows 95/985.3_M3
Microsoft Windows 2000 Advanced Server5.3_M3
Microsoft Windows 2000 Datacenter Server5.3_M3
Microsoft Windows 2000 Server5.3_M3
Microsoft Windows 2000 Professional5.3_M3
Microsoft Windows NT Workstation5.3_M3
Microsoft Windows Server 2003 Datacenter Edition5.3_M36.1_M19.3 TS1M2
Microsoft Windows Server 2003 Enterprise Edition5.3_M36.1_M19.3 TS1M2
Microsoft Windows Server 2003 Standard Edition5.3_M36.1_M19.3 TS1M2
Microsoft Windows Server 2003 for x645.3_M36.1_M19.3 TS1M2
Microsoft Windows Server 20085.3_M36.1_M19.3 TS1M2
Microsoft Windows Server 2008 for x645.3_M36.1_M19.3 TS1M2
Microsoft Windows XP Professional5.3_M36.1_M19.3 TS1M2
Windows 7 Enterprise 32 bit5.3_M36.1_M19.3 TS1M2
Windows 7 Enterprise x645.3_M36.1_M19.3 TS1M2
Windows 7 Home Premium 32 bit5.3_M36.1_M19.3 TS1M2
Windows 7 Home Premium x645.3_M36.1_M19.3 TS1M2
Windows 7 Professional 32 bit5.3_M36.1_M19.3 TS1M2
Windows 7 Professional x645.3_M36.1_M19.3 TS1M2
Windows 7 Ultimate 32 bit5.3_M36.1_M19.3 TS1M2
Windows 7 Ultimate x645.3_M36.1_M19.3 TS1M2
Windows Millennium Edition (Me)5.3_M3
Windows Vista5.3_M36.1_M19.3 TS1M2
Windows Vista for x645.3_M36.1_M19.3 TS1M2
64-bit Enabled AIX5.3_M36.1_M19.3 TS1M2
64-bit Enabled HP-UX5.3_M36.1_M19.3 TS1M2
64-bit Enabled Solaris5.3_M36.1_M19.3 TS1M2
HP-UX IPF5.3_M36.1_M19.3 TS1M2
Linux5.3_M36.1_M19.3 TS1M2
Solaris for x645.3_M36.1_M19.3 TS1M2
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.