none
MIM 2016 Upgrade issues on builds 4.1.3646.0 or 4.1.3634.0 or 4.1.3627.0 RRS feed

  • Question

  • Ok, I am suffering exactly a same problem descripted in this article:

    http://blogs.technet.com/b/identitymanagement/archive/2015/08/07/mim-2016-upgrade-issues-on-builds-4-1-3646-0-or-4-1-3634-0-or-4-1-3627-0.aspx

    The workaround is replace Microsoft.IdentityManagement.DatabaseUpgrade.exe.config file with another one.

    The problem is that I am still getting the same error and facing the problem. So is that file which can be downloaded from the link above broken allready or am I missing something?

    Am I the only one who is suffering with this?

    Wednesday, September 23, 2015 12:24 PM

Answers

  • We have a solution. We need manually add these to the Microsoft.IdentityManagement.DatabaseUpgrade.exe.config file:

          <Version Id="1125to1126" SourceVersion="1125" TargetVersion="1126">
            <SqlScripts>
              <SqlScript Id="PreProcess1125" File="NoOperation.sql" EmbeddedAsResource="true" ContinueOnError="false" Type="PreProcess" />
              <SqlScript Id="Upgrade1125" File="NoOperation.sql" EmbeddedAsResource="true" ContinueOnError="false" Type="SchemaUpgrade" />
              <SqlScript Id="PostProcess1125" File="NoOperation.sql" EmbeddedAsResource="true" ContinueOnError="false" Type="PostProcess" />
            </SqlScripts>
          </Version>
    
          <Version Id="1126to1127" SourceVersion="1126" TargetVersion="1127">
            <SqlScripts>
              <SqlScript Id="PreProcess1126" File="NoOperation.sql" EmbeddedAsResource="true" ContinueOnError="false" Type="PreProcess" />
              <SqlScript Id="Upgrade1126" File="NoOperation.sql" EmbeddedAsResource="true" ContinueOnError="false" Type="SchemaUpgrade" />
              <SqlScript Id="PostProcess1126" File="NoOperation.sql" EmbeddedAsResource="true" ContinueOnError="false" Type="PostProcess" />
            </SqlScripts>
          </Version>
    
          <Version Id="1127to1128" SourceVersion="1127" TargetVersion="1128">
            <SqlScripts>
              <SqlScript Id="PreProcess1127" File="NoOperation.sql" EmbeddedAsResource="true" ContinueOnError="false" Type="PreProcess" />
              <SqlScript Id="Upgrade1127" File="NoOperation.sql" EmbeddedAsResource="true" ContinueOnError="false" Type="SchemaUpgrade" />
              <SqlScript Id="PostProcess1127" File="NoOperation.sql" EmbeddedAsResource="true" ContinueOnError="false" Type="PostProcess" />
            </SqlScripts>
          </Version>

    So basically our database version was later than configured into the Microsoft.IdentityManagement.DatabaseUpgrade.exe.config file.

    I think this is a little bit a frustrating if we need to do things like that. This should be done by Microsoft!

    • Marked as answer by 2xTsei Wednesday, May 18, 2016 12:39 PM
    Wednesday, May 18, 2016 12:39 PM

