Compartilhar via


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.