Certificate import failure when trying to add a certificate to a Communication Profile

Products

• Client Management Suite
• IT Management Suite

Issue/Introduction

When trying to add Certificates to the Communication Profile (i.e. Method 2 in KB 164743) the user encounters an error in the SMP Logs:

Unable to load specified certificate C:\Users\UserName\Desktop\DigiCertTrustedRootG4.crt

An error occurred during encode or decode operation
   [System.ComponentModel.Win32Exception @ Altiris.NS]
   at Altiris.NS.Security.Cryptography.CryptoHelper.NSCertificateManager.LoadCertificatesFromFile(String file, String password)
   at Altiris.NS.UI.Admin.ClientManagement.Certificate.dlgLoadCertificate.ValidateCertificateFile()

Environment

ITMS 8.6 RU3

Cause

Database takes too long to process all of the other certificates that it is managing.

Resolution

Backup the current Stored Procedure named spCertificatesByPurposeAndTrustee.  Rename to -old.

Run the attached SQL to create a new Stored Procedure with the same name.

Additional Information

164743 Windows System Assessment scan fails with Exit Code: 4