locked
Database timeout resolving UniqueConstraint RRS feed

  • Question

  • I have a SQL Server to SQL Server over WCF implementation.

    On the upload sync at the destination I need to handle unique constraint errors in the ApplyChangeFailed handler. I want the destination to win so I try to resolve this by deleting the conflicting record from the destination database, then setting the action to RetryApplyingRow. My problem is that I can't delete the record because the db times out. I'm accessing the DB via entity framework so this timeout is on the SaveChanges() call on the EF context.
    Has the sync framework db provider locked out the DB at this point? If so, how can I resolve the conflict?
    One option would be to set the action to RetryNextSync, then delete the record at the end of the sync, but that doesn't seem like a great solution.

    Sunday, July 2, 2017 10:06 AM