'Gather Data' Failed ... :-( RRS feed

  • 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

  • What's in mig*.log?

    Torsten Meringer | http://www.mssccmfaq.de

    • Edited by TorstenMMVP Wednesday, January 20, 2016 12:18 PM
    Wednesday, January 20, 2016 12:17 PM
  • 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)


                                                                    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)


                                                                    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


    Monday, February 15, 2016 9:36 AM