Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

Unauthorized empty column

krishnakanthp76
Level 2
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
DavidKangni
Correct answer by
Community Advisor
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

View solution in original post

5 Replies
Kalladithodi
Employee
Employee

Hi,

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

1757691_pastedImage_0.png

krishnakanthp76
Level 2
Level 2

Hi,

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

Once again thank you for your time,

DavidKangni
Correct answer by
Community Advisor
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

View solution in original post