SystemEvent table might accumulate in size over time

Issue

• You might encounter a behavior where your SystemEvent table has increased to a size which you deem troublesome.
• The SystemEvent table contains the deletion events of assets for Staging. These events can be exported/published.  

Environment

• Liferay DXP 7.0+

Resolution

• The solution is to set the following portal properties as required to regularly clean the entries:
  

      # Set the interval in hours on how often CheckSystemEventMessageListener
      # will run to check for and delete system events that have been reached the
      # maximum age.
      #
      # Env: LIFERAY_STAGING_PERIOD_SYSTEM_PERIOD_EVENT_PERIOD_CHECK_PERIOD_INTERVAL
      #
      staging.system.event.check.interval=24
      #
      # Set this to the maximum age (in number of hours) that a system event will
      # be kept. Note that these settings may be overridden in Portal Settings for
      # each portal server or in Site Settings for each site.
      #
      # Env: LIFERAY_STAGING_PERIOD_SYSTEM_PERIOD_EVENT_PERIOD_MAX_PERIOD_AGE
      #
      staging.system.event.max.age=0

• Setting staging.system.event.max.age=0 will prevent the entries from timing out.

Additional Information

• Defining System Events for Deletions