Audience import failure (Shared Audience Failure)

Description

Out of box Technical workflow ‘Import audiences from the Adobe Marketing Cloud’ (importSharedAudience)\ is failing  due to 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

Usually such problem comes there is any data issue with the the file  which comes from Audience Manager i.e ftp_0000_0000_full_000000_0000000.sync"

If we check the Data Loading activity on the importSharedAudience workflow we  will see that It expects a flat file with two columns only so as to extract Operator ID and Segment ID.

Column delimiter is SPACE

As per the error message

Error extract

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’)

The incoming file has more than 2 columns delimited by space.  In such cases  we need to check the contents of this file to make sure there should not be any rows with more than one SPACE.

If  there are any data in the file  which has more than one space we need correct the data so that file can be reprocessed

On this page