-
Type:
Bug
-
Status:
Closed
-
Priority:
High
-
Resolution:
Done
-
Affects Version/s:
None
-
Fix Version/s:
None
-
-
-
-
-
-
-
-
-
Item State:
Stage QA
- Production Deployment on Hold
-
-
Sprint:
WT Sprint 38 - Bugs
Replication Steps:
1.Login With Employee (Test Hspl | tehs01011986 | Password@1)
2.Login with Company For QA FDU
3.Login With Employee (SSM)
4.Go to "Demographics Page "
Actual : Server error Occurred
Expected: Should not be any server error
Sachin Hingole Prasad Pise Rakesh Roy
Exception : Incorrect syntax near `.20122013`.Incorrect syntax near `.20122013`.
App Error Log : ControllerAppTier.GetData->WORKTERRAControllerAppTier.GetData->EmployeeData.GetData->EmployeeData.GetEmployeeProfile
Employee ID : 21983
Action Name : EmployeeProfile
Model : System.Web.Mvc.HandleErrorInfo
Controller : Customization
Web Error Log : at WORKTERRA.Shared.WORKTERRAControllerWebTier.GetData(ObjectType I_objectType, Hashtable I_criteria, Object I_context, Boolean I_mode, Boolean I_needCollection)
at WORKTERRA.Shared.Areas.Customization.Models.EmployeeProfileModel.GetEmployeeFormControls(Int32 pageID, Int32 GridRowID)
at WORKTERRA.Shared.Areas.Customization.Controllers.CustomizationController.EmployeeProfile(String PageId, Boolean IsFromRecruit, Boolean IsFromXpress)
at lambda_method(Closure , ControllerBase , Object[] )
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.ControllerActionInvoker.<>c_DisplayClass15.b_12()
at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation)
at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation)
at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation)
at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodWithFilters(ControllerContext controllerContext, IList`1 filters, ActionDescriptor actionDescriptor, IDictionary`2 parameters)
at System.Web.Mvc.ControllerActionInvoker.InvokeAction(ControllerContext controllerContext, String actionName)
- causes
-
NF-5477
CLONE - PE : Employee data screen Optimization
-
-
Closed
{"report":{"apdex":0.5,"isInitial":true,"journeyId":"0a73fd6f-5493-44b2-b379-8056744c812a","key":"jira.project.issue.view-issue","navigationType":0,"readyForUser":1234.6000000014901,"redirectCount":0,"resourceLoadedEnd":1257.5,"resourceLoadedStart":196,"resourceTiming":[{"duration":364.80000000447035,"initiatorType":"link","name":"https://jira.workterra.net/s/3003653444a1e1a85555cab7dcfb3a21-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/2e46d90b5cae895c9c38649c9d510130/_/download/contextbatch/css/_super/batch.css","startTime":196,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":196,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":560.8000000044703,"responseStart":0,"secureConnectionStart":0},{"duration":365.20000000298023,"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":197.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":197.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":562.7000000029802,"responseStart":0,"secureConnectionStart":0},{"duration":365,"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":197.70000000298023,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":197.70000000298023,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":562.7000000029802,"responseStart":0,"secureConnectionStart":0},{"duration":364.8999999985099,"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":197.80000000447035,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":197.80000000447035,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":562.7000000029802,"responseStart":0,"secureConnectionStart":0},{"duration":364.80000000447035,"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":197.89999999850988,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":197.89999999850988,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":562.7000000029802,"responseStart":0,"secureConnectionStart":0},{"duration":380.70000000298023,"initiatorType":"script","name":"https://jira.workterra.net/s/f2623af22c15df767ec6ff268ae0b8bd-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/2e46d90b5cae895c9c38649c9d510130/_/download/contextbatch/js/_super/batch.js?locale=en-US","startTime":199.10000000149012,"connectEnd":199.10000000149012,"connectStart":199.10000000149012,"domainLookupEnd":199.10000000149012,"domainLookupStart":199.10000000149012,"fetchStart":199.10000000149012,"redirectEnd":0,"redirectStart":0,"requestStart":199.10000000149012,"responseEnd":579.8000000044703,"responseStart":579.8000000044703,"secureConnectionStart":199.10000000149012},{"duration":422.19999999552965,"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":199.30000000447035,"connectEnd":199.30000000447035,"connectStart":199.30000000447035,"domainLookupEnd":199.30000000447035,"domainLookupStart":199.30000000447035,"fetchStart":199.30000000447035,"redirectEnd":0,"redirectStart":0,"requestStart":199.30000000447035,"responseEnd":621.5,"responseStart":621.5,"secureConnectionStart":199.30000000447035},{"duration":425.30000000447035,"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":199.5,"connectEnd":199.5,"connectStart":199.5,"domainLookupEnd":199.5,"domainLookupStart":199.5,"fetchStart":199.5,"redirectEnd":0,"redirectStart":0,"requestStart":199.5,"responseEnd":624.8000000044703,"responseStart":624.8000000044703,"secureConnectionStart":199.5},{"duration":426.29999999701977,"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":199.80000000447035,"connectEnd":199.80000000447035,"connectStart":199.80000000447035,"domainLookupEnd":199.80000000447035,"domainLookupStart":199.80000000447035,"fetchStart":199.80000000447035,"redirectEnd":0,"redirectStart":0,"requestStart":199.80000000447035,"responseEnd":626.1000000014901,"responseStart":626.1000000014901,"secureConnectionStart":199.80000000447035},{"duration":427.40000000596046,"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":199.89999999850988,"connectEnd":199.89999999850988,"connectStart":199.89999999850988,"domainLookupEnd":199.89999999850988,"domainLookupStart":199.89999999850988,"fetchStart":199.89999999850988,"redirectEnd":0,"redirectStart":0,"requestStart":199.89999999850988,"responseEnd":627.3000000044703,"responseStart":627.3000000044703,"secureConnectionStart":199.89999999850988},{"duration":428.30000000447035,"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":200,"connectEnd":200,"connectStart":200,"domainLookupEnd":200,"domainLookupStart":200,"fetchStart":200,"redirectEnd":0,"redirectStart":0,"requestStart":200,"responseEnd":628.3000000044703,"responseStart":628.3000000044703,"secureConnectionStart":200},{"duration":429.29999999701977,"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":200.20000000298023,"connectEnd":200.20000000298023,"connectStart":200.20000000298023,"domainLookupEnd":200.20000000298023,"domainLookupStart":200.20000000298023,"fetchStart":200.20000000298023,"redirectEnd":0,"redirectStart":0,"requestStart":200.20000000298023,"responseEnd":629.5,"responseStart":629.5,"secureConnectionStart":200.20000000298023},{"duration":444.19999999552965,"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":200.30000000447035,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":200.30000000447035,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":644.5,"responseStart":0,"secureConnectionStart":0},{"duration":430.40000000596046,"initiatorType":"script","name":"https://jira.workterra.net/rest/api/1.0/shortcuts/805012/e80c7a6aee0fa86c2b1a716575a614aa/shortcuts.js?context=issuenavigation&context=issueaction","startTime":200.39999999850988,"connectEnd":200.39999999850988,"connectStart":200.39999999850988,"domainLookupEnd":200.39999999850988,"domainLookupStart":200.39999999850988,"fetchStart":200.39999999850988,"redirectEnd":0,"redirectStart":0,"requestStart":200.39999999850988,"responseEnd":630.8000000044703,"responseStart":630.8000000044703,"secureConnectionStart":200.39999999850988},{"duration":444.1000000014901,"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":200.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":200.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":644.6000000014901,"responseStart":0,"secureConnectionStart":0},{"duration":433.09999999403954,"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":200.80000000447035,"connectEnd":200.80000000447035,"connectStart":200.80000000447035,"domainLookupEnd":200.80000000447035,"domainLookupStart":200.80000000447035,"fetchStart":200.80000000447035,"redirectEnd":0,"redirectStart":0,"requestStart":200.80000000447035,"responseEnd":633.8999999985099,"responseStart":633.8999999985099,"secureConnectionStart":200.80000000447035},{"duration":972.7000000029802,"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":202.60000000149012,"connectEnd":202.60000000149012,"connectStart":202.60000000149012,"domainLookupEnd":202.60000000149012,"domainLookupStart":202.60000000149012,"fetchStart":202.60000000149012,"redirectEnd":0,"redirectStart":0,"requestStart":202.60000000149012,"responseEnd":1175.3000000044703,"responseStart":1175.3000000044703,"secureConnectionStart":202.60000000149012}],"threshold":1000,"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":28,"responseStart":181,"responseEnd":182,"domLoading":193,"domInteractive":1382,"domContentLoadedEventStart":1382,"domContentLoadedEventEnd":1461,"domComplete":1655,"loadEventStart":1655,"loadEventEnd":1658,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[],"measures":[],"correlationId":"2a0a82b773f227","effectiveType":"4g","downlink":9.3,"rtt":0,"serverDuration":109,"dbReadsTimeInMs":12,"dbConnsTimeInMs":14,"applicationHash":"156decd7d2b4272533aa6cefc8294af635e1da97","experiments":[]}}
Hi
Same issue is present for " For QA Asml and For QA Asml for Hspl " on Confirmation statement Page
cc: Rakesh Roy Prasad Pise Sachin Hingole Hrishikesh Deshpande
Exception : Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
App Error Log : ControllerAppTier.GetData->BenAdminControllerAppTier.GetData->Confirmation.GetData->Confirmation.GetEmployeeAndConfirmationInformation->Confirmation.GetFormBuilderRightsForConfirmation
Employee ID : 4644
Action Name : EnrollmentSummary
Model : System.Web.Mvc.HandleErrorInfo
Controller : UserDetails
Web Error Log : at WORKTERRA.BenAdmin.BenAdminControllerWebTier.GetData(ObjectType I_objectType, Hashtable I_criteria, Object I_context, Boolean I_mode, Boolean I_needCollection)
at WORKTERRA.BenAdmin.Areas.UserDetails.Models.EnrollmentSummaryModel.FillArrayForGridsVisibility(PageName pageName, Boolean IsEnrollNowConsolidated)
at WORKTERRA.BenAdmin.Areas.UserDetails.Controllers.UserDetailsController.EnrollmentSummary(String id)
at lambda_method(Closure , ControllerBase , Object[] )
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.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.AsyncInvocationWithFilters.<>c_DisplayClass46.b_3f()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c_DisplayClass33.b_32(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)