Five New Optimizely Certifications are Here! Validate your expertise and advance your career with our latest certification exams. Click here to find out more
AI OnAI Off
EPiServer 7.5 Commerce - Catalog asset publish error
Vote:
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:
e.g.
EpiServer7app.EpiServerCore.ContentTypes.Media.ImageFile
The sample commerce site luckily only had 48 characters, thus, it doesn't fail.
Mar 03, 2014 4: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.
