KB3199177 - Master Data Management (MDM) Support for Microsoft SQL Server 2016

When you run Microsoft Dynamics AX 2012 R3 PowerShell command of "Set-AXMasterDataManagementMDSSetup –MDSServerName RDVM0005FA-TAE -MDSDatabase MDS", it can't find the MDM.tblTransaction table in the Master Data Services (MDS) database. As a result, you need to add the Master Data Management (MDM) support for Microsoft SQL Server 2016.

Resolution

The changes in the hotfix include the MDM support for Microsoft SQL Server 2016 as expected.

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/resources/support/supportinformation/Global+Support+ContactsCustomers

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, 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 one of the following products installed to apply this hotfix:

  • Microsoft Dynamics AX 2012 R3

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.

Microsoft Dynamics AX 2012 R3

File name

File version

File size

Date

Time

Platform

Aximpactanalysis.exe

Not Applicable

62,888

21-Oct-2016

16:19

x86

Axupdate.exe

Not Applicable

62,872

21-Oct-2016

16:19

x86

Dynamicsax2012r3-kb3199177-syplabels.axmodel

6.3.5000.226

18,045,680

29-Oct-2016

03:45

Not Applicable

Dynamicsax2012r3_cl4571864.axmodel

6.3.5000.226

19,672

29-Oct-2016

03:45

Not Applicable

Hotfixdependencygraph.dgml

Not Applicable

477

29-Oct-2016

03:42

Not Applicable

Hotfixinformation.xml

Not Applicable

4,467

29-Oct-2016

03:42

Not Applicable

Axsetupsp.exe

6.3.4000.3530

2,018,712

21-Oct-2016

16:19

x86

Axsetupsplib.dll

6.3.4000.3530

94,624

21-Oct-2016

16:19

x86

Axsetupui.exe

6.3.4000.3530

364,952

21-Oct-2016

16:19

x86

Axutillib.dll

6.3.4000.3513

984,984

21-Oct-2016

16:19

x86

Dixfserviceprereqhelper.exe

6.3.4000.1645

48,560

19-Aug-2016

17:26

x86

Microsoft.dynamics.servicing.dependencypackage.dll

6.3.164.3546

40,184

10-Feb-2016

07:41

x86

Microsoft.dynamics.servicing.graphlibrary.dll

6.3.4000.1814

46,552

30-Aug-2016

19:47

x86

Microsoft.dynamics.servicing.operations.dll

6.3.164.2384

44,264

10-Feb-2016

07:41

x86

Axsetupsp.resources.dll

6.3.4000.533

519,592

28-Jun-2016

20:28

x86

Axsetupsp.resources.dll

6.3.4000.533

503,208

28-Jun-2016

20:28

x86

Axsetupsp.resources.dll

6.3.4000.533

499,112

28-Jun-2016

20:28

x86

Axsetupsp.resources.dll

6.3.4000.533

503,208

28-Jun-2016

20:28

x86

Axsetupsp.resources.dll

6.3.4000.533

507,304

28-Jun-2016

20:28

x86

Axsetupsp.resources.dll

6.3.4000.533

495,016

28-Jun-2016

20:28

x86

Axsetupsp.resources.dll

6.3.4000.533

499,112

28-Jun-2016

20:28

x86

Axsetupsp.resources.dll

6.3.4000.533

511,400

28-Jun-2016

20:28

x86

Axsetupsp.resources.dll

6.3.4000.533

507,304

28-Jun-2016

20:28

x86

Axsetupsp.resources.dll

6.3.4000.533

499,112

28-Jun-2016

20:28

x86

Axsetupsp.resources.dll

6.3.4000.533

503,208

28-Jun-2016

20:28

x86

Axsetupsp.resources.dll

6.3.4000.533

523,688

28-Jun-2016

20:28

x86

Axsetupsp.resources.dll

6.3.4000.533

499,112

28-Jun-2016

20:28

x86

Axsetupsp.resources.dll

6.3.4000.533

503,208

28-Jun-2016

20:28

x86

Axsetupsp.resources.dll

