PRODUCTION ERROR LOGS ErrorID : 0 ErrorSource : ControllerAppTier.Save->WORKTERRAControllerAppTier.Save->EmployeeData.Save->EmployeeData.UpdateEmployeeProfile ErrorMessage: Violation of UNIQUE KEY constraint 'IX_Employee_Payroll_EmployeeID'. Cannot insert duplicate key in object 'dbo.Employee_Payroll'. The duplicate key value is (1042). StackTrace: at WORKTERRA.Shared.WORKTERRAControllerAppTier.Save(WORKTERRAControllerWebTierEntity objWORKTERRAControllerWebTierEntity) at WORKTERRA.ControllerAppTier.Save(Int32 intProjectsId, String strInput) TargetSite: System.String Save(WORKTERRA.Shared.WORKTERRAControllerWebTierEntity) ------------------------------------------------------------------------------------- Exception : Violation of UNIQUE KEY constraint `IX_Employee_Payroll_EmployeeID`. Cannot insert duplicate key in object `dbo.Employee_Payroll`. The duplicate key value is (1042). App Error Log : ControllerAppTier.Save->WORKTERRAControllerAppTier.Save->EmployeeData.Save->EmployeeData.UpdateEmployeeProfile Employee ID : 0 Action Name : GetEmployeeProfileInfo 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.EmployeeProfileModel.UpdateEmployeeAttribute(EmployeeData EmployeeAttributeObj, EmployeeDataScreen& objUserDetails, Int32 I_TableRef, Int32 I_SaveAndContinue) at WORKTERRA.Shared.Areas.Customization.Models.EmployeeProfileModel.SaveProfile(EmployeeData objEmployeeData, EmployeeDataScreen& objUser, Int32 I_TableRef, Int32 I_SaveAndContinue) at WORKTERRA.Shared.Areas.Customization.Controllers.CustomizationController.GetEmployeeProfileInfo(EmployeeProfileModel Obj_EmployeeProfileModel) 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.InvokeAction(ControllerContext controllerContext, String actionName) ============================================================================================================ STAGE ERROR LOGS ErrorID : 0 ErrorSource : ControllerAppTier.Save->WORKTERRAControllerAppTier.Save->EmployeeData.Save->EmployeeData.UpdateEmployeeProfile ErrorMessage: Violation of UNIQUE KEY constraint 'IX_Employee_Payroll_EmployeeID'. Cannot insert duplicate key in object 'dbo.Employee_Payroll'. The statement has been terminated. 0 1042 Dec 5 2017 12:00AM 0 4 0 0 StackTrace: at WORKTERRA.Shared.WORKTERRAControllerAppTier.Save(WORKTERRAControllerWebTierEntity objWORKTERRAControllerWebTierEntity) at WORKTERRA.ControllerAppTier.Save(Int32 intProjectsId, String strInput) TargetSite: System.String Save(WORKTERRA.Shared.WORKTERRAControllerWebTierEntity) -------------------------------------------------------------------------------------------------- Exception : Violation of UNIQUE KEY constraint `IX_Employee_Payroll_EmployeeID`. Cannot insert duplicate key in object `dbo.Employee_Payroll`.The statement has been terminated.01042Dec 5 2017 12:00AM0400 App Error Log : ControllerAppTier.Save->WORKTERRAControllerAppTier.Save->EmployeeData.Save->EmployeeData.UpdateEmployeeProfile Employee ID : 0 Action Name : GetEmployeeProfileInfo 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.EmployeeProfileModel.UpdateEmployeeAttribute(EmployeeData EmployeeAttributeObj, EmployeeDataScreen& objUserDetails, Int32 I_TableRef, Int32 I_SaveAndContinue) at WORKTERRA.Shared.Areas.Customization.Models.EmployeeProfileModel.SaveProfile(EmployeeData objEmployeeData, EmployeeDataScreen& objUser, Int32 I_TableRef, Int32 I_SaveAndContinue) at WORKTERRA.Shared.Areas.Customization.Controllers.CustomizationController.GetEmployeeProfileInfo(EmployeeProfileModel Obj_EmployeeProfileModel) at lambda_method(Closure , ControllerBase , Object[] ) at System.Web.Mvc.ActionMethodDispatcher.Execute(ControllerBase controller, Object[] parameters) 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__DisplayClass15.b__12() at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation) at System.Web.Mvc.ControllerActionInvoker.<>c__DisplayClass15.<>c__DisplayClass17.b__14() at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation) at System.Web.Mvc.ControllerActionInvoker.<>c__DisplayClass15.<>c__DisplayClass17.b__14() 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)