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

Sever error : Impact of deleting old Eligibility related tables.

    Details

    • Type: Bug
    • Status: Resolution Setting
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Environment:
      Production
    • Bug Severity:
      Medium
    • Module:
      BenAdmin - Enrollment
    • Reported by:
      Harbinger
    • Item State:
      LB QA - On Hold
    • Issue Importance:
      Must Have

      Description

      1.Getting server error on Saving of New eligibility rule.
      2.Getting server error on Employee Login on Elite Staffing For HSPL company

        Attachments

        1. AffectedFiles.txt
          0.9 kB
        2. Checklist_WT-8966.doc
          24 kB
        3. Copy of EligibilityEngine_tables.xls
          31 kB
        4. NF-2271_Scenario.xls
          9 kB

          Issue Links

            Activity

            Hide
            vinanti.yadav Vinanti Yadav (Inactive) added a comment -

            Hi,

            We found below listed impacted area that must changed before dropping old Eligibility Tables.

            1. code uses old eligibility tables needs to be remove which gets called on save functionality eligibility of plan and rate.

            2. functions which are used in Eligibility Generation for old tables that uses old eligibility tables.

            3. Plan Summary SP (to display Eligibility Summary)

            4.Services :

            • CorePlanAllocationService
            • CreditpoolAllocationService
            • EligibilityCheckService
            • DefaultPlanAssignmentService

            5.View History

            • CreditPool
            • Rate
            • PlanDesign

            CC: Jyoti Mayne, Amruta Lohiya, Indraprakash Tiwari

            Show
            vinanti.yadav Vinanti Yadav (Inactive) added a comment - Hi, We found below listed impacted area that must changed before dropping old Eligibility Tables. 1. code uses old eligibility tables needs to be remove which gets called on save functionality eligibility of plan and rate. 2. functions which are used in Eligibility Generation for old tables that uses old eligibility tables. 3. Plan Summary SP (to display Eligibility Summary) 4.Services : CorePlanAllocationService CreditpoolAllocationService EligibilityCheckService DefaultPlanAssignmentService 5.View History CreditPool Rate PlanDesign CC: Jyoti Mayne , Amruta Lohiya , Indraprakash Tiwari
            Hide
            vinanti.yadav Vinanti Yadav (Inactive) added a comment - - edited

            Hi Prasad Pise,

            Please refer following 3c's :

            #Issue 1:
            Concern : Server error is coming after saving Eligibility Rules page of plan and rate.
            Cause : Code uses old table of eligibility.
            Correction : Unused code is removed.

            Note: We also found old tables related code in services, Workterra Utility, View History.

            Services :
            1. Core Plan Allocation Service
            2. Credit Pool Allocation Service
            3. Eligibility Check Service
            4. Notification Service
            5. Default Plan Assignment Service

            We make changes according to new tables for services.

            Workterra Utility :
            1. Eligibility Migration (from old to new tables)
            2. Reverse Eligibility Migration (from New to old tables).
            above functionality is not required so commented related code from Workterra Utility.

            View History :
            In View History, for Plan, Rates & Credit Pool it refers old Eligibility tables.
            Need to make changes according to new Generic Eligibility.
            Jaideep Vinchurkar we have created WT-9091 for same.

            Impact Testing:

            • Verify all above stated functionality
            • Enroll now screen
            • Employee self serve mode

            CC : Amruta Lohiya, Jyoti Mayne, Indraprakash Tiwari, Satya

            Show
            vinanti.yadav Vinanti Yadav (Inactive) added a comment - - edited Hi Prasad Pise , Please refer following 3c's : #Issue 1: Concern : Server error is coming after saving Eligibility Rules page of plan and rate. Cause : Code uses old table of eligibility. Correction : Unused code is removed. Note: We also found old tables related code in services, Workterra Utility, View History. Services : 1. Core Plan Allocation Service 2. Credit Pool Allocation Service 3. Eligibility Check Service 4. Notification Service 5. Default Plan Assignment Service We make changes according to new tables for services. Workterra Utility : 1. Eligibility Migration (from old to new tables) 2. Reverse Eligibility Migration (from New to old tables). above functionality is not required so commented related code from Workterra Utility. View History : In View History, for Plan, Rates & Credit Pool it refers old Eligibility tables. Need to make changes according to new Generic Eligibility. Jaideep Vinchurkar we have created WT-9091 for same. Impact Testing: Verify all above stated functionality Enroll now screen Employee self serve mode CC : Amruta Lohiya , Jyoti Mayne , Indraprakash Tiwari , Satya
            Hide
            priya.dhamande Priya Dhamande (Inactive) added a comment -

            As per discussion with Indraprakash Tiwari, attached tables are deleted from LB from company LONG For Paycheck.

            Show
            priya.dhamande Priya Dhamande (Inactive) added a comment - As per discussion with Indraprakash Tiwari , attached tables are deleted from LB from company LONG For Paycheck.
            Hide
            priya.dhamande Priya Dhamande (Inactive) added a comment -

            Hi Vinanti Yadav,

            As discussed the Form builder is getting empty after the deletion of tables and hence the employee level I am unable to check. this is givng server error and page not found error.

            Can you please look into the same. Please assign back once teh issue is resolved.

            Hrishikesh Deshpande Indraprakash Tiwari

            Show
            priya.dhamande Priya Dhamande (Inactive) added a comment - Hi Vinanti Yadav , As discussed the Form builder is getting empty after the deletion of tables and hence the employee level I am unable to check. this is givng server error and page not found error. Can you please look into the same. Please assign back once teh issue is resolved. Hrishikesh Deshpande Indraprakash Tiwari
            Hide
            vinanti.yadav Vinanti Yadav (Inactive) added a comment -

            Hi Priya Dhamande,

            Please refer below 3c's :

            Issue 1 :
            Concern : Form builder page is not display.
            Cause : Old tables are used in one UDF to check additional Field is refereed in Eligibility Criteria or not .
            Correction : Code fix is done.

            Issue 2 :
            Concern : Plan design summary is not getting display according to Generic Eligibility Rule.
            Cause : Old tables are used to display Eligibility summary.
            Correction : code fixed is done.

            CC : Jyoti Mayne

            Show
            vinanti.yadav Vinanti Yadav (Inactive) added a comment - Hi Priya Dhamande , Please refer below 3c's : Issue 1 : Concern : Form builder page is not display. Cause : Old tables are used in one UDF to check additional Field is refereed in Eligibility Criteria or not . Correction : Code fix is done. Issue 2 : Concern : Plan design summary is not getting display according to Generic Eligibility Rule. Cause : Old tables are used to display Eligibility summary. Correction : code fixed is done. CC : Jyoti Mayne
            Hide
            vinanti.yadav Vinanti Yadav (Inactive) added a comment -

            Hello Priya Dhamande,

            Could you please update testing status for this jira ?

            Cc : Jyoti Mayne, Satya

            Show
            vinanti.yadav Vinanti Yadav (Inactive) added a comment - Hello Priya Dhamande , Could you please update testing status for this jira ? Cc : Jyoti Mayne , Satya
            Hide
            rakeshr Rakesh Roy (Inactive) added a comment -
            Show
            rakeshr Rakesh Roy (Inactive) added a comment - Priya Dhamande Rashmita Dudhe Please update. Hrishikesh Deshpande
            Hide
            priya.dhamande Priya Dhamande (Inactive) added a comment -

            As per discussion with Indraprakash Tiwari and Rushikesh, only the sequence of table dropping has changed.So, there was no impact on any functionality. Impact for the same is already tested. So, pushing jira directly on Stage directly.

            Hrishikesh Deshpande Rakesh Roy Rashmita Dudhe

            Show
            priya.dhamande Priya Dhamande (Inactive) added a comment - As per discussion with Indraprakash Tiwari and Rushikesh, only the sequence of table dropping has changed.So, there was no impact on any functionality. Impact for the same is already tested. So, pushing jira directly on Stage directly. Hrishikesh Deshpande Rakesh Roy Rashmita Dudhe
            Hide
            priya.dhamande Priya Dhamande (Inactive) added a comment -

            Making this jira on Hold as per Vinanti Yadav's comment, as this jira is dependent on WT-9091

            Show
            priya.dhamande Priya Dhamande (Inactive) added a comment - Making this jira on Hold as per Vinanti Yadav 's comment, as this jira is dependent on WT-9091
            Hide
            vinanti.yadav Vinanti Yadav (Inactive) added a comment -

            Hi Priya Dhamande,

            Please Mark this JIRA as On Hold. We can not deploy this JIRA during OE period we will plan it for After OE.

            Thanks,
            Vinanti.

            CC :Jyoti Mayne, Amruta Lohiya , Rakesh Roy

            Show
            vinanti.yadav Vinanti Yadav (Inactive) added a comment - Hi Priya Dhamande , Please Mark this JIRA as On Hold. We can not deploy this JIRA during OE period we will plan it for After OE. Thanks, Vinanti. CC : Jyoti Mayne , Amruta Lohiya , Rakesh Roy
            Hide
            priya.dhamande Priya Dhamande (Inactive) added a comment -

            As per comment, changing status on Hold.

            Show
            priya.dhamande Priya Dhamande (Inactive) added a comment - As per comment, changing status on Hold.

              People

              Assignee:
              priya.dhamande Priya Dhamande (Inactive)
              Reporter:
              vinanti.yadav Vinanti Yadav (Inactive)
              Developer:
              Vinanti Yadav (Inactive)
              QA:
              Priya Dhamande (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Dev Due Date:
                Code Review Date:

                  Time Tracking

                  Estimated:
                  Original Estimate - 48h
                  48h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 46h 20m Time Not Required
                  46h 20m