on 11-30-2011 8:06 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.