Sachin Hingole Rakesh Roy Venkatesh Pujari Komal Barde

Hello Swapnil Pandhare ,
Please look into this.
Thanks,
Pratap

CC: Nidhi Kaul , Vijayendra Shinde

Hello Hrishikesh Deshpande,

Please test this when it is deployed at CodeMap.

Concern : Pre-Prod-OE Testing : Getting server error when adding Child or Spouse

Cause : Data Type was defined bigint in trigger [To add value for Meritain Member Card Number field], so if EmpID is alpha numeric then it was failing and throwing server error.

Correction : Changed Data Type bigint to nvarchar for variable in trigger.

CC: Sheetal Bodhale, Swapnil Pandhare, Satya

Thanks & Regards
Amit Kumawat

Impacted Areas :

• Employee Login > Employee Workflow/ Dashboard > Add Child/ Spouse
• CA/ Partner Login > Employee Dashboard > Add Child/ Spouse

Affected Files :

• 2_NF-5788_OES_TR_trgInsEmployee_DependentChild_InsCardNumber
• 3_NF-5788_OES_TR_trgInsEmployee_DependentSpouse_InsCardNumber
• 4_NF-5788_OES_TR_trgInsEmployee_InsCardNumber

Hi Amit Kumawat

This is Company specific issue hence not able to test it on codemap.
I will verify it on pre production after deployment.

Thanks,
Sanjana Jadhav

CC: Prasad Pise Hrishikesh Deshpande Sachin Hingole Rakesh Roy

Again getting server error on UND company on Pre-prod.

Error log 1-

Exception : The required anti-forgery form field "__RequestVerificationToken" is not present.
App Error Log : -
Employee ID : 12404
Action Name : GetEmployeeProfileInfo
Model : System.Web.Mvc.HandleErrorInfo
Controller : Customization
Web Error Log : at System.Web.Helpers.AntiXsrf.TokenValidator.ValidateTokens(HttpContextBase httpContext, IIdentity identity, AntiForgeryToken sessionToken, AntiForgeryToken fieldToken)
at System.Web.Helpers.AntiXsrf.AntiForgeryWorker.Validate(HttpContextBase httpContext, String cookieToken, String formToken)
at System.Web.Helpers.AntiForgery.Validate(String cookieToken, String formToken)
at WORKTERRA.ValidateJsonAntiForgeryTokenAttribute.OnAuthorization(AuthorizationContext filterContext)
at System.Web.Mvc.ControllerActionInvoker.InvokeAuthorizationFilters(ControllerContext controllerContext, IList`1 filters, ActionDescriptor actionDescriptor)
at System.Web.Mvc.ControllerActionInvoker.InvokeAction(ControllerContext controllerContext, String actionName)

Error Log 2 -

ErrorID : 0
ErrorSource : ControllerAppTier.Save->WORKTERRAControllerAppTier.Save->EmployeeData.Save->EmployeeData.UpdateEmployeeProfile
ErrorMessage: Error converting data type nvarchar to bigint.
@AdminApprovalReqd @IsAdminVerificationApprovalFlag : 1###0
@AdminApprovalReqd @IsAdminVerificationApprovalFlag AFTER OE : 0~~~0

Hello Hrishikesh Deshpande,

Scripts wasn't executed, It will be deployed with next Pre Prod build.
Please check it when it is deployed at Pre Prod.

CC: Sheetal Bodhale, Swapnil Pandhare, Satya

Thanks & Regards
Amit K.

Hello Hrishikesh Deshpande,

Scripts are executed at Pre Prod. Please check it.

CC: Sheetal Bodhale, Swapnil Pandhare, Satya

Thanks & Regards
Amit K.

This issue is Fixed on Pre-prod.

This is Fixed on Production.