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.
ITMS 8.6 RU2
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:
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