All replies

  • So am I still the only one who is suffering with this?
    Tuesday, January 26, 2016 8:46 AM
  • We have a solution. We need manually add these to the Microsoft.IdentityManagement.DatabaseUpgrade.exe.config file:

          <Version Id="1125to1126" SourceVersion="1125" TargetVersion="1126">
            <SqlScripts>
              <SqlScript Id="PreProcess1125" File="NoOperation.sql" EmbeddedAsResource="true" ContinueOnError="false" Type="PreProcess" />
              <SqlScript Id="Upgrade1125" File="NoOperation.sql" EmbeddedAsResource="true" ContinueOnError="false" Type="SchemaUpgrade" />
              <SqlScript Id="PostProcess1125" File="NoOperation.sql" EmbeddedAsResource="true" ContinueOnError="false" Type="PostProcess" />
            </SqlScripts>
          </Version>
    
          <Version Id="1126to1127" SourceVersion="1126" TargetVersion="1127">
            <SqlScripts>
              <SqlScript Id="PreProcess1126" File="NoOperation.sql" EmbeddedAsResource="true" ContinueOnError="false" Type="PreProcess" />
              <SqlScript Id="Upgrade1126" File="NoOperation.sql" EmbeddedAsResource="true" ContinueOnError="false" Type="SchemaUpgrade" />
              <SqlScript Id="PostProcess1126" File="NoOperation.sql" EmbeddedAsResource="true" ContinueOnError="false" Type="PostProcess" />
            </SqlScripts>
          </Version>
    
          <Version Id="1127to1128" SourceVersion="1127" TargetVersion="1128">
            <SqlScripts>
              <SqlScript Id="PreProcess1127" File="NoOperation.sql" EmbeddedAsResource="true" ContinueOnError="false" Type="PreProcess" />
              <SqlScript Id="Upgrade1127" File="NoOperation.sql" EmbeddedAsResource="true" ContinueOnError="false" Type="SchemaUpgrade" />
              <SqlScript Id="PostProcess1127" File="NoOperation.sql" EmbeddedAsResource="true" ContinueOnError="false" Type="PostProcess" />
            </SqlScripts>
          </Version>

    So basically our database version was later than configured into the Microsoft.IdentityManagement.DatabaseUpgrade.exe.config file.

    I think this is a little bit a frustrating if we need to do things like that. This should be done by Microsoft!

    • Marked as answer by 2xTsei Wednesday, May 18, 2016 12:39 PM
    Wednesday, May 18, 2016 12:39 PM
  • Johnny-come-lately here. I had to fix this same problem while upgrading from FIM 2010 R2 (4.1.3766.0) to MIM 2016 RTM (4.3.0.0/4.3.1935.0), but I couldn't find a download for the config file that was mentioned in a few articles. I merged the files from SP1 and RTM and posted a download link on my blog (shameless plug). Hopefully this helps someone else.

    http://blog.idmware.com/2018/12/database-upgrade-failure-fim-2010-r2.html

    Relevant parts:


    Hack DatabaseUpgrade.config file

    References:

     

    https://social.technet.microsoft.com/Forums/en-US/9d0b3537-7bf6-415d-8263-549a6686732a/mim-2016-upgrade-issues-on-builds-4136460-or-4136340-or-4136270

     

    https://blogs.msdn.microsoft.com/connector_space/2015/08/05/performing-an-in-place-upgrade-of-fim-2010-r2-to-microsoft-identity-manager-2016-service-and-portal/

     

    https://blogs.technet.microsoft.com/iamsupport/2015/08/07/mim-2016-upgrade-issues-on-builds-4-1-3646-0-or-4-1-3634-0-or-4-1-3627-0/

     

     

    Merge config file from SP1 to RTM

    D:\Install\Service and Portal\Program Files\Microsoft Forefront Identity Manager\2010\Service\Microsoft.IdentityManagement.DatabaseUpgrade.exe.config

     

    Replace this

    <!-- 2001 == vNext -->

    <Version Id="1122to2001" SourceVersion="1122" TargetVersion="2001">

      <SqlScripts>

        <SqlScript Id="PreProcess1122" File="NoOperation.sql" EmbeddedAsResource="true" ContinueOnError="false" Type="PreProcess" />

        <SqlScript Id="Upgrade1122" File="NoOperation.sql" EmbeddedAsResource="true" ContinueOnError="false" Type="SchemaUpgrade" />

        <SqlScript Id="PostProcess1122" File="NoOperation.sql" EmbeddedAsResource="true" ContinueOnError="false" Type="PostProcess" />

      </SqlScripts>

    </Version>

     

    With this

    <Version Id="1122to1123" SourceVersion="1122" TargetVersion="1123">

      <SqlScripts>

        <SqlScript Id="PreProcess1122" File="NoOperation.sql" EmbeddedAsResource="true" ContinueOnError="false" Type="PreProcess" />

        <SqlScript Id="Upgrade1122" File="NoOperation.sql" EmbeddedAsResource="true" ContinueOnError="false" Type="SchemaUpgrade" />

        <SqlScript Id="PostProcess1122" File="NoOperation.sql" EmbeddedAsResource="true" ContinueOnError="false" Type="PostProcess" />

      </SqlScripts>

    </Version>

    <!-- Next 100 update blocks are reserved for future LDR1 patches-->

    <Version Id="1123to1124" SourceVersion="1123" TargetVersion="1124">

      <SqlScripts>

        <SqlScript Id="PreProcess1123" File="NoOperation.sql" EmbeddedAsResource="true" ContinueOnError="false" Type="PreProcess" />

        <SqlScript Id="Upgrade1123" File="NoOperation.sql" EmbeddedAsResource="true" ContinueOnError="false" Type="SchemaUpgrade" />

        <SqlScript Id="PostProcess1123" File="NoOperation.sql" EmbeddedAsResource="true" ContinueOnError="false" Type="PostProcess" />

      </SqlScripts>

    </Version>

    <Version Id="1124to1125" SourceVersion="1124" TargetVersion="1125">

      <SqlScripts>

        <SqlScript Id="PreProcess1124" File="NoOperation.sql" EmbeddedAsResource="true" ContinueOnError="false" Type="PreProcess" />

        <SqlScript Id="Upgrade1124" File="NoOperation.sql" EmbeddedAsResource="true" ContinueOnError="false" Type="SchemaUpgrade" />

        <SqlScript Id="PostProcess1124" File="NoOperation.sql" EmbeddedAsResource="true" ContinueOnError="false" Type="PostProcess" />

      </SqlScripts>

    </Version>

    <Version Id="1125to1126" SourceVersion="1125" TargetVersion="1126">

      <SqlScripts>

        <SqlScript Id="PreProcess1125" File="NoOperation.sql" EmbeddedAsResource="true" ContinueOnError="false" Type="PreProcess" />

        <SqlScript Id="Upgrade1125" File="NoOperation.sql" EmbeddedAsResource="true" ContinueOnError="false" Type="SchemaUpgrade" />

        <SqlScript Id="PostProcess1125" File="NoOperation.sql" EmbeddedAsResource="true" ContinueOnError="false" Type="PostProcess" />

      </SqlScripts>

    </Version>

    <Version Id="1126to1127" SourceVersion="1126" TargetVersion="1127">

      <SqlScripts>

        <SqlScript Id="PreProcess1126" File="NoOperation.sql" EmbeddedAsResource="true" ContinueOnError="false" Type="PreProcess" />

        <SqlScript Id="Upgrade1126" File="NoOperation.sql" EmbeddedAsResource="true" ContinueOnError="false" Type="SchemaUpgrade" />

        <SqlScript Id="PostProcess1126" File="NoOperation.sql" EmbeddedAsResource="true" ContinueOnError="false" Type="PostProcess" />

      </SqlScripts>

    </Version>

    <Version Id="1127to1128" SourceVersion="1127" TargetVersion="1128">

      <SqlScripts>

        <SqlScript Id="PreProcess1127" File="NoOperation.sql" EmbeddedAsResource="true" ContinueOnError="false" Type="PreProcess" />

        <SqlScript Id="Upgrade1127" File="NoOperation.sql" EmbeddedAsResource="true" ContinueOnError="false" Type="SchemaUpgrade" />

        <SqlScript Id="PostProcess1127" File="NoOperation.sql" EmbeddedAsResource="true" ContinueOnError="false" Type="PostProcess" />

      </SqlScripts>

    </Version>

    <!-- 2001 == vNext -->

    <Version Id="1128to2001" SourceVersion="1128" TargetVersion="2001">

      <SqlScripts>

        <SqlScript Id="PreProcess1128" File="NoOperation.sql" EmbeddedAsResource="true" ContinueOnError="false" Type="PreProcess" />

        <SqlScript Id="Upgrade1128" File="NoOperation.sql" EmbeddedAsResource="true" ContinueOnError="false" Type="SchemaUpgrade" />

        <SqlScript Id="PostProcess1128" File="NoOperation.sql" EmbeddedAsResource="true" ContinueOnError="false" Type="PostProcess" />

      </SqlScripts>

    </Version>

    Sunday, December 23, 2018 7:43 PM