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

[ladislav_meszaros]

Hi Brent,

There is a limitation of 8060 for record, as described in note 798432:

"Length of record in single record is restricted to 8060 bytes in MSSQL and Sybase.

The total length (sum of all fields) of a record in an MSSQL and Sybase table cannot be longer than 8060 bytes. This restricts the number of fields that may be added to a table".

Please refer to the mentioned SAP Note [798432|https://websmp130.sap-ag.de/sap(bD1odSZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=798432] and run the procedure as described to check if the mentioned issue affects your database.

hope it helps,

Regards,

Ladislav

SAP Business One Forum Team