Data is not updated and you receive an error message when you update a workbook that uses the BudgetPlanOfficeAddinService service in Microsoft Dynamics AX 2012 R2: "Failed to load query AxdBudgetPlanofficeAddin"


This article applies to Microsoft Dynamics AX 2012 R2 for all regions.

Symptoms

Consider the following scenario:
  • You start an instance of Microsoft Excel in which the Excel add-in is installed.
  • You configure the BudgetPlanOfficeAddinService service in Microsoft Dynamics AX 2012 R2 as a document data source for an Excel workbook.
  • You bind the DocumentNumber and BudgetPlan fields by using the field chooser.
  • You close the field chooser, save the workbook and then exit Excel.
  • You start Excel and then open the workbook.

In this scenario, when you try to update the data in the workbook, the data is not updated. Additionally, you receive the following error message:

Failed to load query AxdBudgetPlanofficeAddin the metadata does not contain the expected data source OMInternalOrganization_1_DirPartyTable field Name.

Resolution

Hotfix information

A supported hotfix is available from Microsoft. There is a "Hotfix download available" section at the top of this Knowledge Base article. If you are encountering an issue downloading, installing this hotfix, or have other technical support questions, contact your partner or, if enrolled in a support plan directly with Microsoft, you can contact technical support for Microsoft Dynamics and create a new support request. To do this, go to the following Microsoft website:You can also contact technical support for Microsoft Dynamics by telephone by using these links for country specific telephone numbers. To do this, go to one of the following Microsoft websites:

PartnersCustomersIn special cases, charges that are ordinarily incurred for support calls may be canceled if a Technical Support Professional for Microsoft Dynamics and related products determines that a specific update will resolve your problem. The usual support costs will apply to any additional support questions and issues that do not qualify for the specific update in question.

Installation information

If you have customizations for one or more of the methods or the tables that are affected by this hotfix, apply these changes in a test environment before you apply the hotfix in a production environment.

For more information about how to install this hotfix, click the following article number to go to the article in the Microsoft Knowledge Base:

893082 How to install a Microsoft Dynamics AX hotfix

Prerequisites

You must have Microsoft Dynamics AX 2012 R2 installed to apply this hotfix.

Restart requirement

You must restart the Application Object Server (AOS) service after you apply this hotfix.
File information
Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.
Properties

Article ID: 2809792 - Last Review: 2017 ots. 17 - Revision: 2

Microsoft Dynamics AX 2012 R2

Oharrak