Skip to main content

Impossible to export event log

If a Business Process (BP) has extensive event logs or the row size is excessive, there will be issues downloading the logs.

To resolve the issue, act as follows:

Get record count for BP run​

To know the count of records written against a BP run, execute the query:

SELECT COUNT(*) from ct.event_tracking et
join ct.event_object eo on et.id = eo.event_tracking_id and eo.object_type = 'Run'
join ct.run r ON r.id = eo.object_id
where r.rootrunuuid = 'Enter_here_BP_rootrunuuid'

Download event logs from database​

To download the event logs from the database, use the query below. Specify the BP name and the UUID. You can get the UUID when you click the run of the BP.

SELECT c.title, r.title,
r.rootRunUUID, r.childrenRunUUID,
et.CREATED_TIME,
et.hitId,
et.DESCRIPTION,
et.fullDescription
FROM EVENT_TRACKING et
JOIN AwsHit ah ON ah.id = et.hitId
JOIN Run r ON r.id = ah.run_id
JOIN Campaign c ON c.id = r.campaign_id
WHERE c.title = '<BP Name>'
and r.rootRunUUID='<uuid of the BP run>'
ORDER by et.CREATED_TIME desc;

Check indexing availability​

To check the availability of indexing for the table, use the query:

exec SP_HELPINDEX 'ct.event_object'

Clear event log​

Use the following queries to clear the event logs for a particular BP:

DELETE FROM ct.event_object WHERE event_tracking_id in (select et.id from ct.event_tracking et where et.hitid in (select ah.id from ct.awshit ah where ah.run_id in
(select r.id from ct.run r where r.rootrunuuid='<uuid of the BP run>')));

DELETE FROM ct.event_tracking WHERE hitid in (select ah.id from ct.awshit ah where ah.run_id in
(select r.id from ct.run r where r.rootrunuuid='<uuid of the BP run>'));

If, based on the instructions above, you failed to resolve the issue, create a support ticket.

View also: