[WT-11258] Functional-Any company-EE Login-New Hire Mode-Demographics-Server Error - Workterra Jira

Details

Type: Bug
Status: Closed
Priority: High
Resolution: Done
Affects Version/s: None
Fix Version/s: None
Component/s: BenAdmin
Labels:
- Employee_workflow

Environment:

QA
Bug Type:
Functional
Bug Severity:
Medium
Level:

Employee
Module:
BenAdmin - EDS
Reported by:
Harbinger
Item State:
Stage QA - Production Deployment on Hold
Browser:

Google Chrome
Sprint:
WT Sprint 38 - Bugs

Description

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)

Attachments

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

Attachments

Admin login Server error.jpg
130 kB
29/Sep/17 05:35 AM
Confirmation Statement.jpg
94 kB
25/Sep/17 09:28 AM
Demographics Server error.jpg
95 kB
25/Sep/17 06:45 AM
WT_11258.jpg
144 kB
28/Sep/17 12:08 PM
Wt-11258.jpg
133 kB
03/Oct/17 09:40 AM
WT-11258.jpg
102 kB
09/Oct/17 09:41 AM
WT-11258.jpg
135 kB
28/Sep/17 12:08 PM
WT-11258.png
69 kB
05/Mar/18 11:48 AM
WT-11258-FilesAffected .txt
0.1 kB
28/Sep/17 08:35 AM

Issue Links

causes

NF-5477 CLONE - PE : Employee data screen Optimization

Closed

Activity

Ascending order - Click to sort in descending order

Hide

Permalink

Priya Handepatil (Inactive) added a comment - 25/Sep/17 09:28 AM

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)

Show

Priya Handepatil (Inactive) added a comment - 25/Sep/17 09:28 AM 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.<>c DisplayClass2b.b _1c() at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c_ DisplayClass21.b _1e(IAsyncResult asyncResult)

Hide

Permalink

Akshay Mukkawar (Inactive) added a comment - 28/Sep/17 08:25 AM

Hi Priya Handepatil,

Please find following 3C's:
Concern: "Functional-Any company-EE Login-New Hire Mode-Demographics-Server Error"
Cause: dynamic query was not handled properly.
Correction: We have handled properly for now.
Impacted Areas:
EE login

Thanks,
Akshay Mukkawar
----------------------------------
CC:Swapnil Pandhare,Satya,Sheetal Bodhale

Show

Akshay Mukkawar (Inactive) added a comment - 28/Sep/17 08:25 AM Hi Priya Handepatil , Please find following 3C's: Concern: "Functional-Any company-EE Login-New Hire Mode-Demographics-Server Error" Cause: dynamic query was not handled properly. Correction: We have handled properly for now. Impacted Areas: EE login Thanks, Akshay Mukkawar ---------------------------------- CC: Swapnil Pandhare , Satya , Sheetal Bodhale

Hide

Permalink

Priya Handepatil (Inactive) added a comment - 28/Sep/17 12:08 PM - edited

Hi Akshay Mukkawar

I have verified this issue on LB

Verified with Employee Login

Verified with Company For QA Asml and For QA Fdu

Its working fine

Hence, Marking it as on Hold while enhancement testing is in Progress .

cc: Sachin Hingole Prasad Pise Rakesh Roy Hrishikesh Deshpande

Thank you !

Show

Priya Handepatil (Inactive) added a comment - 28/Sep/17 12:08 PM - edited Hi Akshay Mukkawar I have verified this issue on LB Verified with Employee Login Verified with Company For QA Asml and For QA Fdu Its working fine Hence, Marking it as on Hold while enhancement testing is in Progress . cc: Sachin Hingole Prasad Pise Rakesh Roy Hrishikesh Deshpande Thank you !

Hide

Permalink

Priya Handepatil (Inactive) added a comment - 29/Sep/17 05:36 AM - edited

Hi Akshay Mukkawar

There is server error with CA login workflow while saving "Demographics "

CC:Sachin Hingole Prasad Pise Rakesh Roy Hrishikesh Deshpande

Error Log : Exception : Incorrect syntax near the keyword `AND`.Incorrect syntax near `)`.
App Error Log : ControllerAppTier.Save->WORKTERRAControllerAppTier.Save->EmployeeData.Save->EmployeeData.UpdateEmployeeProfile->DefinedFieldRuleEngine.UpdateDefinedFieldByApplyingRuleEngine->DefinedFieldRuleEngine.UpdateTableFieldsForDataRuleEngine->DefinedFieldRuleEngine.UpdateConditionalValue->DefinedFieldRuleEngine.GetQueryForThenRule
Employee ID : 4949
Action Name : GetEmployeeProfileInfo
Model : System.Web.Mvc.HandleErrorInfo
Controller : Customization
Web Error Log : at WORKTERRA.Shared.WORKTERRAControllerWebTier.Save(ObjectType I_objectType, Object objInputObject, Object I_context, Boolean I_mode)
at WORKTERRA.Shared.Areas.Customization.Models.EmployeeProfileModel.UpdateEmployeeAttribute(EmployeeData EmployeeAttributeObj, EmployeeDataScreen& objUserDetails, Int32 I_TableRef, Int32 I_SaveAndContinue)
at WORKTERRA.Shared.Areas.Customization.Models.EmployeeProfileModel.SaveProfile(EmployeeData objEmployeeData, EmployeeDataScreen& objUser, Int32 I_TableRef, Int32 I_SaveAndContinue)
at WORKTERRA.Shared.Areas.Customization.Controllers.CustomizationController.GetEmployeeProfileInfo(EmployeeProfileModel Obj_EmployeeProfileModel)
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.InvokeActionMethodWithFilters(ControllerContext controllerContext, IList`1 filters, ActionDescriptor actionDescriptor, IDictionary`2 parameters)
at System.Web.Mvc.ControllerActionInvoker.InvokeAction(ControllerContext controllerContext, String actionName)

