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

University Health - Incorrect date time inserted

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Medium
    • Resolution: Cannot Reproduce
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Environment:
      Production
    • Bug Type:
      Functional
    • Bug Severity:
      Medium
    • Module:
      BenAdmin - Enrollment
    • Reported by:
      Support
    • Company:
      University Health
    • Sprint:
      WT Sprint 40 - Bugs

      Description

      As we discussed please check why the incorrect date time inserted against enrollment.

      Gaurav Sodani,Satya

        Attachments

          Issue Links

            Activity

            Ganesh.sadawarte Ganesh Sadawarte (Inactive) created issue -
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
            Field Original Value New Value
            Account Executive Van Nguyen [ van.nguyen ]
            EDI Analyst 1 Van Nguyen [ van.nguyen ]
            abhilash.warkari Abhilash Warkari (Inactive) made changes -
            Assignee Jyoti Mayne [ jyoti.mayne ] Abhilash Warkari [ abhilash.warkari ]
            abhilash.warkari Abhilash Warkari (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            abhilash.warkari Abhilash Warkari (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Analysis(10204)
            abhilash.warkari Abhilash Warkari (Inactive) made changes -
            Developer Abhilash Warkari [ abhilash.warkari ]
            jyoti.mayne Jyoti Mayne made changes -
            Link This issue relates to WT-11667 [ WT-11667 ]
            abhilash.warkari Abhilash Warkari (Inactive) made changes -
            Sprint WT Sprint 40 - Bugs [ 94 ]
            abhilash.warkari Abhilash Warkari (Inactive) made changes -
            Dev Due Date 24/Oct/2017
            abhilash.warkari Abhilash Warkari (Inactive) logged work - 23/Oct/17 04:30 PM
            • Time Spent:
              1h
               

              Analysis.
              Data Anylisis.
              Discussion with jyoti.

            abhilash.warkari Abhilash Warkari (Inactive) made changes -
            Remaining Estimate 0h [ 0 ]
            Time Spent 1h [ 3600 ]
            Worklog Id 85955 [ 85955 ]
            jyoti.mayne Jyoti Mayne made changes -
            Dev Due Date 24/Oct/2017 25/Oct/2017
            jyoti.mayne Jyoti Mayne logged work - 25/Oct/17 08:43 AM
            • Time Spent:
              1h
               

              analysis, data correction of duplicate election and reproduce issue discussion

            Hide
            abhilash.warkari Abhilash Warkari (Inactive) added a comment - - edited

            Hi Prasad Pise

            Please find below details :

            Employee : ANGELA JIMES .
            Plan : Spouse AD&D

            Mentioed EE's spouse is enrolled in 'Spouse AD&D' plan.
            On 17-10-2017 reduction service reduced the coverage of Spouse but wrong DateTimeStamp was updated.
            Please refer the screenshot attached.

            We tiered to reproduce the issue but it is not reproducing.
            Please help us in reproducing the issue.

            Thanks And Regards
            Abhilash Warkari

            CC : Jyoti Mayne, Umesh Kadam, Amruta Lohiya

            Show
            abhilash.warkari Abhilash Warkari (Inactive) added a comment - - edited Hi Prasad Pise Please find below details : Employee : ANGELA JIMES . Plan : Spouse AD&D Mentioed EE's spouse is enrolled in 'Spouse AD&D' plan. On 17-10-2017 reduction service reduced the coverage of Spouse but wrong DateTimeStamp was updated. Please refer the screenshot attached. We tiered to reproduce the issue but it is not reproducing. Please help us in reproducing the issue. Thanks And Regards Abhilash Warkari CC : Jyoti Mayne , Umesh Kadam , Amruta Lohiya
            abhilash.warkari Abhilash Warkari (Inactive) made changes -
            Assignee Abhilash Warkari [ abhilash.warkari ] Prasad Pise [ prasadp ]
            abhilash.warkari Abhilash Warkari (Inactive) made changes -
            Time Spent 1h [ 3600 ] 7h [ 25200 ]
            Worklog Id 86267 [ 86267 ]
            prasadp Prasad Pise (Inactive) made changes -
            Assignee Prasad Pise [ prasadp ] Hrishikesh Deshpande [ hrishikesh.deshpande ]
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Assignee Hrishikesh Deshpande [ hrishikesh.deshpande ] Rashmita Dudhe [ rashmita.dudhe ]
            abhilash.warkari Abhilash Warkari (Inactive) logged work - 25/Oct/17 04:30 PM
            • Time Spent:
              6h
               

              Analysis of the issue.
              Tried scenarios.
              Data Analysis on local and production.
              Discussion With Jyoti.
              Tried to reproduce the issue.

            jyoti.mayne Jyoti Mayne made changes -
            Time Spent 7h [ 25200 ] 8h [ 28800 ]
            Worklog Id 86600 [ 86600 ]
            rashmita.dudhe Rashmita Dudhe (Inactive) logged work - 26/Oct/17 10:15 AM - edited
            • Time Spent:
              4.5h
               

              try to repro issue analysis of employee data

            Hide
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - - edited

            Hi Satya,

            CC:Rakesh Roy,Hrishikesh Deshpande,Jyoti Mayne,Abhilash Warkari,Jaideep Vinchurkar,Suraj Sokasane, Amruta Lohiya

            I have tried to reproduce this issue but it not getting reproduced. So, why it had happened for that I analyze reported employee data. As per employee View History, I found Employee data was inserted through import as historical data on date 10/06/2017 By Jaideep and Vishal.

            For Spouse AD&D Plan Election import was done more than 30 times and spouse age is already 70+ so after every import reduction service run and reduced coverage as 50%.
            Sometimes reduction service run through manually.
            Because of that data corrupted and wrong date time stamp was updated for Employees.

            Thanks,
            Rashmita

            Show
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - - edited Hi Satya , CC: Rakesh Roy , Hrishikesh Deshpande , Jyoti Mayne , Abhilash Warkari , Jaideep Vinchurkar , Suraj Sokasane , Amruta Lohiya I have tried to reproduce this issue but it not getting reproduced. So, why it had happened for that I analyze reported employee data. As per employee View History, I found Employee data was inserted through import as historical data on date 10/06/2017 By Jaideep and Vishal. For Spouse AD&D Plan Election import was done more than 30 times and spouse age is already 70+ so after every import reduction service run and reduced coverage as 50%. Sometimes reduction service run through manually. Because of that data corrupted and wrong date time stamp was updated for Employees. Thanks, Rashmita
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Time Spent 8h [ 28800 ] 12h [ 43200 ]
            Worklog Id 86662 [ 86662 ]
            jyoti.mayne Jyoti Mayne logged work - 26/Oct/17 12:17 PM
            • Time Spent:
              0.25h
               

              discussion with Rashmita on her findings

            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Time Spent 12h [ 43200 ] 12.5h [ 45000 ]
            Worklog Id 86662 [ 86662 ]
            jyoti.mayne Jyoti Mayne made changes -
            Time Spent 12.5h [ 45000 ] 12.75h [ 45900 ]
            Worklog Id 87166 [ 87166 ]
            rashmita.dudhe Rashmita Dudhe (Inactive) logged work - 30/Oct/17 09:04 AM
            • Time Spent:
              0.5h
               

              Discussion with jaideep

            Hide
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment -

            Hi Van Nguyen,

            CC:Hrishikesh Deshpande,Jaideep Vinchurkar,Hrishikesh Deshpande

            I have verified reported employees and found manual data correction was done for those employees and because of that wrong date time stamp was updated.
            I have all possible scenarios to reproduce this issue through UI but could not able to reproduce it is working properly.

            Thanks,
            Rashmita

            Show
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - Hi Van Nguyen , CC: Hrishikesh Deshpande , Jaideep Vinchurkar , Hrishikesh Deshpande I have verified reported employees and found manual data correction was done for those employees and because of that wrong date time stamp was updated. I have all possible scenarios to reproduce this issue through UI but could not able to reproduce it is working properly. Thanks, Rashmita
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Time Spent 12.75h [ 45900 ] 13.25h [ 47700 ]
            Worklog Id 87495 [ 87495 ]
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Assignee Rashmita Dudhe [ rashmita.dudhe ] Van Nguyen [ van.nguyen ]
            Resolution Cannot Reproduce [ 5 ]
            Status In Development [ 10007 ] Rejected [ 10004 ]
            jyoti.mayne Jyoti Mayne made changes -
            Item State Parent values: Development(10200)Level 1 values: In Analysis(10204)
            umesh.kadam Umesh Kadam (Inactive) made changes -
            Labels Benefit_Administration
            Van.Nguyen Van Nguyen (Inactive) made changes -
            Status Rejected [ 10004 ] Closed [ 6 ]
            satyap Satya made changes -
            Environment_New Production [ 18442 ]
            Transition Time In Source Status Execution Times
            Abhilash Warkari (Inactive) made transition -
            Open In Development
            4d 18h 4m 1
            Rashmita Dudhe (Inactive) made transition -
            In Development Rejected
            7d 3h 22m 1
            Van Nguyen (Inactive) made transition -
            Rejected Closed
            2d 13h 23m 1

              People

              Assignee:
              Van.Nguyen Van Nguyen (Inactive)
              Reporter:
              Ganesh.sadawarte Ganesh Sadawarte (Inactive)
              Account Executive:
              Van Nguyen (Inactive)
              EDI Analyst 1:
              Van Nguyen (Inactive)
              Developer:
              Abhilash Warkari (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Dev Due Date:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 13.25h
                  13.25h