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

[Former Member]

Thanks everyone for your help. This was indeed my problem. It kind of stinks that Microsoft imposes this limit. Luckily I had some UDFs we weren't using that were fairly large. I ended up having to delete them to make room for the new ones I was trying to create.

Thanks again to everyone who replied,

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

[jitin_chawla]

Hi Brent,

Check this Note [816387|https://websmp130.sap-ag.de/sap(bD1odSZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=816387] and see if it is of any help in your case.

Regards,

Jitin

[svasquez8]

Hola, ya no existen las notas