Showing results for 
Show  only  | Search instead for 
Did you mean: 


Attempts to create or update a purchase record may fail if the record has a value in the Part No./SKU field that contains more than 2 occurrences of any of the following characters appearing within the first 7 characters: \ % _ [ ]


The issue occurs due to a data processing error that can occur when the problematic characters are used within the first 7 characters of a SKU value.

Logging associated with this issue may include the following error message:

String or binary data would be truncated. The statement has been terminated.

This issue affects creating and updating purchase records through any interface, including the web UI, business adapters, and procurement data spreadsheet uploads.


Avoid using more than 2 occurrences of the problematic characters in the first 7 characters of SKU values on purchase records.

Fix status

There are no plans to address this issue.

Other information

Affected components: Business adapters, Purchase management, Web UI

Master issue ID: IOK-929475

Also known as: ITAM-2018

Was this article helpful? Yes No
No ratings
Version history
Last update:
‎Nov 20, 2023 01:33 PM
Updated by:
Knowledge base article header content