Datasync - The INSERT statement conflicted with the FOREIGN KEY constraint - by szenasy

Status : 

  Not Reproducible<br /><br />
		The product team could not reproduce this item with the description and steps provided.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.


1
0
Sign in
to vote
ID 770820 Comments
Status Resolved Workarounds
Type Bug Repros 0
Opened 11/12/2012 10:09:21 AM
Access Restriction Public

Description

Could you please shed some light on this issue.  The issue was reproduced and faulted both on two hub databases (each with a fresh schema only of the source db). 

Will be going through the same steps today with a new schema to see if the same issue persist.
Did not have this issue with the BETA environment that uses the same schema as the one used here making this a confusing scenario. 

Will be appending finding later in the day.






Sync failed with the exception "Sync was aborted because more than 1000 changes failed to apply. Examine your table schemas to look for conflicting constraints or incompatible data types that may prevent sync from succeeding.
Upload - 
errors for first 5 rows that failed to apply:
Error #1: SqlException Error Code: -2146232060 - SqlError Number:547, Message: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_Alert_Item". The conflict occurred in database "prodmirror", table "SwanIsland.Item", column 'ItemID'. SqlError Number:3621, Message: The statement has been terminated. 

Error #2: SqlException Error Code: -2146232060 - SqlError Number:547, Message: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_Alert_Item". The conflict occurred in database "prodmirror", table "SwanIsland.Item", column 'ItemID'. SqlError Number:3621, Message: The statement has been terminated. 

Error #3: SqlException Error Code: -2146232060 - SqlError Number:547, Message: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_Alert_Item". The conflict occurred in database "prodmirror", table "SwanIsland.Item", column 'ItemID'. SqlError Number:3621, Message: The statement has been terminated. 

Error #4: SqlException Error Code: -2146232060 - SqlError Number:547, Message: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_Alert_Item". The conflict occurred in database "prodmirror", table "SwanIsland.Item", column 'ItemID'. SqlError Number:3621, Message: The statement has been terminated. 

Error #5: SqlException Error Code: -2146232060 - SqlError Number:547, Message: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_Alert_Item". The conflict occurred in database "prodmirror", table "SwanIsland.Item", column 'ItemID'. SqlError Number:3621, Message: The statement has been terminated. 

"

For more information, provide tracing id ‘c513eae3-6da0-4baa-8f08-96fb366b3709’ to customer support.

Sync failed with the exception "Sync was aborted because more than 1000 changes failed to apply. Examine your table schemas to look for conflicting constraints or incompatible data types that may prevent sync from succeeding.
Upload - 
errors for first 5 rows that failed to apply:
Error #1: SqlException Error Code: -2146232060 - SqlError Number:547, Message: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_Alert_Item". The conflict occurred in database "prodmirror", table "SwanIsland.Item", column 'ItemID'. SqlError Number:3621, Message: The statement has been terminated. 

Error #2: SqlException Error Code: -2146232060 - SqlError Number:547, Message: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_Alert_Item". The conflict occurred in database "prodmirror", table "SwanIsland.Item", column 'ItemID'. SqlError Number:3621, Message: The statement has been terminated. 

Error #3: SqlException Error Code: -2146232060 - SqlError Number:547, Message: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_Alert_Item". The conflict occurred in database "prodmirror", table "SwanIsland.Item", column 'ItemID'. SqlError Number:3621, Message: The statement has been terminated. 

Error #4: SqlException Error Code: -2146232060 - SqlError Number:547, Message: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_Alert_Item". The conflict occurred in database "prodmirror", table "SwanIsland.Item", column 'ItemID'. SqlError Number:3621, Message: The statement has been terminated. 

Error #5: SqlException Error Code: -2146232060 - SqlError Number:547, Message: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_Alert_Item". The conflict occurred in database "prodmirror", table "SwanIsland.Item", column 'ItemID'. SqlError Number:3621, Message: The statement has been terminated. 
Sign in to post a comment.
Posted by Microsoft on 11/15/2012 at 2:06 AM
szenasy, can you check whether the master table that foreign key FK_Alert_Item points to is in your scope definition? Or is SwanIsland.Item table a self reference table?
Posted by Microsoft on 11/13/2012 at 10:58 PM
hi szenasy, DSS can process tables that have FK relations. Can you describe the FK relations on table SwanIsland.Item?