This issue is again produced today on Production, company Long, during testing of JIRA WT-9529. It is observed in Partner and Employee login both. PFA screen shot and error log.

Exception : Length of LOB data (89506) to be replicated exceeds configured maximum 65536.The statement has been terminated.
App Error Log : ControllerAppTier.Save->WORKTERRAControllerAppTier.Save->EmployeeFormBuilder.Save->EmployeeFormBuilder.UpdateFormBuilderAttribute
Employee ID : 1613
Action Name : GetEmployeeFormBuilderInfo
Model : System.Web.Mvc.HandleErrorInfo
Controller : Customization
Web Error Log : at WORKTERRA.Shared.WORKTERRAControllerWebTier.Save(ObjectType I_objectType, Object objInputObject, Object I_context, Boolean I_mode)
at WORKTERRA.Shared.Areas.Customization.Models.EmployeeFormBuilderModel.UpdateFormBuilderAttribute(EmployeeData objEmployeeData, Int32 PageID, String

PageTitle)
at WORKTERRA.Shared.Areas.Customization.Models.EmployeeFormBuilderModel.SaveAdditionalForm(EmployeeProfileModel objEmployeeFormBuilder, EmployeeData

objEmployeeData)
at WORKTERRA.Shared.Areas.Customization.Controllers.CustomizationController.GetEmployeeFormBuilderInfo(EmployeeProfileModel objEmployeeFormBuilder)
at lambda_method(Closure , ControllerBase , Object[] )
at System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary`2 parameters)
at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2

parameters)
at System.Web.Mvc.ControllerActionInvoker.<>c_DisplayClass13.b_10()
at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation)
at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation)
at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodWithFilters(ControllerContext controllerContext, IList`1 filters, ActionDescriptor

actionDescriptor, IDictionary`2 parameters)
at System.Web.Mvc.ControllerActionInvoker.InvokeAction(ControllerContext controllerContext, String actionName)

Hello Rajendra Joshi,

This issue occurred because of database server settings for 'Max Text Replication Size' property. As per discussion with Indraprakash Tiwari, he has changed the value of this property appropriately which will resolve this issue.

Can you please verify and confirm if the issue is resolved.

Thanks,
Shubhangi

CC Swapnil Pandhare

Verified on Production using company long. This issue is resolved now. It is verified in employee and partner login. Form containing long text strings with complex signature is saved without any server error. PFA screen shots

Please deploy this fix on LB as per process.

CC: Swapnil Pandhare, Hrishikesh Deshpande

Hi Shubhangi Jadhav,

As per discussion please deploy this on LB and then stage as per our discussion before.

With Best Regards
Rajendra Joshi

Hello Indraprakash Tiwari,

As per our discussion, to fix this issue you had to change database server settings for 'Max Text Replication Size' property.

This change is done on Production but as oper our QA Rajendra Joshi this issue needs to be fixed on LB and Stage as well. Can you please look into this.

Thanks,
Shubhangi

CC Swapnil Pandhare

Indraprakash Tiwari
Can you please make the required changes and close the ticket?

Thanks,
Nidhi.

Rajendra Joshi

I did required changes on Stage and LB. Please review and close this ticket if everything working as per expectation.

Regards,
Indra

Verified on Stage and LB using company LONG for HSPL. Above issue is resolved now.