Unauthorized empty column

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)

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)