PRB617735 How should I count the Row Size?

Yuri Yoshinami
Tera Contributor

Hi, all.

I got the error message which says"  Syntax Error or Access Rule Violation detected by database (Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs)..".

I have reduced the max length of each column from 100 to 40 of 30 columns, which means I have reduced 1800(60 * 30) in max length in total.

Succeftly, I don't see the error msg any more, and currently I have 147,870 in total for the max length of all the columns in the same table. (Max length > Configure > List calculations)

 

Could you kindly tell me the way to count all the row size on the table?

I need to upgrade to Madrid version in May and am wondering whether the error msg comes out agian.

 

*I have seen through the website below, the error message is a bit different though.

PRB617735  <<https://hi.service-now.com/kb_view.do?sysparm_article=KB0584932>>

 

 

 

find_real_file.png

6 REPLIES 6

jacob_kimball
ServiceNow Employee
ServiceNow Employee

I am not entirely sure it something you'll be able to do yourself. However, ServiceNow support should be able to help.  If you put in a ticket with them, reference the following KB article: KB0689595. This KB details to our support how to ID orphaned rows as well as rows that are impacting this number more than others. 

Thank you, jacob.

I will ask for the SN support!

 

 

 

shanedavis
Tera Expert

Hi, I am curious how you resolved this issue now that it has been 5 years from your original post.  Thank you!

As stated previously, you will want to contact Support. Essentially, it's a limitation of the MySQL database and you will need to reduce the overall table row size. While you (or someone on your team) will have to decide how best to do that, ServiceNow Support can provide a breakdown of what fields are the highest contributors.