Customer exports fail due to invalid characters in Address ID field
Last updated 17 days ago ·Reference W-4450178 ·Reported By 1 users
In Review
Summary
Attempts to export customers fail with a simpleType.Generic.NonEmptyString.256 error that indicates that there is invalid data in the address-id element.
Repro
This can be reproduced when exporting customers using any of the following methods:
- The Export functionality in Business Manager under Merchant Tools > Customers > Import & Export
- The ExportCustomerList and ExportCustomers job steps
- The ExportCustomerList and ExportCustomers piplets
An example of the error seen when exporting via Business Manager is below:
[2020-07-21 19:21:58.126 GMT] ERROR [customer:00000001] cvc-pattern-valid: Value '123 Salesforce Drive
San Francisco, CA 94105' is not facet-valid with respect to pattern '\S|(\S(.*)\S)' for type 'simpleType.Generic.NonEmptyString.256'.
[2020-07-21 19:21:58.127 GMT] ERROR [customer:00000001] cvc-attribute.3: The value '123 Salesforce Drive
San Francisco, CA 94105' of attribute 'address-id' on element 'address' is not valid with respect to its type, 'simpleType.Generic.NonEmptyString.256'.
.
.
.
[2020-07-21 19:24:38.127 GMT] ERROR Internal fatal error. Details: ErrorMsg=Export failed due to internal XML mapping problems (1 elements have been skipped). The problem is likely caused by invalid data. Please use the information in the log above to correct the problem so that future exports do not result in skipped elements.; LogFileName=export-customer-202007211924387-0.log; error=Internal fatal error.
[2020-07-21 19:24:38.127 GMT] INFO Export: End
Workaround
Remove the data in the Address ID field that contains the invalid characters.
Reported By (1)
Any unreleased services, features, statuses, or dates referenced in this or other public statements are not currently available and may not be delivered on time or at all. Customers who purchase our services should make their purchase decisions based upon features that are currently available.
