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. You experience performance problems when you post a sales order in Microsoft Dynamics AX 3.0

You experience performance problems when you post a sales order in Microsoft Dynamics AX 3.0

View products that this article applies to.

Symptoms

When you post a sales order in Microsoft Dynamics AX 3.0, you experience performance problems. Specifically, you experience the following problems:
  • Tables may remain locked for an unexpected time.
  • Transactions may block other pending transactions for an unexpected time.
  • The Microsoft Dynamics AX database experiences unexpected growth. Specifically, the InventSumLogTTS table becomes very large.
These problems occur if the following conditions are true:
  • You have a license for Master Planning in Microsoft Dynamics AX 3.0.
  • You run Master Planning infrequently.
  • Many records exist in the InventSumLogTTS.
  • You run the "select for update" codeunit on the InventSumLogTTS table.

↑ Back to the top

Resolution

If you do not require the InventSumLogTTS table for Master Planning or for the Inventory Multi-Transaction System (IMTS), you can resolve this problem by using the following methods. In the future, if you intend to use Master Planning or the IMTS, review any changes that you make to the InventSumLogTTS table.

Caution If you use one of these methods to resolve the problem, you will modify the database. Before you change the database, perform a full database backup and test the changes in a test environment.

Method 1: Remove the InventSumLogTTS table

To remove the InventSumLogTTS table, clear the Master Planning configuration key, and then synchronize the database.

Method 2: Periodically delete records from the InventSumLogTTS table

Periodically delete records from the InventSumLogTTS table. Delete records that meet the following criteria:
  • The iscommitted field for the record contains a 1.
  • The dataareaid field for the record contains the name of the current company.
You can schedule a job in Microsoft SQL Server to periodically delete the records.

↑ Back to the top

More Information

The InventSumLogTTS table is created when you enable the Master Planning configuration.

The InventSumLogTTS table is used for the following purposes:
  • When IMTS is enabled, the InventSumLogTTS table is used to roll back unsuccessful transactions.For more information about IMTS, click the following article number to view the article in the Microsoft Knowledge Base:

    862694 Inventory Multi-Transaction System

  • When you run Master Planning, the InventSumLogTTS table enables Master Scheduling to be updated based on the changes to transactions. After Master Scheduling runs, the records in the InventSumLogTTS table are deleted.

↑ Back to the top

Keywords: kbnosurvey, kbarchive, kbmbspartner, kbentirenet, kbtshoot, kbmbsmigrate, kbprb, kb

↑ Back to the top

Article Info
Article ID : 904855
Revision : 1
Created on : 1/7/2017
Published on : 12/28/2014
Exists online : False
Views : 631