Dropped Batch Email Jobs Using Enquire MAP

Dropped Batch Email Jobs Using Enquire MAP

1. Get workflow_id from email                     
2. Check Sidekiq > Busy tab to verify that it is being processed.
3. Check that account's Account ID in account_campaigns in Queues. If either of these are there, it probably just needs time.
4. Place the  workflow_id into both spots of this query to see if the missing counts are equal.
   

   select count(*)
   from contacts_workflows
   where workflow_id = 86589
   and finished = 1
   and contact_id not in (select contact_id from contact_histories where history_type = 'Email Log' and contact_id is not null and workflow_id = contacts_workflows.workflow_id
   and contacts_workflows.contact_id = contact_histories.contact_id);

   
   
5. If they are equal, put that same workflow_id into both spots of this query. Please Note: It is very important to not make an error here as it will send double emails.

update contacts_workflows
set finished = 0
where workflow_id = 86589
and finished = 1
and contact_id not in (select contact_id from contact_histories where history_type = 'Email Log' and contact_id is not null and workflow_id = contacts_workflows.workflow_id
and contacts_workflows.contact_id = contact_histories.contact_id);

Please reach out to the dedicated Enquire Account Manager or Enquire MAP Support team for further assistance.