Try our conversational search powered by Generative AI!

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.
 
#81672
Feb 24, 2014 4:07
Vote:
 

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.

 

 

 

#81967
Mar 03, 2014 4:07
Vote:
 

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

Regards.

/Q

#81968
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.