Row size too large

[manojjain4328]

Hello Friends,

I got one starange issue in my end when i am creating new form so system generates one error

"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. You have to change some columns to TEXT or BLOBs)"

please help me to find out the solution of this error.

Thanks,
Manoj

[nancyhz]

Hi Mike,

I don't see   com.glide.loader.verify_target_field_size in   System Property [sys_properties].   DO I need to add this property myself?

[hslau]

Hello.

I checked my instance, and I don't have it either in sys_properties.list. This article:

http://wiki.servicenow.com/index.php?title=Available_System_Properties

In it, it mentions you can add it:

com.glide.loader.verify_target_field_size Controls whether import set fields can automatically increase in size during an import (true) or not (false). By default, data that exceeds the import field size is truncated. Set this property to true to allow any import set field to increase the column size to match the length of the data.

• Type: true | false
• Default value: false
• Location: Add to the System Property [sys_properties] table

[sergiu_panaite]

Hi Manoj,

The error you are referring to is a database error. When you create that form you are probably adding new fields, and that error shows that on the table you are trying to add the fields, the maximum length of all fields is exceeding a particular size.

This is a database limitation and workaround is to drop some unused or unnecessary columns (especially text column types).

Hope this helps.

Regards,

Sergiu

[Claudia Pellegr]

Hello,

I have the same issue described above: 

"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. You have to change some columns to TEXT or BLOBs)".

Is there any other solution other than drop some unused or unnecessary columns? 

Thank you.