MsDrdaService - Event 1058

Microsoft.HostIntegrationServer.2016.MsDrda_CriticalEvent_1058 (Rule)

The Microsoft Service for DRDA failed to load DB2 to SQL data mappings XML file.

Knowledge Base article:

Summary

The Microsoft Service for DRDA failed to load DB2 to SQL data mappings XML file.

Causes

The DRDA Service validates the contents of theMSSQLToDB2.XML file by element and attribute type, enumerated and other defined values. If the event messages file content is not valid, the DRDA Service will not start and log a Windows application event message.

Resolutions

The administrator should verify the format and contents of the Microsoft Service for DRDA DB2 to SQL data mappings XML file.

Element properties:

TargetMicrosoft.HostIntegrationServer.2016.MsDrda
CategoryEventCollection
EnabledTrue
Event_ID1058
Event SourceMsDrdaService
Alert GenerateTrue
Alert SeverityError
Alert PriorityNormal
RemotableTrue
Alert Message
MsDrdaService Alert 1058
Server: {0}
Event ID: {1}
Event Description: {2}
Event LogApplication

Member Modules:

ID Module Type TypeId RunAs 
DS DataSource Microsoft.Windows.EventProvider Default
Alert WriteAction System.Health.GenerateAlert Default
WriteToDB WriteAction Microsoft.SystemCenter.CollectEvent Default
WriteToDW WriteAction Microsoft.SystemCenter.DataWarehouse.PublishEventData Default

Source Code:

<Rule ID="Microsoft.HostIntegrationServer.2016.MsDrda_CriticalEvent_1058" Enabled="true" Target="Microsoft.HostIntegrationServer.2016.MsDrda" ConfirmDelivery="true" Remotable="true" Priority="Normal" DiscardLevel="100">
<Category>EventCollection</Category>
<DataSources>
<DataSource ID="DS" TypeID="Windows!Microsoft.Windows.EventProvider">
<ComputerName>$Target/Host/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$</ComputerName>
<LogName>Application</LogName>
<Expression>
<And>
<Expression>
<SimpleExpression>
<ValueExpression>
<XPathQuery Type="UnsignedInteger">EventDisplayNumber</XPathQuery>
</ValueExpression>
<Operator>Equal</Operator>
<ValueExpression>
<Value Type="UnsignedInteger">1058</Value>
</ValueExpression>
</SimpleExpression>
</Expression>
<Expression>
<SimpleExpression>
<ValueExpression>
<XPathQuery Type="String">PublisherName</XPathQuery>
</ValueExpression>
<Operator>Equal</Operator>
<ValueExpression>
<Value Type="String">MsDrdaService</Value>
</ValueExpression>
</SimpleExpression>
</Expression>
</And>
</Expression>
</DataSource>
</DataSources>
<WriteActions>
<WriteAction ID="Alert" TypeID="Health!System.Health.GenerateAlert">
<Priority>1</Priority>
<Severity>2</Severity>
<AlertName/>
<AlertDescription/>
<AlertOwner/>
<AlertMessageId>$MPElement[Name="Microsoft.HostIntegrationServer.2016.MsDrda_CriticalEvent_1058.AlertMessage"]$</AlertMessageId>
<AlertParameters>
<AlertParameter1>$Data/LoggingComputer$</AlertParameter1>
<AlertParameter2>$Data/EventDisplayNumber$</AlertParameter2>
<AlertParameter3>$Data/EventDescription$</AlertParameter3>
</AlertParameters>
<Suppression/>
<Custom1/>
<Custom2/>
<Custom3/>
<Custom4/>
<Custom5/>
<Custom6/>
<Custom7/>
<Custom8/>
<Custom9/>
<Custom10/>
</WriteAction>
<WriteAction ID="WriteToDB" TypeID="SC!Microsoft.SystemCenter.CollectEvent"/>
<WriteAction ID="WriteToDW" TypeID="SCDW!Microsoft.SystemCenter.DataWarehouse.PublishEventData"/>
</WriteActions>
</Rule>