Search

Datasync failure post initial successfull sync by szenasy

Active

1
0
Sign in
to vote
Type: Bug
ID: 776269
Opened: 1/10/2013 10:25:59 AM
Access Restriction: Public
0
Workaround(s)
0
User(s) can reproduce this bug
Sync completed successfully in 26443.68 seconds.     Upload: 41771543 changes applied    Download: 0 changes applied    For more information, provide tracing id ‘afdfa335-8c28-4253-95da-3424b83796ba’ to customer support.

Sync failed with the exception "An unexpected error occurred when applying batch file C:\Resources\directory\d96f7bd66384418da6a7a10e67657b29.CloudAgentWorkerRole.BatchDir\DSS_69d1b3a3-8723-4bd3-b75f-1e85b99973cb\7636644d-ead1-44e0-83f7-caba6621a218.batch. See the inner exception for more details.Inner exception: Failed to execute the command 'SelectRowCommand' for table 'SwanIsland.Log'; the transaction was rolled back. Ensure that the command syntax is correct.Inner exception: SqlException Error Code: -2146232060 - SqlError Number:10054, Message: A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.) "    For more information, provide tracing id ‘95e86cc8-b517-48c2-a5a0-96eac6b3d262’ 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.Download - errors for first 5 rows that failed to apply:Error #1: SqlException Error Code: -2146232060 - SqlError Number:547, Message: The DELETE statement conflicted with the REFERENCE constraint "FK_AlertVersion_ItemVersion". The conflict occurred in database "tiesprod_south", table "SwanIsland.AlertVersion", column 'ItemVersionID'. SqlError Number:3621, Message: The statement has been terminated. Error #2: SqlException Error Code: -2146232060 - SqlError Number:547, Message: The DELETE statement conflicted with the REFERENCE constraint "FK_AlertVersion_ItemVersion". The conflict occurred in database "tiesprod_south", table "SwanIsland.AlertVersion", column 'ItemVersionID'. SqlError Number:3621, Message: The statement has been terminated. Error #3: SqlException Error Code: -2146232060 - SqlError Number:547, Message: The DELETE statement conflicted with the REFERENCE constraint "FK_AlertVersion_ItemVersion". The conflict occurred in database "tiesprod_south", table "SwanIsland.AlertVersion", column 'ItemVersionID'. SqlError Number:3621, Message: The statement has been terminated. Error #4: SqlException Error Code: -2146232060 - SqlError Number:547, Message: The DELETE statement conflicted with the REFERENCE constraint "FK_AlertVersion_ItemVersion". The conflict occurred in database "tiesprod_south", table "SwanIsland.AlertVersion", column 'ItemVersionID'. SqlError Number:3621, Message: The statement has been terminated. Error #5: SqlException Error Code: -2146232060 - SqlError Number:547, Message: The DELETE statement conflicted with the REFERENCE constraint "FK_AlertVersion_ItemVersion". The conflict occurred in database "tiesprod_south", table "SwanIsland.AlertVersion", column 'ItemVersionID'. SqlError Number:3621, Message: The statement has been terminated. "    For more information, provide tracing id ‘e34018de-4933-4db7-a4f2-2d7102627edb’ to customer support.
Details (expand)

Product Language

English

Version

Sync Framework 2.0

Category

Sync Framework

Operating System

Not Applicable

Operating System Language

Not Applicable

Steps to Reproduce

Fix indicated error and continue with a successful sync.

Actual Results

Failure continues post initial sync.

Expected Results

Successful sync after finding and fixing presented issue.

Platform

 

Virtualization

 
File Attachments
0 attachments
Sign in to post a comment.
Sign in to post a workaround.