Issue
Error messages in the a.log on the SMP server regarding Duplicate Resources for ResourceTypeKey.
Source: Arellia.SMP.FileInventory.Discovery.FileDigitalSignatureResourceDiscoverer.DiscoverResource
Description: Unable to inventory certificate details for Resource DISTRIB.exe (f8adc4a4-f512-432b-92ca-d40663ed811e)
( Exception Details: Arellia.SMP.Resource.Exceptions.AeXDuplicateResourceTypeKeyValueException: Duplicate Resources for ResourceTypeKey Hash (2244c832-3c51-4b26-9f8b-b2dfff449d9f). Resolving for ResourceType Digital Certificate (c76fc2a7-85db-4ecb-a055-8cd0d5fc91fd). Values = AlgorithmGuid='sha1 (3bc0e8a0-caa1-40e0-b705-c8d990c0babf)', Hash='Vk4BBmOH8myRIBDQa9eNPPHoRas='. MatchDerived = True ---> Altiris.Resource.AeXDuplicatedKeyValueException: Error in the application.
at Altiris.Resource.ResourceTypeKey.FindResource(DataRow row, Guid resourceType, Boolean matchDerivedTypes)
Resolution
select * from syscolumns sc
join sysobjects so on sc.id=so.id
where sc.name = 'AlgorithmGuid' and so.xtype = 'U'