0

I recently tried to replicate a database with only one table in it using transactional replication, using GUI of SQL server management studio. But, as soon, the publication is set up, I get this error.

Logger: Utility.LogHelper
Callsite: Utility.LogHelper+<>c__DisplayClass2_0.<Log>b__2
Message: RawRequestLogManager > Add > Query EXCEPTION:Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
StackTrace:ExecutionContext.RunInternal => Task.Execute => <>c__DisplayClass2_0.<Log>b__2 Exception:Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
Inner Exception:
Inner Exception:System.Data.SqlClient.SqlException Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding. Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Win32Exception The wait operation timed out  

I tried setting the concurrent flag on in @sync_method, but no use. Any way to avoid this error while using transactional replication or should I switch to snapshot or merge replication? Although, my requirement is to use transactional replication. Any workaround will be helpful.

9
  • Where do you see that error? Jan 31 at 12:51
  • ... and what is this "concurrent flag", exactly? Jan 31 at 17:31
  • @DavidBrowne-Microsoft, so developer team has setup this alert in emails, what they suggest is that maybe tables get locked and only one query is inserted at a time and other insert queries are throwing timeout error
    – tsu90280
    Jan 31 at 23:33
  • @TiborKaraszi, its one option in sync_method
    – tsu90280
    Jan 31 at 23:35
  • You mean the parameter for sp_addpublication, I assume. To me, the error is just a timeout from some client application. This option for sp_addpublication is only relevant when the initial snapshot is created, after that it has no meaning. If your problem is when the snapshot is generated, then generate it when it is OK to have higher load on the system. If the problem is after then snapshot was generated, then this option is irrelevant. Switching replication type won't help you since then also need to do an initial snapshot. Feb 1 at 9:32

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.