Solved

Unauthorized empty column

Forum|Forum|6 years ago
February 20, 2019
5 replies
3883 views

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.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Best answer by DavidKangni

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

K

krishnakanthp76Author

Does anyone have any inputs on this?

Adobe Employee

Hi,

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

K

krishnakanthp76Author

Hi,

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

Once again thank you for your time,

DavidKangni

Accepted solution

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.

Thanks

David

David Kangni

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded