RetailerID Type Schema Definition results in truncation of value in downstream system. #8
Description
This schema defines RetailerID as of type MandatoryString (String, MinLength=1) which results in an unbounded MaxLength.
RetailerID XML Values are staged out of the provided XML and into a reference/ cache type table, in which, the column containing this value has a length constraint (of unicode string, maxlength = 20).
Impact:
During the import process, where a value is provided which has a length greater than 20 characters, this results in arbitrary "left-indexed" string truncation.
Mitigation:
Current advice is that, where RetailerId has significance to the Customer, a maxlength constraint of 20 characters should be applied. If this is not possible, please contact your Nielsen Brandbank Account Manager or a member of the Integration team via the Integration Support Portal so that this can be prioritised accordingly.
Internal Ticket Reference INTD-905