[NF-5823] NF:- Sonoma Academy :- Server Error displayed on Beneficiary Page in EE OE Workflow - Workterra Jira

Details

Type: Bug
Status: Closed
Priority: Medium
Resolution: Cannot Reproduce
Affects Version/s: None
Fix Version/s: None
Component/s: UI Refresh
Labels:
None

Environment:

Pre Production
Bug Type:
Functional
Bug Severity:
Medium
Level:

Employee
Module:
BenAdmin - EDS
Reported by:
Harbinger
Company:
Sonoma Academy
Item State:
Development - In Progress
Browser:

Mozilla Firefox

Description

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

Attachments

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

Attachments

sonoma.png
81 kB
29/Jan/18 09:43 AM

Issue Links

relates to

NF-5728 Pre-Prod Company testing Time Update Jira

Reopen

Activity

Ascending order - Click to sort in descending order

Venkatesh Pujari (Inactive) created issue - 29/Jan/18 09:43 AM

Venkatesh Pujari (Inactive) made changes - 29/Jan/18 09:45 AM

Field	Original Value	New Value
Link		This issue relates to NF-5728 [ NF-5728 ]

Vijayendra Shinde (Inactive) made changes - 29/Jan/18 10:20 AM

Assignee

Vijayendra Shinde [ ID10506 ]

Ramesh Shinde [ ramesh.shinde ]

Ramesh Shinde (Inactive) made changes - 29/Jan/18 11:37 AM

Status

Open [ 1 ]

In Development [ 10007 ]

Ramesh Shinde (Inactive) made changes - 29/Jan/18 11:37 AM

Item State

Parent values: Development(10200)Level 1 values: In Progress(10206)

Permalink

Ramesh Shinde (Inactive) logged work - 29/Jan/18 12:26 PM

Time Spent:

2h

--> Analysis , debugging.
--> issue reproducing on local.

Komal Barde (Inactive) made changes - 30/Jan/18 05:56 AM

Assignee

Ramesh Shinde [ ramesh.shinde ]

Komal Barde [ komal.barde ]

Hide

Permalink

Komal Barde (Inactive) added a comment - 30/Jan/18 07:50 AM

Hi Venkatesh Pujari,

As per our dicssioon, the spouse deletion is done from back-end at your side,which caused improper deletion of spouse and also it caused issue at employee beneficiary.
Due to this server error is occurring.

So please share proper steps to reproduce this issue.

Thanks,
Komal.

CC:Vijayendra Shinde,Swapnil Pandhare,Sachin Hingole,Nidhi Kaul

Show

Komal Barde (Inactive) added a comment - 30/Jan/18 07:50 AM Hi Venkatesh Pujari , As per our dicssioon, the spouse deletion is done from back-end at your side,which caused improper deletion of spouse and also it caused issue at employee beneficiary. Due to this server error is occurring. So please share proper steps to reproduce this issue. Thanks, Komal. CC: Vijayendra Shinde , Swapnil Pandhare , Sachin Hingole , Nidhi Kaul

Komal Barde (Inactive) made changes - 30/Jan/18 07:50 AM

Assignee

Komal Barde [ komal.barde ]

Venkatesh Pujari [ venkatesh.pujari ]

Ramesh Shinde (Inactive) made changes - 30/Jan/18 12:27 PM

Remaining Estimate		0h [ 0 ]
Time Spent		2h [ 7200 ]
Worklog Id		102636 [ 102636 ]

Permalink

Ramesh Shinde (Inactive) logged work - 30/Jan/18 12:29 PM

Time Spent:

2h

--> Company restoring on local.
--> discussion with Komal and debugging on local for issue reproducing.

Ramesh Shinde (Inactive) made changes - 30/Jan/18 12:31 PM

Time Spent	2h [ 7200 ]	4h [ 14400 ]
Worklog Id		102643 [ 102643 ]

Permalink

Komal Barde (Inactive) logged work - 30/Jan/18 12:47 PM

Time Spent:

5h
- Company restoring on local.
- Discussion with Ramesh and QA
- Debugging on local for issue reproducing.

Hide

Permalink

Komal Barde (Inactive) added a comment - 31/Jan/18 05:15 AM

Hi Venkatesh Pujari,

As per our discussion, this issue is caused by improper deletion of data from back end by QA.
The spouse deletion is done from back-end at QA side,which caused improper deletion of spouse and also updated wrong data in employee beneficiary page and it caused server error on employee beneficiary page.

So this is not a valid jira and rejecting it.

Thanks,
Komal.

CC:Vijayendra Shinde,Swapnil Pandhare,Sachin Hingole,Nidhi Kaul

Show

Komal Barde (Inactive) added a comment - 31/Jan/18 05:15 AM Hi Venkatesh Pujari , As per our discussion, this issue is caused by improper deletion of data from back end by QA. The spouse deletion is done from back-end at QA side,which caused improper deletion of spouse and also updated wrong data in employee beneficiary page and it caused server error on employee beneficiary page. So this is not a valid jira and rejecting it. Thanks, Komal. CC: Vijayendra Shinde , Swapnil Pandhare , Sachin Hingole , Nidhi Kaul

Komal Barde (Inactive) made changes - 31/Jan/18 05:15 AM

Resolution		Cannot Reproduce [ 5 ]
Status	In Development [ 10007 ]	Rejected [ 10004 ]

Venkatesh Pujari (Inactive) made changes - 31/Jan/18 05:21 AM

Status

Rejected [ 10004 ]

Closed [ 6 ]

Komal Barde (Inactive) made changes - 31/Jan/18 12:47 PM

Time Spent	4h [ 14400 ]	9h [ 32400 ]
Worklog Id		102883 [ 102883 ]

Transition	Time In Source Status	Execution Times

Ramesh Shinde (Inactive) made transition - 29/Jan/18 11:37 AM

Open

In Development

1h 54m

Komal Barde (Inactive) made transition - 31/Jan/18 05:15 AM

In Development

Rejected

1d 17h 37m

Venkatesh Pujari (Inactive) made transition - 31/Jan/18 05:21 AM

Rejected

Closed

5m 52s

People

Assignee:: Venkatesh Pujari (Inactive)

Reporter:: Venkatesh Pujari (Inactive)

QA:: Venkatesh Pujari (Inactive)

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 29/Jan/18 09:43 AM

Updated:: 31/Jan/18 12:47 PM

Resolved:: 31/Jan/18 05:15 AM

Time Tracking

Estimated:

Not Specified

Remaining:

Logged: