Expand my Community achievements bar.

SOLVED

Unauthorized empty column

Avatar

Level 2

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.

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

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



David Kangni

View solution in original post

5 Replies

Avatar

Level 2

Does anyone have any inputs on this?

Avatar

Employee

Hi,

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

1757691_pastedImage_0.png

Avatar

Level 2

Hi,

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

Once again thank you for your time,

Avatar

Correct answer by
Community Advisor

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



David Kangni