Replication link failed between primary and secondary site (Network Steve Forum)

Replication link failed between primary and secondary site

Please find the replication link analyzer logs

viceRunning serviceName="SMS_EXECUTIVE" serverName="SCCM2012.luminousindia.com" ></IsServiceRunning>
2/23/2013 5:56:57 PM: ReplicationLinkAnalysis Information: 1 : Renamed the previous troubleshooting report file from C:\Users\smsadmin\Desktop\ReplicationAnalysis.xml to C:\Users\smsadmin\Desktop\ReplicationAnalysis_634972390176265330.xml.
2/23/2013 5:56:57 PM: ReplicationLinkAnalysis Information: 1 : Running rule: <IsServiceRunning serviceName="SMS_EXECUTIVE" serverName="GGNSCCM.luminousindia.com" ></IsServiceRunning>
2/23/2013 5:56:59 PM: ReplicationLinkAnalysis Information: 1 : Running rule: <IsComponentRunning siteCode="LHO" serverName="SCCM2012.luminousindia.com" componentName="SMS_REPLICATION_CONFIGURATION_MONITOR" ></IsComponentRunning>
2/23/2013 5:56:59 PM: ReplicationLinkAnalysis Information: 1 : Running rule: <IsComponentRunning siteCode="LGN" serverName="GGNSCCM.luminousindia.com" componentName="SMS_REPLICATION_CONFIGURATION_MONITOR" ></IsComponentRunning>
2/23/2013 5:57:01 PM: ReplicationLinkAnalysis Information: 1 : Running rule: <IsSqlDynamicPortEnabled SqlInstanceName="SCCM2012.luminousindia.com" ></IsSqlDynamicPortEnabled>
2/23/2013 5:57:01 PM: ReplicationLinkAnalysis Information: 1 : Running rule: <IsSqlDynamicPortEnabled SqlInstanceName="GGNSCCM.luminousindia.com\CONFIGMGRSEC" ></IsSqlDynamicPortEnabled>
2/23/2013 5:57:01 PM: ReplicationLinkAnalysis Information: 1 : Running rule: <IsSqlVersionCorrect sqlServerName="SCCM2012.luminousindia.com" ></IsSqlVersionCorrect>
2/23/2013 5:57:01 PM: ReplicationLinkAnalysis Information: 1 : Running rule: <IsSqlVersionCorrect sqlServerName="GGNSCCM.luminousindia.com\CONFIGMGRSEC" ></IsSqlVersionCorrect>
2/23/2013 5:57:02 PM: ReplicationLinkAnalysis Information: 1 : Running rule: <IsNetworkDownBetweenSites sourceSiteServer="SCCM2012.luminousindia.com" targetSiteServer="GGNSCCM.luminousindia.com" ></IsNetworkDownBetweenSites>
2/23/2013 5:57:04 PM: ReplicationLinkAnalysis Information: 1 : Running rule: <IsDatabaseOutOfSpace databaseName="CM_LHO" SqlInstanceName="SCCM2012.luminousindia.com" minimumFreeSpacePercentage="5" ></IsDatabaseOutOfSpace>
2/23/2013 5:57:04 PM: ReplicationLinkAnalysis Information: 1 : Running rule: <IsDatabaseOutOfSpace databaseName="CM_LGN" SqlInstanceName="GGNSCCM.luminousindia.com\CONFIGMGRSEC" minimumFreeSpacePercentage="5" ></IsDatabaseOutOfSpace>
2/23/2013 5:57:05 PM: ReplicationLinkAnalysis Information: 1 : Running rule: <IsDatabaseOutOfSpace databaseName="tempdb" SqlInstanceName="SCCM2012.luminousindia.com" minimumFreeSpacePercentage="5" ></IsDatabaseOutOfSpace>
2/23/2013 5:57:05 PM: ReplicationLinkAnalysis Information: 1 : Running rule: <IsDatabaseOutOfSpace databaseName="tempdb" SqlInstanceName="GGNSCCM.luminousindia.com\CONFIGMGRSEC" minimumFreeSpacePercentage="5" ></IsDatabaseOutOfSpace>
2/23/2013 5:57:05 PM: ReplicationLinkAnalysis Information: 1 : Running rule: <DoesBrokerConfigurationExist ssbPort="4022" SqlInstanceName="SCCM2012.luminousindia.com" SiteCode="LHO" ></DoesBrokerConfigurationExist>
2/23/2013 5:57:06 PM: ReplicationLinkAnalysis Information: 1 : Running rule: <DoesBrokerConfigurationExist ssbPort="4022" SqlInstanceName="GGNSCCM.luminousindia.com\CONFIGMGRSEC" SiteCode="LGN" ></DoesBrokerConfigurationExist>
2/23/2013 5:57:20 PM: ReplicationLinkAnalysis Information: 1 : Running rule: <DoesBrokerCertificateMatch targetSiteCode="LGN" sourceSiteCode="LHO" sourceServerName="SCCM2012.luminousindia.com" targetServerName="GGNSCCM.luminousindia.com\CONFIGMGRSEC" ></DoesBrokerCertificateMatch>
2/23/2013 5:57:20 PM: ReplicationLinkAnalysis Information: 1 : Running rule: <IsBrokerDisabled siteCode="LHO" sqlServerName="SCCM2012.luminousindia.com" ></IsBrokerDisabled>
2/23/2013 5:57:20 PM: ReplicationLinkAnalysis Information: 1 : Running rule: <IsBrokerDisabled siteCode="LGN" sqlServerName="GGNSCCM.luminousindia.com\CONFIGMGRSEC" ></IsBrokerDisabled>
2/23/2013 5:57:20 PM: ReplicationLinkAnalysis Information: 1 : Running rule: <IsSysCommitTabError SqlInstanceName="SCCM2012.luminousindia.com" ></IsSysCommitTabError>
2/23/2013 5:57:20 PM: ReplicationLinkAnalysis Verbose: 1 : The last time sys.syscommittab error was checked at 02/23/2013 15:58:00.
2/23/2013 5:57:20 PM: ReplicationLinkAnalysis Verbose: 1 : SQL's error log file for SQL instance SCCM2012.luminousindia.com is C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log\ERRORLOG.
2/23/2013 5:57:20 PM: ReplicationLinkAnalysis Information: 1 : Scanning SQL error log files for the string [3999].
2/23/2013 5:57:20 PM: ReplicationLinkAnalysis Verbose: 1 : Checking SQL error log file \\SCCM2012.luminousindia.com\C$\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log\ERRORLOG.
2/23/2013 5:57:20 PM: ReplicationLinkAnalysis Verbose: 1 : Done checking the file \\SCCM2012.luminousindia.com\C$\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log\ERRORLOG since all other lines in the file are earlier than last check date and time.
2/23/2013 5:57:20 PM: ReplicationLinkAnalysis Information: 1 : Running rule: <IsSysCommitTabError SqlInstanceName="GGNSCCM.luminousindia.com\CONFIGMGRSEC" ></IsSysCommitTabError>
2/23/2013 5:57:20 PM: ReplicationLinkAnalysis Verbose: 1 : The last time sys.syscommittab error was checked at 02/23/2013 15:58:00.
2/23/2013 5:57:30 PM: ReplicationLinkAnalysis Verbose: 1 : SQL's error log file for SQL instance GGNSCCM.luminousindia.com\CONFIGMGRSEC is C:\Program Files\Microsoft SQL Server\MSSQL10_50.CONFIGMGRSEC\MSSQL\Log\ERRORLOG.
2/23/2013 5:57:30 PM: ReplicationLinkAnalysis Information: 1 : Scanning SQL error log files for the string [3999].
2/23/2013 5:57:30 PM: ReplicationLinkAnalysis Verbose: 1 : Checking SQL error log file \\GGNSCCM.luminousindia.com\C$\Program Files\Microsoft SQL Server\MSSQL10_50.CONFIGMGRSEC\MSSQL\Log\ERRORLOG.
2/23/2013 5:57:32 PM: ReplicationLinkAnalysis Verbose: 1 : Done checking the file \\GGNSCCM.luminousindia.com\C$\Program Files\Microsoft SQL Server\MSSQL10_50.CONFIGMGRSEC\MSSQL\Log\ERRORLOG since all other lines in the file are earlier than last check date and time.
2/23/2013 5:57:32 PM: ReplicationLinkAnalysis Information: 1 : Running rule: <IsQueueDisabled queueNameList="ConfigMgrDRSQueue, ConfigMgrDRSSiteQueue, ConfigMgrRCMQueue" serverName="SCCM2012.luminousindia.com" ></IsQueueDisabled>
2/23/2013 5:57:32 PM: ReplicationLinkAnalysis Information: 1 : Executing SQL query SELECT dbo.fnIsDrsQueueEnabled(@QueueName) on SCCM2012.luminousindia.com
2/23/2013 5:57:32 PM: ReplicationLinkAnalysis Information: 1 : Executing SQL query SELECT dbo.fnIsDrsQueueEnabled(@QueueName) on SCCM2012.luminousindia.com
2/23/2013 5:57:32 PM: ReplicationLinkAnalysis Information: 1 : Executing SQL query SELECT dbo.fnIsDrsQueueEnabled(@QueueName) on SCCM2012.luminousindia.com
2/23/2013 5:57:32 PM: ReplicationLinkAnalysis Information: 1 : Running rule: <IsQueueDisabled queueNameList="ConfigMgrDRSQueue, ConfigMgrRCMQueue" serverName="GGNSCCM.luminousindia.com\CONFIGMGRSEC" ></IsQueueDisabled>
2/23/2013 5:57:32 PM: ReplicationLinkAnalysis Information: 1 : Executing SQL query SELECT dbo.fnIsDrsQueueEnabled(@QueueName) on GGNSCCM.luminousindia.com\CONFIGMGRSEC
2/23/2013 5:57:32 PM: ReplicationLinkAnalysis Information: 1 : Executing SQL query SELECT dbo.fnIsDrsQueueEnabled(@QueueName) on GGNSCCM.luminousindia.com\CONFIGMGRSEC
2/23/2013 5:57:32 PM: ReplicationLinkAnalysis Information: 1 : Running rule: <IsRcmCreateInstanceWorking siteCode="LHO" siteServerName="SCCM2012.luminousindia.com" ></IsRcmCreateInstanceWorking>
2/23/2013 5:57:32 PM: ReplicationLinkAnalysis Information: 1 : Running rule: <IsRcmCreateInstanceWorking siteCode="LGN" siteServerName="GGNSCCM.luminousindia.com" ></IsRcmCreateInstanceWorking>
2/23/2013 5:57:32 PM: ReplicationLinkAnalysis Information: 1 : Running rule: <IsTimeInSync sourceSite="SCCM2012.luminousindia.com" targetSite="GGNSCCM.luminousindia.com\CONFIGMGRSEC" ></IsTimeInSync>
2/23/2013 5:57:32 PM: ReplicationLinkAnalysis Information: 1 : Running rule: <IsTransmissionStuck sourceSqlServerName="SCCM2012.luminousindia.com" SqlInstanceName="GGNSCCM.luminousindia.com\CONFIGMGRSEC" ></IsTransmissionStuck>
2/23/2013 5:57:34 PM: ReplicationLinkAnalysis Information: 1 : Running rule: <IsTransmissionStuck sourceSqlServerName="GGNSCCM.luminousindia.com\CONFIGMGRSEC" SqlInstanceName="SCCM2012.luminousindia.com" ></IsTransmissionStuck>
2/23/2013 5:57:35 PM: ReplicationLinkAnalysis Information: 1 : Running rule: <IsSiteActive SiteCode="LGN" ></IsSiteActive>
2/23/2013 5:57:36 PM: ReplicationLinkAnalysis Information: 1 : All links are initialized between subscriber LGN and publisher LHO.
2/23/2013 5:57:36 PM: ReplicationLinkAnalysis Information: 1 : Running rule: <DoesKeyConflictExist siteCode="LHO" serverName="SCCM2012.luminousindia.com" ></DoesKeyConflictExist>
2/23/2013 5:57:36 PM: ReplicationLinkAnalysis Information: 1 : Running rule: <DoesKeyConflictExist siteCode="LGN" serverName="GGNSCCM.luminousindia.com" ></DoesKeyConflictExist>
2/23/2013 5:57:36 PM: ReplicationLinkAnalysis Information: 1 : Running rule: <CheckDegradedLinks SiteCode="LGN" ></CheckDegradedLinks>
2/23/2013 5:57:37 PM: ReplicationLinkAnalysis Information: 1 : Running rule: <CheckDegradedLinks SiteCode="LHO" ></CheckDegradedLinks>
2/23/2013 5:57:37 PM: ReplicationLinkAnalysis Information: 1 : Running rule: <CheckFailedLinks SiteCode="LGN" ></CheckFailedLinks>
2/23/2013 5:57:37 PM: ReplicationLinkAnalysis Information: 1 : Rule CheckFailedLinks failed. Stopped running replication link analysis rules.
2/23/2013 5:57:38 PM: ReplicationLinkAnalysis Information: 1 : Completed replication link analysis thread.
2/23/2013 5:58:03 PM: ReplicationLinkAnalysis Information: 1 : Skipping rule CheckFailedLinks.
2/23/2013 5:58:03 PM: ReplicationLinkAnalysis Information: 1 : Skipping rule CheckFailedLinks.
2/23/2013 5:58:03 PM: ReplicationLinkAnalysis Information: 1 : Finished running replication link analysis rules.
2/23/2013 5:58:03 PM: ReplicationLinkAnalysis Information: 1 : Completed replication link analysis thread.
2/23/2013 5:58:37 PM: ReplicationLinkAnalysis Information: 1 : Uninitialized the link analysis engine.

Please suggest what would i do to start the replication again..if you need anything from my side please update..

February 24th, 2013 8:26pm

Yes, I know this is an old post, Just trying to clean this up,

Did you even figure this out?, if so what was the fix?

Free Windows Admin Tool Kit Click here and download it now

January 12th, 2014 4:56am

Hi Garth,

Yes, I have to do some troubleshooting in the SQL part as SQL is not connecting and found that the issue resolved after that.

Proposed as answer by Garth JonesMVP 1 hour 44 minutes ago

January 17th, 2014 2:01am

This topic is archived. No further replies will be accepted.