VERIFIED SOLUTION i

Resolve purge scripts running continuously in EngageOne V4.4GA

Product Feature: Purge
Versions affected: 4.4GA, 4.4SP1
 

Issue

Purge-em.sh taking in excess of 9 hours to run.

Cause

Known issue in versions of EngageOne earlier than 4.4.2 where purge-em called one SQL statement after another resulting in poor performance.

Resolution

UPDATED: October 3, 2017
Event monitor purge mechanism has been re-engineered in EO 4.4.SP2 – instead of calling one SQL statement after another, everything has been packed into a stored procedure which drastically improves performance of the event monitor purge process.