You’re offline. This is a read only version of the page.
10
Hello D365 Community!
I have encountered a rather odd issue...I am attempting to import new products into our D365 instance but am met with the following error: "Sql error: Generic SQL error. CRM ErrorCode: -2147204784 Sql ErrorCode: -2146232060 Sql Number: 2628". I have looked up the error code 2628 here and found that the code is defined as "String or binary data would be truncated in table '%.*ls', column '%.*ls'. Truncated value: '%.*ls'.".
After some testing, I've narrowed it down to the name of certain products being too long, anything over 100 characters specifically. Oddly enough, the text field properties for product.name allow for up to 300 characters per our custom needs, and I have verified that the maximum product name length in this import is less than 150 characters long. I wonder why it's throwing an error then?
For your reference, part of my testing included parsing the product names and only keeping the first 100 characters and upon import via that test I achieved 100% success. So I have verified that the product name length is the issue. As a side note - I did go ahead and bump up the maximum character limit to 350 to see if that would "reset" anything but I am still hit with failures when attempting to import the full names.
We recently migrated from Dynamics On-Premise to D365 - I wonder if that would have anything to do with this?
I appreciate any suggestions in advance - thank you!!!
- Jared
Thank you for your input Adrian. Unfortunately that is not the issue I am experiencing here. I have verified that the destination column's length is 350 characters, while the source data's maximum character length is less than 150 characters - yet D365 still "thinks" that it will be truncated for some reason.
Hi Jared Moore,
One of the columns in the source data is larger than its corresponding destination column. You will need to increase the size of the destination column causing the issue, or alternatively if it is acceptable for the data to be truncated then you can turn off the warning and allow the truncation to take place.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (