Deletion Service Failed To Successfully Perform Cleanup

Microsoft.Dynamics.CRM.Deletion_Service_Failed_To_Successfully_Perform_Cleanup (Rule)

Knowledge Base article:

Summary

The CRM Deletion Service failed to cleanup one or more tables in the CRM database. Therefore, the database still contains the records that were marked for deletion

Causes

This problem can occur if the SQL Server Agent service is not running.

Resolutions

Restart the SQL Server Agent service. If the problem persists, install the most recent cumulative update rollup for Microsoft Dynamics CRM.

Element properties:

TargetMicrosoft.Dynamics.CRM.Asynchronous_Processing_Service_Server
CategoryEventCollection
EnabledFalse
Event_ID16387
Event SourceMSCRMDeletionService
Alert GenerateTrue
Alert SeverityWarning
Alert PriorityNormal
RemotableTrue
Alert Message
Deletion Service failed to successfully perform cleanup
EventId: {0} Event Publisher: {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

Source Code:

<Rule ID="Microsoft.Dynamics.CRM.Deletion_Service_Failed_To_Successfully_Perform_Cleanup" Enabled="false" Target="Microsoft.Dynamics.CRM.Asynchronous_Processing_Service_Server" ConfirmDelivery="true" Remotable="true" Priority="Normal" DiscardLevel="100">
<Category>EventCollection</Category>
<DataSources>
<DataSource ID="DS" TypeID="Windows!Microsoft.Windows.EventProvider">
<ComputerName>$Target/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">16387</Value>
</ValueExpression>
</SimpleExpression>
</Expression>
<Expression>
<SimpleExpression>
<ValueExpression>
<XPathQuery Type="String">PublisherName</XPathQuery>
</ValueExpression>
<Operator>Equal</Operator>
<ValueExpression>
<Value Type="String">MSCRMDeletionService</Value>
</ValueExpression>
</SimpleExpression>
</Expression>
</And>
</Expression>
</DataSource>
</DataSources>
<WriteActions>
<WriteAction ID="Alert" TypeID="Health!System.Health.GenerateAlert">
<Priority>1</Priority>
<Severity>1</Severity>
<AlertOwner/>
<AlertMessageId>$MPElement[Name="Microsoft.Dynamics.CRM.Deletion_Service_Failed_To_Successfully_Perform_Cleanup.AlertMessage"]$</AlertMessageId>
<AlertParameters>
<AlertParameter1>$Data/EventDisplayNumber$</AlertParameter1>
<AlertParameter2>$Data/PublisherName$</AlertParameter2>
<AlertParameter3>$Data/EventDescription$</AlertParameter3>
</AlertParameters>
<Suppression>
<SuppressionValue>$Data/LoggingComputer$</SuppressionValue>
</Suppression>
<Custom1/>
<Custom2/>
<Custom3/>
<Custom4/>
<Custom5/>
<Custom6/>
<Custom7/>
<Custom8/>
<Custom9/>
<Custom10/>
</WriteAction>
</WriteActions>
</Rule>