-
Type:
Bug
-
Status: Closed
-
Priority:
High
-
Resolution: Bug Fixed
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: UI Refresh
-
Labels:None
-
Environment:Pre Production
-
Bug Severity:Medium
-
Level:Employee
-
Module:BenAdmin
-
Reported by:Harbinger
-
Company:UND
-
Item State:Stage QA - Production Deployment on Hold
We got server error while we tried to add Child or spouse.
Test User Details:
Company : UND
Userid: obasi9632587418741
Password: Password@1
Steps to reproduce:
1. Create one use
2. Login with created user
3. Traverse OE workflow
4. On Child page – try to add child
5. You will get an server error
Error Log: 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
- relates to
-
NF-5728 Pre-Prod Company testing Time Update Jira
-
- Reopen
-
Shaikh Ateeque (Inactive)
created issue -
| Field | Original Value | New Value |
|---|---|---|
| Priority | Medium [ 3 ] | High [ 2 ] |
| Component/s | UI Refresh [ 10902 ] | |
| UAT For | UI Refresh [ 16600 ] |
Hello Swapnil Pandhare ,
Please look into this.
Thanks,
Pratap
CC: Nidhi Kaul , Vijayendra Shinde
| Assignee | Vijayendra Shinde [ ID10506 ] | Swapnil Pandhare [ swapnil.pandhare ] |
Shaikh Ateeque (Inactive)
made changes -
| Assignee | Swapnil Pandhare [ swapnil.pandhare ] | Amit Kumawat [ amit.kumawat ] |
Mukund Patil (Inactive)
logged work - 24/Jan/18 04:39 PM -
- Time Spent:
- 2h
-
- Issue analysis on pre-prod and code map
- Discussion with pratap
| Status | Open [ 1 ] | In Development [ 10007 ] |
| Developer | Amit Kumawat [ amit.kumawat ] | |
| Item State | Parent values: Development(10200)Level 1 values: In Analysis(10204) |
| Item State | Parent values: Development(10200)Level 1 values: In Analysis(10204) | Parent values: Development(10200)Level 1 values: In Progress(10206) |
Sheetal Bodhale (Inactive)
made changes -
| Remaining Estimate | 0h [ 0 ] | |
| Time Spent | 0.5h [ 1800 ] | |
| Worklog Id | 102054 [ 102054 ] |
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 :
| Assignee | Amit Kumawat [ amit.kumawat ] | Hrishikesh Deshpande [ hrishikesh.deshpande ] |
| Time Spent | 0.5h [ 1800 ] | 7.5h [ 27000 ] |
| Worklog Id | 102076 [ 102076 ] |
Sheetal Bodhale (Inactive)
logged work - 26/Jan/18 12:16 AM -
- Time Spent:
- 0.5h
-
Discussion with amit and satya
Trigger finding
-
- Time Spent:
- 7h
-
- Analysis on issue
- Discussion with Niteen/ Sheetal and Satya
- Code debug
- Code changes
- Code review with Sheetal
- Code check in
- 3C's
Mukund Patil (Inactive)
made changes -
| Time Spent | 7.5h [ 27000 ] | 9.5h [ 34200 ] |
| Worklog Id | 102392 [ 102392 ] |
| Item State | Parent values: Development(10200)Level 1 values: In Progress(10206) | Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209) |
| Code Review Date | 25/Jan/2018 | |
| Code Reviewed By | Sheetal Bodhale [ 11905 ] | |
| Original Estimate | 0h [ 0 ] |
Khandu Kshirsagar (Inactive)
made changes -
| Item State | Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209) | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) |
Sachin Hingole (Inactive)
made changes -
| Item State | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) | Parent values: LB QA(10201)Level 1 values: In Testing(10210) |
Sachin Hingole (Inactive)
made changes -
| Status | In Development [ 10007 ] | Local Testing [ 10200 ] |
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
| Item State | Parent values: LB QA(10201)Level 1 values: In Testing(10210) | Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) |
Khandu Kshirsagar (Inactive)
made changes -
| Item State | Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) | Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) |
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
| Time Spent | 9.5h [ 34200 ] | 10h [ 36000 ] |
| Worklog Id | 103053 [ 103053 ] |
| Item State | Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) | Parent values: Stage QA(10202)Level 1 values: Re-open(10216) |
| Status | Local Testing [ 10200 ] | Stage Testing [ 10201 ] |
| Resolution | Unresolved [ 10200 ] | |
| Status | Stage Testing [ 10201 ] | Reopen in Stage [ 10023 ] |
| Assignee | Hrishikesh Deshpande [ hrishikesh.deshpande ] | Amit Kumawat [ amit.kumawat ] |
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.
| Assignee | Amit Kumawat [ amit.kumawat ] | Hrishikesh Deshpande [ hrishikesh.deshpande ] |
| Time Spent | 10h [ 36000 ] | 12h [ 43200 ] |
| Worklog Id | 103128 [ 103128 ] |
-
- Time Spent:
- 2h
-
- Analysis
- Discussion with Hrishikesh & Khandu
- Check issue at HSPL company
Hello Hrishikesh Deshpande,
Scripts are executed at Pre Prod. Please check it.
CC: Sheetal Bodhale, Swapnil Pandhare, Satya
Thanks & Regards
Amit K.
| Item State | Parent values: Stage QA(10202)Level 1 values: Re-open(10216) | Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) |
| Status | Reopen in Stage [ 10023 ] | In Development [ 10007 ] |
| Status | In Development [ 10007 ] | Local Testing [ 10200 ] |
| Status | Local Testing [ 10200 ] | Stage Testing [ 10201 ] |
| Item State | Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) | Parent values: Stage QA(10202)Level 1 values: In Testing(10214) |
This issue is Fixed on Pre-prod.
| Attachment | UND.png [ 72851 ] |
| Item State | Parent values: Stage QA(10202)Level 1 values: In Testing(10214) | Parent values: Stage QA(10202)Level 1 values: Production Deployment on Hold(10224) |
| Time Spent | 12h [ 43200 ] | 12.5h [ 45000 ] |
| Worklog Id | 103362 [ 103362 ] |
| Time Spent | 12.5h [ 45000 ] | 12.75h [ 45900 ] |
| Worklog Id | 109471 [ 109471 ] |
| Status | Stage Testing [ 10201 ] | Production Testing [ 10202 ] |
This is Fixed on Production.
| Resolution | Unresolved [ 10200 ] | Bug Fixed [ 10402 ] |
| Status | Production Testing [ 10202 ] | Production Complete [ 10028 ] |
| Status | Production Complete [ 10028 ] | Closed [ 6 ] |
| Transition | Time In Source Status | Execution Times |
|---|
|
1d 17h 34m | 1 |
|
4s | 1 |
|
3d 20h 54m | 1 |
|
5d 4h 24m | 2 |
|
2d 7m | 2 |
|
46d 42m | 1 |
|
20s | 1 |
|
4s | 1 |
Sachin Hingole Rakesh Roy Venkatesh Pujari Komal Barde