Page MenuHomePhabricator

Civi to Acoustic Export: Job "MASTER SUPPRESSION LIST" failing every other day.
Closed, ResolvedPublic

Description

Greetings Fr-Tech,

Acoustic's daily import job of contact source "MASTER SUPPRESSION LIST" has been failing every other day recently. Specifically:

  • May 24: Failed
  • May 25: Successful
  • May 26: Failed
  • May 27: Successful
  • May 28: Failed

The .csv files seem to be present during import time. For instance, the most recent import was file "Unsubscribes-20240528041932.csv" .

May you be so kind to check this for us, please?

Steps to replicate the issue (include links if applicable)

We receive a daily email to check if the daily Acoustic import has been completed successfully. Received a message notating that the Contact Source job failed.

What happens?
While reviewing the daily export email notification, we received the following error message via email:

Unsubscribes

Contact Source Name: MASTER SUPPRESSION LIST
File Name: Unsubscribes-20240528041932.csv

Job ID: 242834131
Job Description: Adding contacts to existing contact source, MASTER SUPPRESSION LIST
Job Type: Recurring Contact Source Import @ Tuesday, May 28, 2024 at 9:00:13 AM GMT
Job Status: Failed
Total Rows: 9470945
Total Valid Rows: 9465987
Total Invalid Addresses: 2401
Total Duplicate Addresses: 0
Total Disallowed Addresses: 2477
Total Bad Data: 80

What should have happened instead?
The import jobs should have completed succesfully. We would have received email notifications informing us of their completion. An example of a success email would be:

Contact Source Name: MASTER SUPPRESSION LIST
File Name: Unsubscribes-20240527041622.csv

Job ID: 242817252
Job Description: Adding contacts to existing contact source, MASTER SUPPRESSION LIST
Job Type: Recurring Contact Source Import @ Monday, May 27, 2024 at 9:00:17 AM GMT
Job Status: Complete
Total Rows: 9468614
Total Valid Rows: 9463657
Total Invalid Addresses: 2401
Total Duplicate Addresses: 121
Total Disallowed Addresses: 2477
Total Bad Data: 79

Event Timeline

KHaggard triaged this task as Unbreak Now! priority.May 28 2024, 4:16 PM

Today's "MASTER SUPPRESSION LIST" job was completed successfully. Might be coincidental but it matches the original pattern reported, i.e. it works every other day.

From today's email:

Contact Source Name: MASTER SUPPRESSION LIST
File Name: Unsubscribes-20240529041122.csv

Job ID: 242851541
Job Description: Adding contacts to existing contact source, MASTER SUPPRESSION LIST
Job Type: Recurring Contact Source Import @ Wednesday, May 29, 2024 at 9:00:29 AM GMT
Job Status: Complete
Total Rows: 9473793
Total Valid Rows: 9468835
Total Invalid Addresses: 2400
Total Duplicate Addresses: 121
Total Disallowed Addresses: 2477
Total Bad Data: 81

I manually ran the silverpop export today and @KHaggard was able to import it successfully

@bsisolak is checking on this issue with Acoustic so we can decipher the error codes. Thanks!

KHaggard closed this task as Resolved.EditedJun 14 2024, 6:58 PM

Updating this phab ticket. We haven't heard back from Acoustic on why this was failing yet; they are still looking at it.
But given the fact that this seemed to resolve itself (the jobs have been running fine for 11 days now), I think it's appropriate to resolve this task.

Thanks for taking the time to help us look at it when it was acting strange!