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)

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

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 !

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)

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 !

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 !

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