locked
Replication link failed between primary and secondary site RRS feed

  • Question

  • 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..

    Sunday, February 24, 2013 5:26 PM

Answers

  • 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.

    Friday, January 17, 2014 7:01 AM

All replies

  • 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?


    http://www.enhansoft.com/

    Sunday, January 12, 2014 1:56 AM
  • 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.

    Friday, January 17, 2014 7:01 AM