Row size too large - can't drop columns
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-17-2022 03:39 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-17-2022 03:44 AM
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
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-22-2024 03:48 AM
Hello @Ankur Bawiskar ,
Can i ask, How does SN determines the row size and replies with error like size too large?