Audience import failure (Shared Audience Failure)

Description

Environment
Campaign Classic
Issue/Symptoms
Out-of-box Technical workflow Import audiences from the Adobe Marketing Cloud (importSharedAudience) is failing, due to the below mentioned error

fileImport    Too many columns (2 expected(s))

fileImport    Start loading file ‘/usr/local/neolane/nl6/var/instancename/workflow/wf-importSharedAudience/fileTransfer/ftp_000_000_full_000000_00000.sync’ into the database (step ‘Load IDs and segments’)

Resolution

To resolve this issue, check the contents of this file to ensure that there aren’t any rows with more than one SPACE. The importSharedAudience workflow expects a flat file with two columns only to extract the Operator ID and Segment ID.

If there is any data in the file which has more than one space, correct the data so that the file can be reprocessed.

Cause

Usually, this error occurs when there is any data issue with the the file which comes from the Audience Manager i.e.,  ftp_0000_0000_full_000000_0000000.sync

Check the Data Loading activityon the importSharedAudience workflow. You will see that, it expects a flat file with two columns only to extract Operator ID and Segment ID.

The column delimiter is SPACE

As per the error message, the incoming file has more than 2 columns delimited by space.

fileImport    Too many columns (2 expected(s))

fileImport    Start loading file ‘/usr/local/neolane/nl6/var/instancename/workflow/wf-importSharedAudience/fileTransfer/ftp_0000_0000_full_000000_000000.sync’ into the database (step ‘Load IDs and segments’)

On this page