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

            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
            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
            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
            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 .
            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
            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.
            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
            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
            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
            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 .
            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
            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.
            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
            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.

              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