Datasync Warning message after multi-day successfull sync - by szenasy

Status : 

 


1
0
Sign in
to vote
ID 776507 Comments
Status Active Workarounds
Type Bug Repros 0
Opened 1/14/2013 11:00:02 AM
Access Restriction Public

Description

Started receiving warning notices post several day of successful synchronizations on our BETA system.

I need to determine whether these warnings stem from the failure to upload the data as shown in the warning log what then triggered the later conflicts.

The below log shown last successful sync and two consecutive warnings that came after.

Sync completed successfully in 39.92 seconds. 	Upload:   13041 changes applied	Download: 0 changes applied    For more information, provide tracing id ‘97532d6e-363b-4731-9780-66440dc34976’ to customer support.

Sync completed with warnings in 52.16 seconds.	Upload:   16444 changes applied/3 failed 	Download: 0 changes applied/0 failedData Sync will stop synchronizing changes for this sync group member in 44 days if the failures are not resolved.	Download - 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_SubscriptionFilter_Filter". The conflict occurred in database "tieshub", table "SwanIsland.Filter", column 'FilterID'. 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_SubscriptionFilter_Filter". The conflict occurred in database "tieshub", table "SwanIsland.Filter", column 'FilterID'. 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_SubscriptionFilter_Filter". The conflict occurred in database "tieshub", table "SwanIsland.Filter", column 'FilterID'. SqlError Number:3621, Message: The statement has been terminated.     For more information, provide tracing id ‘5a7ee756-8342-44da-8ac9-80d7db372b0f’ to customer support.

Sync completed with warnings in 67.65 seconds.	Upload:   13578 changes applied/4 failed 	Download: 0 changes applied/0 failedData Sync will stop synchronizing changes for this sync group member in 43 days if the failures are not resolved.	Download - 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_SubscriptionFilter_Filter". The conflict occurred in database "tieshub", table "SwanIsland.Filter", column 'FilterID'. SqlError Number:3621, Message: The statement has been terminated. Error #2: SqlException Error Code: -2146232060 - SqlError Number:2627, Message: Violation of UNIQUE KEY constraint 'UK_SubscriptionFilter'. Cannot insert duplicate key in object 'SwanIsland.SubscriptionFilter'. The duplicate key value is (38201). SqlError Number:3621, Message: The statement has been terminated. Error #3: SqlException Error Code: -2146232060 - SqlError Number:2627, Message: Violation of UNIQUE KEY constraint 'UK_SubscriptionFilter'. Cannot insert duplicate key in object 'SwanIsland.SubscriptionFilter'. The duplicate key value is (38202). SqlError Number:3621, Message: The statement has been terminated. Error #4: SqlException Error Code: -2146232060 - SqlError Number:2627, Message: Violation of UNIQUE KEY constraint 'UK_SubscriptionFilter'. Cannot insert duplicate key in object 'SwanIsland.SubscriptionFilter'. The duplicate key value is (38203). SqlError Number:3621, Message: The statement has been terminated.     For more information, provide tracing id ‘94630556-4923-41ec-b042-07d5a8970eac’ to customer support.
Sign in to post a comment.