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.

 

Was this article helpful?
0 out of 0 found this helpful