Row size too large - can't drop columns

Claudia Pellegr
Kilo Contributor

Hello, 

when creating new fields in a custom table I had this issue:

"Syntax Error or Access Rule Violation detected by database ((conn=1069664) 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)".

As a result, the field was created, but the label was "invisible" in the list.

Is there any workaround which doesn't involve dropping unused or unnecessary columns? 

Thank you.

2 REPLIES 2

Ankur Bawiskar
Tera Patron
Tera Patron

Hi,

ServiceNow restricts it OOB

check this link where there are discussions around this and some useful tips

Row size too large (> 8126) - Working with string heavy requirements

Regards
Ankur

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

Community Alums
Not applicable

Hello @Ankur Bawiskar ,

Can i ask, How does SN determines the row size and replies with error like size too large?