Uploaded image for project: 'WORKTERRA'
  1. WORKTERRA
  2. WT-6529

Pre-Stage>>'DCOB'>>Server error observed Eligible Benefit Summery screen.

    Details

    • Type: Bug
    • Status: Closed
    • Priority: High
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Onboard
    • Labels:
      None
    • Environment:
      Stage
    • Module:
      OnBoard
    • Reported by:
      Harbinger
    • Item State:
      Stage QA - Re-open
    • Issue Importance:
      Q1

      Description

      In Employee login, during pre-board tour, Server error observed on Eligible summery benefit screen. Here, employee gets logged out and it blocks the further flow. PFA screen shot and error log.

      Exception : SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999

      11:59:59 PM.
      App Error Log : ControllerAppTier.GetCollection->BenAdminControllerAppTier.GetData-

      >CollectionManager.GetCollection-

      >CollectionManager.GetEligibileBenefitTypesForGivenEffectiveDate-

      >Eligibility.GetEligibleBenefitTypes_EnrollNow-

      >Eligibility.FetchCheckEligibilityForPlanDesign_EnrollNow_Ex
      Employee ID : 4998
      Action Name : EligibleBenefitsSummary
      Model : System.Web.Mvc.HandleErrorInfo
      Controller : UserDetails
      Web Error Log : at WORKTERRA.BenAdmin.BenAdminControllerWebTier.GetCollection

      (ObjectType I_objectType, Hashtable I_criteria, String I_AdditionalCriteriaString,

      Object I_context, Boolean I_mode, Boolean I_needCollection)
      at

      WORKTERRA.BenAdmin.Areas.UserDetails.Models.EligibleBenefitsSummaryModel.GetEligibleBe

      nefitTypesCollection()
      at

      WORKTERRA.BenAdmin.Areas.UserDetails.Models.EligibleBenefitsSummaryModel.getEligibleBe

      nefitsSummary()
      at

      WORKTERRA.BenAdmin.Areas.UserDetails.Controllers.UserDetailsController.EligibleBenefit

      sSummary()
      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_DisplayClass13.b_10()
      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

          Issue Links

            Activity

            rajendraj Rajendra Joshi (Inactive) created issue -
            rajendraj Rajendra Joshi (Inactive) made changes -
            Field Original Value New Value
            Link This issue relates to WT-4200 [ WT-4200 ]
            swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
            Assignee Swapnil Pandhare [ swapnil.pandhare ] Aarati Sabnis [ aarati.sabnis ]
            aarati.sabnis Aarati Sabnis (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            aarati.sabnis Aarati Sabnis (Inactive) made changes -
            Remaining Estimate 1h [ 3600 ]
            Original Estimate 1h [ 3600 ]
            aarati.sabnis Aarati Sabnis (Inactive) made changes -
            Remaining Estimate 1h [ 3600 ] 0h [ 0 ]
            Hide
            aarati.sabnis Aarati Sabnis (Inactive) added a comment -

            Hello Rajendra Joshi,

            Please check this again. If you get same error let me know.

            Thanks,
            Aarati R. Sabnis

            Show
            aarati.sabnis Aarati Sabnis (Inactive) added a comment - Hello Rajendra Joshi , Please check this again. If you get same error let me know. Thanks, Aarati R. Sabnis
            aarati.sabnis Aarati Sabnis (Inactive) made changes -
            Assignee Aarati Sabnis [ aarati.sabnis ] Rajendra Joshi [ rajendraj ]
            rajendraj Rajendra Joshi (Inactive) made changes -
            Item State Parent values: Stage QA(10202) Parent values: Stage QA(10202)Level 1 values: Re-open(10216)
            rajendraj Rajendra Joshi (Inactive) made changes -
            Assignee Rajendra Joshi [ rajendraj ] Aarati Sabnis [ aarati.sabnis ]
            rajendraj Rajendra Joshi (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            rajendraj Rajendra Joshi (Inactive) made changes -
            Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
            Hide
            rajendraj Rajendra Joshi (Inactive) added a comment -

            Verified on Pre-stage using company DCOB and DC. Server error observed on downloading file on Eligible summery benefit screen. Employee gets logged out after this error. PFA error log.

            Exception : Input string was not in a correct format.
            App Error Log : -
            Employee ID : 4999
            Action Name : DownloadFile
            Model : System.Web.Mvc.HandleErrorInfo
            Controller : Common
            Web Error Log : at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal)
            at System.Number.ParseInt64(String value, NumberStyles options, NumberFormatInfo numfmt)
            at WORKTERRA.Shared.Models.DownloadFormModel.ValidateEmployeeRequestForDownload(String FilePath, Int32 companyIndex)
            at WORKTERRA.Shared.Models.DownloadFormModel.ValidateRequestForDownload(String FilePath)
            at WORKTERRA.Shared.Models.DownloadFormModel.DownloadFile(String FileId, String FileName, String FileDescription, String DestinationPath, Boolean DownloadFromWebServer, Boolean IsDeviceCall, Boolean GetFileFromCurrentWebServer)
            at WORKTERRA.Shared.Controllers.CommonController.DownloadFile(String FileId, String FileName, String FileDescription, String DestinationPath, Boolean DownloadFromWebServer, Boolean GetFileFromCurrentWebServer, Boolean AppendGUIDtoFilename, Boolean RemoveGUIDfromFilename)
            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_DisplayClass13.b_10()
            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
            rajendraj Rajendra Joshi (Inactive) added a comment - Verified on Pre-stage using company DCOB and DC. Server error observed on downloading file on Eligible summery benefit screen. Employee gets logged out after this error. PFA error log. Exception : Input string was not in a correct format. App Error Log : - Employee ID : 4999 Action Name : DownloadFile Model : System.Web.Mvc.HandleErrorInfo Controller : Common Web Error Log : at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal) at System.Number.ParseInt64(String value, NumberStyles options, NumberFormatInfo numfmt) at WORKTERRA.Shared.Models.DownloadFormModel.ValidateEmployeeRequestForDownload(String FilePath, Int32 companyIndex) at WORKTERRA.Shared.Models.DownloadFormModel.ValidateRequestForDownload(String FilePath) at WORKTERRA.Shared.Models.DownloadFormModel.DownloadFile(String FileId, String FileName, String FileDescription, String DestinationPath, Boolean DownloadFromWebServer, Boolean IsDeviceCall, Boolean GetFileFromCurrentWebServer) at WORKTERRA.Shared.Controllers.CommonController.DownloadFile(String FileId, String FileName, String FileDescription, String DestinationPath, Boolean DownloadFromWebServer, Boolean GetFileFromCurrentWebServer, Boolean AppendGUIDtoFilename, Boolean RemoveGUIDfromFilename) 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_ DisplayClass13.b _10() 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)
            rajendraj Rajendra Joshi (Inactive) logged work - 22/Nov/16 06:06 AM
            • Time Spent:
              1h
               
              <No comment>
            rajendraj Rajendra Joshi (Inactive) made changes -
            Remaining Estimate 0h [ 0 ] 2h [ 7200 ]
            Time Spent 1h [ 3600 ]
            Worklog Id 10133 [ 10133 ]
            rajendraj Rajendra Joshi (Inactive) made changes -
            Resolution Unresolved [ 10200 ]
            Status Stage Testing [ 10201 ] Reopen in Stage [ 10023 ]
            Hide
            aarati.sabnis Aarati Sabnis (Inactive) added a comment -

            Hello Rajendra Joshi,

            Concern : server error displayed while downloading a pdf file on Eligible summery benefit screen

            Cause : It was because of checking EmployeeID authentication. EmployeeID from file path condition was not working as File path does not contain EmployeeID in it.

            Correction : The condition of checking EmployeeID authentication is changed now and pdf file is getting downloaded according to file path properly.

            Pre-stage check-in is done.

            Thanks,
            Aarati R. Sabnis

            CC Satya,Swapnil Pandhare,Rakesh Roy

            Show
            aarati.sabnis Aarati Sabnis (Inactive) added a comment - Hello Rajendra Joshi , Concern : server error displayed while downloading a pdf file on Eligible summery benefit screen Cause : It was because of checking EmployeeID authentication. EmployeeID from file path condition was not working as File path does not contain EmployeeID in it. Correction : The condition of checking EmployeeID authentication is changed now and pdf file is getting downloaded according to file path properly. Pre-stage check-in is done. Thanks, Aarati R. Sabnis CC Satya , Swapnil Pandhare , Rakesh Roy
            rajendraj Rajendra Joshi (Inactive) logged work - 23/Nov/16 04:48 AM
            • Time Spent:
              5h
               
              <No comment>
            rajendraj Rajendra Joshi (Inactive) made changes -
            Original Estimate 1h [ 3600 ] 8h [ 28800 ]
            rajendraj Rajendra Joshi (Inactive) made changes -
            Remaining Estimate 2h [ 7200 ] 0h [ 0 ]
            Time Spent 1h [ 3600 ] 6h [ 21600 ]
            Worklog Id 10251 [ 10251 ]
            rajendraj Rajendra Joshi (Inactive) logged work - 23/Nov/16 04:49 AM
            • Time Spent:
              5h
               
              <No comment>
            rajendraj Rajendra Joshi (Inactive) made changes -
            Time Spent 6h [ 21600 ] 11h [ 39600 ]
            Worklog Id 10252 [ 10252 ]
            rajendraj Rajendra Joshi (Inactive) made changes -
            Remaining Estimate 0h [ 0 ] 4h [ 14400 ]
            satyap Satya made changes -
            Assignee Aarati Sabnis [ aarati.sabnis ] Shyam Sharma [ shyam sharma ]
            shyam.sharma shyam sharma (Inactive) made changes -
            Assignee Shyam Sharma [ shyam sharma ] Swapnil Pandhare [ swapnil.pandhare ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Issue Importance Q1 [ 14900 ]
            nidhi.kaul Nidhi Kaul (Inactive) made changes -
            Assignee Swapnil Pandhare [ swapnil.pandhare ] Nidhi Kaul [ nidhi.kaul ]
            nidhi.kaul Nidhi Kaul (Inactive) made changes -
            Assignee Nidhi Kaul [ nidhi.kaul ] Swapnil Pandhare [ swapnil.pandhare ]
            nidhi.kaul Nidhi Kaul (Inactive) made changes -
            Attachment Re WT-6529.msg [ 56234 ]
            Hide
            nidhi.kaul Nidhi Kaul (Inactive) added a comment -

            closing as pre-stage environment is no longer in use. Reference communication attached.

            Show
            nidhi.kaul Nidhi Kaul (Inactive) added a comment - closing as pre-stage environment is no longer in use. Reference communication attached.
            nidhi.kaul Nidhi Kaul (Inactive) made changes -
            Status Reopen in Stage [ 10023 ] In Development [ 10007 ]
            nidhi.kaul Nidhi Kaul (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            nidhi.kaul Nidhi Kaul (Inactive) made changes -
            Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
            nidhi.kaul Nidhi Kaul (Inactive) made changes -
            Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
            Hide
            nidhi.kaul Nidhi Kaul (Inactive) added a comment -

            not valid anymore

            Show
            nidhi.kaul Nidhi Kaul (Inactive) added a comment - not valid anymore
            nidhi.kaul Nidhi Kaul (Inactive) made changes -
            Resolution Unresolved [ 10200 ] Cancelled [ 10300 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            nidhi.kaul Nidhi Kaul (Inactive) made changes -
            Resolution Cancelled [ 10300 ] Fixed [ 1 ]
            Status Production Complete [ 10028 ] Closed [ 6 ]
            satyap Satya made changes -
            Environment_New Stage [ 18443 ]
            Transition Time In Source Status Execution Times
            Aarati Sabnis (Inactive) made transition -
            Open In Development
            19h 58m 1
            Rajendra Joshi (Inactive) made transition -
            Stage Testing Reopened in Stage
            6m 5s 1
            Nidhi Kaul (Inactive) made transition -
            Reopened in Stage In Development
            241d 16m 1
            Nidhi Kaul (Inactive) made transition -
            In Development In LB Testing
            1h 31m 2
            Nidhi Kaul (Inactive) made transition -
            In LB Testing Stage Testing
            6s 2
            Nidhi Kaul (Inactive) made transition -
            Stage Testing In Production Testing
            2s 1
            Nidhi Kaul (Inactive) made transition -
            In Production Testing Production Complete
            26s 1
            Nidhi Kaul (Inactive) made transition -
            Production Complete Closed
            6s 1

              People

              Assignee:
              swapnil.pandhare Swapnil Pandhare (Inactive)
              Reporter:
              rajendraj Rajendra Joshi (Inactive)
              QA:
              Rajendra Joshi (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 8h Original Estimate - 8h
                  8h
                  Remaining:
                  Time Spent - 11h Remaining Estimate - 4h
                  4h
                  Logged:
                  Time Spent - 11h Remaining Estimate - 4h
                  11h