[NF-5041] Server Error on Enroll Now page when EE in Birth (Date of Birth) - Future date QE workflow - Workterra Jira

Details

Type: Bug
Status: Production Complete
Priority: Medium
Resolution: Bug Fixed
Affects Version/s: None
Fix Version/s: None
Component/s: UI Refresh
Labels:
None

Environment:

Others
Bug Type:
Functional
Bug Severity:
Medium
Level:

Employee
Module:
BenAdmin - Enrollment
Reported by:
Harbinger
Company:
Ohio Northern University
Item State:
Stage QA - Production Deployment on Hold

Description

Employee- 384463325

Company - Ohio Northern University For HSPL

EE details -User ID : 3325a00843771/Test_123456

QE - Birth (Date of Birth) - 11/16/2017

Step:-
1.Login with EE
2.Start OE
3.Complete OE
4.Raise QE for Birth (Date of Birth) - Future date
5.Navigate to Enroll Now

Actual - Server Error

Expected - It should display Enroll now page with eligible plan

Error Log -

Exception : The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.
App Error Log : ControllerAppTier.GetCollection->BenAdminControllerAppTier.GetData->CollectionManager.GetCollection->CollectionManager.GetEligibileBenefitTypesForGivenEffectiveDate->CollectionManager.GetPlanDesignInformationFromPlanDesignID_Health_ForBenefitLoad->Eligibility.CheckEligibilityForDependentForEnrollNowPlanDesign
Employee ID : 952
Action Name : LoadEligibleBenefitTypes
Model : System.Web.Mvc.HandleErrorInfo
Controller : UserDetails
Web Error Log : at WORKTERRA.BenAdmin.BenAdminControllerWebTier.GetCollection(ObjectType I_objectType, Hashtable I_criteria, String I_AdditionalCriteriaString, Object I_context, Boolean I_mode, Boolean I_needCollection)
at WORKTERRA.BenAdmin.Areas.UserDetails.Models.SelectBenefitTypePVModel.PopulateEligibileBenefitTypes()
at WORKTERRA.BenAdmin.Areas.UserDetails.Models.SelectBenefitTypePVModel.EffectiveDatesSelectedIndexChanged(String strEffectiveDate)
at WORKTERRA.BenAdmin.Areas.UserDetails.Controllers.UserDetailsController.LoadEligibleBenefitTypes(String Parameter1, String Parameter2, String Parameter3, String Parameter4, String Parameter5)
at lambda_method(Closure , ControllerBase , Object[] )
at System.Web.Mvc.ActionMethodDispatcher.Execute(ControllerBase controller, Object[] parameters)
at System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary`2 parameters)
at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters)
at System.Web.Mvc.Async.AsyncControllerActionInvoker.ActionInvocation.InvokeSynchronousActionMethod()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.b__39(IAsyncResult asyncResult, ActionInvocation innerInvokeState)
at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResult`2.CallEndDelegate(IAsyncResult asyncResult)
at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResultBase`1.End()
at System.Web.Mvc.Async.AsyncResultWrapper.End[TResult](IAsyncResult asyncResult, Object tag)
at System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethod(IAsyncResult asyncResult)
at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.b__3d()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c_DisplayClass46.b_3f()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c_DisplayClass46.b_3f()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c_DisplayClass33.b_32(IAsyncResult asyncResult)
at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResult`1.CallEndDelegate(IAsyncResult asyncResult)
at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResultBase`1.End()
at System.Web.Mvc.Async.AsyncResultWrapper.End[TResult](IAsyncResult asyncResult, Object tag)
at System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethodWithFilters(IAsyncResult asyncResult)
at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c_DisplayClass21.<>cDisplayClass2b.b_1c()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c_DisplayClass21.b_1e(IAsyncResult asyncResult)

Attachments

Options
- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

Attachments

QE_Birth_Ohio Northern University For HSPL.jpg
266 kB
15/Nov/17 01:05 PM

Issue Links

is caused by

NF-4920 Functional - Any company - EE OE - Same session after completion not able to open up the benefit types.

Resolution Setting

Activity

Ascending order - Click to sort in descending order

Mahendra Mungase (Inactive) created issue - 15/Nov/17 01:04 PM

Mahendra Mungase (Inactive) made changes - 15/Nov/17 01:05 PM

Field	Original Value	New Value
Attachment		QE_Birth_Ohio Northern University For HSPL.jpg [ 67771 ]

Mahendra Mungase (Inactive) made changes - 15/Nov/17 01:05 PM

Description

Employee- 384463325

Company - Ohio Northern University For HSPL

EE details -User ID : 3325a00843771/Test_123456

QE - Birth (Date of Birth) - 11/16/2017

Step:-
1.Login with EE
2.Start OE
3.Complete OE
4.Raise QE for Birth (Date of Birth) - Future date
5.Navigate to Enroll Now

Actual - Server Error

Expected - It should display Enroll now page with eligible plan

!QE_Birth_Ohio Northern University For HSPL.jpg|thumbnail!

Employee- 384463325

Company - Ohio Northern University For HSPL

EE details -User ID : 3325a00843771/Test_123456

QE - Birth (Date of Birth) - 11/16/2017

Step:-
1.Login with EE
2.Start OE
3.Complete OE
4.Raise QE for Birth (Date of Birth) - Future date
5.Navigate to Enroll Now

Actual - Server Error

Expected - It should display Enroll now page with eligible plan

Error Log -

Exception : The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.
App Error Log : ControllerAppTier.GetCollection->BenAdminControllerAppTier.GetData->CollectionManager.GetCollection->CollectionManager.GetEligibileBenefitTypesForGivenEffectiveDate->CollectionManager.GetPlanDesignInformationFromPlanDesignID_Health_ForBenefitLoad->Eligibility.CheckEligibilityForDependentForEnrollNowPlanDesign
Employee ID : 952
Action Name : LoadEligibleBenefitTypes
Model : System.Web.Mvc.HandleErrorInfo
Controller : UserDetails
Web Error Log : at WORKTERRA.BenAdmin.BenAdminControllerWebTier.GetCollection(ObjectType I_objectType, Hashtable I_criteria, String I_AdditionalCriteriaString, Object I_context, Boolean I_mode, Boolean I_needCollection)
at WORKTERRA.BenAdmin.Areas.UserDetails.Models.SelectBenefitTypePVModel.PopulateEligibileBenefitTypes()
at WORKTERRA.BenAdmin.Areas.UserDetails.Models.SelectBenefitTypePVModel.EffectiveDatesSelectedIndexChanged(String strEffectiveDate)
at WORKTERRA.BenAdmin.Areas.UserDetails.Controllers.UserDetailsController.LoadEligibleBenefitTypes(String Parameter1, String Parameter2, String Parameter3, String Parameter4, String Parameter5)
at lambda_method(Closure , ControllerBase , Object[] )
at System.Web.Mvc.ActionMethodDispatcher.Execute(ControllerBase controller, Object[] parameters)
at System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary`2 parameters)
at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters)
at System.Web.Mvc.Async.AsyncControllerActionInvoker.ActionInvocation.InvokeSynchronousActionMethod()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.b__39(IAsyncResult asyncResult, ActionInvocation innerInvokeState)
at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResult`2.CallEndDelegate(IAsyncResult asyncResult)
at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResultBase`1.End()
at System.Web.Mvc.Async.AsyncResultWrapper.End[TResult](IAsyncResult asyncResult, Object tag)
at System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethod(IAsyncResult asyncResult)
at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.b__3d()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c__DisplayClass46.b__3f()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c__DisplayClass46.b__3f()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass33.b__32(IAsyncResult asyncResult)
at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResult`1.CallEndDelegate(IAsyncResult asyncResult)
at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResultBase`1.End()
at System.Web.Mvc.Async.AsyncResultWrapper.End[TResult](IAsyncResult asyncResult, Object tag)
at System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethodWithFilters(IAsyncResult asyncResult)
at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass21.<>c__DisplayClass2b.b__1c()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass21.b__1e(IAsyncResult asyncResult)

