Prioritized upgrade scripts (form)
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.
Tip
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:
-
Press Ctrl+F3 to create a new row.
-
Enter the name of the table or script whose weight you wish to change.
-
Enter a custom weight.
Tasks that use this form
Generate upgrade task prioritization
Navigating the form
The following tables provide descriptions for the controls in this form.
Tabs
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. |
Grids
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. |
Grid columns
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). |
Buttons
Button |
Description |
|---|---|
Regenerate priority |
Regenerate priority rankings after adjusting table or script weights. |
Fields
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).