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

Duplicate election was caused by Reduction Schedule Service

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Cannot Reproduce
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Environment:
      Production
    • Bug Type:
      Functional
    • Bug Severity:
      Critical
    • Module:
      BenAdmin - Enrollment
    • Reported by:
      Data Audit
    • Issue Importance:
      Must Have
    • Sprint:
      WT Sprint 35 - Bugs

      Description

      Duplicate election was caused by Reduction Schedule Service, on 01/24/2017 RSS reduce coverage and insert two enrollments with same effective date.

      Company Name:- BDG
      Employee:- Brenda Osorio
      Plan Name:- Basic Life and AD&D Hourly

      Company Name:- Mendocino Coast District Hospital
      Employee:- NICOLA BOYNOFF
      Plan Name:- Basic Life and AD&D Non-Exempt

      Employee:- Kyle Siler
      Plan Name:- Basic Life and AD&D Exempt Employee

      CC-- Amruta Lohiya,Satya,Vijay Siddha

        Attachments

        1. 1stScenario.png
          1stScenario.png
          66 kB
        2. 2ndScenario.png
          2ndScenario.png
          72 kB
        3. 3rdScenario.png
          3rdScenario.png
          83 kB

          Activity

          avnish.yadav Avnish Yadav (Inactive) created issue -
          avnish.yadav Avnish Yadav (Inactive) made changes -
          Field Original Value New Value
          Assignee Avnish Yadav [ avnish.yadav ] Jyoti Mayne [ jyoti.mayne ]
          jyoti.mayne Jyoti Mayne made changes -
          Assignee Jyoti Mayne [ jyoti.mayne ] Shailendra Honrao [ shailendra.honrao ]
          jyoti.mayne Jyoti Mayne made changes -
          Sprint WT Sprint 35 - Bugs [ 81 ]
          jyoti.mayne Jyoti Mayne made changes -
          Dev Due Date 24/Aug/2017
          jyoti.mayne Jyoti Mayne made changes -
          Assignee Shailendra Honrao [ shailendra.honrao ] Snehal Shabade [ snehal.shabade ]
          snehal.shabade Snehal Shabade (Inactive) made changes -
          Status Open [ 1 ] In Development [ 10007 ]
          snehal.shabade Snehal Shabade (Inactive) made changes -
          Dev Due Date 24/Aug/2017 24/Aug/2017
          Developer Snehal Shabade [ snehal.shabade ]
          Item State Parent values: Development(10200)Level 1 values: In Analysis(10204)
          jyoti.mayne Jyoti Mayne logged work - 21/Aug/17 09:43 AM
          • Time Spent:
            40m
             

            analysis and scenario explanation

          snehal.shabade Snehal Shabade (Inactive) logged work - 21/Aug/17 05:11 PM
          • Time Spent:
            3h
             

            Analysis data on production,discussion with jyoti and avnish
            Company attached to local

          snehal.shabade Snehal Shabade (Inactive) made changes -
          Remaining Estimate 0h [ 0 ]
          Original Estimate 0h [ 0 ]
          snehal.shabade Snehal Shabade (Inactive) made changes -
          Original Estimate 0h [ 0 ] 20h [ 72000 ]
          snehal.shabade Snehal Shabade (Inactive) made changes -
          Time Spent 3h [ 10800 ]
          Worklog Id 73171 [ 73171 ]
          jyoti.mayne Jyoti Mayne logged work - 22/Aug/17 10:12 AM
          • Time Spent:
            0.5h
             

            discussion and analysis

          snehal.shabade Snehal Shabade (Inactive) made changes -
          Attachment 2ndScenario.png [ 59534 ]
          Attachment 3rdScenario.png [ 59535 ]
          Attachment 1stScenario.png [ 59536 ]
          Hide
          snehal.shabade Snehal Shabade (Inactive) added a comment -

          Hi,
          We tried scenarios for following issue :

          Duplicate election was caused by Reduction Schedule Service
          Company Name:- BDG
          Employee:- Brenda Osorio
          Plan Name:- Basic Life and AD&D Hourly

          We did some analysis on production and observe that even though the enrollment table has duplicate elections ,the ReductionDetailsForReductionSchedule table has only one entry of coverage Reduction.

          For reproducing this issue we tried following scenarios:

          1. Enroll EE with Effective Date 2015/01/01 on 2017/08/22
            Update DOB of EE such that age of EE >65 on 2017/08/22 and Run the Reduction service
            Result : Election is enrolled properly with no duplication
          2. Enroll EE with Effective Date 2015/01/01 on 2017/08/22
            Update DOB of EE such that age of EE = 65 on 2017/08/22 and Run the Reduction service
            Result : Election is enrolled properly with no duplication
          3. Enroll EE with Effective Date 2015/01/01 on 2017/08/22
            Update DOB of EE such that age of EE is one day minus of 65 on 2017/08/22 and Run the Reduction service
            Result : Election is enrolled properly with no duplication

          Please find the attached screen shot for all scenarios :

          Cc: Jyoti Mayne Avnish Yadav Gaurav Sodani Hrishikesh Deshpande Prasad Pise

          Thanks,
          Snehal Shabade

          Show
          snehal.shabade Snehal Shabade (Inactive) added a comment - Hi, We tried scenarios for following issue : Duplicate election was caused by Reduction Schedule Service Company Name:- BDG Employee:- Brenda Osorio Plan Name:- Basic Life and AD&D Hourly We did some analysis on production and observe that even though the enrollment table has duplicate elections ,the ReductionDetailsForReductionSchedule table has only one entry of coverage Reduction. For reproducing this issue we tried following scenarios: Enroll EE with Effective Date 2015/01/01 on 2017/08/22 Update DOB of EE such that age of EE >65 on 2017/08/22 and Run the Reduction service Result : Election is enrolled properly with no duplication Enroll EE with Effective Date 2015/01/01 on 2017/08/22 Update DOB of EE such that age of EE = 65 on 2017/08/22 and Run the Reduction service Result : Election is enrolled properly with no duplication Enroll EE with Effective Date 2015/01/01 on 2017/08/22 Update DOB of EE such that age of EE is one day minus of 65 on 2017/08/22 and Run the Reduction service Result : Election is enrolled properly with no duplication Please find the attached screen shot for all scenarios : Cc: Jyoti Mayne Avnish Yadav Gaurav Sodani Hrishikesh Deshpande Prasad Pise Thanks, Snehal Shabade
          snehal.shabade Snehal Shabade (Inactive) logged work - 22/Aug/17 04:18 PM
          • Time Spent:
            6.5h
             

            Analysis,Tried scenarios,discussion with jyoti

          snehal.shabade Snehal Shabade (Inactive) made changes -
          Time Spent 3h [ 10800 ] 9.5h [ 34200 ]
          Worklog Id 73576 [ 73576 ]
          jyoti.mayne Jyoti Mayne logged work - 23/Aug/17 10:31 AM
          • Time Spent:
            0.25h
             

            discussion on reduction data corrupted issue for Mendocino Coast District Hospital company

          Hide
          snehal.shabade Snehal Shabade (Inactive) added a comment -

          Hi Avnish Yadav,

          Issue: Duplicate Coverage string
          Company Name:- Mendocino Coast District Hospital
          Employee:- NICOLA BOYNOFF
          Plan Name:- Basic Life and AD&D Non-Exempt

          We did some analysis on production and we found that the duplicate coverage string is present in enrollment on 2015-12-03 and this issue is not present after 2015-12-03 .
          This is due to data corruption.We need some data correction for this.

          We also tried this but it is not getting reproduced.

          Cc: Jyoti Mayne

          Thanks,
          Snehal Shabade

          Show
          snehal.shabade Snehal Shabade (Inactive) added a comment - Hi Avnish Yadav , Issue: Duplicate Coverage string Company Name:- Mendocino Coast District Hospital Employee:- NICOLA BOYNOFF Plan Name:- Basic Life and AD&D Non-Exempt We did some analysis on production and we found that the duplicate coverage string is present in enrollment on 2015-12-03 and this issue is not present after 2015-12-03 . This is due to data corruption.We need some data correction for this. We also tried this but it is not getting reproduced. Cc: Jyoti Mayne Thanks, Snehal Shabade
          Hide
          snehal.shabade Snehal Shabade (Inactive) added a comment -

          hi Prasad Pise,

          We tried above scenarios for reproducing issue "Duplicate election was caused by Reduction Schedule Service" but it is not getting reproduced.

          Could you please help to reproduce this issue?

          Cc: Jyoti Mayne

          Thanks,
          Snehal Shabade

          Show
          snehal.shabade Snehal Shabade (Inactive) added a comment - hi Prasad Pise , We tried above scenarios for reproducing issue "Duplicate election was caused by Reduction Schedule Service" but it is not getting reproduced. Could you please help to reproduce this issue? Cc: Jyoti Mayne Thanks, Snehal Shabade
          snehal.shabade Snehal Shabade (Inactive) made changes -
          Assignee Snehal Shabade [ snehal.shabade ] Prasad Pise [ prasadp ]
          snehal.shabade Snehal Shabade (Inactive) logged work - 23/Aug/17 04:23 PM
          • Time Spent:
            6.5h
             

            Did analysis on duplicate coverage string and duplicate election inserted on feature enrollment OK and cancel popup .

          snehal.shabade Snehal Shabade (Inactive) made changes -
          Time Spent 9.5h [ 34200 ] 16h [ 57600 ]
          Worklog Id 73976 [ 73976 ]
          jyoti.mayne Jyoti Mayne made changes -
          Time Spent 16h [ 57600 ] 16h 40m [ 60000 ]
          Worklog Id 74242 [ 74242 ]
          jyoti.mayne Jyoti Mayne made changes -
          Time Spent 16h 40m [ 60000 ] 17h 10m [ 61800 ]
          Worklog Id 74251 [ 74251 ]
          jyoti.mayne Jyoti Mayne made changes -
          Time Spent 17h 10m [ 61800 ] 17h 25m [ 62700 ]
          Worklog Id 74258 [ 74258 ]
          Hide
          prasadp Prasad Pise (Inactive) added a comment -

          Hi Rashmita Dudhe

          Could you please try to reproduce this issue and share your findings with dev team?

          Thanks
          -Prasad

          CC: Hrishikesh DeshpandeRakesh RoySachin Hingole

          Show
          prasadp Prasad Pise (Inactive) added a comment - Hi Rashmita Dudhe Could you please try to reproduce this issue and share your findings with dev team? Thanks -Prasad CC: Hrishikesh Deshpande Rakesh Roy Sachin Hingole
          prasadp Prasad Pise (Inactive) made changes -
          Assignee Prasad Pise [ prasadp ] Rashmita Dudhe [ rashmita.dudhe ]
          Hide
          rashmita.dudhe Rashmita Dudhe (Inactive) added a comment -

          Hi Avnish Yadav,

          CC:Satya,Hrishikesh Deshpande,Rakesh Roy,Gaurav Sodani,Jyoti Mayne

          Try to reproduced Above issue but it is not getting reproduced tried below scenarios:

          Company Name:- BDG
          Employee:- Brenda Osorio
          Plan Name:- Basic Life and AD&D Hourly

          1] As per Employee view history, Employee data inserted through Import and core plan allocated to employee.
          Basic Life and AD&D Hourly :01/01/2014 - 12/31/2014
          Basic Life and AD&D Hourly: 1/1/2015 - Null

          after data imported cross verified on view history It showing two Entries
          Basic Life and AD&D Hourly :01/01/2014 - 12/31/2014
          Basic Life and AD&D Hourly: 1/1/2015 - Null

          when reduction serviced run on Employee birth day
          It reduced Employee Coverage and insert New entry.

          2] Employee data inserted through Import and core plan allocated to employee.
          Basic Life and AD&D Hourly :01/01/2014 - 12/31/2014
          Basic Life and AD&D Hourly: 1/1/2015 - Null

          verified for Age band change and reduction same time
          run reduction service and appyAgebandchange service
          It reduced Employee Coverage and New entry.

          3] Add employee through Ui core plan allocated to employee
          verified on view history It showing two Entries
          Basic Life and AD&D Hourly :01/01/2014 - 12/31/2014
          Basic Life and AD&D Hourly: 1/1/2015 - Null

          verified for Age band change and reduction same time
          run reduction service and appyAgebandchange service
          It reduced Employee Coverage and New entry.

          4] Verified Plan View history and found Plan Basic Life and AD&D Hourly: 1/1/2015 - Null is cloned from Basic Life and AD&D Hourly :01/01/2014 - 12/31/2014

          So created same scenario on Company Create New Life plan with date 01/01/2014 - 12/31/2014 and clone paln with 1/1/2015 - Null

          Employee data inserted through Import and core plan allocated to employee.

          after data imported cross verified on view history It showing two Entries
          verified for Age band change and reduction same time
          run reduction service and appyAgebandchange service
          It reduced Employee Coverage and New entry.

          5] Add employee through Ui core plan allocated to employee

          verified for Age band change and reduction same time
          run reduction service and appyAgebandchange service
          It reduced Employee Coverage and New entry.

          Thanks,
          Rashmita

          Show
          rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - Hi Avnish Yadav , CC: Satya , Hrishikesh Deshpande , Rakesh Roy , Gaurav Sodani , Jyoti Mayne Try to reproduced Above issue but it is not getting reproduced tried below scenarios: Company Name:- BDG Employee:- Brenda Osorio Plan Name:- Basic Life and AD&D Hourly 1] As per Employee view history, Employee data inserted through Import and core plan allocated to employee. Basic Life and AD&D Hourly :01/01/2014 - 12/31/2014 Basic Life and AD&D Hourly: 1/1/2015 - Null after data imported cross verified on view history It showing two Entries Basic Life and AD&D Hourly :01/01/2014 - 12/31/2014 Basic Life and AD&D Hourly: 1/1/2015 - Null when reduction serviced run on Employee birth day It reduced Employee Coverage and insert New entry. 2] Employee data inserted through Import and core plan allocated to employee. Basic Life and AD&D Hourly :01/01/2014 - 12/31/2014 Basic Life and AD&D Hourly: 1/1/2015 - Null verified for Age band change and reduction same time run reduction service and appyAgebandchange service It reduced Employee Coverage and New entry. 3] Add employee through Ui core plan allocated to employee verified on view history It showing two Entries Basic Life and AD&D Hourly :01/01/2014 - 12/31/2014 Basic Life and AD&D Hourly: 1/1/2015 - Null verified for Age band change and reduction same time run reduction service and appyAgebandchange service It reduced Employee Coverage and New entry. 4] Verified Plan View history and found Plan Basic Life and AD&D Hourly: 1/1/2015 - Null is cloned from Basic Life and AD&D Hourly :01/01/2014 - 12/31/2014 So created same scenario on Company Create New Life plan with date 01/01/2014 - 12/31/2014 and clone paln with 1/1/2015 - Null Employee data inserted through Import and core plan allocated to employee. after data imported cross verified on view history It showing two Entries verified for Age band change and reduction same time run reduction service and appyAgebandchange service It reduced Employee Coverage and New entry. 5] Add employee through Ui core plan allocated to employee verified for Age band change and reduction same time run reduction service and appyAgebandchange service It reduced Employee Coverage and New entry. Thanks, Rashmita
          rashmita.dudhe Rashmita Dudhe (Inactive) logged work - 01/Sep/17 04:18 AM - edited
          • Time Spent:
            2h
             

            Scenario Verification

          rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
          Time Spent 17h 25m [ 62700 ] 21h 25m [ 77100 ]
          Worklog Id 76325 [ 76325 ]
          rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
          Remaining Estimate 0h [ 0 ] 2h [ 7200 ]
          Time Spent 21h 25m [ 77100 ] 19h 25m [ 69900 ]
          Worklog Id 76325 [ 76325 ]
          Hide
          gaurav.sodani Gaurav Sodani (Inactive) added a comment -

          Hi Avnish,

          Could you please look into the issue

          Thanks
          Gaurav

          CC SatyaVijay SiddhaRashmita DudheJyoti Mayne

          Show
          gaurav.sodani Gaurav Sodani (Inactive) added a comment - Hi Avnish, Could you please look into the issue Thanks Gaurav CC Satya Vijay Siddha Rashmita Dudhe Jyoti Mayne
          rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
          Assignee Rashmita Dudhe [ rashmita.dudhe ] Avnish Yadav [ avnish.yadav ]
          gaurav.sodani Gaurav Sodani (Inactive) made changes -
          Issue Category Harbinger [ 10700 ] Data Audit [ 18400 ]
          Hide
          avnish.yadav Avnish Yadav (Inactive) added a comment -

          As this is not reproduce by QA and Dev. So we are marking as close.

          Show
          avnish.yadav Avnish Yadav (Inactive) added a comment - As this is not reproduce by QA and Dev. So we are marking as close.
          avnish.yadav Avnish Yadav (Inactive) made changes -
          Resolution Cannot Reproduce [ 5 ]
          Status In Development [ 10007 ] Rejected [ 10004 ]
          avnish.yadav Avnish Yadav (Inactive) made changes -
          Status Rejected [ 10004 ] Closed [ 6 ]
          jyoti.mayne Jyoti Mayne made changes -
          Item State Parent values: Development(10200)Level 1 values: In Analysis(10204)
          satyap Satya made changes -
          Environment_New Production [ 18442 ]
          Transition Time In Source Status Execution Times
          Snehal Shabade (Inactive) made transition -
          Open In Development
          12d 2h 59m 1
          Avnish Yadav (Inactive) made transition -
          In Development Rejected
          56d 21h 56m 1
          Avnish Yadav (Inactive) made transition -
          Rejected Closed
          5s 1

            People

            Assignee:
            avnish.yadav Avnish Yadav (Inactive)
            Reporter:
            avnish.yadav Avnish Yadav (Inactive)
            Developer:
            Snehal Shabade (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Dev Due Date:

                Time Tracking

                Estimated:
                Original Estimate - 20h Original Estimate - 20h
                20h
                Remaining:
                Time Spent - 19h 25m Remaining Estimate - 2h
                2h
                Logged:
                Time Spent - 19h 25m Remaining Estimate - 2h
                19h 25m