MIM 2016 Upgrade issues on builds 4.1.3646.0 or 4.1.3634.0 or 4.1.3627.0

While exploring to upgrade from FIM to MIM you may encounter the following error when upgrading from latest FIM 2010 R2 SP1 hotfixes (4.1.3646.0 or 4.1.3634.0 or 4.1.3627.0) 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