High 1. make a Life plan as auto enrolled plan
2. have the cost and coverage options as salary multiple
3. try adding an employee
Actual result : Server Error
employee gets created though
When I go to the above Life plan - plan is not getting auto enrolled
Error Log -
ErrorID : 0
ErrorSource : ControllerAppTier.Save->WORKTERRAControllerAppTier.Save->EmployeeData.Save->EmployeeData.UpdateEmployeeProfile->
EmployeeData.CreateUserForEmployee->CorePlanAllocation.CorePlanAllocationForOptimization->CorePlanAllocation.ActualCorePlanAllocation->
Eligibility.FetchCheckEligibilityForPlanDesign->Eligibility.IsDatingEligibilitySatisfied
ErrorMessage: Conversion from type 'DBNull' to type 'Integer' is not valid.
| Assignee | Satya [ ID10004 ] | Amnesh Goel [ amnesh.goel ] |
My findings after analysis for this bug is :
Cause: When there is NULL value in ZipCodeRuleID and system try to convert NULL into Int, Exception occurs.
Page: Eligibility.vb
Method: IsDatingEligibilitySatisfied(
| Assignee | Amnesh Goel [ amnesh.goel ] | Vinanti Yadav [ vinanti.yadav ] |
| Assignee | Vinanti Yadav [ vinanti.yadav ] | Prasanna Karlekar [ prasanna ] |
Concern:
When there is NULL value in ZipCodeRuleID and system try to convert NULL into Int, Exception occurs.
Cause:
As per discussion with Aditya, Default Rule was mapped to core plan due to which error occured.
Script for Default Plan was incorrect. It had ZipCodeEligibility set to 1 with ZipCodeRuleID set to NULL.
From screen this will never happen.
Correction:
Script for Default Rule is corrected. It will be deployed in next patch.
This issue is on LB only as Generic Eligibility changes are on LB environment only.
Fix is deployed on LB. Please verify.
File Changes:
Script to insert Default rule: 33_ST1_WTB_NewData_GenericEligibilityRules
Impacted areas:
Enroll Now screen for Plans / Rates / Credit Pool where "Default" Rule is mapped.
| Status | Open [ 1 ] | In Development [ 10007 ] |
| Assignee | Prasanna Karlekar [ prasanna ] | Alankar Chavan [ alankar.chavan ] |
| Item State | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) |
FYI Prasanna Karlekar Deepali Tidke Rakesh Roy
This is tested on WT Stage - 13th May 2016
1. No server error on Add Employee
2. Employee's are getting their auto enrolled plans (plans where default eligibility rule was saved)
3. also tested this with couple of more pages where there was a default rule mapping
Working well
As discussed with Prasanna, this exists on LB only - hence closing this issue at LB level only
| Item State | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) | Parent values: Production Complete(10222)Level 1 values: Closed(10223) |
| Status | In Development [ 10007 ] | Local Testing [ 10200 ] |
| Status | Local Testing [ 10200 ] | Stage Testing [ 10201 ] |
| Status | Stage Testing [ 10201 ] | Production Testing [ 10202 ] |
| Resolution | Fixed [ 1 ] | |
| Status | Production Testing [ 10202 ] | Production Complete [ 10028 ] |
| Status | Production Complete [ 10028 ] | Closed [ 6 ] |
| Environment_New | LB [ 18444 ] |
| Transition | Time In Source Status | Execution Times |
|---|
|
2d 1h 42m | 1 |
|
1h 36m | 1 |
|
6s | 1 |
|
5s | 1 |
|
58s | 1 |
|
84d 18h 19m | 1 |
Amnesh Goel -
WT 2287 is tested - all working well
I want to test one scenario with the auto enrolled plan - which I can not do because of WT 2375
Please fix this as earliest - so as WT 2287 can be move to Stage