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