PRB617735 How should I count the Row Size?

Yuri Yoshinami
Tera Contributor

‎04-10-2019 12:21 AM

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

Labels:
Preview file
12 KB
0 Helpfuls
  • 2,702 Views
6 REPLIES 6

Community Alums
Not applicable
In response to Paige Duffey

‎10-22-2024 04:05 AM

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?

 

0 Helpfuls

Community Alums
Not applicable

‎10-22-2024 03:51 AM

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 ?

0 Helpfuls