London Dev Meetup Rescheduled! Due to unavoidable reasons, the event has been moved to 21st May. Speakers remain the same—any changes will be communicated. Seats are limited—register here to secure your spot!

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.