Azure + Sync Framework + Error: Value was either too large or too small for a UInt64 RRS feed

  • Question

  • Hi,

    We have an in-house developed syncronisation service built on the Sync Framework v2.1 which has been running well for over 2 years. It pushes data from a local SQLServer 2005 database to one hosted on Azure with some added encryption.

    The service was stopped recently and when we try to re-start it, it fails with the error:

    System.OverflowException: Value was either too large or too small for a UInt64.

       at System.Convert.ToUInt64(Int64 value)

       at System.Int64.System.IConvertible.ToUInt64(IFormatProvider provider)

       at System.Convert.ToUInt64(Object value, IFormatProvider provider)

       at Microsoft.Synchronization.Data.SyncUtil.ParseTimestamp(Object obj, UInt64& timestamp)

       at Microsoft.Synchronization.Data.SqlServer.SqlSyncScopeHandler.GetLocalTimestamp(IDbConnection connection, IDbTransaction transaction)

    I have found the Hotfix 2703853, and we are proposing to apply this to our local server, but we have found that running SELECT CONVERT(INT, @@dbts) on the local database returns 1545488692 but running the same query on the Cloud database returns -2098169504. which indicates the issue is on the Azure side. Would applying the hotfix to our local server resolve the issue or would it need to be somehow applied to the Azure server?

    Thanks in advance for any assistance!


    Monday, February 9, 2015 9:53 AM

All replies