6.3.4000.533

499,112

28-Jun-2016

20:28

x86

Axsetupsp.resources.dll

6.3.4000.533

499,112

28-Jun-2016

20:28

x86

Axsetupsp.resources.dll

6.3.4000.533

503,208

28-Jun-2016

20:28

x86

Axsetupsp.resources.dll

6.3.4000.533

503,208

28-Jun-2016

20:28

x86

Axsetupsp.resources.dll

6.3.4000.533

540,072

28-Jun-2016

20:28

x86

Axsetupsp.resources.dll

6.3.4000.533

499,112

28-Jun-2016

20:28

x86

Axsetupsp.resources.dll

6.3.4000.533

572,840

28-Jun-2016

20:28

x86

Axsetupsp.resources.dll

6.3.4000.533

490,920

28-Jun-2016

20:28

x86

Aximpactanalysis.exe

Not Applicable

62,888

21-Oct-2016

10:07

x86

Axupdate.exe

Not Applicable

62,872

21-Oct-2016

10:07

x86

Clientoba32.msp

Not Applicable

35,139,584

29-Oct-2016

11:58

Not Applicable

Clientoba64.msp

Not Applicable

35,336,192

29-Oct-2016

11:58

Not Applicable

Commercedataexchangeasyncclient.msp

Not Applicable

2,797,568

29-Oct-2016

11:58

Not Applicable

Commercedataexchangeasyncserver.msp

Not Applicable

770,048

29-Oct-2016

11:58

Not Applicable

Commercedataexchangereal-timeservice.msp

Not Applicable

1,155,072

29-Oct-2016

11:58

Not Applicable

Components32.msp

Not Applicable

27,459,584

29-Oct-2016

11:59

Not Applicable

Components64.msp

Not Applicable

45,453,312

29-Oct-2016

11:58

Not Applicable

Dixf_aos32.msp

Not Applicable

118,784

29-Oct-2016

11:58

Not Applicable

Dixf_aos64.msp

Not Applicable

118,784

29-Oct-2016

11:58

Not Applicable

Dixf_client32.msp

Not Applicable

229,376

29-Oct-2016

11:58

Not Applicable

Dixf_client64.msp

Not Applicable

233,472

29-Oct-2016

11:58

Not Applicable

Dixf_service32.msp

Not Applicable

684,032

29-Oct-2016

11:58

Not Applicable

Dixf_service64.msp

Not Applicable

684,032

29-Oct-2016

11:58

Not Applicable

Helpserver64.msp

Not Applicable

884,736

29-Oct-2016

11:58

Not Applicable

Objectserver32.msp

Not Applicable

16,257,024

29-Oct-2016

11:58

Not Applicable

Objectserver64.msp

Not Applicable

18,313,216

29-Oct-2016

11:59

Not Applicable

Retailchanneldatabase.msp

Not Applicable

1,208,320

29-Oct-2016

11:58

Not Applicable

Retaildatabaseutility.msp

Not Applicable

2,441,216

29-Oct-2016

11:58

Not Applicable

Retailhardwarestation.msp

Not Applicable

1,998,848

29-Oct-2016

11:58

Not Applicable

Retailheadquarters32.msp

Not Applicable

27,967,488

29-Oct-2016

11:57

Not Applicable

Retailheadquarters64.msp

Not Applicable

27,779,072

29-Oct-2016

11:57

Not Applicable

Retailmodernpos.msp

Not Applicable

23,969,792

29-Oct-2016

11:57

Not Applicable

Retailpos.msp

Not Applicable

43,225,088

29-Oct-2016

12:05

Not Applicable

Retailsaltutility32.msp

Not Applicable

180,224

29-Oct-2016

11:58

Not Applicable

Retailsaltutility64.msp

Not Applicable

319,488

29-Oct-2016

11:58

Not Applicable

Retailscaleoutdeployment.msp

Not Applicable

20,238,336

29-Oct-2016

11:57

Not Applicable

Retailserver.msp

Not Applicable

2,387,968

29-Oct-2016

11:58

Not Applicable

Setupsupport32.msp

