Error when creating Extension fields

[Former Member]

Hi,

We are on Sourcing 7, SP02. We are create many extension fields for Master agreements.

We created about 10-15 fields and for the next new field that we are creating - we are getting the error

"Your changes cannot be saved because doing so would exceed the allowable database row length (32,056/32000 bytes)."

This looks like a DB size issue. This is happening only with a new string field (most of the other extensions we created before this were string).

We were able to create a VLV type field for MA without any issue.

Can someone point out what could be the issue?

Regards,

Srivatsan

[Former Member]

Hi,

All field extensions defined for an object are stored in a single table. Depending on the DB, there is a limit on how big the size of the row can be.. Looks like you have exceeded the maximum limit that can be on a single table.

I would suggest looking at using BigText data type instead of using a string column of larger length for extensions , as they would be stored as BLOB internally in a different page in the DB.

Other option is to model as Extension collection, which internally is stored in a seperate table. But this should be your last resort.

Thanks, Baski