locked
Distribution-Point sharing (SCCM 2007 -> SCCM 2012) RRS feed

  • Question

  • I've some problems by gathering data from a SCCM 2007 Hierarchy, into the SCCM 2012 environment.

    Gathering Data without enable Distribution Point sharing is successful, enabling Distribution Point Sharing the Process always fail.

    In migmctrl.log i recogniced that the process alway stucks on the following Row for about one hour:

     [Worker]:                                 Query against Legacy Site , @SourceSiteCode=KR1, @LastID=KR10001B:                       WITH Block AS                      (                          SELECT TOP 2500 ID FROM PkgStatus WHERE ID > @LastID ORDER BY ID                      )                      SELECT                          ps.ID COLLATE SQL_Latin1_General_CP1_CI_AS AS ID,                          ps.Type AS Type,                          ps.SiteCode COLLATE SQL_Latin1_General_CP1_CI_AS AS SiteCode,                          ps.PkgServer COLLATE SQL_Latin1_General_CP1_CI_AS AS PkgServer,                          ps.Personality AS Personality,                          ps.Status AS Status,                          ps.SourceVersion AS SourceVersion,                          ps.UpdateTime AS UpdateTime,                          ps.Location COLLATE SQL_Latin1_General_CP1_CI_AS AS Location,                          ps.SigLocation COLLATE SQL_Latin1_General_CP1_CI_AS AS SigLocation,                          ps.ShareName COLLATE SQL_Latin1_General_CP1_CI_AS AS ShareName,                          ps.HTTPUrl COLLATE SQL_Latin1_General_CP1_CI_AS AS HTTPUrl,                          ps.State AS State,                          ps.SigURL COLLATE SQL_Latin1_General_CP1_CI_AS AS SigURL                       FROM dbo.PkgStatus ps                      JOIN (                          SELECT d.ThisSiteCode COLLATE SQL_Latin1_General_CP1_CI_AS AS SiteCode FROM SMSData d                           UNION ALL                          SELECT s.SiteCode FROM Sites s JOIN SMSData d ON s.ReportToSite = d.ThisSiteCode AND s.SiteType = 1) s2                      ON s2.SiteCode = ps.SiteCode                      JOIN DistributionPoints dp ON ps.SiteCode = dp.SMSSiteCode                          AND ps.PkgServer = dp.NALPath collate SQL_Latin1_General_CP1_CI_AS                      WHERE ps.Type != 1 AND dp.Action != 3                          AND ps.ID > @LastID                          AND ps.ID <= (SELECT MAX(ID) FROM Block)

     

    And after that this Errormessage appear:

    ERROR: [Worker]:                                 Failed to execute:                       WHILE (1 = 1)                      BEGIN                          MERGE TOP (1000) PkgStatus AS target                          USING   (                              SELECT                                ps.ID, ps.Type, SiteCode = @CurrentSiteCode, PkgServer = dps.PkgServerFQDN, ps.Personality, ps.Status, ps.SourceVersion, ps.UpdateTime,                                ps.Location, ps.SigLocation, ps.ShareName, ps.HTTPUrl, ps.State, ps.SigURL, SiteCode as SourceSiteCode                              FROM #MIG_PkgStatus ps                              JOIN #MIG_DistributionPointSource dps ON ps.PkgServer = dps.PkgServer                              WHERE ID in (SELECT PkgID collate SQL_Latin1_General_CP1_CI_AS from dbo.SMSPackages_L)                             ) AS src                          ON                            (target.ID = src.ID AND target.Type = src.Type AND target.SiteCode = src.SiteCode AND target.PkgServer = src.PkgServer AND target.Personality = src.Personality) -- TODO: Ensure we match an index                          WHEN NOT MATCHED THEN                              INSERT  (ID, Type, SiteCode, PkgServer, Personality, Status, SourceVersion, UpdateTime,                                      Location, SigLocation, ShareName, HTTPUrl, State, SigURL)                              VALUES (src.ID, src.Type, src.SiteCode, src.PkgServer, src.Personality, src.Status, src.SourceVersion, src.UpdateTime,                                      src.Location, src.SigLocation, src.ShareName, src.HTTPUrl, src.State, src.SigURL)                          WHEN MATCHED AND (                              target.Status != src.Status                              OR target.SourceVersion != src.SourceVersion                              OR target.UpdateTime != src.UpdateTime                              OR target.Location != src.Location                              OR target.SigLocation != src.SigLocation                              OR target.ShareName != src.ShareName                              OR target.HTTPUrl != src.HTTPUrl                              OR target.State != src.State                              OR target.SigURL != src.SigURL                              ) THEN                              UPDATE SET                                  target.Status = src.Status,                                  target.SourceVersion = src.SourceVersion,                                  target.UpdateTime = src.UpdateTime,                                  target.Location = src.Location,                                  target.SigLocation = src.SigLocation,                                  target.ShareName = src.ShareName,                                  target.HTTPUrl = src.HTTPUrl,                                  target.State = src.State,                                  target.SigURL = src.SigURL                          WHEN NOT MATCHED BY SOURCE AND EXISTS(                                  SELECT * FROM MIG_Entity me WHERE me.Type = 2 AND me.ObjectKey = target.ID)                              AND EXISTS (                                  SELECT * FROM MIG_DistributionPointSource dpsrc                                  WHERE dpsrc.PkgServerFQDN = target.PkgServer AND dpsrc.SourceSiteCode = @SourceSiteCode                              )                              AND NOT EXISTS (                                  SELECT * FROM MIG_Job job                                  WHERE Type = 3 AND dbo.fn_GetNALPathFromMIGJobConfiguration(job.AdditionalConfiguration) = target.PkgServer                              )                              THEN DELETE ;                            IF @@ROWCOUNT = 0 BREAK                      END SMS_MIGRATION_MANAGER 07.11.2013 12:28:33 4516 (0x11A4)
                                                                    [Worker]:                 End syncing Distribution Points related tables. SMS_MIGRATION_MANAGER 07.11.2013 12:28:33 4516 (0x11A4)
                                                                    [Worker]:         ========== End syncing distribution points ========== SMS_MIGRATION_MANAGER 07.11.2013 12:28:33 4516 (0x11A4)
                                                                    ERROR: [Worker]:         System.Data.SqlClient.SqlException: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.     at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)     at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)     at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)     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)     at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)     at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)     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.MigrationRepository.BulkCopyData[T](Snapshot snapshot, LegacyRepository legacyRepository, IntlSqlFormatter formatter, Func`2 watermarkFunc, T lastMaxId)     at Microsoft.ConfigurationManagement.MigrationManager.SyncAgentJob.<SyncDPSettings>d__5f.MoveNext()     at Microsoft.ConfigurationManagement.MigrationManager.ExtensionMethods.<AttachErrorHandler>d__6`1.MoveNext() SMS_MIGRATION_MANAGER 07.11.2013 12:28:33 4516 (0x11A4)
    STATMSG: ID=8610 SEV=E LEV=M SOURCE="SMS Server" COMP="SMS_MIGRATION_MANAGER" SYS="<SourceSITESERVER>" SITE=CA1 PID=2348 TID=4516 GMTDATE=Do Nov 07 11:28:33.390 2013 ISTR0=""<SourceSITESERVER>" (CA1)" ISTR1="<DestinationSITESERVER>" ISTR2="-2146232060" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0 SMS_MIGRATION_MANAGER 07.11.2013 12:28:33 4516 (0x11A4)
    STATMSG: ID=8605 SEV=I LEV=M SOURCE="SMS Server" COMP="SMS_MIGRATION_MANAGER" SYS="<SourceSITESERVER>" SITE=CA1 PID=2348 TID=4516 GMTDATE=Do Nov 07 11:28:33.416 2013 ISTR0=""<SourceSITESERVER>" (CA1)" ISTR1="<DestinationSITESERVER>" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0 SMS_MIGRATION_MANAGER 07.11.2013 12:28:33 4516 (0x11A4)
                                                                    [Worker]: ==================== Sync Agent Job 16 Ended ==================== SMS_MIGRATION_MANAGER 07.11.2013 12:28:33 4516 (0x11A4)
                                                                    ERROR: [Worker]: Microsoft.ConfigurationManagement.Migration.MigrationException: 1 exceptions occurred during syncing.     at Microsoft.ConfigurationManagement.MigrationManager.SyncAgentJob.<get_ExecutionPlan>d__7.MoveNext()     at Microsoft.ConfigurationManagement.MigrationManager.Job`1.ExecuteNext() SMS_MIGRATION_MANAGER 07.11.2013 12:28:33 4516 (0x11A4)
                                                                    [Worker]: Start processing status changed event for MIG_SiteMapping.ID=16 SMS_MIGRATION_MANAGER 07.11.2013 12:28:33 4516 (0x11A4)
                                                                    [Worker]:         Set the schedule item 16 end time SMS_MIGRATION_MANAGER 07.11.2013 12:28:33 4516 (0x11A4)
                                                                    [Worker]:         Set the schedule item 16 status to Failed SMS_MIGRATION_MANAGER 07.11.2013 12:28:33 4516 (0x11A4)
                                                                    [Worker]: End processing status changed event for MIG_SiteMapping.ID=16 SMS_MIGRATION_MANAGER 07.11.2013 12:28:33 4516 (0x11A4)
                                                                    [Worker]: Disposing Job 16 SMS_MIGRATION_MANAGER 07.11.2013 12:28:33 4516 (0x11A4)
                                                                    [Worker]: Removing Job 16 from job manager. SMS_MIGRATION_MANAGER 07.11.2013 12:28:33 4516 (0x11A4)
                                                                    [Worker]: Removing the Job with Id 16. SMS_MIGRATION_MANAGER 07.11.2013 12:28:33 4516 (0x11A4)
                                                                    [Worker]: Disposing worker SMS_MIGRATION_MANAGER 07.11.2013 12:28:33 4516 (0x11A4)
                                                                    [Worker]: Disposing current site connection SMS_MIGRATION_MANAGER 07.11.2013 12:28:33 4516 (0x11A4)
    ERROR: [MigMCtrl]: FAILED to EXECUTE job. error = Unknown error 0x80131500, 80131500 SMS_MIGRATION_MANAGER 07.11.2013 12:28:33 4516 (0x11A4)
    ERROR: [MigMCtrl]: FAILED to EXECUTE job. error = Unknown error 0x80131500, 80131500 SMS_MIGRATION_MANAGER 07.11.2013 12:28:33 4516 (0x11A4)


    In the StatusMessages of Migration_Manager there are the following Errormessage:

    The Migration Manager on Configuration Manager site server "<SourceSITESERVER>" was unable to complete the SQL operation on the SQL Server "<DestinationSITESERVER>" of Configuration Manager 2007 due to error "-2146232060".

    Thanks in advance

    Thursday, November 7, 2013 11:45 AM

Answers

All replies