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