-
Type:
Bug
-
Status: Closed
-
Priority:
Medium
-
Resolution: Done
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: BenAdmin
-
Labels:None
-
Environment:Production
-
Bug Severity:Medium
-
Module:BenAdmin - Enrollment
-
Reported by:Support
-
Company:SCCSIG
-
Item State:Production Complete
Hello,
I am trying to make changes to existing Health Tier Mapping values and add new mappings, but i am getting the attached error stating Form Description Format Invalid. I originally added these mapping and the format was accepted then, but not now. Please see attached screenshot.
Plan i am adjusting is called "Delta Dental - COBRA-Dental-Delta Dental", but i suspect this error will occur on every SCCSIG client build because the format of these values are the same across all SCCSIG clients.
Need this issue resolved so i can move forward with my adjustments.
Thanks,
Chris
- relates to
-
-
- Closed
-
| Field | Original Value | New Value |
|---|---|---|
| Assignee | Vijay Siddha [ vijays ] | Jyoti Mayne [ jyoti.mayne ] |
| Assignee | Jyoti Mayne [ jyoti.mayne ] | Umesh Kadam [ umesh.kadam ] |
Vijay Siddha (Inactive)
made changes -
| Module | Parent values: BenAdmin(10100)Level 1 values: Export(10110) | Parent values: BenAdmin(10100)Level 1 values: Enrollment(10107) |
| Status | Open [ 1 ] | In Progress [ 3 ] |
Please find below our analysis details below.
| Concern | Issue with Adding or Changing Health Tier Mapping Value |
| Cause | Earlier, there were no restriction for special characters for policy number. Later, to resolve the discrepancy in storing policy number due to special character, validation for special characters needed to add for policy number which results in restricting underscore ('_') character now (Please find more details in Hence, it is showing alert of incorrect form description format. |
| Correction | We have made code change to allow underscore ('_') symbol and it is under testing. It will be moved to production once it is being tested. |
NOTE : Allowed special Character are - [ ^ < > ' \ " = + $ ~ @ @ % * ( ) ! ? \ ] $. Please let us know if you want more special characters to be allowed for policy number
Thanks and Regards,
:: Umesh Kadam
CC : Jyoti Mayne
| Status | In Progress [ 3 ] | Waiting for Customer Input [ 10500 ] |
| Assignee | Umesh Kadam [ umesh.kadam ] | Chris Ellenberger [ chris.ellenberger ] |
-
- Time Spent:
- 2.5h
-
Analysis of an issue
Discussed with Jyoti and Vinanti for recent changes for validation
Code change done in local
Unit testing
-
- Time Spent:
- 0.25h
-
scenario discussion with Umesh
Hello Umesh Kadam
I need to make adjustments and add health tier mapping for this client before the file runs tomorrow, 1/19/2017. I can suppress the file to run later in the morning, but i need this completed tonight so i can proceed.
Thanks,
Chris
| Assignee | Chris Ellenberger [ chris.ellenberger ] | Umesh Kadam [ umesh.kadam ] |
| Status | Waiting for Customer Input [ 10500 ] | Open [ 1 ] |
| Remaining Estimate | 0h [ 0 ] | |
| Time Spent | 2.5h [ 9000 ] | |
| Worklog Id | 19854 [ 19854 ] |
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Issue Type | Support Activity [ 10301 ] | Bug [ 1 ] |
| Status | In Progress [ 3 ] | In Development [ 10007 ] |
| Support Task Type | Data Correction [ 11203 ] | |
| Workflow | WT_Support [ 30701 ] | WT_Defects [ 30956 ] |
Converted to bug category to track it all the way to production deployment and to maintain Item State
| Account Executive | Chris Ellenberger [ chris.ellenberger ] | |
| Code Review Date | 18/Jan/2017 | |
| Code Reviewed By | Jyoti Mayne [ 11910 ] | |
| Dev Due Date | 19/Jan/2017 | |
| Developer | Umesh Kadam [ umesh.kadam ] | |
| Item State | Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209) | |
| 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) |
| Attachment | Special Charact.png [ 37773 ] |
Hello Umesh Kadam,
We started testing this on Wt Stage.
Out of all the allowed special characters mentioned by you in earlier comment, system is still throwing format validation error for many of the like !-'"$=~%
[ specially as per the client;s screenshot we have to allow - character ]
Please go through all the mentioned special characters - and make them allowed to put in the health tier policy name
CC - Sachin Hingole Hrishikesh Deshpande Prasad Pise Rakesh Roy Jyoti Mayne
| Item State | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) | Parent values: LB QA(10201)Level 1 values: Re-open(10212) |
| Status | In Development [ 10007 ] | Local Testing [ 10200 ] |
| Item State | Parent values: LB QA(10201)Level 1 values: Re-open(10212) | Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209) |
| Status | Local Testing [ 10200 ] | Reopen in Local [ 10018 ] |
| Status | Reopen in Local [ 10018 ] | In Development [ 10007 ] |
Hi Alankar Chavan,
My bad, I wrongly put all symbols together.
For Policy 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 (_) are allowed.
Thanks and Regards,
:: Umesh Kadam
CC : Jyoti Mayne
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 | Umesh Kadam [ umesh.kadam ] | Alankar Chavan [ alankar.chavan ] |
Hello Umesh Kadam,
We have tested this on WT Stage - 19th Jan 2016
Now you can put down the policy nos which has special characters like* Plus ( + ), Hypen ( - ) , Rounded Brackets ( ( ) ), Forward Slash ( / ) and Underscore (_)*
We have verified the policy nos are appearing properly on SA utility for respective election entries
We have also exported the respective data and verified - are the policy nos coming properly on file - this worked as expected
Ready for Stage and Production
CC - Prasad Pise Sachin Hingole Hrishikesh Deshpande Rakesh Roy Jyoti Mayne
| Attachment | Policy No with Special Characters.png [ 37780 ] |
| Item State | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) | Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) |
-
- Time Spent:
- 0.5h
-
Discussion and Export point testing
| Time Spent | 2.5h [ 9000 ] | 3h [ 10800 ] |
| Worklog Id | 19952 [ 19952 ] |
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) |
-
- Time Spent:
- 0.5h
-
Done Export testing.
| Item State | Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) | Parent values: Stage QA(10202)Level 1 values: In Testing(10214) |
| Time Spent | 3h [ 10800 ] | 3.5h [ 12600 ] |
| Worklog Id | 19997 [ 19997 ] |
Tested this on Stage - please move this patch to Production
CC - Prasad Pise Sachin Hingole Hrishikesh Deshpande Rakesh Roy Jyoti Mayne
| Item State | Parent values: Stage QA(10202)Level 1 values: In Testing(10214) | Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) |
| 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) |
| Status | In Development [ 10007 ] | Local Testing [ 10200 ] |
| Status | Local Testing [ 10200 ] | Reopen in Local [ 10018 ] |
| Status | Reopen in Local [ 10018 ] | In Development [ 10007 ] |
| Status | In Development [ 10007 ] | Local Testing [ 10200 ] |
| Status | Local Testing [ 10200 ] | Stage Testing [ 10201 ] |
| 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) |
Hello Chris Ellenberger
We have deployed and tested the fix on Production
Now you can put down the policy nos which has alphanumeric letters (a-z, A-Z, 0-9) with white space special characters like * Plus ( + ), Hypen ( - ) , Rounded Brackets ( ( ) ), Forward Slash ( / ) and Underscore (_)*
We have verified the policy nos are appearing properly on SA utility for respective election entries
We have also exported the respective data and verified - are the policy nos coming properly on file - this worked as expected
[ Note - while editing the policy nos, system might not allow you to keep the special characters in mapping name. In that case kindly remove the special characters from the names. If you want us to remove those validations also - do let us know on this. We can create a separate JIRA for the same and make the changes]
Please review this at your end - and if its working as per your expectations, you may close this JIRA
CC - Prasad Pise Sachin Hingole Hrishikesh Deshpande Rakesh Roy Jyoti Mayne
| Time Spent | 3.5h [ 12600 ] | 10.5h [ 37800 ] |
| Worklog Id | 20035 [ 20035 ] |
| Time Spent | 10.5h [ 37800 ] | 12.5h [ 45000 ] |
| Worklog Id | 20064 [ 20064 ] |
-
- Time Spent:
- 2h
-
Unit testing for remaining special characters
Code change done for regex
Code commit in LB, Stage and Production
Discussion with Vinanti, Jyoti and Alankar for the validation
| Resolution | Fixed [ 1 ] | |
| Status | Production Testing [ 10202 ] | Production Complete [ 10028 ] |
| Status | Production Complete [ 10028 ] | Closed [ 6 ] |
| Time Spent | 12.5h [ 45000 ] | 12.75h [ 45900 ] |
| Worklog Id | 20187 [ 20187 ] |
| Worklog Id | 20187 [ 20187 ] |
| Worklog Id | 20187 [ 20187 ] |
| Time Spent | 12.75h [ 45900 ] | 13h [ 46800 ] |
| Worklog Id | 20430 [ 20430 ] |
| Bug Severity | Medium [ 16702 ] | |
| Code Review Date | 18/Jan/2017 | 18/Jan/2017 |
| Dev Due Date | 19/Jan/2017 | 19/Jan/2017 |
| Environment_New | Production [ 18442 ] |
| Transition | Time In Source Status | Execution Times |
|---|
|
5m 55s | 1 |
|
9h 56m | 1 |
|
1d 21h 23m | 2 |
|
15m 56s | 1 |
|
11m 57s | 2 |
|
4s | 2 |
|
8h 2m | 3 |
|
1s | 1 |
|
2s | 1 |
|
8h 20m | 1 |
|
4s | 1 |
Hi Chris Ellenberger,
Due to other priority task, couldn't work on this today. We will update you once it is completed.
cc: Satya