Not Applicable

13,606,912

29-Oct-2016

11:56

Not Applicable

Setupsupport64.msp

Not Applicable

21,131,264

29-Oct-2016

11:56

Not Applicable

Uspayroll32.msp

Not Applicable

90,112

29-Oct-2016

11:58

Not Applicable

Uspayroll64.msp

Not Applicable

6,438,912

29-Oct-2016

11:59

Not Applicable

Vstools32.msp

Not Applicable

1,150,976

29-Oct-2016

11:58

Not Applicable

Vstools64.msp

Not Applicable

1,150,976

29-Oct-2016

11:58

Not Applicable

Warehouse.msp

Not Applicable

77,824

29-Oct-2016

11:58

Not Applicable

Axsetupsp.exe

6.3.4000.3530

2,018,712

21-Oct-2016

10:07

x86

Axsetupsplib.dll

6.3.4000.3530

94,624

21-Oct-2016

10:07

x86

Axsetupui.exe

6.3.4000.3530

364,952

21-Oct-2016

10:07

x86

Axutillib.dll

6.3.4000.3513

984,984

20-Oct-2016

17:51

x86

Dixfserviceprereqhelper.exe

6.3.4000.1645

48,560

20-Aug-2016

08:05

x86

Microsoft.dynamics.servicing.dependencypackage.dll

6.3.164.3546

40,184

10-Feb-2016

15:24

x86

Microsoft.dynamics.servicing.graphlibrary.dll

6.3.4000.1814

46,552

30-Aug-2016

15:25

x86

Microsoft.dynamics.servicing.operations.dll

6.3.164.2384

44,264

10-Feb-2016

15:24

x86

Axsetupsp.resources.dll

6.3.4000.533

519,592

03-Jul-2016

23:36

x86

Axsetupsp.resources.dll

6.3.4000.533

503,208

03-Jul-2016

23:36

x86

Axsetupsp.resources.dll

6.3.4000.533

499,112

03-Jul-2016

23:36

x86

Axsetupsp.resources.dll

6.3.4000.533

503,208

03-Jul-2016

23:36

x86

Axsetupsp.resources.dll

6.3.4000.533

507,304

03-Jul-2016

23:36

x86

Axsetupsp.resources.dll

6.3.4000.533

495,016

03-Jul-2016

23:36

x86

Axsetupsp.resources.dll

6.3.4000.533

499,112

03-Jul-2016

23:36

x86

Axsetupsp.resources.dll

6.3.4000.533

511,400

03-Jul-2016

23:36

x86

Axsetupsp.resources.dll

6.3.4000.533

507,304

03-Jul-2016

23:36

x86

Axsetupsp.resources.dll

6.3.4000.533

499,112

03-Jul-2016

23:36

x86

Axsetupsp.resources.dll

6.3.4000.533

503,208

03-Jul-2016

23:36

x86

Axsetupsp.resources.dll

6.3.4000.533

523,688

03-Jul-2016

23:36

x86

Axsetupsp.resources.dll

6.3.4000.533

499,112

03-Jul-2016

23:36

x86

Axsetupsp.resources.dll

6.3.4000.533

503,208

03-Jul-2016

23:36

x86

Axsetupsp.resources.dll

6.3.4000.533

499,112

03-Jul-2016

23:36

x86

Axsetupsp.resources.dll

6.3.4000.533

499,112

03-Jul-2016

23:36

x86

Axsetupsp.resources.dll

6.3.4000.533

503,208

03-Jul-2016

23:36

x86

Axsetupsp.resources.dll

6.3.4000.533

503,208

03-Jul-2016

23:36

x86

Axsetupsp.resources.dll

6.3.4000.533

540,072

03-Jul-2016

23:36

x86

Axsetupsp.resources.dll

6.3.4000.533

499,112

03-Jul-2016

23:36

x86

Axsetupsp.resources.dll

6.3.4000.533

572,840

03-Jul-2016

23:36

x86

Axsetupsp.resources.dll

6.3.4000.533

490,920

03-Jul-2016

23:36

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.

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×