Uploaded image for project: 'New Features 2017'
  1. New Features 2017
  2. NF-4293

National Stores - Functional - Server error on Review Changes Spouse/Child data accept

    XMLWordPrintable

    Details

    • 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

      Description

      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?

      CC: Jaideep Vinchurkar Satya Samir Rakesh Roy

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              hrishikesh.deshpande Hrishikesh Deshpande (Inactive)
              Reporter:
              hrishikesh.deshpande Hrishikesh Deshpande (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 8h
                  8h
                  Remaining:
                  Time Spent - 5.5h Remaining Estimate - 2.5h
                  2.5h
                  Logged:
                  Time Spent - 5.5h Remaining Estimate - 2.5h
                  5.5h