Home Dashboard Directory Help
Search

Datasync Warning message after multi-day successfull sync by szenasy


Status: 

Active


1
0
Sign in
to vote
Type: Bug
ID: 776507
Opened: 1/14/2013 11:00:02 AM
Access Restriction: Public
0
Workaround(s)
view
0
User(s) can reproduce this bug

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