Share via


ReleaseUpdateDB60_Basic.updateAlerts 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

updateAlerts

Description

Upgrades and disables all alert rules. Also resolves all duplicate rule IDs, because rules are now global and no longer bound by company.

Affected Modules and Tables

Affected Modules

Basic

Affected Tables

EventRule

EventRuleData

EventRuleField

EventRuleIgnore

EventRuleIgnoreAggregation

EventRuleRel

EventRuleRelData

Remarks

As alert tables have become global in Microsoft Dynamics AX 2012, duplicate rule IDs could exist after the bulk copy is performed from the source system. These are resolved in this upgrade script. The resolution is to suffix the company name against all duplicate rules.

New Tables or Fields

Table

Field

Extended Data Type

-or- Base Enum

EventRule

ActionNames

BlobData

EventRule

AlertInstanceRelationshipType

EventInstanceRelationshipType

EventRule

CompanyId

SelectableDataArea

EventRule

GlobalRule

EventIsGlobalRule

EventRule

PrimInstanceRelationType

EventInstanceRelationType

EventRuleField

uInstanceRelationType

EventInstanceRelationType

EventRuleRel

CudInstanceRelationType

EventInstanceRelationshipType

EventRuleRel

RelType

EventRuleRelData

FieldNameList

EventFieldLis

EventRuleRelData

Data

BlobData

Deleted Tables or Fields

Table

Field

EventRule

ActionIds

EventRuleData

DataAreaId

EventRuleField

DataAreaId

EventRuleIgnore

DataAreaId

EventRuleIgnoreAggregation

DataAreaId

EventRuleRel

DataAreaId

EventRuleRelData

FieldList

EventRuleRelData

DataAreaId