ReplicationLinkAnalysis Error: 1 : Unable to find SiteCode or SiteNumber

[dfpjopo]

Can someone help me with this problem?

 

15-2-2013 10:40:00: ReplicationLinkAnalysis Information: 1 : Uninitialized the link analysis engine.
15-2-2013 10:49:11: ReplicationLinkAnalysis Information: 1 : Initializing replication link analysis engine...
15-2-2013 10:49:12: ReplicationLinkAnalysis Information: 1 : Checking registry access to VHSCENTRAL01.singelland.local.
15-2-2013 10:49:12: ReplicationLinkAnalysis Information: 1 : Checking registry access to VHSCENTRAL02.singelland.local.
15-2-2013 10:49:12: ReplicationLinkAnalysis Information: 1 : Writing certificate for VHSCENTRAL01.singelland.local in the certificate store.
15-2-2013 10:49:12: ReplicationLinkAnalysis Information: 1 : The certificate for VHSCENTRAL01.singelland.local already exist in the cert store
15-2-2013 10:49:12: ReplicationLinkAnalysis Information: 1 : Writing certificate for VHSCENTRAL02.singelland.local in the certificate store.
15-2-2013 10:49:12: ReplicationLinkAnalysis Information: 1 : Added the certificate for VHSCENTRAL02.singelland.local to trusted store.
15-2-2013 10:49:12: ReplicationLinkAnalysis Information: 1 : Checking if SQL service is running on VHSCENTRAL01.singelland.local.
15-2-2013 10:49:12: ReplicationLinkAnalysis Information: 1 : Running rule: <IsServiceRunning serviceName="MSSQLSERVER" serverName="VHSCENTRAL01.singelland.local" ></IsServiceRunning>
15-2-2013 10:49:12: ReplicationLinkAnalysis Information: 1 : Checking if SQL service is running on VHSCENTRAL02.singelland.local.
15-2-2013 10:49:12: ReplicationLinkAnalysis Information: 1 : Running rule: <IsServiceRunning serviceName="MSSQLSERVER" serverName="VHSCENTRAL02.singelland.local" ></IsServiceRunning>
15-2-2013 10:49:12: ReplicationLinkAnalysis Verbose: 1 : Connection string = Data Source=VHSCENTRAL01.singelland.local,1433;Initial Catalog=CM_SLD;Integrated Security=True;Persist Security Info=False;MultipleActiveResultSets=True;Encrypt=True;TrustServerCertificate=False;Application Name=REPLICATION_LINK_ANALYZER.
15-2-2013 10:49:12: ReplicationLinkAnalysis Verbose: 1 : Created new sqlConnection to VHSCENTRAL01.singelland.local
15-2-2013 10:49:12: ReplicationLinkAnalysis Verbose: 1 : Connection string = Data Source=VHSCENTRAL02.singelland.local,1433;Initial Catalog=CM_VHS;Integrated Security=True;Persist Security Info=False;MultipleActiveResultSets=True;Encrypt=True;TrustServerCertificate=False;Application Name=REPLICATION_LINK_ANALYZER.
15-2-2013 10:49:12: ReplicationLinkAnalysis Verbose: 1 : Created new sqlConnection to VHSCENTRAL02.singelland.local
15-2-2013 10:49:12: ReplicationLinkAnalysis Information: 1 : Completed replication link analysis thread.
15-2-2013 10:49:12: ReplicationLinkAnalysis Error: 1 : Unable to find SiteCode or SiteNumber
15-2-2013 10:49:12: ReplicationLinkAnalysis Error: 1 : Microsoft.ConfigurationManager.ManagedBase.LocalServerDataNotFoundException: Unable to find SiteCode or SiteNumber
bij Microsoft.ConfigurationManager.ManagedBase.SiteData.Refresh()
bij Microsoft.ConfigurationManager.ReplicationLinkAnalyzer.ReplicationLinkAnalysisEngine.Initialize()
bij Microsoft.ConfigurationManager.ReplicationLinkAnalyzer.ReplicationLinkAnalysisEngine.RunRulesInBackground(Object sender, DoWorkEventArgs e)
bij System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument)

 

Thanks

[learningmode]

Hi, I am getting the same site to site issue with my secondary. Did you find out how to troubleshoot this?

 

 

Thanks

[learningmode]

I figured it out. So I was getting failed from primary rep to secondary. Logs in Secondary I was getting (The asynchronous command finished with return message: [A .NET Framework error occurred during execution of user-defined routine or aggregate "spDRSActivation":)

 

I noticed there was a KB2840628 installed on the server that was released in July 2013 which is around the same time CU2 was released that had broke this before. Just uninstalled KB2840628 and this resolved the issue I was having.

 

I hope this will help others in the future.

 

 

Thanks!