Error at Creating UDF

[Former Member]

Hi all,

We try to create an UDF in marketing documents at title level, but there is an error message "SQL Server limitation for row data length (8060 bytes)".

Please advice,

Regards.

[pedro_magueija]

Hi everyone,

I know this is an old issue, however, as of today (2015/11/26) there is an issue with creating UDF's that contain SQL code in the default value.

E.g.: Create a simple UDF in your client but place a single quote ( ' ) in the default value.

The business client will fail with that exact message. Same situation using the SDK.

This situation has been reported to SAP and we can expect a fix for a later release.

Will update this post once SAP replies.

---

Best regards,

Pedro Magueija

[former_member227598]

Hi Maria,

There is no limitation about the numbers of UDF from Business One,   

the limitation is from MS SQL server 2005.                                                                              

In SQL Server 2005, it is has limitation of the columns in one table,

A table can contain a maximum of 8,060 bytes per row, comparing to   

MS SQL Server 2000, the advantage of MS SQL 2005 is the combination  

of the columns can exceed 8060 byte, however this does not mean      

there is no limitation in MS SQL 2005.       

Please refer to the following link for more details:         

http://technet.microsoft.com/en-us/library/ms186981.aspx     

Please feel free to let us know should further clarification is needed.

Rgds

Kamlesh N

[KennedyT21]

Hi Maria...

Which SQL Server version are you using SQL 2000 / SQL 2005?

In SQL 2000, there is a maximum row size restriction of 8060 bytes.

Hope Helpful

Regards

Kennedy

[Former Member]

Hi,

We're using SQL Server 2008.

Thanks,

Regards.

[former_member687054]

Hi,

How have you solve this problem ?

Thank you

[kothandaraman_nagarajan]

Hi Maria,

It is an application error:

Please refer SAP notes:

1669863 - User-Defined Field cannot be added for specific
object

But in 8.82 PL04 version there is no such error.

Thanks & Regards,

Nagarajan

[Former Member]

Hi,

The Note 1669863 says it's an application problem that will be fixed in a patch, but there is a remark: "After the fix for this issue is delivered there will be a different error message displayed for user "SQL Server limitation for row data lenght (8060 bytes)"". That is our current error.

Any ideas on how to solve this error?

We use SB1 8.82 PL 10, and SQL Server 2008.

Thanks

Regards.

[kothandaraman_nagarajan]

Hi Maria,

Please check with another SAP notes:

816387 - Length of a single record is restricted to 8060
bytes

Hope helpful.

Thanks & Regards,

Nagarajan

[kothandaraman_nagarajan]

Hi Maria,

Reduce length of UDF and then try.

Thanks & Regards,

Nagarajan