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
