Skip to Content
0
Former Member
Dec 12, 2011 at 01:54 PM

[B1 2004C] Can't add a valid value to a UDF

245 Views

Hello all,

I am trying to modify a user-defined field in marketing documents' title on a client's database and, after a long pause during which the client is unresponsive, get the following error in the status bar on red background:

"The table "ADOC" has been created but its maximum row size 'Service Contract'(8570) exceeds the maximum number of bytes per row (8060). Insert or Update of a row in this table will fail."

and after a shorter freeze I am returned to the "Manage User Fields..." window, but another inspection of said UDF shows that the change was not applied.

I have checked the max. row size of the ADOC table, and it is far from the limit u2014 7444 bytes.

More interesring is that I am just adding a valid value for a field, which in no way should affect the corresponding table's max. row size. I also have no idea why 'Service Contract' is mentioned, because it has nothing to do with ADOC...

A simultaneously maintained "test" version of the same database with a virually identical structure of the problematic table does not evince this error, so I suggest the culprit is some corruption of B1's metadata in the "working" DB.

Could you help me to resolve this issue?

Anton