locked
Value was either too large or too small for an int64 RRS feed

  • Question

  • Hi All,

    I am using Application with sync Services for Ado.net.
    client : CE

    Server : Sel Server

    When first time Synchronization it is comming with out error.


    Now when i update on server(seq server 2005) then again sync it will giving Error 

    "Value was either too large or too small for an int64"

    the "SelectIncrementalUpdatesCommand"  query is


    SELECT

    CustomerID, UserID, LastName, FirstName

    FROM

    Customer

    WHERE

    (UserID = @UserID AND

    UpdateTimestamp

    > @sync_last_received_anchor

     

    AND UpdateTimestamp <= @sync_new_received_anchor

     

    AND UpdateId <> @sync_client_id

     

    AND NOT (InsertTimestamp > @sync_last_received_anchor

     

    AND InsertId <> @sync_client_id))


    can any one help out.

    Thanks
    • Moved by Hengzhe Li Friday, April 22, 2011 2:31 AM (From:SyncFx - Microsoft Sync Framework Database Providers [ReadOnly])
    Wednesday, June 10, 2009 9:11 AM

Answers

  • Hello - 

    1. When incremental download sync happens, can you turn on the SQL Profiler and capture which parameter value is too large or too small for int64.
    2. Also please turn on tracking so that we can see which value is assigned too large/too small value.

    Thanks.


    Leo Zhou ------ This posting is provided "AS IS" with no warranties, and confers no rights.
    Wednesday, July 22, 2009 11:08 PM
    Answerer