Try our conversational search powered by Generative AI!

EPiServer 7.5 Commerce - Catalog asset publish error

EPiServer Commerce 7.5 
I tried to add a 16.7KB media file to a product variant via the CMS > Catalog UI. On publish, I receive the following error:
"String or binary data would be truncated. The statement has been terminated." 
If I remove the media file and republish, publish works successully.
Does this have to do with the number of custom meta-fields added to the Variation? There are 25 meta-fields as of the moment.
Feb 24, 2014 4:07

Found the cause:


The [CatalogItemAsset] database table only supports nvarchar(50) for the asset type while our image media file has 56 characters:




The sample commerce site luckily only had 48 characters, thus, it doesn't fail.




Mar 03, 2014 4:07

Thank you for your finding. This indeed is a bug and we've filed a bug report for it.



Mar 03, 2014 7:07
This topic was created over six months ago and has been resolved. If you have a similar question, please create a new topic and refer to this one.
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.