Internal error when adding UDF

[Former Member]

Hello,

I have been getting an error "Internal error (1) occurred Message 131-183" when I try to create a UDF in the Marketing Documents category. Normally I'm able to do this, but the other day I deleted a UDF (a different one than the one I'm adding) that I wanted to clean out of the system and I'm pretty sure that having deleted this UDF is causing me to not be able to add any new UDFs to the Marketing Documents category. The UDF I deleted had never been used and I'm almost positive it never had any data in it. I am able to modify and add to other UDF categories though.

I need to add these UDFs to the Marketing Documents category hopefully today or tomorrow. If someone has any ideas that would fix this problem, please let me know.

Thank you,

Brent McDonell

[Former Member · Accepted solution]

Hi,

The issue reported is mostly known due to SQL 2000 Server row length

limitation.Please refer to the SAP note number:816387 and run the attached

query in the corresponding database and check whether the marketing

document table using the UDF,is exceeding the limits.

The solution to this problem is to decrease the size of the

User Defined Fields. Either by decreasing the length or changing

the definition of "Alpahnumeric" fields to Text, or the last resort

is to remove the fields.

All these actions have to be done via the SAP Business One application.

The change of field type alphanumeric to Text might influence the

performance.

Regards,

Abhinav Banerjee

SAP Business One Forums Team

Edited by: Abhinav Banerjee on Nov 22, 2008 2:40 AM