MIM 2016 Upgrade issues on builds 4.1.3646.0 / 4.1.3634.0 / 4.1.3627.0 / 4.1.3733 / 4.1.3766

While exploring to upgrade from FIM 2010 SP1 to MIM you may encounter the following error when upgrading from latest FIM 2010 R2 SP1 hotfixes (4.1.3646.0 / 4.1.3634.0 / 4.1.3627.0 / 4.1.3733 / 4.1.3766) to Microsoft Identity Manager. We are aware of this issue and have a solution

clip_image001

We have a workaround for this issue. We simply replace the file <iso_drive>\Service and Portal\Program Files\Microsoft Forefront Identity Manager\2010\Service\Microsoft.IdentityManagement.DatabaseUpgrade.exe.config with the one below before installing .

In the Microsoft.Identitymanagement.DatabaseUpgrade_tracelog you would see the following error below if you attempted this upgrade without replacing the configuration file.

Microsoft.ResourceManagement Verbose: 0 : Execute SQL : The transaction failed with the following errors System.Data.SqlClient.SqlException: Column, parameter, or variable #1: Cannot find data type fim.ObjectKeyListInternal.
Must declare the table variable "@objectKeyList".
Parameter or variable '@objectKeyList' has an invalid data type.

Thank you

Identity and Security Team / AKA Support

Updated  9/12/2016

Note: please rename to Microsoft.IdentityManagement.DatabaseUpgrade.exe.config