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:

Note

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:

https:⁠//mbs.microsoft.com/support/newstart.aspx 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:

Partners

https:⁠//mbs.microsoft.com/partnersource/support Customers

https:⁠//mbs.microsoft.com/customersource/support/information/SupportInformation/global_support_contacts_eng.htm In 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

This hotfix has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in Coordinated Universal Time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time item in Control Panel.

File name File version File size Date Time Platform
Aximpactanalysis.exe Not Applicable 61,136 20-Nov-2012 14:35 x86
Axupdate.exe Not Applicable 61,120 20-Nov-2012 14:35 x86
Licensetermsar.rtf Not Applicable 2,173 20-Nov-2012 14:35 Not Applicable
Licensetermscs.rtf Not Applicable 91,247 20-Nov-2012 14:35 Not Applicable
Licensetermsda.rtf Not Applicable 101,181 20-Nov-2012 14:35 Not Applicable
Licensetermsde.rtf Not Applicable 116,642 20-Nov-2012 14:35 Not Applicable
Licensetermsen.rtf Not Applicable 102,374 20-Nov-2012 14:35 Not Applicable
Licensetermses.rtf Not Applicable 96,985 20-Nov-2012 14:35 Not Applicable
Licensetermset.rtf Not Applicable 102,895 20-Nov-2012 14:35 Not Applicable
Licensetermsfi.rtf Not Applicable 106,101 20-Nov-2012 14:35 Not Applicable
Licensetermsfr.rtf Not Applicable 130,011 20-Nov-2012 14:35 Not Applicable
Licensetermshu.rtf Not Applicable 93,010 20-Nov-2012 14:35 Not Applicable
Licensetermsis.rtf Not Applicable 36,458 20-Nov-2012 14:35 Not Applicable
Licensetermsit.rtf Not Applicable 115,086 20-Nov-2012 14:35 Not Applicable
Licensetermsja.rtf Not Applicable 105,917 20-Nov-2012 14:35 Not Applicable
Licensetermslt.rtf Not Applicable 122,674 20-Nov-2012 14:35 Not Applicable
Licensetermslv.rtf Not Applicable 105,401 20-Nov-2012 14:35 Not Applicable
Licensetermsnb-no.rtf Not Applicable 115,700 20-Nov-2012 14:35 Not Applicable
Licensetermsnl.rtf Not Applicable 110,040 20-Nov-2012 14:35 Not Applicable
Licensetermspl.rtf Not Applicable 116,322 20-Nov-2012 14:35 Not Applicable
Licensetermspt-br.rtf Not Applicable 101,514 20-Nov-2012 14:35 Not Applicable
Licensetermsru.rtf Not Applicable 148,577 20-Nov-2012 14:35 Not Applicable
Licensetermssv.rtf Not Applicable 115,453 20-Nov-2012 14:35 Not Applicable
Licensetermsth.rtf Not Applicable 153,768 20-Nov-2012 14:35 Not Applicable
Licensetermszh-hans.rtf Not Applicable 99,245 20-Nov-2012 14:35 Not Applicable
Clientoba32.msp Not Applicable 16,863,232 29-Jan-2013 23:33 Not Applicable
Clientoba64.msp Not Applicable 16,875,520 29-Jan-2013 23:33 Not Applicable
Commercedataexchangereal-timeservice.msp Not Applicable 49,152 29-Jan-2013 23:33 Not Applicable
Commercedataexchangesynchservice32.msp Not Applicable 122,880 29-Jan-2013 23:33 Not Applicable
Commercedataexchangesynchservice64.msp Not Applicable 122,880 29-Jan-2013 23:33 Not Applicable
Components32.msp Not Applicable 352,256 29-Jan-2013 23:33 Not Applicable
Components64.msp Not Applicable 352,256 29-Jan-2013 23:33 Not Applicable
Objectserver32.msp Not Applicable 446,464 29-Jan-2013 23:33 Not Applicable
Objectserver64.msp Not Applicable 6,336,512 29-Jan-2013 23:33 Not Applicable
Retaildatabaseutility.msp Not Applicable 516,096 29-Jan-2013 23:33 Not Applicable
Retailheadquarters32.msp Not Applicable 2,748,416 29-Jan-2013 23:33 Not Applicable
Retailheadquarters64.msp Not Applicable 2,748,416 29-Jan-2013 23:33 Not Applicable
Retailonlinechannel.msp Not Applicable 2,732,032 29-Jan-2013 23:33 Not Applicable
Retailpos.msp Not Applicable 3,747,840 29-Jan-2013 23:34 Not Applicable
Retailposplugins.msp Not Applicable 47,878,144 29-Jan-2013 23:34 Not Applicable
Axsetupsp.exe 6.2.139.8316 1,390,784 20-Nov-2012 14:35 x86
Axutillib.dll 6.2.120.0 929,472 29-Jan-2013 23:42 x86
Microsoft.dynamics.servicing.operations.dll 6.2.73.8303 37,168 02-Nov-2012 11:31 x86
Axsetupsp.resources.dll 6.2.147.8303 387,288 29-Jan-2013 23:42 x86
Axsetupsp.resources.dll 6.2.147.8303 375,000 29-Jan-2013 23:42 x86
Axsetupsp.resources.dll 6.2.147.8303 375,000 29-Jan-2013 23:42 x86
Axsetupsp.resources.dll 6.2.147.8303 379,096 29-Jan-2013 23:42 x86
Axsetupsp.resources.dll 6.2.147.8303 379,096 29-Jan-2013 23:42 x86
Axsetupsp.resources.dll 6.2.147.8303 370,904 29-Jan-2013 23:41 x86
Axsetupsp.resources.dll 6.2.147.8303 375,000 29-Jan-2013 23:42 x86
Axsetupsp.resources.dll 6.2.147.8303 383,192 29-Jan-2013 23:42 x86
Axsetupsp.resources.dll 6.2.147.8303 395,480 29-Jan-2013 23:42 x86
Axsetupsp.resources.dll 6.2.147.8303 375,000 29-Jan-2013 23:42 x86
Axsetupsp.resources.dll 6.2.147.8303 379,096 29-Jan-2013 23:41 x86
Axsetupsp.resources.dll 6.2.147.8303 387,288 29-Jan-2013 23:41 x86
Axsetupsp.resources.dll 6.2.147.8303 375,000 29-Jan-2013 23:42 x86
Axsetupsp.resources.dll 6.2.147.8303 375,000 29-Jan-2013 23:42 x86
Axsetupsp.resources.dll 6.2.147.8303 375,000 29-Jan-2013 23:42 x86
Axsetupsp.resources.dll 6.2.147.8303 379,096 29-Jan-2013 23:42 x86
Axsetupsp.resources.dll 6.2.147.8303 379,096 29-Jan-2013 23:42 x86
Axsetupsp.resources.dll 6.2.147.8303 379,096 29-Jan-2013 23:42 x86
Axsetupsp.resources.dll 6.2.147.8303 395,480 29-Jan-2013 23:42 x86
Axsetupsp.resources.dll 6.2.147.8303 375,000 29-Jan-2013 23:42 x86
Axsetupsp.resources.dll 6.2.147.8303 415,960 29-Jan-2013 23:42 x86
Axsetupsp.resources.dll 6.2.147.8303 370,904 29-Jan-2013 23:42 x86

      

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.