ReleaseUpdateDB60_Basic.allowDupWorkflowTables Upgrade Script
Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012
Class |
ReleaseUpdateDB60_Basic |
Method |
allowDupWorkflowTables |
Description |
This upgrade script removes the unique indexes on the workflow and alerts tables to allow duplicate IDs. |
Affected Modules and Tables
Affected Modules |
|---|
Basic |
Affected Tables |
|---|
WorkflowElementTable |
WorkflowStepTable |
WorkflowMessageText |
WorkflowVersionTableNotes |
ExpressionTable |
EventRule |
EventRuleData |
EventRuleField |
EventRuleIgnore |
EventRuleRel |
EventRuleRelData |
Remarks
In Microsoft Dynamics AX 2009, all workflow and alert rule tables were bound by company. In Microsoft Dynamics AX 2012 these tables are global. As a consequence, there will be duplicate IDs in the Microsoft Dynamics AX 2012 tables that will get created during the bulk copy from the source system to the target system. This script will remove the unique indexes on these tables thereby allowing existence of duplicate IDs.