This morning, the nightly import jobs ran successfully but the DatabaseUpdate summary is showing over a million rows of bad data:
Job ID: 198963192
Job Description: Adding and updating contacts in existing contact source, _all_Wikimedia
Job Type: Recurring Contact Source Import @ Tuesday, March 29, 2022 at 9:00:53 AM GMT
Job Status: Complete
Total Rows: 1037437
Total Valid Rows: 0
Total Invalid Addresses: 279
Total Duplicate Addresses: 0
Total Disallowed Addresses: 0
Total Bad Data: 1037158
Normally, bad data = 0 like March 28th's export:
Job ID: 198914969
Job Description: Adding and updating contacts in existing contact source, _all_Wikimedia
Job Type: Recurring Contact Source Import @ Monday, March 28, 2022 at 9:00:42 AM GMT
Job Status: Complete
Total Rows: 115905
Total Valid Rows: 115875
Total Invalid Addresses: 3
Total Duplicate Addresses: 0
Total Disallowed Addresses: 27
Total Bad Data: 0
The error code is: "Email Address Not Found in Row", so it seems like the file that was sent to FTP had over a million blank rows. The other files look fine, so this is only affecting the DatabaseUpdate-* file.
We have an email send going out tomorrow, so I'm setting this task at "unbreak now" priority. Thanks!