locked
SMS_REPLICATION_CONFIGURATION_MONITOR error- System.Data.SqlClient.SqlException (0x80131904): Timeout expired RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

     I am getting below state message in SMS_REPLICATION_CONFIGURATION_MONITOR System Components on every 30 minutes.

    at same time i am getting a error in rcmctrl.log and found database replication link state Unknown as below in one primary site server for all its all secondary sites.

    My SCCM infra is one CAS, 4 Primary and multiple secondary site within each Primary sites. SCCM 2012 SP2 CU1, but i am getting same error on only one primary site server..

    SMS_REPLICATION_CONFIGURATION_MONITOR state message 

    An unhandled exception has occurred - System.Data.SqlClient.SqlException (0x80131904): Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception (0x80004005): The wait operation timed out
       a.
    Refer to rcmctrl.log for further details.

    rcmctrl.log 

    Error: Received unhandled SQL exception, printing info and throwing it again. SMS_REPLICATION_CONFIGURATION_MONITOR 12/26/2016 5:30:55 PM 17924 (0x4604)
    Error: Exception message: [Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.] SMS_REPLICATION_CONFIGURATION_MONITOR 12/26/2016 5:30:55 PM 17924 (0x4604)

    Database Replication 

    Shailendra Dev

    Monday, December 26, 2016 10:35 AM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote
    How is the CAS seeing the replication links for this primary and its sites? Are the database and SQL services up and running on all the servers (DB, port configuration, TCP/IP, etc)? Any firewalls in between? Were they working before? If so, what change was implemented? Did you check spdiagdrs for any indications? Did you run RLA and examined the results?
    Tuesday, December 27, 2016 3:33 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Normally, even if the CAS can't replicate Primary, you should still have a link to the secondary boxes. I think this indicates a broader issue like a port or a recent change to all the machines like a sql update or services are stopped.

    http://www.sccm-tools.com http://sms-hints-tricks.blogspot.com

    Tuesday, December 27, 2016 4:30 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi

    thanks for your reply..

    on CAS replication link state of concerned Primary and its all secondary sites are unknown..

    all the required services and ports are open,same issue resolves auto . mainly i am getting above state message on every 30 minutes starting from 12:30 AM to 6:30 PM...

    Shailendra Dev

    Tuesday, December 27, 2016 4:34 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    When you use the Replication Link analyzer tool, what does it say as the error?

    Do you have any errors in your SQL logs on the CAS?

     

    http://www.sccm-tools.com http://sms-hints-tricks.blogspot.com

    Tuesday, December 27, 2016 4:41 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    are you still on 2012 or have you moved to 1511? are you running custom ports for SQL or a custom Named instance for your database?  There is a hotfix necessary to install after the upgrade to make Replication work again, this isn't necessary if you move to 1602 or higher.

    http://www.sccm-tools.com http://sms-hints-tricks.blogspot.com


    Tuesday, December 27, 2016 4:42 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    also there is a notice about installing or reinstalling the latest CU if you just ran a recovery: https://support.microsoft.com/en-us/kb/2890472

    http://www.sccm-tools.com http://sms-hints-tricks.blogspot.com

    Tuesday, December 27, 2016 4:43 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    i am using SQL Default instance for all SCCM Site DB , SCCM is 2012 SP2 CU1.on SCCM Primary site DB there is no any error in SQL error logs.

    Shailendra Dev

    Tuesday, December 27, 2016 6:14 PM