none
sql2sql sync v2.0 error: Could not find the file RRS feed

  • Question

  • I'm using the Sync FX v2.0 SDK

    I'm trying to sync 2 databases, both of which have large amount of data.

    The sync scope has just been provisioned, and i chose to populate the syncdata tables...

    I'm using Batches of 20-100 MB in size

     

    But im getting many errors:

    Synchronization failed due to an error 10/7/2010 12:25:50 PM

    Error Message: An unexpected error occurred when applying batch file C:\SyncSettings\BatchTemp\sync_0acd6236e7404e419e117b71fea83bf76299067aa2544b668d18230ba6caf94b\e2cb2d68-c20c-4bec-9bfb-79f9df7f25b4.batch. See the inner exception for more details.

    Could not find file 'C:\SyncSettings\BatchTemp\sync_0acd6236e7404e419e117b71fea83bf76299067aa2544b668d18230ba6caf94b\e2cb2d68-c20c-4bec-9bfb-79f9df7f25b4.batch'.

    also this one:

    Synchronization failed due to an error 10/6/2010 4:19:16 PM

    Error Message: An unexpected error occured when spooling changes to a batch file. See the inner exception for more details.

    Exception of type 'System.OutOfMemoryException' was thrown.


    What should i do ???

    Thursday, October 7, 2010 11:09 AM

All replies

  • can you post the full stack trace of the exception?
    Thursday, October 7, 2010 4:21 PM
    Moderator
  • What's the MemoryDataCacheSize you set on the provider? Can you try to decrease this value and see if you still hit the OutOfMemoryException?

    Thanks,


    Ann Tang
    • Marked as answer by Kyle LeckieEditor Friday, October 8, 2010 6:00 PM
    • Unmarked as answer by Montago Friday, October 8, 2010 6:28 PM
    Thursday, October 7, 2010 6:28 PM
  • The MemoryDataCacheSize was set to 100MB...  but im pretty sure i tried other sizes - including 20 and 50MB

    but what i did, was to clean the destination database, and then resync all over... using 100MB chunks.. 

    i've now successfully uploaded 4 GB data... that the server is now chewing on... 

     

    Friday, October 8, 2010 6:40 PM