Skip to main content

Notifications

Microsoft Dynamics CRM (Archived)

Upgrade failure from CRM 2011 to CRM 2016

Posted on by Microsoft Employee

Hello there,

I have successfully upgraded from CRM 2011 to CRM 2013. Later I installed CRM 2015 and imported it with Deployment Manager without any errors.

But when I upgrade to 2016, I get the following error.

21:35:55|Verbose| DatabaseAction execution time; Bin\Microsoft.Crm.Setup.DiffBuilder.dll:CreateDefaultFullTextCatalog; 00:00:00
21:35:55| Info| Adds Missing AttributeLookupValue for Custom Activities' sendermailboxid attribute.
21:35:55|Verbose| Adding missing attribute lookup value for the sendermailboxid attribute
21:35:55|Verbose| Error occurred: System.IndexOutOfRangeException: attributeid
at System.Data.SqlClient.SqlDataReader.GetOrdinal(String name)
at System.Data.SqlClient.SqlDataReader.get_Item(String name)
at Microsoft.Crm.SE.DllMethodActions.AddMissingSenderMailboxIdAttributeLookupValue.Execute()
21:35:55| Info| CrmAction execution time; UpgradeDatabaseAction; 00:00:05.3126870
21:35:55| Error| Installer Complete: OrganizationUpgrader - Error encountered
21:35:55| Error| Exception occured during Microsoft.Crm.Tools.Admin.OrganizationUpgrader: Error.ActionFailed Microsoft.Crm.Tools.Admin.UpgradeDatabaseAction
InnerException:
System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.IndexOutOfRangeException: attributeid
at System.Data.SqlClient.SqlDataReader.GetOrdinal(String name)
at System.Data.SqlClient.SqlDataReader.get_Item(String name)
at Microsoft.Crm.SE.DllMethodActions.AddMissingSenderMailboxIdAttributeLookupValue.Execute()
--- End of inner exception stack trace ---
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 System.RuntimeType.InvokeMember(String name, BindingFlags bindingFlags, Binder binder, Object target, Object[] providedArgs, ParameterModifier[] modifiers, CultureInfo culture, String[] namedParams)
at Microsoft.Crm.Setup.Database.DllMethodAction.Execute(Guid organizationId, Nullable`1 operationType)
at Microsoft.Crm.Setup.Database.DllMethodAction.Execute(Guid organizationId)
at Microsoft.Crm.Setup.Database.DatabaseInstaller.ExecuteReleases(ReleaseInfo releaseInfo, Boolean isInstall)
at Microsoft.Crm.Setup.Database.DatabaseInstaller.Install(Int32 languageCode, String configurationFilePath, Boolean upgradeDatabase, Boolean isInstall)
at Microsoft.Crm.Setup.Database.DatabaseInstaller.Install(Int32 languageCode, String configurationFilePath, Boolean upgradeDatabase)
at Microsoft.Crm.Tools.Admin.InstallDatabaseAction.Do(IDictionary parameters)
at Microsoft.Crm.Setup.Shared.CrmAction.ExecuteAction(CrmAction action, IDictionary parameters, Boolean undo)
InnerException:
System.IndexOutOfRangeException: attributeid
at System.Data.SqlClient.SqlDataReader.GetOrdinal(String name)
at System.Data.SqlClient.SqlDataReader.get_Item(String name)
at Microsoft.Crm.SE.DllMethodActions.AddMissingSenderMailboxIdAttributeLookupValue.Execute()

*This post is locked for comments

  • Suggested answer
    okank Profile Picture
    okank 70 on at
    RE: Upgrade failure from CRM 2011 to CRM 2016

    We ended up working around the issue by searching for all the custom activity entities that use sendermailboxid lookup field. Luckily we had only one of them and it was just a test entity and we were able to delete it. After the deletion and restoring the database and restarting the import wizard it resolved.

  • okank Profile Picture
    okank 70 on at
    RE: Upgrade failure from CRM 2011 to CRM 2016

    System.IndexOutOfRangeException: attributeid
    at System.Data.SqlClient.SqlDataReader.GetOrdinal(String name)
    at System.Data.SqlClient.SqlDataReader.get_Item(String name)
    at Microsoft.Crm.SE.DllMethodActions.AddMissingSenderMailboxIdAttributeLookupValue.Execute()

    Same issue. Any info on solution?
    If we need to execute an update on table field properties, which table is it?

     

  • Allie_B Profile Picture
    Allie_B 69 User Group Leader on at
    RE: Upgrade failure from CRM 2011 to CRM 2016

    I've run into a similar issue; I have been unable to import one of my custom Solutions CRM 2016; it fails on the field sendermailboxid in a custom activity entity.

    Import error message: "Invalid name for field 'sendermailboxid'. Custom field names must start with a valid customization prefix. The prefix for a solution component should match the prefix that is specified for the publisher of the solution."

    This is what I've found:

    Customized activities were introduced in CRM 2011.

    The Mailbox entity was introduced in CRM2013.

    The sendermailboxid field was added in the 2013 upgrade.

    Has anyone been able to import a Solution into CRM 2016 with a custom activity entity that is email-enabled?

  • OzgurPakcay Profile Picture
    OzgurPakcay on at
    RE: Upgrade failure from CRM 2011 to CRM 2016

    Hi,

    Is there any news for this case?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Upgrade failure from CRM 2011 to CRM 2016

    Hi Serkan,

    Is there any news about it? How did you solve it?

    Best Regards

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans