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