Replication Error - TCP Provider: The semaphore timeout period has expired. 

• Joy Smith San

  SSC-Insane

  Points: 24877

  More actions

  August 20, 2019 at 12:48 pm

  #3672722

  Experts,

  We are facing an issue with one of the replication subscriber.

  There were already two subscribers and replication is working fine since long time for both.

  Recently added one more subscriber and while configuring replication we are getting the below error.

  TCP Provider: The semaphore timeout period has expired.

  This error occurs with ONLY one simple procedure. It doesn't query any table or anything, it just execute some command with "xp_cmdshell" and nothing else.

  If we remove this sproc from publication, replication works just fine. Some of the tables are really large with millions of records.

  Everything works just fine if we just exclude this simple sproc, which basically has only xp_cmdshell command.

  All the servers has SQL Server 2016 - Std.

  Only difference is new subscriber has Windows 2016 Datacenter edition where as other servers have Windows 2016 standard.

  Can someone please help on this ?. Thanks in advance.

   

   

   

   

   

• Site Owners

  SSC Guru

  Points: 80342

  More actions

  August 21, 2019 at 1:10 pm

  #3673118

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.

• eltaljl

  Newbie

  Points: 1

  More actions

  June 3, 2022 at 2:02 pm

  #4043804

  Hi Joy.

  Did you ever get this issue fixed? I'm facing the same

  Thanks!