SSRS report, incorrect number format is used if BC proxy is not a Microsoft Dynamics AX user

This article applies to Microsoft Dynamics AX for all regions.

Symptoms

The number format on many SSRS reports is incorrect. This problem happens if BC proxy user is not AX user.
Since the most of reports are legal or formal reports, incorrect number format is not acceptable for all customers.

Cause

The API BuildInMethods.GetExtendedDataTypeFormat(), fails to provide the ax session with the correct information, so the service call can set the proper call context. as a consequence the AOS refuse to allow the service call.

Resolution

Change the internals of the API using a known pattern to set the session as it should.
This allows for the correct context header to be applied to the AX WFC service call.

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, visit the following Microsoft website:

https:⁠//mbs.microsoft.com/support/newstart.aspx You can also contact technical support for Microsoft Dynamics by phone using these links for country specific phone numbers. To do this, visit 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, you must 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 view 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 the hotfix.

File information

The global version of 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 15:07 x86
Axupdate.exe Not Applicable 61,120 20-Nov-2012 15:07 x86
Licensetermsar.rtf Not Applicable 2,173 20-Nov-2012 15:07 Not Applicable
Licensetermscs.rtf Not Applicable 91,247 20-Nov-2012 15:07 Not Applicable
Licensetermsda.rtf Not Applicable 101,181 20-Nov-2012 15:07 Not Applicable
Licensetermsde.rtf Not Applicable 116,642 20-Nov-2012 15:07 Not Applicable
Licensetermsen.rtf Not Applicable 102,374 20-Nov-2012 15:07 Not Applicable
Licensetermses.rtf Not Applicable 96,985 20-Nov-2012 15:07 Not Applicable
Licensetermset.rtf Not Applicable 102,895 20-Nov-2012 15:07 Not Applicable
Licensetermsfi.rtf Not Applicable 106,101 20-Nov-2012 15:07 Not Applicable
Licensetermsfr.rtf Not Applicable 130,011 20-Nov-2012 15:07 Not Applicable
Licensetermshu.rtf Not Applicable 93,010 20-Nov-2012 15:07 Not Applicable
Licensetermsis.rtf Not Applicable 36,458 20-Nov-2012 15:07 Not Applicable
Licensetermsit.rtf Not Applicable 115,086 20-Nov-2012 15:07 Not Applicable
Licensetermsja.rtf Not Applicable 105,917 20-Nov-2012 15:07 Not Applicable
Licensetermslt.rtf Not Applicable 122,674 20-Nov-2012 15:07 Not Applicable
Licensetermslv.rtf Not Applicable 105,401 20-Nov-2012 15:07 Not Applicable
Licensetermsnb-no.rtf Not Applicable 115,700 20-Nov-2012 15:07 Not Applicable
Licensetermsnl.rtf Not Applicable 110,040 20-Nov-2012 15:07 Not Applicable
Licensetermspl.rtf Not Applicable 116,322 20-Nov-2012 15:07 Not Applicable
Licensetermspt-br.rtf Not Applicable 101,514 20-Nov-2012 15:07 Not Applicable
Licensetermsru.rtf Not Applicable 148,577 20-Nov-2012 15:07 Not Applicable
Licensetermssv.rtf Not Applicable 115,453 20-Nov-2012 15:07 Not Applicable
Licensetermsth.rtf Not Applicable 153,768 20-Nov-2012 15:07 Not Applicable
Licensetermszh-hans.rtf Not Applicable 99,245 20-Nov-2012 15:07 Not Applicable
Clientoba32.msp Not Applicable 25,927,680 27-Jun-2013 14:40 Not Applicable
Clientoba64.msp Not Applicable 26,095,616 27-Jun-2013 14:40 Not Applicable
Commercedataexchangereal-timeservice.msp Not Applicable 49,152 27-Jun-2013 14:40 Not Applicable
Commercedataexchangesynchservice32.msp Not Applicable 126,976 27-Jun-2013 14:40 Not Applicable
Commercedataexchangesynchservice64.msp Not Applicable 126,976 27-Jun-2013 14:40 Not Applicable
Components32.msp Not Applicable 18,817,024 27-Jun-2013 14:40 Not Applicable
Components64.msp Not Applicable 36,311,040 27-Jun-2013 14:41 Not Applicable
Objectserver32.msp Not Applicable 9,912,320 27-Jun-2013 14:40 Not Applicable
Objectserver64.msp Not Applicable 17,821,696 27-Jun-2013 14:40 Not Applicable
Retaildatabaseutility.msp Not Applicable 622,592 27-Jun-2013 14:40 Not Applicable
Retailheadquarters32.msp Not Applicable 3,014,656 27-Jun-2013 14:40 Not Applicable
Retailheadquarters64.msp Not Applicable 3,014,656 27-Jun-2013 14:41 Not Applicable
Retailonlinechannel.msp Not Applicable 2,760,704 27-Jun-2013 14:41 Not Applicable
Retailpos.msp Not Applicable 4,550,656 27-Jun-2013 14:41 Not Applicable
Retailposplugins.msp Not Applicable 48,074,752 27-Jun-2013 14:41 Not Applicable
Setupsupport32.msp Not Applicable 7,364,608 27-Jun-2013 14:40 Not Applicable
Setupsupport64.msp Not Applicable 14,626,816 27-Jun-2013 14:40 Not Applicable
Axsetupsp.exe 6.2.1000.1154 1,391,280 01-Jun-2013 02:10 x86
Axutillib.dll 6.2.120.0 929,968 27-Jun-2013 14:56 x86
Microsoft.dynamics.servicing.operations.dll 6.2.73.8303 37,168 31-Oct-2012 05:20 x86
Axsetupsp.resources.dll 6.2.147.8303 387,776 27-Jun-2013 14:56 x86
Axsetupsp.resources.dll 6.2.147.8303 375,488 27-Jun-2013 14:56 x86
Axsetupsp.resources.dll 6.2.147.8303 375,488 27-Jun-2013 14:56 x86
Axsetupsp.resources.dll 6.2.147.8303 379,584 27-Jun-2013 14:56 x86
Axsetupsp.resources.dll 6.2.147.8303 379,584 27-Jun-2013 14:56 x86
Axsetupsp.resources.dll 6.2.147.8303 371,392 27-Jun-2013 14:56 x86
Axsetupsp.resources.dll 6.2.147.8303 375,488 27-Jun-2013 14:56 x86
Axsetupsp.resources.dll 6.2.147.8303 383,680 27-Jun-2013 14:56 x86
Axsetupsp.resources.dll 6.2.147.8303 395,968 27-Jun-2013 14:56 x86
Axsetupsp.resources.dll 6.2.147.8303 375,488 27-Jun-2013 14:56 x86
Axsetupsp.resources.dll 6.2.147.8303 379,584 27-Jun-2013 14:56 x86
Axsetupsp.resources.dll 6.2.147.8303 387,776 27-Jun-2013 14:56 x86
Axsetupsp.resources.dll 6.2.147.8303 375,488 27-Jun-2013 14:56 x86
Axsetupsp.resources.dll 6.2.147.8303 375,488 27-Jun-2013 14:56 x86
Axsetupsp.resources.dll 6.2.147.8303 375,488 27-Jun-2013 14:56 x86
Axsetupsp.resources.dll 6.2.147.8303 379,584 27-Jun-2013 14:56 x86
Axsetupsp.resources.dll 6.2.147.8303 379,584 27-Jun-2013 14:56 x86
Axsetupsp.resources.dll 6.2.147.8303 379,584 27-Jun-2013 14:56 x86
Axsetupsp.resources.dll 6.2.147.8303 395,968 27-Jun-2013 14:56 x86
Axsetupsp.resources.dll 6.2.147.8303 375,488 27-Jun-2013 14:56 x86
Axsetupsp.resources.dll 6.2.147.8303 416,448 27-Jun-2013 14:56 x86
Axsetupsp.resources.dll 6.2.147.8303 371,392 27-Jun-2013 14:56 x86

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained here in 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.