Site Server console page shows package server service as CRITICAL ...

Products

• Server Management Suite
• IT Management Suite

Issue/Introduction

Package Server is working fine (downloading and delivering packages) but from the perspective of the Notification Server, when looking at this Site Server / Package Server on the SMP Console in Site Server Settings > Site Server it shows the Package service as "not installed" and "Critical".  The "Install/remove services" option shows the "Package Service" as installed:

The SMP Logs show the following error message: 

HTTP Request failed:
/Altiris/Resource/Explorer/BasicSummary.aspx?Type=full&ResourceGuid=deb6aec5-f19a-44c6-8966-839ee871497a 
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <=, >, >= or when the subquery is used as an expression.

Environment

ITMS 8.6 RU2

Cause

Used the FIND GUID & FIND STRING queries from KB 171823 (Find all tables that contain a specific GUID) and found two instances of the Site Server name in the RM_ResourcePackageService table with different GUID numbers:

Resolution

Resolved by running the following queries to validate the duplicate resource and then cleaning it up - AFTER CONFIRMING a KNOWN GOOD DATABASE BACKUP EXISTS:

--Run this query first to validate that the expected results are shown (correctly identifies the problem Site Server)
select * 
from RM_ResourcePackageService p
join vrm_computer_item i on i.Guid = p.Guid and i.Name = p.Name

--Run this query to clean up the problem rows (removes the problem Site Server) - ONLY RUN THIS QUERY AFTER CONFIRMING A KNOWN GOOD DATABASE BACKUP EXISTS
delete p 
from RM_ResourcePackageService p
join vrm_computer_item i on i.Guid = p.Guid and i.Name = p.Name