Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. Performance issue with invoicing caused by the TaxBookSectionDate table in the Italian version of Microsoft Dynamics AX 2012 R3

Performance issue with invoicing caused by the TaxBookSectionDate table in the Italian version of Microsoft Dynamics AX 2012 R3

View products that this article applies to.

This article applies to Microsoft Dynamics AX for the Italian (it) region.

↑ Back to the top

In the current implementation for Italy, the table's primary key is {TaxBookSection, TransDate}. There is one record for each day. The property OCC (Optimistic Concurrency Control) is switched off for this table. When an invoice is posted, the TaxBookSectionDate.LastRec field is updated by the invoice number, and this blocks other parallel postings until the transaction ends.

↑ Back to the top

Resolution

The changes in the hotfix resolve this issue.

The TaxBookSectionDate.LastRec field is added to the primary key. Instead of updating a single record, an insert is done. This helps to completely remove blockings and utilize multithreaded postings.

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


↑ Back to the top

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 nameFile versionFile sizeDateTimePlatform
Aximpactanalysis.exeNot Applicable62,13618-Feb-201620:00x86
Axupdate.exeNot Applicable62,12018-Feb-201620:00x86
Dynamicsax2012r3-kb3151265-syplabels.axmodel6.3.3000.270014,977,77611-Apr-201611:05Not Applicable
Dynamicsax2012r3_cl4568304.axmodel6.3.3000.270015,06411-Apr-201611:05Not Applicable
Hotfixdependencygraph.dgmlNot Applicable47711-Apr-201611:03Not Applicable
Hotfixinformation.xmlNot Applicable1,66011-Apr-201611:03Not Applicable
Axsetupsp.exe6.3.3000.26922,010,52011-Apr-201607:16x86
Axsetupsplib.dll6.3.3000.269294,62411-Apr-201607:16x86
Axsetupui.exe6.3.3000.2692364,95211-Apr-201607:16x86
Axutillib.dll6.3.3000.1547981,40018-Feb-201620:00x86
Microsoft.dynamics.servicing.dependencypackage.dll6.3.164.354640,18418-Feb-201620:00x86
Microsoft.dynamics.servicing.graphlibrary.dll6.3.164.238445,80018-Feb-201620:00x86
Microsoft.dynamics.servicing.operations.dll6.3.164.238444,26418-Feb-201620:00x86
Axsetupsp.resources.dll6.3.1000.284518,84018-Feb-201620:00x86
Axsetupsp.resources.dll6.3.1000.284502,45618-Feb-201620:00x86
Axsetupsp.resources.dll6.3.1000.284498,36018-Feb-201620:00x86
Axsetupsp.resources.dll6.3.1000.284502,45618-Feb-201620:00x86
Axsetupsp.resources.dll6.3.1000.284506,55218-Feb-201620:00x86
Axsetupsp.resources.dll6.3.1000.284494,26418-Feb-201620:00x86
Axsetupsp.resources.dll6.3.1000.284494,26418-Feb-201620:00x86
Axsetupsp.resources.dll6.3.1000.284510,64818-Feb-201620:00x86
Axsetupsp.resources.dll6.3.1000.284506,55218-Feb-201620:00x86
Axsetupsp.resources.dll6.3.1000.284498,36018-Feb-201620:00x86
Axsetupsp.resources.dll6.3.1000.284502,45618-Feb-201620:00x86
Axsetupsp.resources.dll6.3.1000.284518,84018-Feb-201620:00x86
Axsetupsp.resources.dll6.3.1000.284498,36018-Feb-201620:00x86
Axsetupsp.resources.dll6.3.1000.284502,45618-Feb-201620:00x86
Axsetupsp.resources.dll6.3.1000.284494,26418-Feb-201620:00x86
Axsetupsp.resources.dll6.3.1000.284498,36018-Feb-201620:00x86
Axsetupsp.resources.dll6.3.1000.284502,45618-Feb-201620:00x86
Axsetupsp.resources.dll6.3.1000.284502,45618-Feb-201620:00x86
Axsetupsp.resources.dll6.3.1000.284539,32018-Feb-201620:00x86
Axsetupsp.resources.dll6.3.1000.284494,26418-Feb-201620:00x86
Axsetupsp.resources.dll6.3.1000.284567,99218-Feb-201620:00x86
Axsetupsp.resources.dll6.3.1000.284486,07218-Feb-201620:00x86

↑ Back to the top

Status

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

↑ Back to the top

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.

↑ Back to the top

Keywords: kbexpertisebeginner, kbexpertiseinter, kbexpertiseadvanced, kbnoloc, kbqfe, kbsurveynew, kbmbspartner, kbmbsmigrate, kb, kbautohotfix, kbmbsquickpub, kbhotfixserver

↑ Back to the top

Article Info
Article ID : 3151265
Revision : 2
Created on : 2/17/2017
Published on : 2/17/2017
Exists online : False
Views : 290