-
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
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
| Description |
Receiving a server error when attempting to the run 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 [~vijays], [~samir] |
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 [~vijays], [~samir] |
Vijay Siddha (Inactive)
made changes -
| Assignee | Vijay Siddha [ vijays ] | Aditya Vishwakarma [ aditya.vishwakarma ] |
| Assignee | Aditya Vishwakarma [ aditya.vishwakarma ] | Prasanna Karlekar [ prasanna ] |
| Severity | Complex [ 13103 ] |
| Code Reviewed By | Prasanna Karlekar [ 11907 ] | |
| Dev Due Date | 18/Jul/2017 | |
| Developer | Parmeshwar Jumbad [ parmeshwar.jumbade ] |
| Assignee | Prasanna Karlekar [ prasanna ] | Parmeshwar Jumbad [ parmeshwar.jumbade ] |
Gaurav Sodani (Inactive)
made changes -
| Sprint | WT Sprint 32-Bugs [ 76 ] |
Gaurav Sodani (Inactive)
made changes -
| Sprint | WT Sprint 32-Bugs [ 76 ] | WT Sprint 33-Bugs [ 77 ] |
| Dev Due Date | 18/Jul/2017 | 21/Jul/2017 |
Parmeshwar Jumbad (Inactive)
made changes -
| Item State | Parent values: Development(10200)Level 1 values: In Analysis(10204) |
Parmeshwar Jumbad (Inactive)
made changes -
| Status | Open [ 1 ] | In Development [ 10007 ] |
Parmeshwar Jumbad (Inactive)
logged work - 17/Jul/17 12:30 PM -
- Time Spent:
- 7h
-
Analysis and understand existing impelmenatation
Parmeshwar Jumbad (Inactive)
made changes -
| Remaining Estimate | 0h [ 0 ] | |
| Time Spent | 7h [ 25200 ] | |
| Worklog Id | 63950 [ 63950 ] |
Sachin Hingole (Inactive)
made changes -
| QA | Sachin Hingole [ sachin.hingole ] | |
| Original Estimate | 0h [ 0 ] |
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 (Inactive)
made changes -
| Time Spent | 7h [ 25200 ] | 14.5h [ 52200 ] |
| Worklog Id | 64302 [ 64302 ] |
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
Parmeshwar Jumbad (Inactive)
made changes -
| Time Spent | 14.5h [ 52200 ] | 22.75h [ 81900 ] |
| Worklog Id | 64722 [ 64722 ] |
-
- Time Spent:
- 0.5h
-
OE changes report not working on local database
Discussion and analysis
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
Parmeshwar Jumbad (Inactive)
made changes -
| Time Spent | 22.75h [ 81900 ] | 31.25h [ 112500 ] |
| Worklog Id | 65086 [ 65086 ] |
-
- Time Spent:
- 1.5h
-
Discussion on issue repro and Eligibility joins
Verification of procedure in Production and Dev environment
Parmeshwar Jumbad (Inactive)
logged work - 21/Jul/17 12:55 PM -
- Time Spent:
- 4h
-
Discussion, Try to reproduce issue and code changes
Parmeshwar Jumbad (Inactive)
made changes -
| Time Spent | 31.25h [ 112500 ] | 35.25h [ 126900 ] |
| Worklog Id | 65320 [ 65320 ] |
-
- Time Spent:
- 0.75h
-
Discussion on issue repro and code go through
Discussion on getting the latest rule for Classwise OE
Parmeshwar Jumbad (Inactive)
made changes -
| Item State | Parent values: Development(10200)Level 1 values: In Analysis(10204) | Parent values: Development(10200)Level 1 values: In Progress(10206) |
-
- Time Spent:
- 0.5h
-
Discussion on scenario repro
| Time Spent | 35.25h [ 126900 ] | 35.75h [ 128700 ] |
| Worklog Id | 65907 [ 65907 ] |
| Time Spent | 35.75h [ 128700 ] | 37.25h [ 134100 ] |
| Worklog Id | 65910 [ 65910 ] |
| Time Spent | 37.25h [ 134100 ] | 38h [ 136800 ] |
| Worklog Id | 65915 [ 65915 ] |
-
- 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 (Inactive)
made changes -
| Time Spent | 38h [ 136800 ] | 45h [ 162000 ] |
| Worklog Id | 65936 [ 65936 ] |
Parmeshwar Jumbad (Inactive)
made changes -
| Item State | Parent values: Development(10200)Level 1 values: In Progress(10206) | Parent values: Development(10200)Level 1 values: Ready for Review(10208) |
3C's:
Concern and cause metioned in above comments
Correction: Now we are considering OE rules for current date (i.e. OE rule which is open for current date). If any OE is available for today's date then we are returning results otherwise we will get no records screen. As per current implementation result on report only will display if OE period is in progress.
Affected Areas: Open Enrollment Report
Tested Scenarios:
1. Checked reports in both conditions of ApplyOERules (i.e. Yes and No)
2. Modified demographics of Employee and verified it displaying on report or not as expected.
Afftected Files:
/MasterCompanyDB/04_Stored Procedures/dbo.OES_SP_Report_GetOEEffectiveDateForAllEmployees.StoredProcedure.sql
/MasterCompanyDB/04_Stored Procedures/dbo.OES_SP_Report_OpenEnrollmentChangesAllBenefits.StoredProcedure.sql
Note: We could not able to reproduce issue on local environment but handled code to return only Current OE records.
Parmeshwar Jumbad (Inactive)
added a comment - 3C's:
Concern and cause metioned in above comments
Correction : Now we are considering OE rules for current date (i.e. OE rule which is open for current date). If any OE is available for today's date then we are returning results otherwise we will get no records screen. As per current implementation result on report only will display if OE period is in progress.
Affected Areas : Open Enrollment Report
Tested Scenarios:
1. Checked reports in both conditions of ApplyOERules (i.e. Yes and No)
2. Modified demographics of Employee and verified it displaying on report or not as expected.
Afftected Files:
/MasterCompanyDB/04_Stored Procedures/dbo.OES_SP_Report_GetOEEffectiveDateForAllEmployees.StoredProcedure.sql
/MasterCompanyDB/04_Stored Procedures/dbo.OES_SP_Report_OpenEnrollmentChangesAllBenefits.StoredProcedure.sql
Note : We could not able to reproduce issue on local environment but handled code to return only Current OE records. Parmeshwar Jumbad (Inactive)
made changes -
| Code Review Date | 25/Jul/2017 |
Khandu Kshirsagar (Inactive)
made changes -
| Item State | Parent values: Development(10200)Level 1 values: Ready for Review(10208) | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) |
Parmeshwar Jumbad (Inactive)
made changes -
| Assignee | Parmeshwar Jumbad [ parmeshwar.jumbade ] | Sachin Hingole [ sachin.hingole ] |
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
Parmeshwar Jumbad (Inactive)
made changes -
| Time Spent | 45h [ 162000 ] | 48.5h [ 174600 ] |
| Worklog Id | 66223 [ 66223 ] |
Sachin Hingole (Inactive)
made changes -
| Status | In Development [ 10007 ] | Local Testing [ 10200 ] |
Sachin Hingole (Inactive)
made changes -
| Item State | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) | Parent values: LB QA(10201)Level 1 values: In Testing(10210) |
Sachin Hingole (Inactive)
made changes -
| QA | Sachin Hingole [ sachin.hingole ] | Meghana Joshi [ meghana.kulkarni ] |
Sachin Hingole (Inactive)
made changes -
| Assignee | Sachin Hingole [ sachin.hingole ] | Meghana Joshi [ meghana.kulkarni ] |
Parmeshwar Jumbad (Inactive)
made changes -
| Time Spent | 48.5h [ 174600 ] | 50h [ 180000 ] |
| Worklog Id | 65936 [ 65936 ] |
| Production Due Date | 03/Aug/2017 | |
| Stage Due Date | 2/Aug/17 [ 2017-08-02 ] |
| Time Spent | 50h [ 180000 ] | 50.5h [ 181800 ] |
| Worklog Id | 68034 [ 68034 ] |
| Time Spent | 50.5h [ 181800 ] | 51h [ 183600 ] |
| Worklog Id | 68044 [ 68044 ] |
| Time Spent | 51h [ 183600 ] | 54h [ 194400 ] |
| Worklog Id | 68267 [ 68267 ] |
Verified below Scenarios on LB :
1) Verified OE Changes report when class wise OE is in Progress for all employee
2) Verified OE Changes report when class wise OE is in Progress by changing demographics data of employee
3) Verified OE Changes report when class wise OE is in Progress by changing enrollment of employee
4) Verified OE Changes report when class wise OE is not in Progress
5) Verified OE Changes report when OE is in Progress for all employee
Working Fine
CC - Sachin Hingole
| Item State | Parent values: LB QA(10201)Level 1 values: In Testing(10210) | Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) |
| Production Due Date | 03/Aug/2017 | |
| Stage Due Date | 2/Aug/17 [ 2017-08-02 ] |
| Item State | Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) | Parent values: LB QA(10201)Level 1 values: On Hold(10211) |
Hi [~meghana joshi]
Keep this JIRA on hold because it is blocked due to WT-4073 (Generic Eligibility changes). We can move this once Generic Eligibility changes get deployed on stage.
-CC: Prasanna Karlekar
Parmeshwar Jumbad (Inactive)
added a comment - - edited Hi [~meghana joshi]
Keep this JIRA on hold because it is blocked due to WT-4073 (Generic Eligibility changes). We can move this once Generic Eligibility changes get deployed on stage.
-CC: Prasanna Karlekar | Bug Severity | Critical [ 16701 ] |
| Time Spent | 54h [ 194400 ] | 57h [ 205200 ] |
| Worklog Id | 71377 [ 71377 ] |
Hi [~meghana joshi],
JIRA WT-3747 is main Enhancement to implement 'Generic Eligibility Component for Class wise open Enrollment - UI and Business logic'. We can not move WT-3747 jira to stage in regular stage build. its require migration of Generic Eligibility for all companies. This will get deploy on stage when LB branch is move to Stage branch.
Thanks & Regards,
Vinanti.
CC : Amruta Lohiya, Prasanna Karlekar, [~parmeshwar.jumbade], Satya, Vijay Siddha
Vinanti Yadav (Inactive)
added a comment - Hi [~meghana joshi] ,
JIRA WT-3747 is main Enhancement to implement 'Generic Eligibility Component for Class wise open Enrollment - UI and Business logic'. We can not move WT-3747 jira to stage in regular stage build. its require migration of Generic Eligibility for all companies. This will get deploy on stage when LB branch is move to Stage branch.
Thanks & Regards,
Vinanti.
CC : Amruta Lohiya , Prasanna Karlekar , [~parmeshwar.jumbade] , Satya , Vijay Siddha | Item State | Parent values: LB QA(10201)Level 1 values: On Hold(10211) | Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) |
| Production Due Date | 14/Oct/2017 |
| Stage Due Date | 3/Sep/17 [ 2017-09-03 ] |
| Status | Local Testing [ 10200 ] | Stage Testing [ 10201 ] |
| Item State | Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) | Parent values: Stage QA(10202)Level 1 values: In Testing(10214) |
| Item State | Parent values: Stage QA(10202)Level 1 values: In Testing(10214) | Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) |
| Resolution | Unresolved [ 10200 ] | |
| Status | Stage Testing [ 10201 ] | Reopen in Stage [ 10023 ] |
| Status | Reopen in Stage [ 10023 ] | In Development [ 10007 ] |
| Status | In Development [ 10007 ] | Local Testing [ 10200 ] |
| Production Due Date | 14/Oct/2017 | 18/Oct/2017 |
| Stage Due Date | 3/Sep/17 [ 2017-09-03 ] | 16/Oct/17 [ 2017-10-16 ] |
Now, Patch is Ready For Stage.
CC - Sachin Hingole , [~parmeshwar.jumbade] , Prasanna Karlekar
Khandu Kshirsagar (Inactive)
made changes -
| Item State | Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) | Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) |
| Status | Local Testing [ 10200 ] | Stage Testing [ 10201 ] |
| Item State | Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) | Parent values: Stage QA(10202)Level 1 values: In Testing(10214) |
| Time Spent | 57h [ 205200 ] | 58.5h [ 210600 ] |
| Worklog Id | 85255 [ 85255 ] |
| Item State | Parent values: Stage QA(10202)Level 1 values: In Testing(10214) | Parent values: Stage QA(10202)Level 1 values: Production Deployment on Hold(10224) |
Parmeshwar Jumbad (Inactive)
made changes -
| Labels | Static_Reports |
| Environment_New | Production [ 18442 ] |
| Production Due Date | 18/Oct/2017 | 29/Jan/2018 |
Parmeshwar Jumbad (Inactive)
made changes -
| Attachment | WT-5940- Issue and implementation Approach.xls [ 70460 ] |
Have added WT-5940- Issue and implementation Approach.xls
file for current implementation and bug resolution approach.
Parmeshwar Jumbad (Inactive)
added a comment - - edited Hi Gaurav Sodani
Have added WT-5940- Issue and implementation Approach.xls file for current implementation and bug resolution approach.
CC: Prasanna Karlekar Satya | Assignee | Meghana Joshi [ meghana.kulkarni ] | Venkatesh Pujari [ venkatesh.pujari ] |
| Production Due Date | 29/Jan/2018 | 05/Mar/2018 |
| Status | Stage Testing [ 10201 ] | Production Testing [ 10202 ] |
Verified this fix on Production. Working fine as expected
| Resolution | Unresolved [ 10200 ] | Bug Fixed [ 10402 ] |
| Status | Production Testing [ 10202 ] | Production Complete [ 10028 ] |
| Time Spent | 58.5h [ 210600 ] | 59h [ 212400 ] |
| Worklog Id | 107162 [ 107162 ] |
Sachin Hingole (Inactive)
made changes -
| Status | Production Complete [ 10028 ] | Closed [ 6 ] |
| Transition | Time In Source Status | Execution Times |
|---|
Parmeshwar Jumbad (Inactive)
made transition
-
|
257d 4h 42m | 1 |
|
36m 50s | 1 |
|
3s | 1 |
|
8d 17h 16m | 2 |
|
82d 4h 40m | 2 |
|
140d 2h 41m | 1 |
|
18h 30m | 1 |
Sachin Hingole (Inactive)
made transition
-
|
1d 2m | 1 |
Hi Shubhankar Joshi,
Following are the 3Cs:
Concern:
Receiving a server error when attempting to preview the OE Changes Report for Prime_Healthcare: GGH company.
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 1/1/2016 and 1/1/2017 both are getting populated, which is causing the error.
Correction:
Need to check if Open Enrollment rules for previous years also exists in the "OpenEnrollmentRules" table. If yes, then implementation changes will required.
As of now giving temporary fix for this issue to avoid server error. Permanent fix needs to be worked on at earliest
cc: Satya, Samir, shyam sharma, Vijay Siddha