Unauthorized empty column

Avatar

Avatar

krishnakanthp76

Avatar

krishnakanthp76

krishnakanthp76

20-02-2019

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.

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

DavidKangni

MVP

Avatar

DavidKangni

MVP

DavidKangni
MVP

27-05-2019

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.

1760842_pastedImage_0.png

Thanks

David

Answers (4)

Answers (4)

Avatar

Avatar

krishnakanthp76

Avatar

krishnakanthp76

krishnakanthp76

22-05-2019

Hi,

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

Once again thank you for your time,

Avatar

Avatar

Kalladithodi

Employee

Avatar

Kalladithodi

Employee

Kalladithodi
Employee

22-05-2019

Hi,

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

1757691_pastedImage_0.png

Avatar

Avatar

krishnakanthp76

Avatar

krishnakanthp76

krishnakanthp76

24-02-2019

Does anyone have any inputs on this?