Views:

Applies to Product - Dynamics 365 Supply Chain Management


What’s happening?
Customers are experiencing issues with the SysOutgoingEmail and SysOutgoingEmailData tables, which require cleanup due to excessive data retention beyond the specified limits.
 

Reason:
The tables have accumulated data beyond the retention policy of 30 days, leading to database space issues.
 

Resolution:

  1. Run a custom X++ script to clean up the SysOutgoingEmail and SysOutgoingEmailData tables.
  2. Specify the date range for cleanup, ensuring that records created prior to the specified date (e.g., 7th of the month) are targeted for deletion.
  3. The cleanup script should be executed in the UAT environment first, following the guidelines for running custom X++ scripts with zero downtime.
  4. Once validated in UAT, the script can be executed in the production environment to clear the necessary records.
  5. Monitor the database space after the cleanup to confirm that the issue has been resolved.