Prioritized upgrade scripts (form) [AX 2012]

Updated: February 25, 2011

Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012

Click System administration > Setup > Checklists > Data upgrade checklist. Click Generate upgrade task prioritization.

This form analyzes the sizes and dependencies of tables that are being upgraded and the scripts that process them, and then prioritizes jobs for processing during upgrade. Each table or script is algorithmically assigned a weight, with heavier weights indicating large tables or scripts with many dependencies. Heavily-weighted tables and scripts receive a high job priority because they are likely to block other jobs until they finish running. Custom weights and priorities may be useful when you have knowledge of the actual loads that your system will encounter while upgrading certain tables. You can override the ranking algorithm and assign lower or higher weights to scripts.

TipTip

To insert an additional script or table in the grid, press Ctrl+F3 to create a new row, and then fill in the table or script information. This method can also be used to override the calculated weight of an existing table or script that is not displayed in its grid:

  1. Press Ctrl+F3 to create a new row.

  2. Enter the name of the table or script whose weight you wish to change.

  3. Enter a custom weight.

The following tables provide descriptions for the controls in this form.

Tab

Description

Top tables and scripts

Displays size, weight, and dependency information for the top tables and data upgrade scripts. Table weight is derived from the row count and physical size of the table. Script weight is derived from the weight of the table and the cumulative effect of dependencies on other scripts.

Prioritized scripts

Based on the information on the Top tables and scripts tab, the upgrade algorithm prioritizes the tasks with highest weights so as to run the most time-consuming tasks first. This prevents dependency-caused delays in running other scripts. This tab displays priority and other information about the upgrade scripts.

Grid

Description

Top tables

Displays size, row count, and weight of the tables with the highest weight. The number of tables displayed is determined by the value entered in the Top tables and scripts field.

Top scripts

Displays the weight for the scripts with the highest weight. The number of scripts displayed is determined by the value entered in the Top tables and scripts field.

Tables used by script

Displays information about the source and target tables processed by the selected script.

Column

Description

Script ID

The unique identifier for the script.

Description

The description of the action performed by the script.

Table size (MB)

The size in megabytes of the table to be processed.

Table row count

The number of rows in the table to be processed.

Weight

The calculated or assigned processing weight of the table or script. To change the prioritization of a job, you can manually enter a customized weight here and then click Regenerate priority. The updated prioritization can be viewed on the Prioritized scripts tab.

Target table name

The name of the table processed by the script on the target system.

Source table name

The name of the table processed by the script on the source system.

Source table size (MB)

The size in megabytes of the source system table to be processed by the script.

Source table row count

The number of rows in the source system table to be processed by the script.

Priority

The script priority calculated from the script and table weights.

Method name

The method that calls the script.

Module

The Microsoft Dynamics AX application module affected by the script.

Type

The type of upgrade task: Bulk copy, Start, Final, Standard, or Shared.

Version

Refers to the Microsoft Dynamics AX version in which the script shipped. In an upgrade from Microsoft Dynamics AX 4.0, upgrade scripts from Microsoft Dynamics AX 2009 will be used for some operations.

Script stage

The upgrade stage that the task belongs to. Possible values are Bulk copy (if referring to tables) and PostSync (if referring to scripts).

Button

Description

Regenerate priority

Regenerate priority rankings after adjusting table or script weights.

Field

Description

Top tables and scripts

Set the size of each concurrently running block of tables and scripts. A setting of 20 means that a block of 20 tables and 20 scripts will be completed before the next block begins.


Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).

Community Additions

Show: