Problem Definition

Currently JEPP stores all mails fetched from the mail server into AO_2C4E5C_MAILITEMCHUNK table and keeps them in the table for a period of time (45 days by default, minimum 14 days).
This causes the DB size to increase really quick.

This table's main purpose is to make sure Service Desk will process all mails fetched from the mail server and, in case of any problems, keep the email for reprocessing in the future so it isn't lost.

Suggested Solution

We should remove the mails successfully processed right after they are processed to avoid storing information that won't be needed.

Workaround 1 (if not implemented already)

Reduce the mail retention interval from the default 45 days to 14 via JIRA -> Settings -> Global Mail - > DB Cleaner

Workaround 2

The retention period can be set via a direct database update. Please reach out to support for further guidance on this.

Note: In case of performing Workaround 1 and Workaround 2, be mindful of a potential impact on the database server. In case of MS SQL for example, temb db and MS SQL will grow extremely quickly on cleaning up large tables, so best to perform both these workarounds in a controlled and staged manner