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

Prime_Healthcare: GGH. Server Error on OE Changes Report

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Bug Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
    • Environment:
      Production
    • Bug Severity:
      Critical
    • Module:
      BenAdmin - Report
    • Reported by:
      Harbinger
    • Item State:
      Stage QA - Production Deployment on Hold
    • Issue Importance:
      Must Have
    • Sprint:
      WT Sprint 33-Bugs

      Description

      Receiving a server error when attempting to preview the OE Changes Report for Prime_Healthcare: GGH company.

      Report Parameters:
      From Date = 10/10/2016
      To Date = 10/23/2016
      All Classes, All Status, All Benefit Provider, All Benefit Types, All Plan Design

      Vijay Siddha, Samir

        Attachments

          Issue Links

            Activity

            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) logged work - 17/Jul/17 12:30 PM
            • Time Spent:
              7h
               

              Analysis and understand existing impelmenatation

            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) logged work - 18/Jul/17 12:49 PM
            • Time Spent:
              7.5h
               

              Prior learning (Debug code, Check used SP for report)

            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) logged work - 19/Jul/17 12:53 PM
            • Time Spent:
              8.25h
               

              Discussion and configuration to reproduce issue on Local
              Debug code

            prasanna Prasanna Karlekar (Inactive) logged work - 19/Jul/17 09:30 PM
            • Time Spent:
              0.5h
               

              OE changes report not working on local database
              Discussion and analysis

            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) logged work - 20/Jul/17 12:59 PM
            • Time Spent:
              8.5h
               

              Discussion about eligibility joins
              Modify existing query
              Check existing reports
              Modify configuration to pull reports and try to reproduce issue

            prasanna Prasanna Karlekar (Inactive) logged work - 20/Jul/17 06:30 PM
            • Time Spent:
              1.5h
               

              Discussion on issue repro and Eligibility joins
              Verification of procedure in Production and Dev environment

            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) logged work - 21/Jul/17 12:55 PM
            • Time Spent:
              4h
               

              Discussion, Try to reproduce issue and code changes

            prasanna Prasanna Karlekar (Inactive) logged work - 21/Jul/17 07:30 PM
            • Time Spent:
              0.75h
               

              Discussion on issue repro and code go through
              Discussion on getting the latest rule for Classwise OE

            prasanna Prasanna Karlekar (Inactive) logged work - 24/Jul/17 09:30 PM
            • Time Spent:
              0.5h
               

              Discussion on scenario repro

            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) logged work - 25/Jul/17 05:34 AM - edited
            • Time Spent:
              8.5h
               

              Discussion and try to reproduce issue on local environment
              Check reports on productions
              Check scope and discussion related to optimization in existing queries
              Unit testing

            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) logged work - 25/Jul/17 12:33 PM
            • Time Spent:
              3.5h
               

              Attach production backup on Local environment
              Discussion and try to repro issue
              Code Review request and JIRA Update
              Merge changes in LB

            prasanna Prasanna Karlekar (Inactive) logged work - 25/Jul/17 09:00 PM
            • Time Spent:
              0.5h
               

              Code review

            meghana.joshi Meghana Joshi (Inactive) logged work - 31/Jul/17 11:56 AM
            • Time Spent:
              3h
               

              LB Testing

            meghana.joshi Meghana Joshi (Inactive) logged work - 31/Jul/17 12:57 PM
            • Time Spent:
              3h
               
              <No comment>
            meghana.joshi Meghana Joshi (Inactive) logged work - 16/Oct/17 10:51 AM
            • Time Spent:
              1.5h
               

              Stage Testing

            venkatesh.pujari Venkatesh Pujari (Inactive) logged work - 06/Mar/18 06:27 PM
            • Time Spent:
              0.5h
               
              <No comment>

              People

              Assignee:
              venkatesh.pujari Venkatesh Pujari (Inactive)
              Reporter:
              shubhankar Shubhankar Joshi (Inactive)
              Account Executive:
              Amber Love-Jones (Inactive)
              Developer:
              Parmeshwar Jumbad (Inactive)
              QA:
              Meghana Joshi (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

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

                  Time Tracking

                  Estimated:
                  Original Estimate - 0h
                  0h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 59h
                  59h