Mahendra Mungase (Inactive) made changes - 15/Nov/17 01:05 PM

Link

This issue is caused by ~~NF-4920~~ [ ~~NF-4920~~ ]

Rohan J Khandave (Inactive) made changes - 15/Nov/17 01:15 PM

Status

Open [ 1 ]

In Development [ 10007 ]

Rohan J Khandave (Inactive) made changes - 15/Nov/17 01:18 PM

Item State		Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209)
Remaining Estimate		2h [ 7200 ]
Original Estimate		2h [ 7200 ]

Rohan J Khandave (Inactive) made changes - 15/Nov/17 01:18 PM

Remaining Estimate	2h [ 7200 ]	1h [ 3600 ]
Time Spent		1h [ 3600 ]
Worklog Id		90957 [ 90957 ]

Rohan J Khandave (Inactive) made changes - 15/Nov/17 01:21 PM

Assignee

Rohan J Khandave [ rohan.khandave ]

Mahendra Mungase [ mahendra.mungase ]

Sachin Hingole (Inactive) made changes - 17/Nov/17 05:36 AM

Status

In Development [ 10007 ]

Local Testing [ 10200 ]

Khandu Kshirsagar (Inactive) made changes - 17/Nov/17 09:36 AM

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 - 20/Nov/17 05:11 AM

