Pre-requisite :- OE should be ON for this company
Steps:-
1] Log into the system using EE credentials on Preprod site.
2] Traverse till the Beneficiary page and observe
Actual Result :-
Server Error displayed on Beneficiary Page.
Error Log is as below :-
Exception : Conversion from type `DBNull` to type `Integer` is not valid.
App Error Log : ControllerAppTier.GetCollection->BenAdminControllerAppTier.GetData->CollectionManager.GetCollection->CollectionManager.GetEmployeeBeneficiaryCollection
Employee ID : 71
Action Name : EmployeePlanBeneficiaryPV
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) in c:\WT\branches\UiRefresh-LB\Web\ControllerWebTier\ControllerWebTier\BenAdminControllerWebTier.cs:line 160
at WORKTERRA.BenAdmin.Areas.UserDetails.Models.EmployeePlanBeneficiaryModel.GetBeneficiaryForPlan(Int64 EmployeeId, Int32 PlanDesignId, String EmployeeEffectiveDate)
at WORKTERRA.BenAdmin.Areas.UserDetails.Controllers.UserDetailsController.EmployeePlanBeneficiaryPV(EmployeePlanBeneficiaryModel objEmployeePlanBeneficiaryModel, String EffectiveDate, Int32 PlanIndex)
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.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.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.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)
Please let me know if you need any more information on this. The credentials are as below :-
thspl7867
Password@2
Sonoma Academy