locked
Failed to convert parameter value from a String to a Int32. RRS feed

  • Question

  • When I do a downloadonly sync , I see this error :Failed to convert parameter value from a String to a Int32.

    Is this caused by a null value in data coming from the server ? Is there any way I can get ahold of the actual error so that I can fix this ?( I have a

    ApplyChangeFailed handler, but it is not reached)



    According to my log below, I am  'Applying Inserts'  when this happens.



    Any Ideas?
    Peter


    st2.vshost, 10, 05/08/2009 23:38:13:164,    ----- Applying Inserts for Table ANNOTATION -----
    VERBOSE, Test2.vshost, 10, 05/08/2009 23:38:13:164, Using Command: sp_ANNOTATION_applyinsert
    VERBOSE, Test2.vshost, 10, 05/08/2009 23:38:13:164,    Parameter: @sync_client_id_hash Value: 1934692394
    VERBOSE, Test2.vshost, 10, 05/08/2009 23:38:13:164,    Parameter: @sync_last_received_anchor Len: 8 Value: 00-00-00-00-00-00-07-FD
    VERBOSE, Test2.vshost, 10, 05/08/2009 23:38:13:164,    Parameter: @sync_row_count Value: Skipped since Not Input/InputOutput
    VERBOSE, Test2.vshost, 10, 05/08/2009 23:38:13:164,
    VERBOSE, Test2.vshost, 10, 05/08/2009 23:38:13:164,    Insert for row with Parameters:
    VERBOSE, Test2.vshost, 10, 05/08/2009 23:38:13:179,    Parameter: @id Len: 2 Value: ab
    VERBOSE, Test2.vshost, 10, 05/08/2009 23:38:13:179,    Parameter: @name Len: 2 Value: cd
    • Moved by Hengzhe Li Friday, April 22, 2011 3:17 AM (From:SyncFx - Microsoft Sync Framework Database Providers [ReadOnly])
    Friday, May 8, 2009 11:46 PM

Answers

  • OK - I answered my own question-I had the wrong parameter datatype in my adapter 'insertcommand'

    But it would be nice if SYNC would catch the error ApplyChangeFailed handler instead of throwing a unhelpful error message.


    Thanks,Peter
    • Marked as answer by peter clift Monday, May 11, 2009 5:25 PM
    Monday, May 11, 2009 5:25 PM