Re-enabling B1 Print & Delivery causes error -2110 SQL Server limitation for row data length (8060 bytes)

B1 Usability Package [ID: BOY_USABILITY (x86)] [Add-On Version: 2016.0.3.2]

[SAP Version: Sbo91Unified (910180)]

B1P&D license ran out and a new one was created.

Company was copied to a TEST database with "Copy Data between Companies" under Implementation.

Re-enabling B1P&D causes the error for tables BOY_85_DEL_LOG and BOY_85_DYN_SYN .

Can not use B1UP at all.

Workaround: use SQL Mgmt Studio to script the creation of the tables from the original company and then it works again.

Detailed errors follow.

Error adding UDF: BOY_DATE in table: BOY_85_DEL_LOG (-2110 - SQL Server limitation for row data length (8060 bytes))

Source: SBO_Functions | Method failed: Void Add(System.String, System.String, System.String, Int32, SAPbobsCOM.BoFieldTypes, SAPbobsCOM.BoFldSubTypes, System.String, Boolean, System.String, SBO.DI.Metadata.UserDefinedFieldsValidValues, Boolean ByRef)

SBO.UdfException: Error adding UDF: BOY_DATE in table: BOY_85_DEL_LOG (-2110 - SQL Server limitation for row data length (8060 bytes))
at SBO.DI.Metadata.UserDefinedFields.Add(String tableUid, String fieldUid, String description, Int32 size, BoFieldTypes type, BoFldSubTypes subType, String defaultValue, Boolean mandatory, String linkedTable, UserDefinedFieldsValidValues validValues, Boolean& metadataChanges)
at SBO.DI.Metadata.UserDefinedFields.AddDate(String tableUid, String fieldUid, String description, Boolean& metadataChanges)
at B1Print.Module.SetupFields(Boolean& metadataChanges) in C:\TFS\B1 Usability Package\Main\Source\Code\Modules\B1PrintAndDelivery\Module.cs:line 892
at Config.Controller.SubModuleController.ReadySubModules(AddonData addonData, SubModuleCollection subModules, UpdateSource updateSource) in C:\TFS\B1 Usability Package\Main\Source\Code\Modules\Config\Controller\SubModuleController.cs:line 126
at Config.Controller.SubModuleController.ReadySubModules(AddonData addonData, SubModuleCollection subModules, UpdateSource updateSource) in C:\TFS\B1 Usability Package\Main\Source\Code\Modules\Config\Controller\SubModuleController.cs:line 122
at Config.Module.SetupData() in C:\TFS\B1 Usability Package\Main\Source\Code\Modules\Config\Module.cs:line 719
at SBO.AddonLogic.Addon.SetupData()
at SBO.AddonLogic.Addon.Start(AddonData addonData, AddonModules addonModules)

Error adding UDF: BOY_FORMTYPE in table: BOY_85_DYN_SYN (-2110 - SQL Server limitation for row data length (8060 bytes))

SBO.UdfException: Error adding UDF: BOY_FORMTYPE in table: BOY_85_DYN_SYN (-2110 - SQL Server limitation for row data length (8060 bytes))
at SBO.DI.Metadata.UserDefinedFields.Add(String tableUid, String fieldUid, String description, Int32 size, BoFieldTypes type, BoFldSubTypes subType, String defaultValue, Boolean mandatory, String linkedTable, UserDefinedFieldsValidValues validValues, Boolean& metadataChanges)
at SBO.DI.Metadata.UserDefinedFields.AddAlphaRegular(String tableUid, String fieldUid, String description, Int32 size, Boolean& metadataChanges)
at B1Print.Module.SetupFields(Boolean& metadataChanges) in C:\TFS\B1 Usability Package\Main\Source\Code\Modules\B1PrintAndDelivery\Module.cs:line 962
at Config.Controller.SubModuleController.ReadySubModules(AddonData addonData, SubModuleCollection subModules, UpdateSource updateSource) in C:\TFS\B1 Usability Package\Main\Source\Code\Modules\Config\Controller\SubModuleController.cs:line 126
at Config.Controller.SubModuleController.ReadySubModules(AddonData addonData, SubModuleCollection subModules, UpdateSource updateSource) in C:\TFS\B1 Usability Package\Main\Source\Code\Modules\Config\Controller\SubModuleController.cs:line 122
at Config.Module.SetupData() in C:\TFS\B1 Usability Package\Main\Source\Code\Modules\Config\Module.cs:line 719
at SBO.AddonLogic.Addon.SetupData()
at SBO.AddonLogic.Addon.Start(AddonData addonData, AddonModules addonModules)

Regards, DL