58912 - A unique index violation occurs in the DETAIL_FACT table in SAS® Customer Intelligence 360

Problem Note 58912: A unique index violation occurs in the DETAIL_FACT table in SAS® Customer Intelligence 360

In SAS Customer Intelligence 360, a unique index violation occurs in the DETAIL_FACT table when the same LOAD_ID column is used in different normalization runs.

At times, the Pageload and load events can be located in separate flume files (the last-available file and the currently active file, respectively). This situation occurs when the time frame between uploading the PageLoad event and the load event is too far apart. When this scenario happens, the index violation occurs.

To obtain a workaround for this problem, contact SAS Technical Support.

A fix for this issue is planned for a future software release.

Operating System and Release Information

Product Family	Product	System	Product Release		SAS Release
			Reported	Fixed*	Reported	Fixed*
SAS System	SAS Customer Intelligence 360	N/A	1.0	1.0

* 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.

A fix for this issue for SAS Customer Experience Targeting Server 6.4 is available at:

https://tshf.sas.com/techsup/download/hotfix/HF2/Y67.html#58912

Type:	Problem Note
Priority:	high

Date Modified:	2016-09-30 10:12:54
Date Created:	2016-09-01 14:23:21