How to get a form size for a record?

HelloCAD
Tera Contributor

Hello,

I want to know the size of one record. Let's say I want to know the form size of a change record - CHG0000001

XML import of the record is 132 KB.

I keep getting the error "java.sql.BatchUpdateException: (conn=478024) Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline." when I try to save the form.

And what could be the ideal number and Max Length of HTML and string fields present in a form.

Thank you.

5 REPLIES 5

Musab Rasheed
Tera Sage
Tera Sage

Hello,

Just export change record and see the size that's the easiest way no ?

Regards

Please hit like and mark my response as correct if that helps
Regards,
Musab

The XML import is 132 KB. 

Is that large?

Nope, it's a small size only, if query is resolved mark my answer as correct and close the thread

Please hit like and mark my response as correct if that helps
Regards,
Musab

I get this error message "java.sql.BatchUpdateException: (conn=478024) Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline: when trying to save this 132 KB size form after I give some text to a field.