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

Community Alums
Not applicable

Hello @Paige Duffey  Thanks for the insight, by any change do we know how SN determines the row size, if any OOTB function present to be used in script which can share the row size?

 

Community Alums
Not applicable

Hello @Paige Duffey , Thanks for the input, do you know how SN decides the row size if there are any scripting function which can help us get that value ?