Task Service has stopped working and shows as needing an upgrade in Site Server Settings

Products

• IT Management Suite
• Client Management Suite

Issue/Introduction

You have upgraded to 8.5 RU3 and have one or more Task Servers that have stopped working as expected. When reviewing the Site Server Settings page in the console for those Task Servers, it shows as needing an upgrade and the version is not 8.5.5030. When you check the installed version of the Altiris Client Task Server Agent, it shows the expected version, 8.5.5030.

Environment

8.5 RU3

Cause

Unknown

Resolution

• Open SQL Management Studio and run the following query to see what versions of Task Service are on your Task Server(s)

select
 vc.name,
 ts.Version as TaskVersion,
 ts.Build as TaskBuild,
 ts._ResourceGuid
from Inv_Client_Task_Servers ts
join vcomputer vc on vc.Guid = ts._ResourceGuid

• Identify which Task Servers show versions other than 8.5.5030 even though 8.5.5030 is known to be installed. 
• Copy the GUID in the _ResourceGuid column and run this query to confirm that only that Task Server is listed

select
 vc.name,
 ts.Version as TaskVersion,
 ts.Build as TaskBuild,
 ts._ResourceGuid
from Inv_Client_Task_Servers ts
join vcomputer vc on vc.Guid = ts._ResourceGuid
where ts._ResourceGuid = 'PASTE GUID HERE'

• Once  you confirm that the above query has the Task Server you need to change, run this query

update Inv_Client_Task_Servers
set Version = '8.5', build = '5030'
where _ResourceGuid = 'GUID OF Bad TS'