Asked by:
'Gather Data' Failed ... :-(

Question
-
Hi All,
I'm performing a migration from 2012 R2 SP1 to 1511.The past few days my 'data gather' has started to fail...
The log always seems to hang on this line:
[Worker]: Query against Legacy Site , @SourceSiteCode=GLO, @LastID=US200003:Where US200003 is a package name.
Nothing has changed with this package. It sits for an hour then moves on and fails.
How to troubleshoot this? And how to remediate?
Wednesday, January 20, 2016 12:09 PM
All replies
-
-
There is that line above...
Then I'll have to wait for a while for it to time out...
Hopefully be back in the hour!
Wednesday, January 20, 2016 12:43 PM -
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)
Wednesday, January 20, 2016 1:04 PM -
How to troubleshoot this?
I don't know Peter. It's kind of a strange problem.
And how to remediate?
Delete or re-create the package (you'd spend longer trying to understand why it stopped working).
Gerry Hampson | Blog: www.gerryhampsoncm.blogspot.ie | LinkedIn: Gerry Hampson | Twitter: @gerryhampson
Wednesday, January 20, 2016 1:12 PM -
After reading this, https://social.technet.microsoft.com/Forums/en-US/52f02192-fbcf-4bfc-ac4d-87aa5364aec9/distributionpoint-sharing-sccm-2007-sccm-2012?forum=configmanagermigration
I'm thinking it could be DP related.
Can I just 'unshare' them easily without causing any issues?- Proposed as answer by Frank Dong Thursday, February 4, 2016 9:48 AM
Wednesday, January 20, 2016 2:04 PM -
Dear Sir,
Sorry, but I would like to clean up some old posts. Was there any update on this issue? Have you found any solution? Thanks in advance.
Best regards
Frank
Monday, February 15, 2016 9:36 AM