-
-
-
-
-
-
-
-
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":1,"isInitial":true,"journeyId":"d4c821fc-6106-423f-85d9-3c5aa86434e9","key":"jira.project.issue.view-issue","navigationType":0,"readyForUser":804.2999997138977,"redirectCount":0,"resourceLoadedEnd":901,"resourceLoadedStart":98.7999997138977,"resourceTiming":[{"duration":280.7000002861023,"initiatorType":"link","name":"https://jira.workterra.net/s/3003653444a1e1a85555cab7dcfb3a21-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/2e46d90b5cae895c9c38649c9d510130/_/download/contextbatch/css/_super/batch.css","startTime":98.7999997138977,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":98.7999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":379.5,"responseStart":0,"secureConnectionStart":0},{"duration":280.8999996185303,"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":99,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":99,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":379.8999996185303,"responseStart":0,"secureConnectionStart":0},{"duration":280.90000009536743,"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":99.19999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":99.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":380.09999990463257,"responseStart":0,"secureConnectionStart":0},{"duration":280.7000002861023,"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":99.39999961853027,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":99.39999961853027,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":380.09999990463257,"responseStart":0,"secureConnectionStart":0},{"duration":280.69999980926514,"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":99.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":99.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":380.19999980926514,"responseStart":0,"secureConnectionStart":0},{"duration":289.19999980926514,"initiatorType":"script","name":"https://jira.workterra.net/s/f2623af22c15df767ec6ff268ae0b8bd-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/2e46d90b5cae895c9c38649c9d510130/_/download/contextbatch/js/_super/batch.js?locale=en-US","startTime":99.69999980926514,"connectEnd":99.69999980926514,"connectStart":99.69999980926514,"domainLookupEnd":99.69999980926514,"domainLookupStart":99.69999980926514,"fetchStart":99.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":99.69999980926514,"responseEnd":388.8999996185303,"responseStart":388.8999996185303,"secureConnectionStart":99.69999980926514},{"duration":308.80000019073486,"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":99.89999961853027,"connectEnd":99.89999961853027,"connectStart":99.89999961853027,"domainLookupEnd":99.89999961853027,"domainLookupStart":99.89999961853027,"fetchStart":99.89999961853027,"redirectEnd":0,"redirectStart":0,"requestStart":99.89999961853027,"responseEnd":408.69999980926514,"responseStart":408.69999980926514,"secureConnectionStart":99.89999961853027},{"duration":311.19999980926514,"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":100.09999990463257,"connectEnd":100.09999990463257,"connectStart":100.09999990463257,"domainLookupEnd":100.09999990463257,"domainLookupStart":100.09999990463257,"fetchStart":100.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":100.09999990463257,"responseEnd":411.2999997138977,"responseStart":411.2999997138977,"secureConnectionStart":100.09999990463257},{"duration":311.59999990463257,"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":100.19999980926514,"connectEnd":100.19999980926514,"connectStart":100.19999980926514,"domainLookupEnd":100.19999980926514,"domainLookupStart":100.19999980926514,"fetchStart":100.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":100.19999980926514,"responseEnd":411.7999997138977,"responseStart":411.7999997138977,"secureConnectionStart":100.19999980926514},{"duration":311.8999996185303,"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":100.5,"connectEnd":100.5,"connectStart":100.5,"domainLookupEnd":100.5,"domainLookupStart":100.5,"fetchStart":100.5,"redirectEnd":0,"redirectStart":0,"requestStart":100.5,"responseEnd":412.3999996185303,"responseStart":412.3999996185303,"secureConnectionStart":100.5},{"duration":312.19999980926514,"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":100.59999990463257,"connectEnd":100.59999990463257,"connectStart":100.59999990463257,"domainLookupEnd":100.59999990463257,"domainLookupStart":100.59999990463257,"fetchStart":100.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":100.59999990463257,"responseEnd":412.7999997138977,"responseStart":412.7999997138977,"secureConnectionStart":100.59999990463257},{"duration":312.5,"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":100.7999997138977,"connectEnd":100.7999997138977,"connectStart":100.7999997138977,"domainLookupEnd":100.7999997138977,"domainLookupStart":100.7999997138977,"fetchStart":100.7999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":100.7999997138977,"responseEnd":413.2999997138977,"responseStart":413.2999997138977,"secureConnectionStart":100.7999997138977},{"duration":313,"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":100.89999961853027,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":100.89999961853027,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":413.8999996185303,"responseStart":0,"secureConnectionStart":0},{"duration":313,"initiatorType":"script","name":"https://jira.workterra.net/rest/api/1.0/shortcuts/805012/9b4bc78b7cc5c86b31ff012e5c329c28/shortcuts.js?context=issuenavigation&context=issueaction","startTime":101,"connectEnd":101,"connectStart":101,"domainLookupEnd":101,"domainLookupStart":101,"fetchStart":101,"redirectEnd":0,"redirectStart":0,"requestStart":101,"responseEnd":414,"responseStart":414,"secureConnectionStart":101},{"duration":313.69999980926514,"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":101.19999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":101.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":414.8999996185303,"responseStart":0,"secureConnectionStart":0},{"duration":313.40000009536743,"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":101.39999961853027,"connectEnd":101.39999961853027,"connectStart":101.39999961853027,"domainLookupEnd":101.39999961853027,"domainLookupStart":101.39999961853027,"fetchStart":101.39999961853027,"redirectEnd":0,"redirectStart":0,"requestStart":101.39999961853027,"responseEnd":414.7999997138977,"responseStart":414.7999997138977,"secureConnectionStart":101.39999961853027}],"threshold":1000,"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":9,"responseStart":88,"responseEnd":90,"domLoading":97,"domInteractive":959,"domContentLoadedEventStart":959,"domContentLoadedEventEnd":1004,"domComplete":1293,"loadEventStart":1293,"loadEventEnd":1295,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[],"measures":[],"correlationId":"b7251a26932aba","effectiveType":"4g","downlink":9.3,"rtt":0,"serverDuration":47,"dbReadsTimeInMs":3,"dbConnsTimeInMs":4,"applicationHash":"156decd7d2b4272533aa6cefc8294af635e1da97","experiments":[]}}
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