PRB617735 How should I count the Row Size?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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>>
- Labels:
-
Best Practices
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-23-2019 10:09 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-23-2019 05:10 PM
Thank you, jacob.
I will ask for the SN support!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-01-2024 01:18 PM
Hi, I am curious how you resolved this issue now that it has been 5 years from your original post. Thank you!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-06-2024 11:18 AM
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.