Hi All,

every weekend, our SCCM replication between CAS and Primary is going down, we are unable to find any issue since 1 month.

from the logs I can only find the below.

rcmctrl.lo

Creating, verifying, and/or modifying view vStatusMessagesWithStrings with definition [SELECT stat.RecordID, m.MachineID, stat.MachineName, stat.ModuleName, stat.Win32Error,~            stat.Time, stat.SiteCode, stat.TopLevelSiteCode, stat.Component, stat.ProcessID,~            stat.ThreadID, stat.ID&0xF0000000 as Severity, stat.MessageID, stat.Type&0x000000F0 as ReportFunction,~            stat.Type&0x00000008 as SuccessfulTransaction, stat.Type&0x00000004 as PartOfTransaction,~            stat.Type&0x00000002 as PerClient, stat.Type&0x0000FF00 as MessageType, ins.InsStrValue1,~            ins.InsStrValue2, ins.InsStrValue3, ins.InsStrValue4, ins.InsStrValue5, ins.InsStrValue6,~            ins.InsStrValue7, ins.InsStrValue8, ins.InsStrValue9, ins.InsStrValue10~          FROM StatusMessages stat~          LEFT JOIN~          (~            select RecordID,~               [0] as InsStrValue1, [1] as InsStrValue2, [2] as InsStrValue3, [3] as InsStrValue4,~               [4] as InsStrValue5, [5] as InsStrValue6, [6] as InsStrValue7, [7] as InsStrValue8,~               [8] as InsStrValue9, [9] as InsStrValue10~            from~              (select RecordID, InsStrIndex,InsStrValue from StatusMessageInsStrs) as S~            PIVOT~              (MAX(InsStrValue) FOR InsStrIndex in ([0],[1],[2],[3],[4],[5],[6],[7],[8],[9])) as P~          ) as ins on stat.RecordID=ins.RecordID~          LEFT JOIN StatusMessageAttributes att on stat.RecordID=att.RecordID and att.AttributeID=408~          LEFT JOIN MachineIdGroupXRef m on att.AttributeValue=m.GUID and m.ArchitectureKey=5] on server xyz on database CM_CAS. SMS_REPLICATION_CONFIGURATION_MONITOR 7/20/2015 12:12:27 AM 11004 (0x2AFC)

View vStatusMessagesWithStrings is already present in the database. Checking if it needs modification. SMS_REPLICATION_CONFIGURATION_MONITOR 7/20/2015 12:12:27 AM 11004 (0x2AFC)
View vStatusMessagesWithStrings definition is correct. SMS_REPLICATION_CONFIGURATION_MONITOR 7/20/2015 12:12:27 AM 11004 (0x2AFC)
Renaming original table to temporary in database CM_CAS for distributed view SMS_REPLICATION_CONFIGURATION_MONITOR 7/20/2015 12:12:27 AM 11004 (0x2AFC)
Configuring distributed view SMS_REPLICATION_CONFIGURATION_MONITOR 7/20/2015 12:12:27 AM 11004 (0x2AFC)
Formulating definition for view vStatusMessages SMS_REPLICATION_CONFIGURATION_MONITOR 7/20/2015 12:12:27 AM 11004 (0x2AFC)
View vStatusMessages is not distributed. Not including distributed servers into its definition SMS_REPLICATION_CONFIGURATION_MONITOR 7/20/2015 12:12:27 AM 11004 (0x2AFC)

Creating, verifying, and/or modifying view vStatusMessages with definition [SELECT RecordID, MachineName, ModuleName, Win32Error, Time, SiteCode, TopLevelSiteCode,~            Component, ProcessID, ThreadID, ID&0xF0000000 as Severity, MessageID,~            Type&0x000000F0 as ReportFunction, Type&0x00000008 as SuccessfulTransaction,~            Type&0x00000004 as PartOfTransaction, Type&0x00000002 as PerClient,~            Type&0x0000FF00 as MessageType~          FROM StatusMessages] on server xyz on database CM_CAS. SMS_REPLICATION_CONFIGURATION_MONITOR 7/20/2015 12:12:27 AM 11004 (0x2AFC)

could you please suggest us what all the logs needs to be monitor or any SQL errors needs to be find out.

Hi,

Can you check the following log replmgr.log and rcmctrl.log.

If you cannot find out anything then run script spDiagDRS: it will output useful information about the DRS General Status, Current replication link status, etc.

Regards,

Vinod

Can you upload rcmctrl.log and replmgr.log to onedrive and share the links here. ?

Check this thread - https://social.technet.microsoft.com/Forums/en-US/2f68bd5b-0944-4deb-98e0-cbf586fe8625/database-replication-link-failed-state-between-cas-and-primary-site?forum=configmanagergeneral

above I have posted rcmctrl.log,replmgr.log

it is happening every weekend, this is the error I get in the status message.

An unhandled exception has occurred - System.Data.SqlClient.SqlException: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
  .

Refer to rcmctrl.log for further details.

could not find any error in rcmctrl.log

Where did you post the logs ?

-Vinod

Yes, I know this is an old post, but Im trying to clean them up. Did you solve this problem, if so what was the solution?

Since no one has answer this post, I recommend opening  a support case with Microsoft Customer Support Services (CSS) as they can work with you to solve this problem.

H Jones,

yes this issue is not resolved, very now and then our SCCM replication link is getting failed between sites.

we investigated and found whenever a big query, task runs CAS we are getting SQL timeout.

due to which link is getting break, we are collecting all our findings once done will raise a case with MS.

thank you.