I get the following 'error' lines:
ERROR: [Worker]:
Failed to execute: WHILE (1 = 1)
BEGIN MERGE TOP (1000) PkgServers_G AS C USING (
SELECT ps.PkgID, NALPath = dps.PkgServerFQDN, SiteCode = @CurrentSiteCode, SiteName = @CurrentSiteCode, SourceSite =
@CurrentSiteCode, ps.LastRefresh, ps.RefreshTrigger, 0 AS UpdateMask, 0 AS Action, ps.ISVData
FROM #MIG_PkgServers ps JOIN
#MIG_DistributionPointSource dps ON ps.NALPath = dps.PkgServer WHERE PkgID in (
SELECT PkgID collate SQL_Latin1_General_CP1_CI_AS from dbo.SMSPackages_L
UNION SELECT V4PkgID FROM MIG_AppVPackageMapping)
) AS T ON (C.PkgID = T.PkgID AND C.NALPath
= T.NALPath AND C.SiteCode = T.SiteCode) WHEN NOT MATCHED THEN
INSERT (PkgID, NALPath, SiteCode, SiteName, SourceSite, LastRefresh, RefreshTrigger, UpdateMask, Action,
ISVData) VALUES (T.PkgID, T.NALPath, T.SiteCode, T.SiteName, T.SourceSite, T.LastRefresh,
T.RefreshTrigger, T.UpdateMask, T.Action, T.ISVData) WHEN MATCHED AND (
C.SiteName != T.SiteName OR C.SourceSite != T.SourceSite
OR C.LastRefresh != T.LastRefresh OR C.RefreshTrigger !=
T.RefreshTrigger OR C.UpdateMask != T.UpdateMask OR
C.Action != T.Action OR C.ISVData != T.ISVData )
THEN UPDATE SET C.SiteName = T.SiteName,
C.SourceSite = T.SourceSite,
C.LastRefresh = T.LastRefresh, C.RefreshTrigger = T.RefreshTrigger,
C.UpdateMask = T.UpdateMask, C.Action = T.Action,
C.ISVData = T.ISVData WHEN NOT MATCHED BY SOURCE
AND EXISTS ( SELECT * FROM MIG_DistributionPointSource dpsrc
WHERE dpsrc.PkgServerFQDN = C.NALPath )
AND NOT EXISTS ( SELECT * FROM MIG_Job job
WHERE Type = 3 AND job.AdditionalConfiguration.value('/*[1]/NALPath[1]', 'NVARCHAR(MAX)') = C.NALPath
) THEN DELETE ;
IF @@ROWCOUNT = 0 BREAK END
SMS_MIGRATION_MANAGER 20/01/2016 13:02:09
2520 (0x09D8)
Then:
ERROR: [Worker]:
System.Data.SqlClient.SqlException (0x80131904): Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. The statement has been terminated. ---> System.ComponentModel.Win32Exception
(0x80004005): The wait operation timed out at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj,
Boolean& dataReady) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior,
RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean
returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe,
Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ConfigurationManagement.MigrationManager.MigrationRepository.BulkCopyData[T](Snapshot snapshot, LegacyRepository legacyRepository,
IntlSqlFormatter formatter, Func`2 watermarkFunc, T lastMaxId, Boolean doNotDrop) at Microsoft.ConfigurationManagement.MigrationManager.V5ToV5DPSharing.<SyncDistributionPoints>d__2.MoveNext() at Microsoft.ConfigurationManagement.MigrationManager.V5SyncAgentJob.<SyncDPSettings>d__65.MoveNext()
at Microsoft.ConfigurationManagement.MigrationManager.ExtensionMethods.<AttachErrorHandler>d__6`1.MoveNext() ClientConnectionId:f7879d0b-61e8-4648-9fa0-df3d234aa97e
SMS_MIGRATION_MANAGER 20/01/2016 13:02:09
2520 (0x09D8)
Then:
ERROR: [Worker]: Microsoft.ConfigurationManagement.Migration.MigrationException:
1 exceptions occurred during syncing. at Microsoft.ConfigurationManagement.MigrationManager.V5SyncAgentJob.<get_ExecutionPlan>d__6.MoveNext() at Microsoft.ConfigurationManagement.MigrationManager.Job`1.ExecuteNext()
SMS_MIGRATION_MANAGER
20/01/2016 13:02:09
2520 (0x09D8)
