-
-
-
-
-
-
-
-
Item State:
Development
- In Progress
-
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
- relates to
-
NF-5728
Pre-Prod Company testing Time Update Jira
-
-
Reopen
{"report":{"apdex":0.5,"isInitial":true,"journeyId":"5acbedac-8ce8-4347-9f99-c4339766dce3","key":"jira.project.issue.view-issue","navigationType":0,"readyForUser":1043.699999999255,"redirectCount":0,"resourceLoadedEnd":789.1999999992549,"resourceLoadedStart":239.19999999925494,"resourceTiming":[{"duration":6.600000001490116,"initiatorType":"link","name":"https://jira.workterra.net/s/3003653444a1e1a85555cab7dcfb3a21-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/2e46d90b5cae895c9c38649c9d510130/_/download/contextbatch/css/_super/batch.css","startTime":239.19999999925494,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":239.19999999925494,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":245.80000000074506,"responseStart":0,"secureConnectionStart":0},{"duration":6.300000000745058,"initiatorType":"link","name":"https://jira.workterra.net/s/dd6a0911920485696ac20493290df627-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/3abe50d469404b639745df44b51476b6/_/download/contextbatch/css/jira.browse.project,jira.view.issue,project.issue.navigator,jira.global,atl.general,-_super/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&richediton=true","startTime":239.59999999776483,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":239.59999999776483,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":245.89999999850988,"responseStart":0,"secureConnectionStart":0},{"duration":6.399999998509884,"initiatorType":"link","name":"https://jira.workterra.net/s/d41d8cd98f00b204e9800998ecf8427e-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/8.5.0/_/download/batch/com.atlassian.auiplugin:split_aui.pattern.label/com.atlassian.auiplugin:split_aui.pattern.label.css","startTime":239.80000000074506,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":239.80000000074506,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":246.19999999925494,"responseStart":0,"secureConnectionStart":0},{"duration":6.699999999254942,"initiatorType":"link","name":"https://jira.workterra.net/s/bd548f27bbf8f278bd83b60dd3284ed8-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/1.0/_/download/batch/jira.webresources:global-static-adgs/jira.webresources:global-static-adgs.css","startTime":240,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":240,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":246.69999999925494,"responseStart":0,"secureConnectionStart":0},{"duration":7.199999999254942,"initiatorType":"link","name":"https://jira.workterra.net/s/70725731a158a7140f19ddbd4201ba27-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/1.0/_/download/batch/jira.webresources:global-static/jira.webresources:global-static.css","startTime":240.19999999925494,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":240.19999999925494,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":247.39999999850988,"responseStart":0,"secureConnectionStart":0},{"duration":379.30000000074506,"initiatorType":"script","name":"https://jira.workterra.net/s/f2623af22c15df767ec6ff268ae0b8bd-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/2e46d90b5cae895c9c38649c9d510130/_/download/contextbatch/js/_super/batch.js?locale=en-US","startTime":240.39999999850988,"connectEnd":240.39999999850988,"connectStart":240.39999999850988,"domainLookupEnd":240.39999999850988,"domainLookupStart":240.39999999850988,"fetchStart":240.39999999850988,"redirectEnd":0,"redirectStart":0,"requestStart":494.5999999977648,"responseEnd":619.6999999992549,"responseStart":530.3999999985099,"secureConnectionStart":240.39999999850988},{"duration":548.1000000014901,"initiatorType":"script","name":"https://jira.workterra.net/s/6ce676f2a5bcc9651cef6e7956f05def-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/3abe50d469404b639745df44b51476b6/_/download/contextbatch/js/jira.browse.project,jira.view.issue,project.issue.navigator,jira.global,atl.general,-_super/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en-US&richediton=true","startTime":241.09999999776483,"connectEnd":241.09999999776483,"connectStart":241.09999999776483,"domainLookupEnd":241.09999999776483,"domainLookupStart":241.09999999776483,"fetchStart":241.09999999776483,"redirectEnd":0,"redirectStart":0,"requestStart":496.19999999925494,"responseEnd":789.1999999992549,"responseStart":558.6999999992549,"secureConnectionStart":241.09999999776483},{"duration":283.5,"initiatorType":"script","name":"https://jira.workterra.net/s/ecf7ec549751ae117b778f0525d6d371-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/4.1.5/_/download/resources/com.atlassian.plugins.atlassian-chaperone:hotspot-tour/hotspot-tour.js?batch=false&locale=en-US","startTime":241.30000000074506,"connectEnd":241.30000000074506,"connectStart":241.30000000074506,"domainLookupEnd":241.30000000074506,"domainLookupStart":241.30000000074506,"fetchStart":241.30000000074506,"redirectEnd":0,"redirectStart":0,"requestStart":494.19999999925494,"responseEnd":524.8000000007451,"responseStart":524.0999999977648,"secureConnectionStart":241.30000000074506},{"duration":284.5,"initiatorType":"script","name":"https://jira.workterra.net/s/6aa3fcf1fac5fd551eee0b69077524e6-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/aae1242f5fc81cc6a5bb8bc963ccda29/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en-US","startTime":241.5,"connectEnd":241.5,"connectStart":241.5,"domainLookupEnd":241.5,"domainLookupStart":241.5,"fetchStart":241.5,"redirectEnd":0,"redirectStart":0,"requestStart":495.5999999977648,"responseEnd":526,"responseStart":525.5,"secureConnectionStart":241.5},{"duration":284.8999999985099,"initiatorType":"script","name":"https://jira.workterra.net/s/d41d8cd98f00b204e9800998ecf8427e-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":241.69999999925494,"connectEnd":241.69999999925494,"connectStart":241.69999999925494,"domainLookupEnd":241.69999999925494,"domainLookupStart":241.69999999925494,"fetchStart":241.69999999925494,"redirectEnd":0,"redirectStart":0,"requestStart":496,"responseEnd":526.5999999977648,"responseStart":526.0999999977648,"secureConnectionStart":241.69999999925494},{"duration":285.3999999985099,"initiatorType":"script","name":"https://jira.workterra.net/s/d41d8cd98f00b204e9800998ecf8427e-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":241.80000000074506,"connectEnd":241.80000000074506,"connectStart":241.80000000074506,"domainLookupEnd":241.80000000074506,"domainLookupStart":241.80000000074506,"fetchStart":241.80000000074506,"redirectEnd":0,"redirectStart":0,"requestStart":496.30000000074506,"responseEnd":527.1999999992549,"responseStart":526.8000000007451,"secureConnectionStart":241.80000000074506},{"duration":287.0999999977648,"initiatorType":"script","name":"https://jira.workterra.net/s/ecf7ec549751ae117b778f0525d6d371-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/8.5.0/_/download/batch/com.atlassian.auiplugin:split_aui.pattern.label/com.atlassian.auiplugin:split_aui.pattern.label.js?locale=en-US","startTime":242,"connectEnd":242,"connectStart":242,"domainLookupEnd":242,"domainLookupStart":242,"fetchStart":242,"redirectEnd":0,"redirectStart":0,"requestStart":498.80000000074506,"responseEnd":529.0999999977648,"responseStart":528.5,"secureConnectionStart":242},{"duration":15,"initiatorType":"link","name":"https://jira.workterra.net/s/05c862146699bb029ceb0a489075e63b-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/bcd66e9a133a1b9f5fd14b56841e1c5b/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":242.19999999925494,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":242.19999999925494,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":257.19999999925494,"responseStart":0,"secureConnectionStart":0},{"duration":319.29999999701977,"initiatorType":"script","name":"https://jira.workterra.net/rest/api/1.0/shortcuts/805012/a664c2c06e52d83566c477b9899c262e/shortcuts.js?context=issuenavigation&context=issueaction","startTime":242.30000000074506,"connectEnd":242.30000000074506,"connectStart":242.30000000074506,"domainLookupEnd":242.30000000074506,"domainLookupStart":242.30000000074506,"fetchStart":242.30000000074506,"redirectEnd":0,"redirectStart":0,"requestStart":498.5999999977648,"responseEnd":561.5999999977648,"responseStart":560.8000000007451,"secureConnectionStart":242.30000000074506},{"duration":205.59999999776483,"initiatorType":"link","name":"https://jira.workterra.net/s/9095228fa10daa2d3e3d7d5760c95e91-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/72477c22780abda5f51fe696920d843f/_/download/contextbatch/css/com.atlassian.jira.projects.sidebar.init,-_super,-jira.view.issue,-project.issue.navigator/batch.css?jira.create.linked.issue=true&richediton=true","startTime":242.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":242.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":448.0999999977648,"responseStart":0,"secureConnectionStart":0},{"duration":287.70000000298023,"initiatorType":"script","name":"https://jira.workterra.net/s/c19a1b46e985d7fb85efaf27c8febfdd-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/72477c22780abda5f51fe696920d843f/_/download/contextbatch/js/com.atlassian.jira.projects.sidebar.init,-_super,-jira.view.issue,-project.issue.navigator/batch.js?jira.create.linked.issue=true&locale=en-US&richediton=true","startTime":242.59999999776483,"connectEnd":242.59999999776483,"connectStart":242.59999999776483,"domainLookupEnd":242.59999999776483,"domainLookupStart":242.59999999776483,"fetchStart":242.59999999776483,"redirectEnd":0,"redirectStart":0,"requestStart":497.0999999977648,"responseEnd":530.3000000007451,"responseStart":529.6999999992549,"secureConnectionStart":242.59999999776483},{"duration":406.79999999701977,"initiatorType":"script","name":"https://jira.workterra.net/s/d41d8cd98f00b204e9800998ecf8427e-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":267.80000000074506,"connectEnd":267.80000000074506,"connectStart":267.80000000074506,"domainLookupEnd":267.80000000074506,"domainLookupStart":267.80000000074506,"fetchStart":267.80000000074506,"redirectEnd":0,"redirectStart":0,"requestStart":574,"responseEnd":674.5999999977648,"responseStart":674.0999999977648,"secureConnectionStart":267.80000000074506},{"duration":407.3999999985099,"initiatorType":"script","name":"https://jira.workterra.net/s/d41d8cd98f00b204e9800998ecf8427e-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":267.80000000074506,"connectEnd":267.80000000074506,"connectStart":267.80000000074506,"domainLookupEnd":267.80000000074506,"domainLookupStart":267.80000000074506,"fetchStart":267.80000000074506,"redirectEnd":0,"redirectStart":0,"requestStart":578.5999999977648,"responseEnd":675.1999999992549,"responseStart":674.6999999992549,"secureConnectionStart":267.80000000074506},{"duration":85.90000000223517,"initiatorType":"xmlhttprequest","name":"https://jira.workterra.net/rest/webResources/1.0/resources","startTime":772.0999999977648,"connectEnd":772.0999999977648,"connectStart":772.0999999977648,"domainLookupEnd":772.0999999977648,"domainLookupStart":772.0999999977648,"fetchStart":772.0999999977648,"redirectEnd":0,"redirectStart":0,"requestStart":792.5,"responseEnd":858,"responseStart":857.5,"secureConnectionStart":772.0999999977648},{"duration":87.70000000298023,"initiatorType":"xmlhttprequest","name":"https://jira.workterra.net/rest/webResources/1.0/resources","startTime":921.5999999977648,"connectEnd":921.5999999977648,"connectStart":921.5999999977648,"domainLookupEnd":921.5999999977648,"domainLookupStart":921.5999999977648,"fetchStart":921.5999999977648,"redirectEnd":0,"redirectStart":0,"requestStart":973.3999999985099,"responseEnd":1009.3000000007451,"responseStart":1008.5,"secureConnectionStart":921.5999999977648}],"threshold":1000,"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":123,"responseStart":208,"responseEnd":267,"domLoading":211,"domInteractive":1100,"domContentLoadedEventStart":1100,"domContentLoadedEventEnd":1154,"domComplete":1226,"loadEventStart":1226,"loadEventEnd":1228,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[],"measures":[],"correlationId":"1496b38d7b3dd1","effectiveType":"4g","downlink":9.7,"rtt":0,"serverDuration":47,"dbReadsTimeInMs":5,"dbConnsTimeInMs":6,"applicationHash":"156decd7d2b4272533aa6cefc8294af635e1da97","experiments":[]}}
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