This article applies to Microsoft Dynamics AX for all regions.

Symptoms

When you run the X++ compilation in Microsoft Dynamics AX 2012 R2, you experience slow performance.

Cause

This problem occurs because the SQL Query Optimizer might not calculate the optimal query path for one of the frequent queries against the ModelSecurityPermission model store table. This happens because of an added Primary Key for this table in Microsoft Dynamics AX 2012 R2 and when it happens, it a causes a significant performance penalty.

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, 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.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

To enable the hotfix, follow these steps after you install the hotfix:

  1. Open a command prompt or PowerShell session on the AOS.

  2. Run the following command:

    axutil schema

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.

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

Service branch

Aximpactanalysis.exe

Not applicable

61,136

04-Feb-2013

03:04

x86

Not applicable

Axupdate.exe

Not applicable

61,120

04-Feb-2013

03:04

x86

Not applicable

Clientoba32.msp

Not applicable

20,033,536

26-Apr-2013

19:59

Not applicable

Not applicable

Clientoba64.msp

Not applicable

20,205,568

26-Apr-2013

19:59

Not applicable

Not applicable

Commercedataexchangereal-timeservice.msp

Not applicable

49,152

26-Apr-2013

19:59

Not applicable

Not applicable

Commercedataexchangesynchservice32.msp

Not applicable

122,880

26-Apr-2013

19:59

Not applicable

Not applicable

Commercedataexchangesynchservice64.msp

Not applicable

122,880

26-Apr-2013

19:59

Not applicable

Not applicable

Components32.msp

Not applicable

17,342,464

26-Apr-2013

19:59

Not applicable

Not applicable

Components64.msp

Not applicable

34,770,944

26-Apr-2013

19:59

Not applicable

Not applicable

Objectserver32.msp

Not applicable

7,258,112

26-Apr-2013

19:59

Not applicable

Not applicable

Objectserver64.msp

Not applicable

15,171,584

26-Apr-2013

19:59

Not applicable

Not applicable

Retaildatabaseutility.msp

Not applicable

528,384

26-Apr-2013

19:59

Not applicable

Not applicable

Retailheadquarters32.msp

Not applicable

2,842,624

26-Apr-2013

19:59

Not applicable

Not applicable

Retailheadquarters64.msp

Not applicable

2,842,624

26-Apr-2013

19:59

Not applicable

Not applicable

Retailonlinechannel.msp

Not applicable

2,756,608

26-Apr-2013

19:59

Not applicable

Not applicable

Retailpos.msp

Not applicable

4,382,720

26-Apr-2013

19:59

Not applicable

Not applicable

Retailposplugins.msp

Not applicable

47,996,928

26-Apr-2013

19:59

Not applicable

RETAILPOSP

Setupsupport32.msp

Not applicable

6,553,600

26-Apr-2013

19:59

Not applicable

Not applicable

Setupsupport64.msp

Not applicable

13,815,808

26-Apr-2013

19:59

Not applicable

Not applicable

Axsetupsp.exe

6.2.139.8316

1,390,784

04-Feb-2013

03:04

x86

Not applicable

Axutillib.dll

6.2.120.0

929,968

26-Apr-2013

20:17

x86

Not applicable

Microsoft.dynamics.servicing.operations.dll

6.2.73.8303

37,168

04-Feb-2013

03:04

x86

Not applicable

Axsetupsp.resources.dll

6.2.147.8303

387,776

26-Apr-2013

20:17

x86

Not applicable

Axsetupsp.resources.dll

6.2.147.8303

375,488

26-Apr-2013

20:17

x86

Not applicable

Axsetupsp.resources.dll

6.2.147.8303

375,488

26-Apr-2013

20:17

x86

Not applicable

Axsetupsp.resources.dll

6.2.147.8303

379,584

26-Apr-2013

20:17

x86

Not applicable

Axsetupsp.resources.dll

6.2.147.8303

379,584

26-Apr-2013

20:17

x86

Not applicable

Axsetupsp.resources.dll

6.2.147.8303

371,392

26-Apr-2013

20:17

x86

Not applicable

Axsetupsp.resources.dll

6.2.147.8303

375,488

26-Apr-2013

20:17

x86

Not applicable

Axsetupsp.resources.dll

6.2.147.8303

383,680

26-Apr-2013

20:17

x86

Not applicable

Axsetupsp.resources.dll

6.2.147.8303

395,968

26-Apr-2013

20:17

x86

Not applicable

Axsetupsp.resources.dll

6.2.147.8303

375,488

26-Apr-2013

20:17

x86

Not applicable

Axsetupsp.resources.dll

6.2.147.8303

379,584

26-Apr-2013

20:17

x86

Not applicable

Axsetupsp.resources.dll

6.2.147.8303

387,776

26-Apr-2013

20:17

x86

Not applicable

Axsetupsp.resources.dll

6.2.147.8303

375,488

26-Apr-2013

20:17

x86

Not applicable

Axsetupsp.resources.dll

6.2.147.8303

375,488

26-Apr-2013

20:17

x86

Not applicable

Axsetupsp.resources.dll

6.2.147.8303

375,488

26-Apr-2013

20:17

x86

Not applicable

Axsetupsp.resources.dll

6.2.147.8303

379,584

26-Apr-2013

20:17

x86

Not applicable

Axsetupsp.resources.dll

6.2.147.8303

379,584

26-Apr-2013

20:17

x86

Not applicable

Axsetupsp.resources.dll

6.2.147.8303

379,584

26-Apr-2013

20:17

x86

Not applicable

Axsetupsp.resources.dll

6.2.147.8303

395,968

26-Apr-2013

20:17

x86

Not applicable

Axsetupsp.resources.dll

6.2.147.8303

375,488

26-Apr-2013

20:17

x86

Not applicable

Axsetupsp.resources.dll

6.2.147.8303

416,448

26-Apr-2013

20:17

x86

Not applicable

Axsetupsp.resources.dll

6.2.147.8303

371,392

26-Apr-2013

20:17

x86

Not applicable

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 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.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.