SOLVED Migration - Fail to gather data from Source Hierarchy

[m0lochwalker]

Hello,

I am trying to Migrate data between 2 x SCCM Sites. The process fails during the Gather Data phase. Here is the initial error from migmctrl.log...

ERROR: [Worker]: System.InvalidOperationException: Column 'ReferencedEntityKey' does not allow DBNull.Value.

I have attached the entire migmctrl.log as well. The process seems to gather some data and then stop error at this same point each time.

This is apparently an issue with a null value in SQL, but I have been unable to track down the cause of the issue.

Please view the attached log in CMTrace and offer any advice. It is much appreciated.

Thank you

 

[Garth]

Since this is a SQL server issues you should contact Microsoft Support directly.

 

[Prajwal Desai]

I agree with @Garth, it's better to contact MS support rather than making changes to DB.