-
Type:
Bug
-
Status: Closed
-
Priority:
Medium
-
Resolution: Done
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: BenAdmin
-
Labels:None
-
Environment:QA
-
Bug Severity:Medium
-
Module:BenAdmin - Enrollment
-
Reported by:Harbinger
-
Item State:Production Complete - Closed
ZCC company
- Just to test the max length of health tier policy no - i entered a policy no as 'Alan_Dental-A+ (AA) / W lon policy name for testing the policy max length problem in SA utility server error'
- employee enrolled in respective plan
- when I tried recalculating healthcare policy no though SA utility - a server error appeared [it worked well with the smaller length policy nos]
With the client JIRA WT-7819 we have allowed to put Number, alphanumeric letters (a-z, A-Z, 0-9) with white space and only few special characters like - Plus ( + ), Hypen ( - ) , Rounded Brackets ( ( ) ), Forward Slash ( / ) and Underscore (_) for policy nos
CC - Prasad Pise Hrishikesh Deshpande Sachin Hingole Rakesh Roy Umesh Kadam
Error Log
Exception : String or binary data would be truncated.The statement has been terminated.
App Error Log : ControllerAppTier.Save->BenAdminControllerAppTier.Save->SAUtilityToolBox.Save->PlanDesignHealthTierMapping.HealthTierPolicyNoCalculation->PlanDesignHealthTierMapping.RecalculateHealthTierPolicyNo->PlanDesignHealthTierMapping.UpdatePolicyNo_logValues
Employee ID : 0
Action Name : ProcessData
Model : System.Web.Mvc.HandleErrorInfo
Controller : Customization
Web Error Log : at WORKTERRA.BenAdmin.BenAdminControllerWebTier.Save(ObjectType I_objectType, Object objInputObject, Object I_context, Boolean I_mode) in d:\WT\branches\LB\Web\ControllerWebTier\ControllerWebTier\BenAdminControllerWebTier.cs:line 65
at WORKTERRA.BenAdmin.Areas.Customization.Models.SAUtilityToolboxModel.RecalculateHealthTierPolicy() in d:\WT\branches\LB\Web\Web Projects\BenAdmin\Areas\Customization\Models\SAUtilityToolbox\SAUtilityToolboxModel.cs:line 1673
at WORKTERRA.BenAdmin.Areas.Customization.Models.SAUtilityToolboxModel.ProcessData() in d:\WT\branches\LB\Web\Web Projects\BenAdmin\Areas\Customization\Models\SAUtilityToolbox\SAUtilityToolboxModel.cs:line 629
at WORKTERRA.BenAdmin.Areas.Customization.Controllers.CustomizationController.ProcessData(SAUtilityToolboxModel objToolBoxModel) in d:\WT\branches\LB\Web\Web Projects\BenAdmin\Areas\Customization\Controllers\SAUtilityToolbox\SAUtilityToolboxController.cs:line 32
at lambda_method(Closure , ControllerBase , Object[] )
| Field | Original Value | New Value |
|---|---|---|
| Severity | Simple [ 13101 ] |
| Assignee | Jyoti Mayne [ jyoti.mayne ] | abhilash warkari [ abhilash.warkari ] |
| Developer | abhilash warkari [ abhilash.warkari ] |
| Status | Open [ 1 ] | In Development [ 10007 ] |
| Item State | Parent values: Development(10200)Level 1 values: In Analysis(10204) |
-
- Time Spent:
- 6h
-
WT-7902issue
analysis
Discussion with umesh
coding
-
- Time Spent:
- 2h
-
Code review, Unit testing with Abhilash
| Item State | Parent values: Development(10200)Level 1 values: In Analysis(10204) | Parent values: Development(10200)Level 1 values: In Progress(10206) |
| Code Review Date | 02/Jun/2017 | |
| Code Reviewed By | Umesh Kadam [ 15302 ] | |
| Dev Due Date | 02/Jun/2017 | |
| Item State | Parent values: Development(10200)Level 1 values: In Progress(10206) | Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209) |
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) |
| Assignee | abhilash warkari [ abhilash.warkari ] | Prasad Pise [ prasadp ] |
| Remaining Estimate | 10h [ 36000 ] | 4h [ 14400 ] |
| Time Spent | 6h [ 21600 ] | |
| Worklog Id | 51952 [ 51952 ] |
| Remaining Estimate | 4h [ 14400 ] | 2h [ 7200 ] |
| Time Spent | 6h [ 21600 ] | 8h [ 28800 ] |
| Worklog Id | 51990 [ 51990 ] |
-
- Time Spent:
- 2h
-
Code Review .
and code check in LB and UI Refresh
| Assignee | Prasad Pise [ prasadp ] | Alankar Chavan [ alankar.chavan ] |
Hi Alankar Chavan,
Please find below 3Cs :
| Concern | Server Error on SA Utility if health tier policy no is of longer length and characters. |
| Cause | As per current table structure, lenght of policy number allowed in DB is 50 characters only. Hence code to insert / update policy number having length greater than 50 characters is failing. |
| Correction | We have changed size of a policy number column in a DB to allow length up to 250 characters. |
| Impacted Areas |
|
Thanks and Regards,
Abhilash Warkari
CC : Jyoti Mayne, Umesh Kadam, Vinanti Yadav
| Status | In Development [ 10007 ] | Local Testing [ 10200 ] |
| Remaining Estimate | 2h [ 7200 ] | 0h [ 0 ] |
| Time Spent | 8h [ 28800 ] | 10h [ 36000 ] |
| Worklog Id | 52315 [ 52315 ] |
| Worklog Id | 52315 [ 52315 ] |
| Attachment | WT-7902 Affected_Files.txt [ 50927 ] |
| Attachment | WT-7902 Code Review Checklist.doc [ 50928 ] |
| Assignee | Alankar Chavan [ alankar.chavan ] | Priya Handepatil [ priya.handepatil ] |
Priya Handepatil (Inactive)
logged work - 13/Jun/17 12:44 PM -
- Time Spent:
- 0.5h
-
Testing & Internal disscusson
Priya Handepatil (Inactive)
made changes -
| Time Spent | 10h [ 36000 ] | 10.5h [ 37800 ] |
| Worklog Id | 54622 [ 54622 ] |
Priya Handepatil (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) |
Priya Handepatil (Inactive)
made changes -
| Assignee | Priya Handepatil [ priya.handepatil ] | Alankar Chavan [ alankar.chavan ] |
As Discussed with Alankar ;
Assigning this issue to Alankar Chavan
Priya Handepatil (Inactive)
added a comment - As Discussed with Alankar ;
Assigning this issue to Alankar Chavan This is tested on WT Stage - Worked Well
Mapped a Health Tier Policy (with allowed special characters and longer length) - EE enrolled in the respective plan - Recalculated the policy from SA Utility - No Server Error while recalculation
Ready for Stage
| 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) |
| Time Spent | 10.5h [ 37800 ] | 12h [ 43200 ] |
| Worklog Id | 55090 [ 55090 ] |
| Time Spent | 12h [ 43200 ] | 12.25h [ 44100 ] |
| Worklog Id | 56037 [ 56037 ] |
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) |
This is tested on Stage - Worked Well
Mapped a Health Tier Policy (with allowed special characters and longer length) - EE enrolled in the respective plan - Recalculated the policy from SA Utility - No Server Error while recalculation
Ready for Production
CC - Rakesh Roy Prasad Pise
| Item State | Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) | Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) |
| Status | Local Testing [ 10200 ] | Stage Testing [ 10201 ] |
| Time Spent | 12.25h [ 44100 ] | 13.25h [ 47700 ] |
| Worklog Id | 56318 [ 56318 ] |
| Time Spent | 13.25h [ 47700 ] | 13.5h [ 48600 ] |
| Worklog Id | 56454 [ 56454 ] |
Khandu Kshirsagar (Inactive)
made changes -
| Item State | Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) | Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) |
This is tested on Production - Worked Well
Mapped a Health Tier Policy (with allowed special characters and longer length) - EE enrolled in the respective plan - Recalculated the policy from SA Utility - No Server Error while recalculation
CC - Prasad Pise Rakesh Roy
| Status | Stage Testing [ 10201 ] | Production Testing [ 10202 ] |
| Item State | Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) | Parent values: Production Complete(10222)Level 1 values: Closed(10223) |
| Resolution | Fixed [ 1 ] | |
| Status | Production Testing [ 10202 ] | Production Complete [ 10028 ] |
| Status | Production Complete [ 10028 ] | Closed [ 6 ] |
-
- Time Spent:
- 0.25h
-
Production code commit on behalf of Abhilash Warkari
| Time Spent | 13.5h [ 48600 ] | 14.5h [ 52200 ] |
| Worklog Id | 56915 [ 56915 ] |
| Bug Severity | Medium [ 16702 ] |
| Environment_New | LB [ 18444 ] |
| Transition | Time In Source Status | Execution Times |
|---|
|
132d 17h 59m | 1 |
|
4d 3h 54m | 1 |
|
13d 23h 4m | 1 |
|
1d 2h 21m | 1 |
|
14s | 1 |
|
2s | 1 |
related to
WT-7819