-
Type:
Bug
-
Status: Rejected
-
Priority:
Medium
-
Resolution: Duplicate
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: UI Refresh
-
Labels:None
-
Environment:Others
-
Bug Type:Functional
-
Bug Severity:Critical
-
Level:Admin, Partner
-
Module:BenAdmin - EDS
-
Reported by:Harbinger
When We Accept Spouse/Child data from Pending Queue or employee review changes page then system throws server error.
Error Log -
Exception : Incorrect syntax near `20122013`.tempID:0tempID:0tempID:0tempID:0tempID:0retrieved values:13616 tempID:0retrieved values:test tempID:0retrieved values:NULL tempID:0retrieved values:test tempID:0retrieved values:NULL tempID:0retrieved values:1 tempID:0retrieved values:NULL tempID:0retrieved values:1 tempID:0retrieved values:Jan 1 1970 12:00AM tempID:0retrieved values:NULL tempID:0retrieved values:Street Address 1 tempID:0retrieved values:NULL tempID:0retrieved values:City tempID:0retrieved values:1 tempID:0retrieved values:1 tempID:0retrieved values:12345 tempID:0retrieved values:NULL tempID:0retrieved values:NULL tempID:0retrieved values:NULL tempID:0retrieved values:NULL tempID:0retrieved values:NULL tempID:0retrieved values:NULL tempID:0retrieved values:NULL tempID:0retrieved values:NULL tempID:0retrieved values:NULL tempID:0retrieved values:NULL tempID:0retrieved values:NULL tempID:0retrieved values:NULL tempID:0retrieved values:NULL tempID:0retrieved values:0 tempID:0retrieved values:NULL tempID:0retrieved values:0 tempID:0retrieved values:0 tempID:0retrieved values:NULL tempID:0retrieved values:NULL tempID:0retrieved values:NULL tempID:0retrieved values:NULL tempID:0retrieved values:NULL tempID:0retrieved values:NULL tempID:0retrieved values:1 tempID:0retrieved values:NULL tempID:0retrieved values:NULL tempID:0retrieved values:1 tempID:0retrieved values:Oct 1 2017 12:00AM tempID:0retrieved values:0 tempID:0retrieved values:0 tempID:0retrieved values:NULL tempID:0retrieved values:1 tempID:0retrieved values:0 tempID:0retrieved values:NULL tempID:0retrieved values:5653 tempID:0tempID:0retrieved values:NULL tempID:0retrieved values:15 tempID:0retrieved values:NULL tempID:0retrieved values:NULL tempID:0retrieved values:NULL tempID:0retrieved values:NULL tempID:0retrieved values:NULL tempID:0retrieved values:NULL insert into Employee_DependentSpouse(EmployeeID,FirstName,MiddleInitial,LastName,TitleID,RelationshipID,SocialSecurityNo,GenderID,BirthDate,MarriageDate,ResidingAddressLine1,ResidingAddressLine2,City,CountryID,StateID,PostalCode,HomePhone,EmploymentStatusID,DateOfEmployment,Occupation,GrossAnnualPay,NoOfHoursPerWeek,EmployerName,EmployerAddressLine1,EmployerAddressLine2,EmployerCity,EmployerCountryID,EmployerStateID,EmployerPostalCode,EmployerWorkPhone,EmployerWorkPhoneExtension,IsTobaccoUser,IsSpouseDisabled,DisabilityDate,DisabilityReason,ClinicCodeMedical,ClinicCodeDental,ClinicCodeVision,ClinicCodeRx,IsActive,IPA,County,LanguageIndicator,EffectiveDate,IsCompanyUser,IsLoginDisabled,EmailAddress,StatusID,IsPatient,ClinicCodeMedicalStartDate,UserID,ClinicCodeMedical2,EnrollMentModeID,QualifyingEventID,IsDependentConfirmed,20122013AnnualAward156,DependentSequenceNo,RecordType,InsertedDateTime) values(13616,NullIf(`test`,``), NULL,NullIf(`test`,``), NULL,1,NULL,1,NullIf(`Jan 1 1970`,``), NULL,NullIf(`Street Address 1`,``), NULL,NullIf(`City`,``), 1,1,NullIf(`12345`,``), NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NullIf(`0`,``), NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,1,NullIf(`Oct 1 2017`,``), 0,0,NULL,1,0,NULL,5653,NULL,15,NULL,NULL,NULL,NULL,NULL,NULL)
App Error Log : ControllerAppTier.Delete->BenAdminControllerAppTier.Delete->RaisedQualifyingEvent.Delete->RaisedQualifyingEvent.UpdateDeleteRecordForIntermediateForReviewTansactions
Employee ID : 0
Action Name : SaveReviewChangesIntermediate
Model : System.Web.Mvc.HandleErrorInfo
Controller : UserDetails
Web Error Log : at WORKTERRA.BenAdmin.BenAdminControllerWebTier.Delete(ObjectType I_objectType, Hashtable I_criteria, Object I_context)
at WORKTERRA.BenAdmin.Areas.UserDetails.Models.PendingQueueDetailsModel.SaveReviewChangesIntermediate(ReviewTransactionField objReviewTransactionField)
at WORKTERRA.BenAdmin.Areas.UserDetails.Controllers.UserDetailsController.SaveReviewChangesIntermediate(ReviewTransactionField objReviewTransactionField)
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.ActionInvocation.InvokeSynchronousActionMethod()
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.AsyncResultWrapper.End[TResult](IAsyncResult asyncResult, Object tag)
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.AsyncResultWrapper.End[TResult](IAsyncResult asyncResult, Object tag)
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)
Can you please fix this issue as We have to handover this demo company to client?
- relates to
-
NF-5000 National Stores - Functional - Server error on Review Changes Intiate qualifying event data accept
-
- Production Complete
-