Show

Priya Handepatil (Inactive) added a comment - 29/Sep/17 05:36 AM - edited Hi Akshay Mukkawar There is server error with CA login workflow while saving "Demographics " CC: Sachin Hingole Prasad Pise Rakesh Roy Hrishikesh Deshpande Error Log : Exception : Incorrect syntax near the keyword `AND`.Incorrect syntax near `)`. App Error Log : ControllerAppTier.Save->WORKTERRAControllerAppTier.Save->EmployeeData.Save->EmployeeData.UpdateEmployeeProfile->DefinedFieldRuleEngine.UpdateDefinedFieldByApplyingRuleEngine->DefinedFieldRuleEngine.UpdateTableFieldsForDataRuleEngine->DefinedFieldRuleEngine.UpdateConditionalValue->DefinedFieldRuleEngine.GetQueryForThenRule Employee ID : 4949 Action Name : GetEmployeeProfileInfo Model : System.Web.Mvc.HandleErrorInfo Controller : Customization Web Error Log : at WORKTERRA.Shared.WORKTERRAControllerWebTier.Save(ObjectType I_objectType, Object objInputObject, Object I_context, Boolean I_mode) at WORKTERRA.Shared.Areas.Customization.Models.EmployeeProfileModel.UpdateEmployeeAttribute(EmployeeData EmployeeAttributeObj, EmployeeDataScreen& objUserDetails, Int32 I_TableRef, Int32 I_SaveAndContinue) at WORKTERRA.Shared.Areas.Customization.Models.EmployeeProfileModel.SaveProfile(EmployeeData objEmployeeData, EmployeeDataScreen& objUser, Int32 I_TableRef, Int32 I_SaveAndContinue) at WORKTERRA.Shared.Areas.Customization.Controllers.CustomizationController.GetEmployeeProfileInfo(EmployeeProfileModel Obj_EmployeeProfileModel) 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.InvokeActionMethodWithFilters(ControllerContext controllerContext, IList`1 filters, ActionDescriptor actionDescriptor, IDictionary`2 parameters) at System.Web.Mvc.ControllerActionInvoker.InvokeAction(ControllerContext controllerContext, String actionName)

Hide

Permalink

Priya Handepatil (Inactive) added a comment - 03/Oct/17 09:42 AM

Hi Akshay Mukkawar

As discussed I have verified this issue on LB

Verified with Company Admin login

Verified with company "For QA ASML"

No Server error occurred

Its working fine

Hence, Marking it as on Hold while enhancement testing is in Progress

cc: Sachin Hingole Prasad Pise Rakesh Roy Sachin Hingole

Thank You !

Show

Priya Handepatil (Inactive) added a comment - 03/Oct/17 09:42 AM Hi Akshay Mukkawar As discussed I have verified this issue on LB Verified with Company Admin login Verified with company "For QA ASML" No Server error occurred Its working fine Hence, Marking it as on Hold while enhancement testing is in Progress cc: Sachin Hingole Prasad Pise Rakesh Roy Sachin Hingole Thank You !

Hide

Permalink

Priya Handepatil (Inactive) added a comment - 09/Oct/17 09:42 AM

Hi Akshay Mukkawar

I have verified this issue on stage

Verified with Employee Login, Partner Login , Company Admin login ( New Hire Mode)

Verified with Company " Tibco for Hspl"

Its working fine

Hence, Marking it as on hold till the enhancement in testing

cc: Sachin Hingole Prasad Pise Rakesh Roy Hrishikesh Deshpande

Thank you !

Show

Priya Handepatil (Inactive) added a comment - 09/Oct/17 09:42 AM Hi Akshay Mukkawar I have verified this issue on stage Verified with Employee Login, Partner Login , Company Admin login ( New Hire Mode) Verified with Company " Tibco for Hspl" Its working fine Hence, Marking it as on hold till the enhancement in testing cc: Sachin Hingole Prasad Pise Rakesh Roy Hrishikesh Deshpande Thank you !

Hide

Permalink

Sanjana Jadhav (Inactive) added a comment - 05/Mar/18 11:48 AM

Verified on production.
Company: Austin for hspl
Browser: Chrome and mozilla firefox
Verified confirmation statement page by partner, admin and employee login(New hire mode).
Working as expected.
PFA,

Thanks,
Sanjana Jadhav

CC: Prasad Pise Sachin Hingole Rakesh Roy

Show

Sanjana Jadhav (Inactive) added a comment - 05/Mar/18 11:48 AM Verified on production. Company: Austin for hspl Browser: Chrome and mozilla firefox Verified confirmation statement page by partner, admin and employee login(New hire mode). Working as expected. PFA, Thanks, Sanjana Jadhav CC: Prasad Pise Sachin Hingole Rakesh Roy

People

Assignee:: Sachin Hingole (Inactive)

Reporter:: Priya Handepatil (Inactive)

Developer:: Akshay Mukkawar (Inactive)

QA:: Priya Handepatil (Inactive)

Votes:: 0 Vote for this issue

Watchers:: 3 Start watching this issue

Dates

Created:: 25/Sep/17 06:46 AM

Updated:: 07/Mar/18 06:19 AM

Resolved:: 05/Mar/18 11:53 AM

Pre-Prod Due Date:: 06/Oct/2017

Production Due Date:: 05/Mar/2018

Time Tracking

Estimated:

Remaining:

Logged:

14.95h