Page MenuHomePhabricator

Civi to Acoustic Export: Job Status Failed
Closed, ResolvedPublicBUG REPORT

Description

Greetings Fr-Tech,

Acoustic's daily import job of files has kindly failed today:

  • ChecksumEmails
  • Optout
  • DatabaseUpdate
  • Unsubscribes

This could be due to maintenance week and just wanted to flag it here for quick reference.

Steps to replicate the issue (include links if applicable):

We receive a daily email to note if the daily export 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 messages via email:

Contact Source Name: MASTER SUPPRESSION LIST   
File Name: Unsubscribes-*

Job ID: 238920055
Job Description: Adding contacts to existing contact source, MASTER SUPPRESSION LIST
Job Type: Recurring Contact Source Import @ Thursday, November 2, 2023 at 9:00:17 AM GMT
Job Status: Failed
Total Rows: 0
Total Valid Rows: 0
Total Invalid Addresses: 0
Total Duplicate Addresses: 0
Total Disallowed Addresses: 0
Total Bad Data: 0

Contact Source Name: _all_Wikimedia   
File Name: ChecksumEmails-*

Job ID: 238920047
Job Description: Adding and updating contacts in existing contact source, _all_Wikimedia
Job Type: Recurring Contact Source Import @ Thursday, November 2, 2023 at 9:00:16 AM GMT
Job Status: Failed
Total Rows: 0
Total Valid Rows: 0
Total Invalid Addresses: 0
Total Duplicate Addresses: 0
Total Disallowed Addresses: 0
Total Bad Data: 0

Contact Source Name: _all_Wikimedia   
File Name: DatabaseUpdate-*

Job ID: 238920048
Job Description: Adding and updating contacts in existing contact source, _all_Wikimedia
Job Type: Recurring Contact Source Import @ Thursday, November 2, 2023 at 9:00:16 AM GMT
Job Status: Failed
Total Rows: 0
Total Valid Rows: 0
Total Invalid Addresses: 0
Total Duplicate Addresses: 0
Total Disallowed Addresses: 0
Total Bad Data: 0

Contact Source Name: _all_Wikimedia   
File Name: Optout-*

Job ID: 238920049
Job Description: Opting out contacts in existing contact source, _all_Wikimedia
Job Type: Recurring Contact Source Import @ Thursday, November 2, 2023 at 9:00:16 AM GMT
Job Status: Failed
Total Rows: 0
Total Valid Rows: 0
Total Invalid Addresses: 0
Total Duplicate Addresses: 0
Total Disallowed Addresses: 0
Total Bad Data: 0

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:

Job ID: 238902005
Job Description: Adding and updating contacts in existing contact source, _all_Wikimedia
Job Type: Recurring Contact Source Import @ Wednesday, November 1, 2023 at 9:00:31 AM GMT
Job Status: Complete
Total Rows: 29192379
Total Valid Rows: 29177478
Total Invalid Addresses: 1709
Total Duplicate Addresses: 11
Total Disallowed Addresses: 13180
Total Bad Data: 12

Software version (skip for WMF-hosted wikis like Wikipedia):

Other information (browser name/version, screenshots, etc.):

Event Timeline

Thanks for such a detailed report! It really helps figure things out!

The jobs were turned off last night while we did upgrade work on civi. They will be back on tonight and you should see files uploaded to Acoustic again

Thanks @Cstone :) Figured it was related to upgrade work as usual with the maintenance weeks but I appreciate you for confirming and @LMedley-WMF for logging this just in case! <3

KHaggard claimed this task.

This looks to be resolved as we had successful import jobs today. Thanks everyone! Resolving this task.