locked
Sync problem when syncing 100K records. RRS feed

  • Question

  • I am syncing data from SQL server 2008 to SQL server compact edition (in a WinCE device).

    While doing sync (in batches) i am getting the following error

    {System.ServiceModel.CommunicationException: The maximum message size quota for incoming messages (29000000) has been exceeded. To increase the quota, use the MaxReceivedMessageSize property on the appropriate binding element. ---> System.ServiceModel.QuotaExceededException: The maximum message size quota for incoming messages (29000000) has been exceeded. To increase the quota, use the MaxReceivedMessageSize property on the appropriate binding element.

    On Increasing the MaxReceivedMessageSize to max, I start getting 

    {System.OutOfMemoryException: The buffer manager failed to allocate a buffer of 33873314 bytes. ---> System.OutOfMemoryException: OutOfMemoryException

     

    I saw this thread.

    http://social.microsoft.com/Forums/is/syncdevdiscussions/thread/2e1968fa-4dbe-47de-9f05-51f6e6d107f4

    On following this, when I try to regenerate the client proxy code I get errors.

    NetCFSvcUtil.exe http://com/TestSS/SyncService.svc

    Microsoft (R) .NET Compact Framework Service Model Metadata Tool

    [Microsoft (R) Windows (R) Communication Foundation, Version 3.5.0.0]

    Copyright (c) Microsoft Corporation.  All rights reserved.

     

    Attempting to download metadata from 'http://com/TestSS/SyncService.svc' using WS-Metadata Exchange or DISCO.

    Error: An error occurred in the tool.

     

    Error: Error in the application.

     

    Please help

    Monday, November 21, 2011 2:21 PM

All replies

  • what does 'http://com/TestSS/SyncService.svc'  when you try to access it directly from the browser?

    as for the buffer, you should set it in the WCF config entry to a value that your client memory can accomodate.

    Wednesday, November 23, 2011 6:12 AM