I have an issue on uploading the MLS file to create baseline purchases. In the pivot data tab, the column has the Country of Usage value equal to United States and Canada, which made the processing got a duplicate error . Is it mandatory to have the Country of Usage value equal to All countries? If so, how can we only creating the purchases just for US and Canada?
Error: Violation of PRIMARY KEY constraint 'PK_IncomingBaseline'. Cannot insert duplicate key in object 'dbo.IncomingBaseline_MT'.
This thread has been automatically locked due to inactivity.
To continue the discussion, please start a new thread.
If you are on premise customer and have database access, you can see this PK Constraint "PK_IncomingBaseLIne" is formed as below:
CONSTRAINT [PK_IncomingBaseline] PRIMARY KEY CLUSTERED
So double check whether your rows of data have any duplication group by those columns .
How about I suggest you creating two MLS file, one with one line (US), one with two lines (US & canada) to have a try? to prove us ....:) can't immediately tell whether it's the cause without seeing data or play with the data ...