Monday, January 23, 2023

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" - Microsoft Support [MS]


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:

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

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

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.

No comments:

Post a Comment

Search This Blog

Scale and align images - Google Web Designer Help [gg-webdesigner-en]

Scale and align images Scaling The Scaling property for images lets you set how the image should scale when your original image file h...