Home Dashboard Directory Help
Search

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


Status: 

Resolved
 as Not Reproducible Help for as Not Reproducible


1
0
Sign in
to vote
Type: Bug
ID: 770820
Opened: 11/12/2012 10:09:21 AM
Access Restriction: Public
0
Workaround(s)
view
0
User(s) can reproduce this bug

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.
Details
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?
Sign in to post a workaround.