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

Known Issue: Purchase records may fail to save if the first 7 characters in the SKU field contain more than 2 occurrences of \, %, _, [ or ] (IOK-929475)

Known Issue: Purchase records may fail to save if the first 7 characters in the SKU field contain more than 2 occurrences of \, %, _, [ or ] (IOK-929475)

Summary

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: \ % _ [ ]

Details

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.

Mitigation

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

Fix status

This issue is still open but not currently scheduled to be addressed.

Other information

Affected components: Business adapters, Purchase management, Web UI

Master issue ID: IOK-929475

Also known as: FNMS-76341

Labels (1)
Was this article helpful? Yes No

Tip: If you have been impacted by this issue, please click the KUDOS button above. This helps to track the relative significance and importance of issues. Clicking on an option against "Was this article helpful?" also helps assess and improve the usefulness of content.

No ratings
Version history
Last update:
‎Sep 09, 2022 02:33 AM
Updated by: