After upgrade to SMP 8.1 the AeXSvc.exe process consumes up to 40GB of memory or more

Products

• Endpoint Encryption
• IT Management Suite
• Inventory Solution

Issue/Introduction

After upgrade to SMP 8.1 the AeXSvc.exe process consumes up to 40GB of memory or more. The memory consumption typically starts in the early hours of the morning (between 12 AM and 2 AM). The server will either be very slow to respond, or will be completely unresponsive. Symptoms include Agents unable to connect, unable to receive their policies, or the Software Portal or console will not load.

Environment

8.1 GA

Cause

This is a known issue.

Resolution

This issue may appear if 8.1 upgrade was done shortly after its release. It is fixed in 8.1 RU1 and above.

You may apply the attached point-fix to resolve the issue. Or, apply it manually using the steps as per PF instructions.

1. Log into the SMP Server with the application identity credentials.
2. Copy the attached archive to the SMP server and extract the files.
3. Execute the PFInstaller.exe and choose to Install Files.
4. The fix will be applied.

To work around the issue, follow the below steps.

Run the following 4 SQL queries to remedy the problem:

--Query 1
delete from Inv_Software_Execution

--Query 2
delete from ResourceUpdateSummary where InventoryClassGuid='FF2EEE59-EAB7-4025-9E3E-9B430E3CB8EB'

--Query 3
Alter PROCEDURE spInvKeyExecutable
    AS
   SELECT ske._ResourceGuid [Guid], CASE WHEN spu.IsUsageTracked = 1 THEN 1 ELSE
0 END [IsMetered]
   FROM dbo.ResourceAssociation comp_file
   LEFT JOIN (dbo.ResourceAssociation prod_comp
   JOIN dbo.Inv_Software_Product_Usage spu
   ON prod_comp.ParentResourceGuid = spu._ResourceGuid
   AND prod_comp.ResourceAssociationTypeGuid =
'9D67B0C6-BEFF-4FCD-86C1-4A40028FE483') --Software Product Contains Software Component
   ON comp_file.ParentResourceGuid = prod_comp.ChildResourceGuid
   JOIN dbo.Inv_Software_Key_Executable ske
   ON ske._ResourceGuid = comp_file.ChildResourceGuid
   AND comp_file.ResourceAssociationTypeGuid = 'EABE86D3-AAFD-487A-AF63-5C95D7511AF6' --Software Component Contains File
   WHERE ske._ResourceGuid NOT IN
   (SELECT _ResourceGuid FROM Inv_Software_Execution)
      Group By ske._ResourceGuid , CASE WHEN spu.IsUsageTracked = 1 THEN 1 ELSE
0 END
   Having COUNT(ske._ResourceGuid) = 1
   UNION ALL
   SELECT distinct se._ResourceGuid [Guid], spu.IsUsageTracked [IsMetered] FROM dbo.Inv_Software_Execution se
   JOIN dbo.ResourceAssociation ra
   ON ra.ChildResourceGuid = se._ResourceGuid
   AND ra.ResourceAssociationTypeGuid = 'EABE86D3-AAFD-487A-AF63-5C95D7511AF6'
--Software Component Contains File
   JOIN dbo.ResourceAssociation ra1
   ON ra1.ChildResourceGuid = ra.ParentResourceGuid
   AND ra1.ResourceAssociationTypeGuid = '9D67B0C6-BEFF-4FCD-86C1-4A40028FE483'
   JOIN dbo.Inv_Software_Product_Usage spu
   ON spu._ResourceGuid = ra1.ParentResourceGuid
   AND spu.IsUsageTracked <> se.IsMetered

--Query 4
CREATE PROCEDURE spGetSoftareComponentMeteringInfo
    AS
              BEGIN
      select distinct se._ResourceGuid, wf.Name, wf.InternalName, wf.ProductName, wf.ProductVersion, wf.FileVersionString from Inv_Software_Execution se
      join vWindowsFile wf on wf.Guid=se._ResourceGuid
      where se.IsMetered=1
    END

The last step is to execute “NS.Hourly schedule to update SBUT policy.{2717bd64-52a7-4faf-bdfd-e6a81e0200b6}” task from windows Task Scheduler:

1. Go into Administrative Tools on the SMP Server.
2. Open the Task Scheduler.
3. Find the task: NS.Hourly schedule to update SBUT policy.{2717bd64-52a7-4faf-bdfd-e6a81e0200b6}
4. Right-click on the task and choose to Run it.