Unauthorized empty column

[krishnakanthp76]

Hi,

I'm trying to load data from a file to profiles with extended attributes. When I try to send an empty value in a text column i'm getting Unauthorized empty column error.

Please find the configurations I did below

1. Data type: text(100)

2. Empty value management: Generate Error

3. Error processing: Use a Default value - 999

4. Value Mapping: Source - 0, Destination - 999

By using this configuration, Ideally the value should get mapped with a default value which is not happening in my case.

Please let me know if my configuration is incorrect.

[krishnakanthp76]

Does anyone have any inputs on this?

[pablo_rosero1]

Jean-Serge Biron

Amit_Kumar

Vipul Raghav

Ananya Kuthiala

[Kalladithodi]

Hi,

Try to change the allow Nulls fileds in Data Loading file format

[krishnakanthp76]

Hi,

Thank you for you reply. But This is related to Adobe Campaign Standard.

Once again thank you for your time,

[DavidKangni · Accepted solution]

Hi Krishna,

In ACS, you will need to set up your error processing as use a default value in case the value is not remapped and set up your default value. Also  try to use a string instead of 999 which acs can consider as an integer.

Thanks

David