Home Dashboard Directory Help
Search

Datasync failure post initial successfull sync by szenasy


Status: 

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)
view
0
User(s) can reproduce this bug

Description

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