无法创建一行大小###，它大于允许的最大行大小8060 [英] Cannot create a row of size ### which is greater than the allowable maximum row size of 8060

问题描述

大家好，

最近我们尝试保存产品数据时遇到此异常

Just recently we got this exception when we try to save the product data

Microsoft.CommerceServer.Catalog.CatalogDatabaseException: Could not set the category/product/variant information. ---> System.Data.SqlClient.SqlException: Cannot create a row of size 9609 which is greater than the allowable maximum row size of 8060

它开始在我们向产品定义添加新属性后发生。我们可以添加到产品定义的属性数量是否有限制？如果是，那么我在文档中找不到它的最大数量是多少。如果没有，那么
我们真的需要你对这个问题的帮助或建议。

It started happening after we added new properties to the Product Definitions. Is there a limit for the number of properties we can add to the Products Definitions? If yes, what is the maximum number since I cannot find it in the documentation. If not, then we really need your help or advice on this issue.

谢谢你，

最好的问候，

RonaldWH

谢谢你，最诚挚的问候，Ronald Wisnu Hariyanto

Thank you, Best Regards, Ronald Wisnu Hariyanto

推荐答案

它与您的SQL Server版本有关。  您已超出行限制。  如果您升级到较新版本的sql（根据本文），您的问题可能会消失，因为sql处理超出限制的方式不同。

It's more related to your version of SQL Server.  You've exceeded your row limit.  If you upgraded to a newer version of sql (per this article) your issue would probably go away because sql handles exceeding the limit differently.

http://www.teratrax.com / varchar-max-sql-server /

http://www.teratrax.com/varchar-max-sql-server/

这篇关于无法创建一行大小###，它大于允许的最大行大小8060的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！