Atrshost and Dataloader restart every few minutes on site server

Products

• Task Server

Issue/Introduction

Atrshost and Dataloader restart every few minutes on site server. This can cause tasks running on client machines to randomly fail.

Cause

This is caused by a misconfiguration in the task server settings where more than one task configuration policy applies to the same site server.

Resolution

Select 
    i.Name as 'Policy Name', 
    vpa.PolicyGuid, 
    i2.Name as 'Server Name'
from vPolicyAppliesToResource vpa
join ItemClass ic on vpa.PolicyGuid = ic.Guid
join Item i on vpa.PolicyGuid = i.Guid
join vItem i2 on vpa.ResourceGuid = i2.Guid
where ic.ClassGuid = '525B112A-4958-4F6C-9C2D-DDCA39F89E0C'
and vpa.Enabled = 1
and vpa.ResourceGuid in (
    Select ResourceGuid from (
        select vpa.ResourceGuid, COUNT(*) as count
        from vPolicyAppliesToResource vpa
        join ItemClass ic
        on vpa.PolicyGuid = ic.guid
        where ic.ClassGuid = '525B112A-4958-4F6C-9C2D-DDCA39F89E0C'
        and vpa.Enabled = '1'
        group by vpa.ResourceGuid) q1
    where q1.count <= 1)