Item State

Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)

Parent values: LB QA(10201)Level 1 values: In Testing(10210)

Mahendra Mungase (Inactive) made changes - 20/Nov/17 06:46 AM

Item State

Parent values: LB QA(10201)Level 1 values: In Testing(10210)

Parent values: LB QA(10201)Level 1 values: On Hold(10211)

Mahendra Mungase (Inactive) made changes - 29/Nov/17 04:18 AM

Remaining Estimate	1h [ 3600 ]	0.5h [ 1800 ]
Time Spent	1h [ 3600 ]	1.5h [ 5400 ]
Worklog Id		93335 [ 93335 ]

Mahendra Mungase (Inactive) made changes - 29/Nov/17 04:21 AM

Remaining Estimate	0.5h [ 1800 ]	0h [ 0 ]
Time Spent	1.5h [ 5400 ]	2h [ 7200 ]
Worklog Id		93344 [ 93344 ]

Mahendra Mungase (Inactive) made changes - 29/Nov/17 04:22 AM

Remaining Estimate	0h [ 0 ]	0.5h [ 1800 ]
Time Spent	2h [ 7200 ]	1.5h [ 5400 ]
Worklog Id	93344 [ 93344 ]
Worklog Time Spent	0.5h [ 1800 ]

Sachin Hingole (Inactive) made changes - 16/Jan/18 03:22 PM

Status

Local Testing [ 10200 ]

Stage Testing [ 10201 ]

Sachin Hingole (Inactive) made changes - 16/Jan/18 03:41 PM

Item State

Parent values: LB QA(10201)Level 1 values: On Hold(10211)

Parent values: Stage QA(10202)Level 1 values: Production Deployment on Hold(10224)

Sachin Hingole (Inactive) made changes - 25/Apr/18 09:36 PM

Status

Stage Testing [ 10201 ]

In Production Testing [ 10202 ]

Sachin Hingole (Inactive) made changes - 25/Apr/18 09:41 PM

Resolution		Bug Fixed [ 10402 ]
Status	In Production Testing [ 10202 ]	Production Complete [ 10028 ]

People

Assignee:: Mahendra Mungase (Inactive)

Reporter:: Mahendra Mungase (Inactive)

Developer:: Rohan J Khandave (Inactive)

QA:: Mahendra Mungase (Inactive)

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 15/Nov/17 01:04 PM

Updated:: 25/Apr/18 09:41 PM

Resolved:: 25/Apr/18 09:41 PM

Time Tracking

Estimated:

Remaining:

0.5h

Logged:

1.5h