Created On:  10 December 2010

Problem:

When populating the table ST_ITEMLINKS during a Datamart extraction the following error occurs:

Violation of PRIMARY KEY constraint 'PK_ST_FILEHISTORY'. Cannot insert duplicate key in object 'dbo.ST_FILEHISTORY"

Resolution:

This problem occurs because the database used as the target for the extraction was previously created using a version of Datamart prior to Datamart 2009.  There where several database schema changes made in DataMart 2009. To resolve this issue, create a new target database using DataMart 2009. This will ensure a clean extraction and older data will not cause any conflicts.
Incident #2476745