WORKTERRAProject Type: software

WORKTERRA

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

EHMC - Partner login - OE change report - Server error on preview and run

    Details

    • Type: Bug
    • Status: Production Complete
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
    • Environment:
      Production
    • Bug Type:
      Functional
    • Bug Severity:
      Medium
    • Level:
      Partner
    • Module:
      BenAdmin - Report
    • Reported by:
      Harbinger
    • Company:
      EHMC
    • Item State:
      Production Complete - Closed

      Description

      Check preview for 10/1/2017 to 10/312017--Server error

      Error log--
      ErrorID : 0
      ErrorSource : ControllerAppTier.SaveAndGetData->BenAdminControllerAppTier.SaveAndGetData->StaticReports.SaveAndGetData->OpenEnrollmentChangesReport.GetData->OpenEnrollmentChangesReport.FetchOpenEnrollmentChangesData->OpenEnrollmentChangesReport.FetchEnrollmentAndRatesData
      ErrorMessage: Item has already been added. Key in dictionary: '35022~10' Key being added: '35022~10'
      StackTrace: at WORKTERRA.BenAdmin.BenAdminControllerAppTier.SaveAndGetData(BenAdminControllerWebTierEntity objBenAdminControllerWebTierEntity)
      at WORKTERRA.ControllerAppTier.SaveAndGetData(Int32 intProjectsId, String strInput)
      TargetSite: System.String SaveAndGetData(ValueObjects.BenAdminControllerWebTierEntity)

        Attachments

          Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. WT-5940 Prime_Healthcare: GGH. Server Error on OE Changes Report

          • Critical - This problem will block progress.
          • Closed

          Support Activity - Support Activity WT-11854 CHMC Server Error when running reports

          • Medium - Has the potential to affect progress.
          • Resolved

            Activity

            Ascending order - Click to sort in descending order
            rakeshr Rakesh Roy (Inactive) created issue -
            rakeshr Rakesh Roy (Inactive) made changes -
            Field Original Value New Value
            Attachment screenshot-1.png [ 64210 ]
            Hide
            Permalink
            vijays Vijay Siddha (Inactive) added a comment -

            CC:Satya,Gaurav Sodani

            Show
            vijays Vijay Siddha (Inactive) added a comment - CC: Satya , Gaurav Sodani
            vijays Vijay Siddha (Inactive) made changes -
            Assignee Vijay Siddha [ vijays ] Prasanna Karlekar [ prasanna ]
            Hide
            Permalink
            prasanna Prasanna Karlekar (Inactive) added a comment -

            Will provide an update for this on 13-Oct-2017.

            cc: Gaurav Sodani

            Show
            prasanna Prasanna Karlekar (Inactive) added a comment - Will provide an update for this on 13-Oct-2017. cc: Gaurav Sodani
            prasanna Prasanna Karlekar (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            Hide
            Permalink
            prasanna Prasanna Karlekar (Inactive) added a comment -

            Hi Sachin Hingole,

            This issue is same as WT-5940.
            It will get resolved once WT-5940 is deployed in Production Environment.

            cc: Gaurav Sodani, [~parmeshwar.jumbade], [~meghana joshi]

            Show
            prasanna Prasanna Karlekar (Inactive) added a comment - Hi Sachin Hingole , This issue is same as WT-5940 . It will get resolved once WT-5940 is deployed in Production Environment. cc: Gaurav Sodani , [~parmeshwar.jumbade] , [~meghana joshi]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Link This issue relates to WT-5940 [ WT-5940 ]
            Permalink
            prasanna Prasanna Karlekar (Inactive) logged work - 14/Oct/17 12:00 AM
            • Time Spent:
              0.5h
               

              Analysis
              JIRA update

            Hide
            Permalink
            prasanna Prasanna Karlekar (Inactive) added a comment -

            Hi Sachin Hingole,

            Assigning this JIRA to you as no separate code fix is required for this.
            This needs to be verified once WT-5940 is deployed in Production environment.

            Thank you!

            cc: Gaurav Sodani, [~meghana joshi], [~parmeshwar.jumbade]

            Show
            prasanna Prasanna Karlekar (Inactive) added a comment - Hi Sachin Hingole , Assigning this JIRA to you as no separate code fix is required for this. This needs to be verified once WT-5940 is deployed in Production environment. Thank you! cc: Gaurav Sodani , [~meghana joshi] , [~parmeshwar.jumbade]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Assignee Prasanna Karlekar [ prasanna ] Gaurav Sodani [ gaurav.sodani ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Analysis(10204)
            prasanna Prasanna Karlekar (Inactive) made changes -
            Assignee Gaurav Sodani [ gaurav.sodani ] Sachin Hingole [ sachin.hingole ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Analysis(10204) Parent values: LB QA(10201)
            prasanna Prasanna Karlekar (Inactive) made changes -
            Link This issue relates to WT-11854 [ WT-11854 ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Item State Parent values: LB QA(10201) Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209)
            Hide
            Permalink
            prasanna Prasanna Karlekar (Inactive) added a comment -

            Hi Sachin Hingole,

            We were expecting WT-5940 to get deployed on Production. But its deployment is on hold as Generic Eligibility changes for Classwise OE are not going on Production.
            On Production fix needs to be given with old code on which we are currently working. After the fix is done, code needs to be deployed and tested in Production environment directly as LB and Stage have Classwise OE customization with Generic Eligibility.
            Removing the reference of WT-5940 from this JIRA. Also, changing, item state and status.

            Thank you!

            cc: Gaurav Sodani, [~parmeshwar.jumbade]

            Show
            prasanna Prasanna Karlekar (Inactive) added a comment - Hi Sachin Hingole , We were expecting WT-5940 to get deployed on Production. But its deployment is on hold as Generic Eligibility changes for Classwise OE are not going on Production. On Production fix needs to be given with old code on which we are currently working. After the fix is done, code needs to be deployed and tested in Production environment directly as LB and Stage have Classwise OE customization with Generic Eligibility. Removing the reference of WT-5940 from this JIRA. Also, changing, item state and status. Thank you! cc: Gaurav Sodani , [~parmeshwar.jumbade]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Company EHMC [ 15500 ]
            Item State Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209) Parent values: Development(10200)Level 1 values: In Progress(10206)
            prasanna Prasanna Karlekar (Inactive) made changes -
            Status Local Testing [ 10200 ] Reopen in Local [ 10018 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Assignee Sachin Hingole [ sachin.hingole ] Prasanna Karlekar [ prasanna ]
            Hide
            Permalink
            prasanna Prasanna Karlekar (Inactive) added a comment -

            Have re-opened the JIRA, as changes needs to be done in old code to make this report work.

            Thank you!

            Show
            prasanna Prasanna Karlekar (Inactive) added a comment - Have re-opened the JIRA, as changes needs to be done in old code to make this report work. Thank you!
            prasanna Prasanna Karlekar (Inactive) made changes -
            Status Reopen in Local [ 10018 ] In Development [ 10007 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Remaining Estimate 0h [ 0 ]
            Time Spent 0.5h [ 1800 ]
            Worklog Id 88234 [ 88234 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 0.5h [ 1800 ] 1h [ 3600 ]
            Worklog Id 88365 [ 88365 ]
            Permalink
            prasanna Prasanna Karlekar (Inactive) logged work - 01/Nov/17 01:30 AM
            • Time Spent:
              0.5h
               

              Scenario Testing - In Progress

            Permalink
            prasanna Prasanna Karlekar (Inactive) logged work - 01/Nov/17 09:00 PM
            • Time Spent:
              2h
               

              Unit testing for normal OE mode
              Discussion on execution time

            satyap Satya made changes -
            Labels Standard_Report
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 1h [ 3600 ] 3h [ 10800 ]
            Worklog Id 88694 [ 88694 ]
            Permalink
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) logged work - 02/Nov/17 12:52 PM
            • Time Spent:
              2.5h
               

              Code and functionality review on production

            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Code Review Date 02/Nov/2017
            Code Reviewed By Parmeshwar Jumbad [ 17800 ]
            Item State Parent values: Development(10200)Level 1 values: In Progress(10206) Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209)
            Original Estimate 0h [ 0 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Time Spent 3h [ 10800 ] 5.5h [ 19800 ]
            Worklog Id 88848 [ 88848 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 5.5h [ 19800 ] 5.75h [ 20700 ]
            Worklog Id 89026 [ 89026 ]
            Permalink
            prasanna Prasanna Karlekar (Inactive) logged work - 03/Nov/17 10:00 PM
            • Time Spent:
              0.25h
               

              Discussion on Patch Deployment

            satyap Satya made changes -
            Environment_New Production [ 18442 ]
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209) Parent values: Production QA(10203)Level 1 values: Production Deployed(10221)
            prasadp Prasad Pise (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            prasadp Prasad Pise (Inactive) made changes -
            Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
            prasadp Prasad Pise (Inactive) made changes -
            Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Assignee Prasanna Karlekar [ prasanna ] Prasad Pise [ prasadp ]
            Permalink
            prasadp Prasad Pise (Inactive) logged work - 04/Nov/17 04:05 PM
            • Time Spent:
              0.5h
               

              Understanding and Issue verification

            prasadp Prasad Pise (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)
            prasadp Prasad Pise (Inactive) made changes -
            Resolution Fixed [ 1 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            prasadp Prasad Pise (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)
            prasadp Prasad Pise (Inactive) made changes -
            Time Spent 5.75h [ 20700 ] 6.25h [ 22500 ]
            Worklog Id 89117 [ 89117 ]
            prasadp Prasad Pise (Inactive) made changes -
            Assignee Prasad Pise [ prasadp ] Sachin Hingole [ sachin.hingole ]
            Hide
            Permalink
            prasanna Prasanna Karlekar (Inactive) added a comment -

            Concern:
            Receiving a server error when attempting to preview the OE Changes Report.

            Cause:
            This company has setting for Classwise Open Enrollment. In system, there is a database table to save Classwise Open Enrollment rules. For this company, it has entries for previous year Open Enrollment also. Employees are eligible for current year as well as previous year rule. Due to which elections with effective date for current as well as previous Open enrollment are getting populated.

            Correction:
            Now we are considering OE rule which is recently active. We are returning result only for recent active OE rule. Please note that, whenever OE report is executed with Enrollment Opening and Closing Date after OE period ends, it should fetch only the changes that were done between specified OE span.

            Affected files:
            /MasterCompanyDB/04_Stored Procedures/dbo.OES_SP_Report_GetOEEffectiveDateForAllEmployees.StoredProcedure.sql
            /MasterCompanyDB/04_Stored Procedures/dbo.OES_SP_Report_OpenEnrollmentChangesAllBenefits.StoredProcedure.sql

            Impacted Areas:
            OE report when executed for classwise OE.

            Unit tested scenarios:
            1. Verified OE changes report with and without classwise OE setting.
            2. Verified OE report for class wise OE, after the OE period completion.

            Show
            prasanna Prasanna Karlekar (Inactive) added a comment - Concern: Receiving a server error when attempting to preview the OE Changes Report. Cause: This company has setting for Classwise Open Enrollment. In system, there is a database table to save Classwise Open Enrollment rules. For this company, it has entries for previous year Open Enrollment also. Employees are eligible for current year as well as previous year rule. Due to which elections with effective date for current as well as previous Open enrollment are getting populated. Correction: Now we are considering OE rule which is recently active. We are returning result only for recent active OE rule. Please note that, whenever OE report is executed with Enrollment Opening and Closing Date after OE period ends, it should fetch only the changes that were done between specified OE span. Affected files: /MasterCompanyDB/04_Stored Procedures/dbo.OES_SP_Report_GetOEEffectiveDateForAllEmployees.StoredProcedure.sql /MasterCompanyDB/04_Stored Procedures/dbo.OES_SP_Report_OpenEnrollmentChangesAllBenefits.StoredProcedure.sql Impacted Areas: OE report when executed for classwise OE. Unit tested scenarios: 1. Verified OE changes report with and without classwise OE setting. 2. Verified OE report for class wise OE, after the OE period completion.
            Transition Time In Source Status Execution Times
            Prasanna Karlekar (Inactive) made transition -
            Open In Development
            		22h 27m 1
            Prasanna Karlekar (Inactive) made transition -
            In LB Testing Reopen in Local
            		12d 20h 9m 1
            Prasanna Karlekar (Inactive) made transition -
            Reopen in Local In Development
            		5h 14m 1
            Prasad Pise (Inactive) made transition -
            In Development In LB Testing
            		8d 23h 56m 2
            Prasad Pise (Inactive) made transition -
            In LB Testing Stage Testing
            		4s 1
            Prasad Pise (Inactive) made transition -
            Stage Testing In Production Testing
            		3s 1
            Prasad Pise (Inactive) made transition -
            In Production Testing Production Complete
            		6h 43m 1

              People

              Assignee:
              sachin.hingole Sachin Hingole (Inactive)
              Reporter:
              rakeshr Rakesh Roy (Inactive)
              QA:
              Sachin Hingole (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Code Review Date:

                  Time Tracking

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