Article ID: SWH-KB-nID-000006884
Published: Oct-06-2022
Symptoms
The CrossFire Framework Service on the MAS is taking an excessive amount of memory, ultimately crashing with an Out of Memory exception.
When checking the event logs, they show that CrossFire failed due to System.Outofmemoryexception.
Version is 2.60.5011.0453.
Cause
A large number of scheduled reports are being run daily, but the reports are not set to expire. This causes the ACVSCore.Access.ReportResult table to contain over 72000 rows on the MAS, and up to 26000 on each SAS.
Solution
1. Backup all SAS and MAS ACVSCore DBs
2. Stop Report Services on SASs and MAS
3. In SQL Management Studio, clear out the ACVSCORE.Access.ReportResult tables on each SAS and the MAS
a. TRUNCATE TABLE ACVSCORE.Access.ReportResult
4. Restart the Report Services on all Servers
5. Edit each Report Event, enable “delete results after the following number of days”, and set to 1 day.
CrossFire_SWH-KB-nID-000006884.lt_.en_-1.pdf