Skip to Content
avatar image
Former Member

Cannot add UDF to table once it's replicated

Hi

I’m currently working on setting up database replication (transactional) on a MS SQL Server 2012 for a customer . After setting up the replication, SAP B1 fails on creating a new UDF. I get the following error: "SBO.UdfException: Error adding UDF: BOY_MAIN_DB in table: BOY_D4_CONFIG (-2110 - SQL Server limitation for row data length (8060 bytes))"

The error occurs both when creating the UDF using the SDK and manually in SAP B1. I tried to add the column (UDF) using SQL: ALTER TABLE [@BOY_D4_CONFIG] ADD [BOY_MAIN_DB] nvarchar(254). Please note that I'm aware of that this it is not allowed, I simply did it to see if it is MS SQL Server that is throwing an error or SAP B1. It was possible to add the column using SQL, which indicates that the error is not coming from MS SQL Server, but SAP B1.

Using the MS SQL Server Profiler, it looks like SAP B1 is executing several stored procedures, before trying to add the column. It seems to me like the procedures execute some sort of validation, whic h in the end makes the creation fail.

Have any of you had the same issue? Is there a work around for this?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Jan 09, 2015 at 10:12 AM

    Dear Micha,

    What is your SAP Business One Version?

    Best Regards,

    Antonis

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 12, 2015 at 01:41 AM
    Add comment
    10|10000 characters needed characters exceeded