This issue can be caused by a large number of event broker subscriptions being executed in a relatively short period of time.
- The default interval for retention of the events is 90 days.
- The default time for executing the event purge is 1AM every day.
Both of these values can be adjusted.
Before you perform/make any changes you first take snapshot of vRealize Automation appliance and manually backup the vRealize Automation postgres database.
To adjust the retention of events in ebs_event:
- Download the attached workflow, configure_event_retention.v1.0.0.workflow
- Import this workflow into the vRO instance you use with vRA
- Run the workflow as a vRA system administrator (e.g. email@example.com)
- If no host entry exists with this system administrator user, create one:
- Use the “Library > vRealize Automation > Configuration > Add a vRA host” workflow to add a vRA host for the vsphere.local tenant. Please use the credentials of the system admin here (firstname.lastname@example.org)
- Use the updated “Configure event retention interval” workflow:
- Select “No” for “Use default vRA host for vsphere.local tenant”
- Select the host you just created for “vRA host”
- Set the retention period in days to your liking
- Submit the workflow and check the logs
- A successful run will write a message like “You have configured event purge interval of N days” in the logs tab, where N is the value entered for the retention period.
To adjust the time when the event purge is executed:
- Open an SSH session to the vRA appliance
- Edit the file /etc/vcac/vcac.properties
- Add the below line to set the execution time of the cron job.
- data.purge.eventlog.cron=* 10 15 * * ?
- This example will execute the event purge at 3:15 PM (1510 in 24hr time).
- The 5 ‘fields’ after the ‘=’ above represent sec|min|hour|day|month. So here we execute on all (*) seconds, days, and months; but only on the 10th minute of the 15th hour.
- Restart vRA services
- service vcac-server restart
- If there are multiple vRA nodes, execute steps 1-4 above on all nodes
On a successful execution of the event purge, you will see a message similar to the below in catalina.out.
vcac: [component=”cafe:event-broker” priority=”INFO” thread=”taskScheduler-2″ tenant=”” context=”” parent=”” token=””] com.vmware.vcac.core.event.broker.service.impl.EventLogServiceImpl.purgeOldEvents:90 – Eventlog purged  number of events