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

Remove CDC dependency from Export

    Details

    • Type: Enhancement
    • Status: Closed
    • Priority: High
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Module:
      BenAdmin - Export
    • Reported by:
      Harbinger
    • Item State:
      Production Complete - Closed
    • Issue Importance:
      Must Have
    • Sprint:
      WT Sprint 34 - Enhancements
    • Severity:
      Complex

      Description

      For Cobra Data template type we currently use CDC feature of Microsoft to gather and track data changes.

      Now a days, CDC services are failing frequently and using more resources which in turn making system slow.

      We need to find out a way to handle this internally and removed CDC dependency.

        Attachments

          Issue Links

            Activity

            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) created issue -
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
            Field Original Value New Value
            Assignee Vijay Siddha [ vijays ] Vinayak Kulkarni [ vinayak.kulkarni ]
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) logged work - 12/Dec/16 01:47 PM
            • Time Spent:
              1h
               

              Internal Discussion of option for CDC

            Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
            Remaining Estimate 35h [ 126000 ] 34h [ 122400 ]
            Time Spent 1h [ 3600 ]
            Worklog Id 12551 [ 12551 ]
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) logged work - 12/Dec/16 01:51 PM
            • Time Spent:
              1h
               

              initial analysis with Indra, Saurabh, Rohan, Ganesh, Rajendra.

            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
            Remaining Estimate 34h [ 122400 ] 33h [ 118800 ]
            Time Spent 1h [ 3600 ] 2h [ 7200 ]
            Worklog Id 12555 [ 12555 ]
            rohan.khandave Rohan J Khandave (Inactive) logged work - 12/Dec/16 02:26 PM
            • Time Spent:
              1h
               

              Discussion For Alternative Option

            rohan.khandave Rohan J Khandave (Inactive) made changes -
            Remaining Estimate 33h [ 118800 ] 32h [ 115200 ]
            Time Spent 2h [ 7200 ] 3h [ 10800 ]
            Worklog Id 12572 [ 12572 ]
            saurabh.sablaka Saurabh Sablaka (Inactive) logged work - 12/Dec/16 03:32 PM
            • Time Spent:
              1h
               

              Internal discussion on alternative for CDC

            saurabh.sablaka Saurabh Sablaka (Inactive) made changes -
            Remaining Estimate 32h [ 115200 ] 31h [ 111600 ]
            Time Spent 3h [ 10800 ] 4h [ 14400 ]
            Worklog Id 12597 [ 12597 ]
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
            Summary Removed CDC dependency from Export Remove CDC dependency from Export
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
            Status New Request [ 10029 ] Pending for Approval [ 10002 ]
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
            Status Pending for Approval [ 10002 ] Rejected [ 10004 ]
            Hide
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment -

            Duplicate of WT-9141

            Show
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment - Duplicate of WT-9141
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
            Link This issue is duplicated by WT-9141 [ WT-9141 ]
            satyap Satya made changes -
            Issue Type Enhancement [ 4 ] Analysis [ 10711 ]
            Status Rejected [ 10004 ] In Analysis [ 10008 ]
            Workflow WT_Features [ 28670 ] WorkTerra_Analysis_ver 1.0 [ 47953 ]
            satyap Satya made changes -
            Issue Type Analysis [ 10711 ] Enhancement [ 4 ]
            Status In Analysis [ 10008 ] New Request [ 10029 ]
            Workflow WorkTerra_Analysis_ver 1.0 [ 47953 ] WT_Features [ 47954 ]
            Hide
            satyap Satya added a comment -

            Re-opened this ticket for scheduling Export part. Other ticket WT-9141, will be used for EDS part enhancement.

            Regards,
            Satya Prakash

            Cc: Vinayak Kulkarni Sheetal Bodhale Gaurav Sodani Vijay Siddha

            Show
            satyap Satya added a comment - Re-opened this ticket for scheduling Export part. Other ticket WT-9141 , will be used for EDS part enhancement. Regards, Satya Prakash Cc: Vinayak Kulkarni Sheetal Bodhale Gaurav Sodani Vijay Siddha
            satyap Satya made changes -
            Priority Medium [ 3 ] High [ 2 ]
            satyap Satya made changes -
            Dev Estimates 56
            Issue Importance Must Have [ 11800 ]
            QA Estimates 21
            Severity Complex [ 13103 ]
            rakesh.shahane Rakesh Shahane (Inactive) made changes -
            Status New Request [ 10029 ] Pending for Approval [ 10002 ]
            rakesh.shahane Rakesh Shahane (Inactive) made changes -
            Status Pending for Approval [ 10002 ] Approved for Development [ 10003 ]
            rakesh.shahane Rakesh Shahane (Inactive) made changes -
            Status Approved for Development [ 10003 ] In Development [ 10007 ]
            rakesh.shahane Rakesh Shahane (Inactive) made changes -
            Assignee Vinayak Kulkarni [ vinayak.kulkarni ] Rakesh Shahane [ rakesh.shahane ]
            rakesh.shahane Rakesh Shahane (Inactive) logged work - 31/Jul/17 05:08 PM
            • Time Spent:
              1.8h
               
              <No comment>
            rakesh.shahane Rakesh Shahane (Inactive) made changes -
            Remaining Estimate 31h [ 111600 ] 29.2h [ 105120 ]
            Time Spent 4h [ 14400 ] 5.8h [ 20880 ]
            Worklog Id 68549 [ 68549 ]
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
            Dev Due Date 07/Aug/2017
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Sprint WT Sprint 34 - Enhancements [ 80 ]
            rakesh.shahane Rakesh Shahane (Inactive) logged work - 02/Aug/17 05:31 AM
            • Time Spent:
              7h
               
              <No comment>
            rakesh.shahane Rakesh Shahane (Inactive) logged work - 02/Aug/17 12:54 PM
            • Time Spent:
              1.2h
               

              Development discussion.

            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) logged work - 02/Aug/17 02:08 PM
            • Time Spent:
              1h
               
              <No comment>
            rakesh.shahane Rakesh Shahane (Inactive) logged work - 02/Aug/17 05:33 PM
            • Time Spent:
              7.2h
               
              <No comment>
            rakesh.shahane Rakesh Shahane (Inactive) made changes -
            Remaining Estimate 29.2h [ 105120 ] 22.2h [ 79920 ]
            Time Spent 5.8h [ 20880 ] 12.8h [ 46080 ]
            Worklog Id 69103 [ 69103 ]
            rakesh.shahane Rakesh Shahane (Inactive) made changes -
            Remaining Estimate 22.2h [ 79920 ] 15h [ 54000 ]
            Time Spent 12.8h [ 46080 ] 20h [ 72000 ]
            Worklog Id 69107 [ 69107 ]
            rakesh.shahane Rakesh Shahane (Inactive) logged work - 03/Aug/17 12:55 PM
            • Time Spent:
              6h
               
              <No comment>
            rakesh.shahane Rakesh Shahane (Inactive) logged work - 04/Aug/17 12:57 PM
            • Time Spent:
              8h
               
              <No comment>
            rakesh.shahane Rakesh Shahane (Inactive) logged work - 07/Aug/17 12:58 PM - edited
            • Time Spent:
              7h 50m
               
              <No comment>
            rakesh.shahane Rakesh Shahane (Inactive) made changes -
            Attachment AffectedFiles.txt [ 57912 ]
            rakesh.shahane Rakesh Shahane (Inactive) made changes -
            Code Review Date 08/Aug/2017
            Code Reviewed By Vinalyak Kulkarni [ 12100 ]
            Item State Parent values: Development(10200)Level 1 values: In Analysis(10204) Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209)
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            rakesh.shahane Rakesh Shahane (Inactive) made changes -
            Remaining Estimate 15h [ 54000 ] 13.8h [ 49680 ]
            Time Spent 20h [ 72000 ] 21.2h [ 76320 ]
            Worklog Id 70120 [ 70120 ]
            rakesh.shahane Rakesh Shahane (Inactive) made changes -
            Remaining Estimate 13.8h [ 49680 ] 7.8h [ 28080 ]
            Time Spent 21.2h [ 76320 ] 27.2h [ 97920 ]
            Worklog Id 70121 [ 70121 ]
            rakesh.shahane Rakesh Shahane (Inactive) made changes -
            Remaining Estimate 7.8h [ 28080 ] 0h [ 0 ]
            Time Spent 27.2h [ 97920 ] 35.2h [ 126720 ]
            Worklog Id 70128 [ 70128 ]
            rakesh.shahane Rakesh Shahane (Inactive) made changes -
            Time Spent 35.2h [ 126720 ] 42.7h [ 153720 ]
            Worklog Id 70131 [ 70131 ]
            rakesh.shahane Rakesh Shahane (Inactive) logged work - 08/Aug/17 01:00 PM
            • Time Spent:
              2.5h
               

              1)Code Review
              2)Changes after code review.
              3)Unit Testing.

            rakesh.shahane Rakesh Shahane (Inactive) made changes -
            Time Spent 42.7h [ 153720 ] 45.2h [ 162720 ]
            Worklog Id 70140 [ 70140 ]
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) logged work - 08/Aug/17 02:39 PM
            • Time Spent:
              2h
               
              <No comment>
            Hide
            rakesh.shahane Rakesh Shahane (Inactive) added a comment -

            Hi Akshay Mukkawar,

            As discussed once your code changes has been deployed to LB, Please assign this ticket to QA.

            CC-Ganesh Sadawarte, Rakesh Shahane

            Show
            rakesh.shahane Rakesh Shahane (Inactive) added a comment - Hi Akshay Mukkawar , As discussed once your code changes has been deployed to LB, Please assign this ticket to QA. CC- Ganesh Sadawarte , Rakesh Shahane
            rakesh.shahane Rakesh Shahane (Inactive) made changes -
            Assignee Rakesh Shahane [ rakesh.shahane ] Akshay Mukkawar [ akshay.mukkawar ]
            akshay.mukkawar Akshay Mukkawar (Inactive) made changes -
            Assignee Akshay Mukkawar [ akshay.mukkawar ] Hrishikesh Deshpande [ hrishikesh.deshpande ]
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Assignee Hrishikesh Deshpande [ hrishikesh.deshpande ] Aniruddha Dev [ aniruddha.dev ]
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            aniruddha.dev Aniruddha Dev (Inactive) logged work - 10/Aug/17 09:57 AM
            • Time Spent:
              2h
               

              Analysis and Test Scenarios writing

            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Attachment WT-7076_COBRA_TC_.xls [ 58239 ]
            rakesh.shahane Rakesh Shahane (Inactive) made changes -
            Time Spent 45.2h [ 162720 ] 45h 32m [ 163920 ]
            Worklog Id 70131 [ 70131 ]
            aniruddha.dev Aniruddha Dev (Inactive) logged work - 11/Aug/17 06:16 PM
            • Time Spent:
              1.5h
               

              Created templates and scenarios for future testing

            aniruddha.dev Aniruddha Dev (Inactive) logged work - 16/Aug/17 09:06 AM
            • Time Spent:
              2.5h
               
              <No comment>
            Hide
            aniruddha.dev Aniruddha Dev (Inactive) added a comment -

            Created New HR simplified COBRA data templates on JE dunn for HSPL company and created below scenarios
            1) Retirement
            2) Deceased
            3) Divroce
            4) Class Change
            5) OAD

            Testing is in progress with other scenarios on different templates .

            Show
            aniruddha.dev Aniruddha Dev (Inactive) added a comment - Created New HR simplified COBRA data templates on JE dunn for HSPL company and created below scenarios 1) Retirement 2) Deceased 3) Divroce 4) Class Change 5) OAD Testing is in progress with other scenarios on different templates .
            aniruddha.dev Aniruddha Dev (Inactive) logged work - 17/Aug/17 09:46 AM
            • Time Spent:
              4h
               

              LB testing issue logging and discussion

            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: In Testing(10210)
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Production Due Date 29/Aug/2017
            QA Aniruddha Dev [ aniruddha.dev ]
            Stage Due Date 23/Aug/17 [ 2017-08-23 ]
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Link This issue is caused by WT-10687 [ WT-10687 ]
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Link This issue causes WT-10687 [ WT-10687 ]
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Link This issue is caused by WT-10687 [ WT-10687 ]
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Link This issue causes WT-10688 [ WT-10688 ]
            Hide
            aniruddha.dev Aniruddha Dev (Inactive) added a comment -

            Hi Akshay Mukkawar,

            We're blocked to test this due to WT-10687 and WT-10688 . Please reassign to me once these are fixed.

            CC:Vinayak Kulkarni Rakesh Shahane Hrishikesh Deshpande

            Show
            aniruddha.dev Aniruddha Dev (Inactive) added a comment - Hi Akshay Mukkawar , We're blocked to test this due to WT-10687 and WT-10688 . Please reassign to me once these are fixed. CC: Vinayak Kulkarni Rakesh Shahane Hrishikesh Deshpande
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Status Local Testing [ 10200 ] Reopen in Local [ 10018 ]
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Assignee Aniruddha Dev [ aniruddha.dev ] Akshay Mukkawar [ akshay.mukkawar ]
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: In Testing(10210) Parent values: LB QA(10201)Level 1 values: Re-open(10212)
            akshay.mukkawar Akshay Mukkawar (Inactive) made changes -
            Assignee Akshay Mukkawar [ akshay.mukkawar ] Rakesh Shahane [ rakesh.shahane ]
            rakesh.shahane Rakesh Shahane (Inactive) made changes -
            Status Reopen in Local [ 10018 ] In Development [ 10007 ]
            rakesh.shahane Rakesh Shahane (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            rakesh.shahane Rakesh Shahane (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: Re-open(10212) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            rakesh.shahane Rakesh Shahane (Inactive) made changes -
            Assignee Rakesh Shahane [ rakesh.shahane ] Aniruddha Dev [ aniruddha.dev ]
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
            Time Spent 45h 32m [ 163920 ] 46h 32m [ 167520 ]
            Worklog Id 72842 [ 72842 ]
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
            Time Spent 46h 32m [ 167520 ] 48h 32m [ 174720 ]
            Worklog Id 72864 [ 72864 ]
            aniruddha.dev Aniruddha Dev (Inactive) logged work - 22/Aug/17 11:59 AM
            • Time Spent:
              4h
               
              <No comment>
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Link This issue causes WT-10774 [ WT-10774 ]
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Status Local Testing [ 10200 ] Reopen in Local [ 10018 ]
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: In Testing(10210)
            Hide
            aniruddha.dev Aniruddha Dev (Inactive) added a comment -

            Verified below scenarios on Discovery Benefits COBRA data Template and New HR simplified templates

            1) Termination
            2) Retirement
            3) Divorce
            4) Ineligible Dependent
            5) Death
            6) Class Change

            New issue WT-10774 found for Divorce event . Please assign back to me once it gets fixed.

            Show
            aniruddha.dev Aniruddha Dev (Inactive) added a comment - Verified below scenarios on Discovery Benefits COBRA data Template and New HR simplified templates 1) Termination 2) Retirement 3) Divorce 4) Ineligible Dependent 5) Death 6) Class Change New issue WT-10774 found for Divorce event . Please assign back to me once it gets fixed.
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Assignee Aniruddha Dev [ aniruddha.dev ] Akshay Mukkawar [ akshay.mukkawar ]
            Hide
            niteen.surwase Niteen Surwase (Inactive) added a comment - - edited

            Analysis of the issue :

            In current implementation of Event Builder for CDC, We have created event such as If Spouse relationship changed from Spouse to Ex-Spouse.
            As it'll work in following cases.
            1. When we go to Spouse Profile and change relationship to Spouse to Ex-Spouse.
            2. When we go to Employee Demographics page and change Marital Status to Divorce

            So, It will not work through Initiate Qualifying Event, as implementation not done for the same.
            It is done only for Event Builder.

            Cc: Swapnil Pandhare Satya Sheetal Bodhale Akshay Mukkawar

            Show
            niteen.surwase Niteen Surwase (Inactive) added a comment - - edited Analysis of the issue : In current implementation of Event Builder for CDC, We have created event such as If Spouse relationship changed from Spouse to Ex-Spouse. As it'll work in following cases. 1. When we go to Spouse Profile and change relationship to Spouse to Ex-Spouse . 2. When we go to Employee Demographics page and change Marital Status to Divorce So, It will not work through Initiate Qualifying Event, as implementation not done for the same. It is done only for Event Builder. Cc: Swapnil Pandhare Satya Sheetal Bodhale Akshay Mukkawar
            niteen.surwase Niteen Surwase (Inactive) logged work - 24/Aug/17 11:35 AM
            • Time Spent:
              4.5h
               

              Discussion with Rakesh, Anirudhha
              Reproducing and Analysis Issue
              JIRA Update

            niteen.surwase Niteen Surwase (Inactive) made changes -
            Time Spent 48h 32m [ 174720 ] 53h 2m [ 190920 ]
            Worklog Id 75244 [ 75244 ]
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Time Spent 53h 2m [ 190920 ] 54h 32m [ 196320 ]
            Worklog Id 75699 [ 75699 ]
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Time Spent 54h 32m [ 196320 ] 57h 2m [ 205320 ]
            Worklog Id 75957 [ 75957 ]
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Time Spent 57h 2m [ 205320 ] 61h 2m [ 219720 ]
            Worklog Id 75985 [ 75985 ]
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Time Spent 61h 2m [ 219720 ] 63h 2m [ 226920 ]
            Worklog Id 75989 [ 75989 ]
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Time Spent 63h 2m [ 226920 ] 67h 2m [ 241320 ]
            Worklog Id 76158 [ 76158 ]
            akshay.mukkawar Akshay Mukkawar (Inactive) made changes -
            Status Reopen in Local [ 10018 ] In Development [ 10007 ]
            akshay.mukkawar Akshay Mukkawar (Inactive) made changes -
            Code Review Date 08/Aug/2017 08/Aug/2017
            Dev Due Date 07/Aug/2017 07/Aug/2017
            Item State Parent values: LB QA(10201)Level 1 values: In Testing(10210) Parent values: Development(10200)Level 1 values: Ready for Review(10208)
            Production Due Date 29/Aug/2017 29/Aug/2017
            Stage Due Date 23/Aug/17 [ 2017-08-23 ] 23/Aug/17 [ 2017-08-23 ]
            akshay.mukkawar Akshay Mukkawar (Inactive) made changes -
            Assignee Akshay Mukkawar [ akshay.mukkawar ] Aniruddha Dev [ aniruddha.dev ]
            akshay.mukkawar Akshay Mukkawar (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: Ready for Review(10208) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Production Due Date 29/Aug/2017 11/Sep/2017
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Production Due Date 11/Sep/2017 14/Sep/2017
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Stage Due Date 23/Aug/17 [ 2017-08-23 ] 11/Sep/17 [ 2017-09-11 ]
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: In Testing(10210)
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            Hide
            aniruddha.dev Aniruddha Dev (Inactive) added a comment -

            Verified below scenarios again after all the bug fixes through File and Back end

            1) Class Change
            2) Divorce
            3) Termination
            4) Retirement
            5) Death

            All scenarios are working as expected . Ready for Stage Deployment

            Show
            aniruddha.dev Aniruddha Dev (Inactive) added a comment - Verified below scenarios again after all the bug fixes through File and Back end 1) Class Change 2) Divorce 3) Termination 4) Retirement 5) Death All scenarios are working as expected . Ready for Stage Deployment
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: In Testing(10210) Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Status Local Testing [ 10200 ] Pending for Stage Approval [ 10300 ]
            rajendra.pawar Rajendra Pawar (Inactive) made changes -
            Account Executive Vinayak Kulkarni [ vinayak.kulkarni ]
            Developer Rakesh Shahane [ rakesh.shahane ]
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Status Pending for Stage Approval [ 10300 ] Approved for Stage [ 10030 ]
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Status Approved for Stage [ 10030 ] Stage Testing [ 10201 ]
            aniruddha.dev Aniruddha Dev (Inactive) logged work - 12/Sep/17 12:24 PM
            • Time Spent:
              3h
               
              <No comment>
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) Parent values: Stage QA(10202)Level 1 values: In Testing(10214)
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Status Stage Testing [ 10201 ] Reopen in Stage [ 10023 ]
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: In Testing(10214) Parent values: Stage QA(10202)Level 1 values: Re-open(10216)
            Hide
            aniruddha.dev Aniruddha Dev (Inactive) added a comment -

            Hi Akshay Mukkawar,

            Verified below scenarios on 2017 Prime Healthcare for HSPL company

            1) termination
            2) retirement
            3) Divorce
            4) Death

            Observed below issue

            1) Retirement scenario not exported on file (Employee : Anjeanette,Canare)
            2) Death Scenario not exported on file (Employee : ALEXANDER,REICHMAN)
            3) One employee (ten,evgenia) appeared on export file which was terminated back in 11/30/2016 But his reason was exported as WW which is for Death in Event Builders

            Also please check whether WT-10687 is deployed on Stage or not ?

            Please reassign to me once it is deployed on stage and above issues are resolved.

            Note: Will check for Class Change and OAD scenarios tomorrow

            CC:Hrishikesh Deshpande Vinayak Kulkarni Rakesh Shahane

            Show
            aniruddha.dev Aniruddha Dev (Inactive) added a comment - Hi Akshay Mukkawar , Verified below scenarios on 2017 Prime Healthcare for HSPL company 1) termination 2) retirement 3) Divorce 4) Death Observed below issue 1) Retirement scenario not exported on file (Employee : Anjeanette,Canare) 2) Death Scenario not exported on file (Employee : ALEXANDER,REICHMAN) 3) One employee (ten,evgenia) appeared on export file which was terminated back in 11/30/2016 But his reason was exported as WW which is for Death in Event Builders Also please check whether WT-10687 is deployed on Stage or not ? Please reassign to me once it is deployed on stage and above issues are resolved. Note : Will check for Class Change and OAD scenarios tomorrow CC: Hrishikesh Deshpande Vinayak Kulkarni Rakesh Shahane
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Assignee Aniruddha Dev [ aniruddha.dev ] Akshay Mukkawar [ akshay.mukkawar ]
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Assignee Akshay Mukkawar [ akshay.mukkawar ] Aniruddha Dev [ aniruddha.dev ]
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Status Reopen in Stage [ 10023 ] In Development [ 10007 ]
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Status Local Testing [ 10200 ] Pending for Stage Approval [ 10300 ]
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Status Pending for Stage Approval [ 10300 ] Approved for Stage [ 10030 ]
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Status Approved for Stage [ 10030 ] Stage Testing [ 10201 ]
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Re-open(10216) Parent values: Stage QA(10202)Level 1 values: In Testing(10214)
            Hide
            akshay.mukkawar Akshay Mukkawar (Inactive) added a comment -

            HI Aniruddha Dev,

            This issue is already resolved Please recheck ,if it is reproduce issue Please reassign to me .

            Thanks,
            Akshay Mukkawar
            ----------------------------
            CC:Sheetal Bodhale,Vinayak Kulkarni,Swapnil Pandhare,Satya

            Show
            akshay.mukkawar Akshay Mukkawar (Inactive) added a comment - HI Aniruddha Dev , This issue is already resolved Please recheck ,if it is reproduce issue Please reassign to me . Thanks, Akshay Mukkawar ---------------------------- CC: Sheetal Bodhale , Vinayak Kulkarni , Swapnil Pandhare , Satya
            Hide
            aniruddha.dev Aniruddha Dev (Inactive) added a comment -

            Verified all scenarios again on 2017 Prime Healthcare for HSPL company on stage by creating new event builders for

            1) termination
            2) retirement
            3) Ineligible Dependent
            4) Death
            5) divorce
            6) Class Change

            and observed all the New HR simplified COBRA files on company. Records exported on all files are proper.

            Note: Overage Dependent scenarios are created for tomorrow . Will update the status once these are verified .

            Show
            aniruddha.dev Aniruddha Dev (Inactive) added a comment - Verified all scenarios again on 2017 Prime Healthcare for HSPL company on stage by creating new event builders for 1) termination 2) retirement 3) Ineligible Dependent 4) Death 5) divorce 6) Class Change and observed all the New HR simplified COBRA files on company. Records exported on all files are proper. Note : Overage Dependent scenarios are created for tomorrow . Will update the status once these are verified .
            aniruddha.dev Aniruddha Dev (Inactive) logged work - 13/Sep/17 02:11 PM
            • Time Spent:
              4h
               
              <No comment>
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Time Spent 67h 2m [ 241320 ] 71h 2m [ 255720 ]
            Worklog Id 78581 [ 78581 ]
            Hide
            aniruddha.dev Aniruddha Dev (Inactive) added a comment -

            Verified remaining OAD scenarios along with Divorce followed by Termination scenario on New HR simplified files on 2017 Prime HealthCare for HSPL company on stage .

            Scenarios working as expected . Ready for Production

            Show
            aniruddha.dev Aniruddha Dev (Inactive) added a comment - Verified remaining OAD scenarios along with Divorce followed by Termination scenario on New HR simplified files on 2017 Prime HealthCare for HSPL company on stage . Scenarios working as expected . Ready for Production
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: In Testing(10214) Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)
            Hide
            aniruddha.dev Aniruddha Dev (Inactive) added a comment -

            Keeping this on hold for Production . As we will be deploying Export enhancement after around a week of WT-9141 EDS deployement.

            Show
            aniruddha.dev Aniruddha Dev (Inactive) added a comment - Keeping this on hold for Production . As we will be deploying Export enhancement after around a week of WT-9141 EDS deployement.
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) Parent values: Stage QA(10202)Level 1 values: On Hold(10215)
            aniruddha.dev Aniruddha Dev (Inactive) logged work - 14/Sep/17 05:50 PM
            • Time Spent:
              1.5h
               
              <No comment>
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Time Spent 71h 2m [ 255720 ] 72h 32m [ 261120 ]
            Worklog Id 80142 [ 80142 ]
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Production Due Date 14/Sep/2017 28/Sep/2017
            rakeshr Rakesh Roy (Inactive) made changes -
            Production Due Date 28/Sep/2017
            rakeshr Rakesh Roy (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: On Hold(10215) Parent values: Stage QA(10202)Level 1 values: Production Deployment on Hold(10224)
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) logged work - 26/Sep/17 02:32 PM
            • Time Spent:
              2h
               
              <No comment>
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
            Time Spent 72h 32m [ 261120 ] 74h 32m [ 268320 ]
            Worklog Id 82003 [ 82003 ]
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Time Spent 74h 32m [ 268320 ] 77h 32m [ 279120 ]
            Worklog Id 82240 [ 82240 ]
            aniruddha.dev Aniruddha Dev (Inactive) logged work - 03/Oct/17 10:23 AM
            • Time Spent:
              4h
               
              <No comment>
            aniruddha.dev Aniruddha Dev (Inactive) logged work - 04/Oct/17 09:49 AM
            • Time Spent:
              4.5h
               
              <No comment>
            Hide
            aniruddha.dev Aniruddha Dev (Inactive) added a comment -

            Verified its impact on ongoing COBRA feeds on production like Discovery COBRA feed on JE Dunn company and New HR Simplified feeds on Prime Healthcare. No impact observed. Ready for Production

            Show
            aniruddha.dev Aniruddha Dev (Inactive) added a comment - Verified its impact on ongoing COBRA feeds on production like Discovery COBRA feed on JE Dunn company and New HR Simplified feeds on Prime Healthcare. No impact observed. Ready for Production
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Production Deployment on Hold(10224) Parent values: Production QA(10203)Level 1 values: In Testing(10218)
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Item State Parent values: Production QA(10203)Level 1 values: In Testing(10218) Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Status Stage Testing [ 10201 ] Pending for Production Approval [ 10301 ]
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Time Spent 77h 32m [ 279120 ] 82h 2m [ 295320 ]
            Worklog Id 83567 [ 83567 ]
            rakesh.shahane Rakesh Shahane (Inactive) logged work - 06/Oct/17 06:43 PM - edited
            • Time Spent:
              0.5h
               

              checkin

            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) Parent values: Production QA(10203)Level 1 values: Production Deployed(10221)
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Status Pending for Production Approval [ 10301 ] Approved for production [ 10034 ]
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Status Approved for production [ 10034 ] Production Testing [ 10202 ]
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Item State Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) Parent values: Production QA(10203)Level 1 values: In Testing(10218)
            Hide
            aniruddha.dev Aniruddha Dev (Inactive) added a comment -

            Verified this Enhancement on Production for COBRA data template with following scenarios without enabling CDC

            1) Termination
            2) retirement
            3) Death
            4) Divorce

            Scenarios worked as expected.

            Show
            aniruddha.dev Aniruddha Dev (Inactive) added a comment - Verified this Enhancement on Production for COBRA data template with following scenarios without enabling CDC 1) Termination 2) retirement 3) Death 4) Divorce Scenarios worked as expected.
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Resolution Done [ 10000 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Item State Parent values: Production QA(10203)Level 1 values: In Testing(10218) Parent values: Production Complete(10222)Level 1 values: Closed(10223)
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Resolution Done [ 10000 ] Fixed [ 1 ]
            Status Production Complete [ 10028 ] Closed [ 6 ]
            rakesh.shahane Rakesh Shahane (Inactive) made changes -
            Time Spent 82h 2m [ 295320 ] 82h 32m [ 297120 ]
            Worklog Id 84044 [ 84044 ]
            rakesh.shahane Rakesh Shahane (Inactive) made changes -
            Worklog Id 84044 [ 84044 ]
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Time Spent 82h 32m [ 297120 ] 86h 32m [ 311520 ]
            Worklog Id 88138 [ 88138 ]
            Transition Time In Source Status Execution Times
            Vinayak Kulkarni (Inactive) made transition -
            Pending for Approval Rejected
            3s 1
            Satya made transition -
            Rejected In Analysis
            103d 23h 17m 1
            Satya made transition -
            In Analysis New Request
            8m 31s 1
            Rakesh Shahane (Inactive) made transition -
            New Request Pending for Approval
            126d 21h 15m 2
            Rakesh Shahane (Inactive) made transition -
            Pending for Approval Approved for Development
            4s 1
            Rakesh Shahane (Inactive) made transition -
            Approved for Development In Development
            3s 1
            Aniruddha Dev (Inactive) made transition -
            In LB Testing Reopen in Local
            11d 2h 33m 2
            Akshay Mukkawar (Inactive) made transition -
            Reopen in Local In Development
            10d 16h 58m 2
            Aniruddha Dev (Inactive) made transition -
            Stage Testing Reopened in Stage
            1d 1h 12m 1
            Aniruddha Dev (Inactive) made transition -
            Reopened in Stage In Development
            21h 53m 1
            Aniruddha Dev (Inactive) made transition -
            In Development In LB Testing
            17d 5h 9m 4
            Aniruddha Dev (Inactive) made transition -
            In LB Testing Pending for Stage Approval
            2m 4s 2
            Aniruddha Dev (Inactive) made transition -
            Pending for Stage Approval Approved for Stage
            3d 2m 2
            Aniruddha Dev (Inactive) made transition -
            Approved for Stage Stage Testing
            6s 2
            Aniruddha Dev (Inactive) made transition -
            Stage Testing Pending for Production Approval
            21d 1h 52m 1
            Aniruddha Dev (Inactive) made transition -
            Pending for Production Approval Approved for production
            4d 22h 54m 1
            Aniruddha Dev (Inactive) made transition -
            Approved for production In Production Testing
            3s 1
            Aniruddha Dev (Inactive) made transition -
            In Production Testing Production Complete
            22m 46s 1
            Aniruddha Dev (Inactive) made transition -
            Production Complete Closed
            15s 1

              People

              Assignee:
              aniruddha.dev Aniruddha Dev (Inactive)
              Reporter:
              Vinayak.Kulkarni Vinayak Kulkarni (Inactive)
              Account Executive:
              Vinayak Kulkarni (Inactive)
              Developer:
              Rakesh Shahane (Inactive)
              QA:
              Aniruddha Dev (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Dev Due Date:
                Pre-Prod Due Date:
                Code Review Date:

                  Time Tracking

                  Estimated:
                  Original Estimate - 35h Original Estimate - 35h
                  35h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 86h 32m
                  86h 32m