Oturum Aç
Microsoft.com
 
Microsoft
 
 
 
Microsoft >
> 
> 
{"Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding."}

Soru {"Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding."}

  • 26 Nisan 2012 Perşembe 17:32
     
      Kod İçerir
    Oylamak İçin Oturum Aç
    0

    Hi,

    I have 100000 records in my server databse table, when i try to download data to local .sdf file its raise this error

    {"Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding."}

    here is my code

      LocalDataCache2SyncAgent syncAgent = new LocalDataCache2SyncAgent();
           Microsoft.Synchronization.Data.SyncStatistics syncStats = syncAgent.Synchronize();
           var localProvider = (ClientSyncProvider)syncAgent.LocalProvider;
           localProvider.ClientId = Guid.Parse("53406795-968f-4205-904d-12f7388316eb");

    How can i overcome that error

     

Tüm Yanıtlar

  • 26 Nisan 2012 Perşembe 23:01
    Moderatör
     
     
    Oylamak İçin Oturum Aç
    0

    are you running on WCF?

    if its SQL timing out, find InitializeCommands in the generated code and set the CommandTimeout in the Commands

     
  • 27 Nisan 2012 Cuma 04:20
     
     
    Oylamak İçin Oturum Aç
    0

    MY application is asp.net MVC one, I have done this way

      this.InsertCommand = new System.Data.SqlClient.SqlCommand();
                this.InsertCommand.CommandTimeout = 500000;

    But still error is comming

    lakmal

     
  • 27 Nisan 2012 Cuma 05:45
    Moderatör
     
     
    Oylamak İçin Oturum Aç
    0

    have you set the timeout for all commands?

    and btw, in your code above, you should be setting the ClientId before calling Synchronize(). setting it after you called Synchronize is useless as the sync has executed already.