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
