locked
Collection Migration Failed - Migration SCCM 2007 to SCCM 2012 R2 RRS feed

  • Question

  • Hi

    I am on the process of migrating SCCM 2007 to SCCM 2012. They are in different forests.

    I have successfully migrated all the packages, drivers and driver packages but I am struggling with collection migration.

    I have noted that most of the collections that are failing to migrate have one advertisement. I have unticked the "Include subcollections" option but they still fail. 

    I get this error on the tab "objects in job":

    Unknown error. See migmctrl.log and smsprov.log for more information. Code: 134217727 Details .

    Then I go to the log files and For every collection that fails to migrate I get on migmctrl.log first 4 errors and later on a few more:

    1:

       ERROR: [Worker]: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation.     at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)     at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)     at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)     at Microsoft.ConfigurationManagement.SoftwareLibrary.ObjectSerialization.Modeling.DynamicLibraryType.InvokeMethod(MethodInfo method, Object obj, Object[] parameters)  |__System.Runtime.InteropServices.COMException:   System.Runtime.InteropServices.COMException:      at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)     at System.Management.ManagementObject.InvokeMethod(String methodName, ManagementBaseObject inParameters, InvokeMethodOptions options)     at Microsoft.ConfigurationManagement.SoftwareLibrary.ObjectSerialization.Adapters.WmiObjectManager.InvokeJoinPoint(Type type, IJoinPoint joinPoint)     at Microsoft.ConfigurationManagement.SoftwareLibrary.ObjectSerialization.ConfigMgr.SMS_CollectionRuleQueryMethods.ValidateQuery(LibraryType`1 self, String wQLQuery)     at Microsoft.ConfigurationManagement.SoftwareLibrary.ObjectSerialization.ConfigMgr.SMS_Collection.BeforeSaveObject(LibraryContext context, WmiPropertyManager propMgr)     at Microsoft.ConfigurationManagement.SoftwareLibrary.ObjectSerialization.ConfigMgr.DynamicSMS_Collection.Save(LibraryContext )

    2:

                  [Worker]: Set the status of the entity ABT GR ALL COM HASP User L 000 00 Distribuir to Failed.

    3:

        [Worker]: Set the status of the job entity ABT GR ALL COM HASP User L 000 00 Distribuir to Failed.

    4:

    ERROR: [Worker]: Entity ABT GR ALL COM HASP User L 000 00 Distribuir with path SMS_Collection.CollectionID='C0000158' failed with: Microsoft.ConfigurationManagement.SoftwareLibrary.ObjectSerialization.LibraryException ---> System.Runtime.InteropServices.COMException     at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)     at System.Management.ManagementObject.InvokeMethod(String methodName, ManagementBaseObject inParameters, InvokeMethodOptions options)     at Microsoft.ConfigurationManagement.SoftwareLibrary.ObjectSerialization.Adapters.WmiObjectManager.InvokeJoinPoint(Type type, IJoinPoint joinPoint)     at Microsoft.ConfigurationManagement.SoftwareLibrary.ObjectSerialization.ConfigMgr.SMS_CollectionRuleQueryMethods.ValidateQuery(LibraryType`1 self, String wQLQuery)     at Microsoft.ConfigurationManagement.SoftwareLibrary.ObjectSerialization.ConfigMgr.SMS_Collection.BeforeSaveObject(LibraryContext context, WmiPropertyManager propMgr)     at Microsoft.ConfigurationManagement.SoftwareLibrary.ObjectSerialization.ConfigMgr.DynamicSMS_Collection.Save(LibraryContext )     --- End of inner exception stack trace ---     at Microsoft.ConfigurationManagement.SoftwareLibrary.ObjectSerialization.Modeling.DynamicLibraryType.InvokeMethod(MethodInfo method, Object obj, Object[] parameters)     at Microsoft.ConfigurationManagement.SoftwareLibrary.ObjectSerialization.ConfigMgr.ConfigMgr10.PutInstance(ILibraryObject instance, LibraryContext context)     at Microsoft.ConfigurationManagement.SoftwareLibrary.ObjectSerialization.Adapters.ObjectManagerBase.PutInstance(ILibraryObject instance, LibraryContext context)     at Microsoft.ConfigurationManagement.SoftwareLibrary.ObjectSerialization.Adapters.ObjectManagerBase.ImportObject(ILibraryObject instance, LibraryContext context, ChangeTracker session, ConflictResolution& result)

    [...]

         ERROR: [Worker]: Failed because we cannot create a composable collection.

     ERROR: [Worker]: Microsoft.ConfigurationManagement.SoftwareLibrary.ObjectSerialization.LibraryException: Cannot create the composable collection for C0000158 because none of the sub collections of the same type as C0000158 in the hierarchy is migrated. This could be caused by the collection fails to migrate.     at Microsoft.ConfigurationManagement.Migration.CollectionMigrationUtilities.CreateComposableOfChildCollections(String collectionId, SqlConnection targetSqlConnection, Library targetLibrary, ConflictResolution conflictResolution, ICollectionHierarchyHandler collectionHierarchyHandler, IDictionary`2 stringResources, Int32 queryTimeout)     at Microsoft.ConfigurationManagement.Migration.CollectionMigrationUtilities.GetResolvedCollectionId(String collectionId, Boolean isApplyingToSubTargets, SqlConnection targetSqlConnection, Library targetLibrary, ConflictResolution resolution, ICollectionHierarchyHandler collectionHierarchyHandler, IDictionary`2 stringResources, Int32 queryTimeout)

            [Worker]: Set the status of the entity ABT GR ALL COM HASP User L 000 00 to Failed.

        [Worker]: Set the status of the job entity ABT GR ALL COM HASP User L 000 00 to Failed.

        ERROR: [Worker]: Entity ABT GR ALL COM HASP User L 000 00 with path SMS_Advertisement.AdvertisementID='C0020043' failed with: Microsoft.ConfigurationManagement.SoftwareLibrary.ObjectSerialization.LibraryException: Cannot create the composable collection for C0000158 because none of the sub collections of the same type as C0000158 in the hierarchy is migrated. This could be caused by the collection fails to migrate.     at Microsoft.ConfigurationManagement.Migration.CollectionMigrationUtilities.CreateComposableOfChildCollections(String collectionId, SqlConnection targetSqlConnection, Library targetLibrary, ConflictResolution conflictResolution, ICollectionHierarchyHandler collectionHierarchyHandler, IDictionary`2 stringResources, Int32 queryTimeout)     at Microsoft.ConfigurationManagement.Migration.CollectionMigrationUtilities.GetResolvedCollectionId(String collectionId, Boolean isApplyingToSubTargets, SqlConnection targetSqlConnection, Library targetLibrary, ConflictResolution resolution, ICollectionHierarchyHandler collectionHierarchyHandler, IDictionary`2 stringResources, Int32 queryTimeout)     at Microsoft.ConfigurationManagement.Migration.AdvertisementMigrationHandler.OnBeforePutInstance(Object item, Dictionary`2 options)     at Microsoft.ConfigurationManagement.Migration.MigrateObjects.<>c__DisplayClass26.<OnObjectImporting>b__25(ObjectMigrationHandler handler)     at System.Collections.Generic.List`1.ForEach(Action`1 action)     at Microsoft.ConfigurationManagement.Migration.MigrateObjects.OnObjectImporting(Object sender, ObjectImportingEventArgs e)     at Microsoft.ConfigurationManagement.SoftwareLibrary.ObjectSerialization.Adapters.ObjectManagerBase.ImportObject(ILibraryObject instance, LibraryContext context, ChangeTracker session, ConflictResolution& result)

    STATMSG: ID=8613 SEV=E LEV=M SOURCE="SMS Server" COMP="SMS_MIGRATION_MANAGER" SYS=sccm.contoso.com SITE=CNX PID=3672 TID=6304 GMTDATE=Fri Apr 15 08:02:23.116 2016 ISTR0="ABT GR ALL COM HASP User L 000 00" ISTR1="SMS_Advertisement.AdvertisementID='C0020043'" ISTR2="Collections & Advertisements" ISTR3="16777225" ISTR4="sccm.contoso.com (CNX)" ISTR5="Cannot create the composable collection for C0000158 because none of the sub collections of the same type as C0000158 in the hierarchy is migrated. This could be caused by the collection fails to migrate." ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0

                                                                    WARNING: [Worker]: Ignore Error & Continue [import failed - ABT GR ALL COM HASP User L 000 00 SMS_Advertisement.AdvertisementID='C0020043' Microsoft.ConfigurationManagement.SoftwareLibrary.ObjectSerialization.LibraryException: Cannot create the composable collection for C0000158 because none of the sub collections of the same type as C0000158 in the hierarchy is migrated. This could be caused by the collection fails to migrate.     at Microsoft.ConfigurationManagement.SoftwareLibrary.ObjectSerialization.Adapters.ObjectManagerBase.ImportObject(ILibraryObject instance, LibraryContext context, ChangeTracker session, ConflictResolution& result)     at Microsoft.ConfigurationManagement.SoftwareLibrary.ObjectSerialization.Adapters.ObjectManagerBase.DoImport(WorkItem`2 item, LibraryContext context, ChangeTracker session)]

    Friday, April 15, 2016 10:46 AM

Answers

  • I will answer to myself. The problem was the sms_cm_res_coll table. Changing those queries to sms_fullcollectionmembership did the trick:

    in (Select resourceID from sms_cm_res_coll_S0200018)

    should be changed to 

     in (Select resourceID from SMS_FullCollectionMembership where CollectionID = "S0200018")

    https://social.technet.microsoft.com/Forums/en-US/9186a11a-0f34-48a6-b1ea-6fdba4eff182/cannot-migrate-collections-that-use-smscmrescollcollectionid?forum=configmanagermigration

    • Marked as answer by Antuanfff Tuesday, April 19, 2016 10:57 AM
    Tuesday, April 19, 2016 10:57 AM

All replies

  • Dear Sir,

        The cause is clear by reading your log, due to the failure of sub collections' migration. So you will have to tick the subcollections. For more information, you could refer to this blog:

        http://blog.coretech.dk/kea/migrating-collections-from-configuration-manager-2007-to-configuration-manager-2012-beta-2/

    Best regards,

    Jimmy


    Please remember to mark the replies as answers if they help and unmark them if they provide no help. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    Monday, April 18, 2016 10:15 AM
  • I will answer to myself. The problem was the sms_cm_res_coll table. Changing those queries to sms_fullcollectionmembership did the trick:

    in (Select resourceID from sms_cm_res_coll_S0200018)

    should be changed to 

     in (Select resourceID from SMS_FullCollectionMembership where CollectionID = "S0200018")

    https://social.technet.microsoft.com/Forums/en-US/9186a11a-0f34-48a6-b1ea-6fdba4eff182/cannot-migrate-collections-that-use-smscmrescollcollectionid?forum=configmanagermigration

    • Marked as answer by Antuanfff Tuesday, April 19, 2016 10:57 AM
    Tuesday, April 19, 2016 10:57 AM
  • Hi,

        Thanks for the sharing, it will be useful to the others which have the same issue.

    Best regards,

    Jimmy


    Please remember to mark the replies as answers if they help and unmark them if they provide no help. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    Wednesday, April 20, 2016 1:47 AM
  • Thank you for sharing. This fixed it for me!

    Tuesday, June 7, 2016 7:39 AM