[NF-5375] Pre-Prod | Intrepid USA | EE level Eligibility Report | Serve Error. - Workterra Jira

Details

Type: Bug
Status: Closed
Priority: Medium
Resolution: Bug Fixed
Affects Version/s: None
Fix Version/s: None
Component/s: UI Refresh
Labels:
None

Environment:

Pre Production
Bug Type:
Functional
Bug Severity:
Medium
Level:

Employee
Module:
BenAdmin - Report
Reported by:
Harbinger
Company:
Intrepid USA
Item State:
Stage QA - Production Deployment on Hold

Description

Checked with EE and CA login, getting server error on Eligibility Report at EE level.

(Please refer the screen shot below and the Error log attached)

Eligibility Report Error Log.txt

Attachments

Options
- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

Attachments

Eligibility Report Error Log.txt
3 kB
04/Dec/17 09:44 AM
Eligibility Rule.png
33 kB
19/Dec/17 07:34 AM
server error.png
27 kB
04/Dec/17 09:45 AM

Issue Links

is duplicated by

WT-13112 Austin- Server Error PROD

Closed

relates to

NF-5195 Preprod build deployment

Open

Activity

Ascending order - Click to sort in descending order

Prasad Patil (Inactive) created issue - 04/Dec/17 09:46 AM

Prasad Patil (Inactive) made changes - 04/Dec/17 10:04 AM

Field	Original Value	New Value
Link		This issue relates to NF-5195 [ NF-5195 ]

Sachin Hingole (Inactive) made changes - 04/Dec/17 10:29 AM

Level

Employee [ 15801 ]

Parmeshwar Jumbad (Inactive) made changes - 15/Dec/17 12:35 PM

Assignee

Prasanna Karlekar [ prasanna ]

Harshada Borole [ harshada.borole ]

Harshada Borole (Inactive) made changes - 18/Dec/17 06:46 AM

Status

Open [ 1 ]

In Development [ 10007 ]

Harshada Borole (Inactive) made changes - 18/Dec/17 06:47 AM

Developer		Harshada Borole [ harshada.borole ]
Item State		Parent values: Development(10200)Level 1 values: In Analysis(10204)

Permalink

Prasad Patil (Inactive) logged work - 18/Dec/17 11:49 AM

Time Spent:

0.25h

Internal discussion.

Permalink

Harshada Borole (Inactive) logged work - 18/Dec/17 04:06 PM

Time Spent:

5h

Company down and resolved issue related to that.
Analysis.
Discussion with Prasanna.

Permalink

Prasanna Karlekar (Inactive) logged work - 18/Dec/17 11:30 PM

Time Spent:

0.5h

Discussion of verification for Eligibility queries
Issue discussion

Harshada Borole (Inactive) made changes - 19/Dec/17 04:08 AM

Remaining Estimate		0h [ 0 ]
Time Spent		5h [ 18000 ]
Worklog Id		96718 [ 96718 ]

Prasanna Karlekar (Inactive) made changes - 19/Dec/17 05:19 AM

Time Spent	5h [ 18000 ]	5.5h [ 19800 ]
Worklog Id		96749 [ 96749 ]

Harshada Borole (Inactive) made changes - 19/Dec/17 07:34 AM

Attachment

Eligibility Rule.png [ 70343 ]

Hide

Permalink

Harshada Borole (Inactive) added a comment - 19/Dec/17 07:35 AM - edited

Hi Prasad Patil,

Eligibility rule, having condition related to 'Mode Effective Date' macro is not implemented for Eligibility report.
Please refer below screen shot:

Kindly remove the criteria and verify it.

Thank you,
Harshada.

cc:Prasanna Karlekar,Jyoti Agrawal

Show

Harshada Borole (Inactive) added a comment - 19/Dec/17 07:35 AM - edited Hi Prasad Patil , Eligibility rule, having condition related to 'Mode Effective Date' macro is not implemented for Eligibility report. Please refer below screen shot: Kindly remove the criteria and verify it. Thank you, Harshada. cc: Prasanna Karlekar , Jyoti Agrawal

Harshada Borole (Inactive) made changes - 19/Dec/17 07:36 AM

Assignee

Harshada Borole [ harshada.borole ]

Prasad Patil [ prasad.patil ]

Harshada Borole (Inactive) made changes - 19/Dec/17 07:39 AM

Time Spent	5.5h [ 19800 ]	8.5h [ 30600 ]
Worklog Id		96815 [ 96815 ]

Prasad Patil (Inactive) made changes - 19/Dec/17 11:49 AM

Time Spent	8.5h [ 30600 ]	8.75h [ 31500 ]
Worklog Id		96851 [ 96851 ]

Hide

Permalink

Prasad Patil (Inactive) added a comment - 19/Dec/17 12:06 PM

Hi Harshada Borole,

As requested, I removed the condition related to 'Mode Effective Date' in the Eligibility Rule 'Rule_23' and verified the report at EE level. The report is running as expected without server error.

As dicussed, 'Mode Effective Date' macro is to be implemented for Eligibility rules.
Request you to please look into this.
Thank you,
----------------------------------------------------------------------------
CC: Mandar Kulkarni, Satya, Prasanna Karlekar

Show

Prasad Patil (Inactive) added a comment - 19/Dec/17 12:06 PM Hi Harshada Borole , As requested, I removed the condition related to 'Mode Effective Date' in the Eligibility Rule 'Rule_23' and verified the report at EE level. The report is running as expected without server error. As dicussed, 'Mode Effective Date' macro is to be implemented for Eligibility rules. Request you to please look into this. Thank you, ---------------------------------------------------------------------------- CC: Mandar Kulkarni , Satya , Prasanna Karlekar

Prasad Patil (Inactive) made changes - 19/Dec/17 12:06 PM

Assignee

Prasad Patil [ prasad.patil ]

Harshada Borole [ harshada.borole ]

Harshada Borole (Inactive) made changes - 19/Dec/17 12:56 PM

Worklog Id

96815 [ 96815 ]

Permalink

Prasanna Karlekar (Inactive) logged work - 19/Dec/17 01:00 PM

Time Spent:

0.75h

Pair programming - Issue debug
Discussion on Mode Effective Date field with EDS team member

Permalink

Harshada Borole (Inactive) logged work - 20/Dec/17 07:37 AM - edited

Time Spent:

3h

Analysis,
Discussion with Prasanna.
Issue verification on Production.

Prasanna Karlekar (Inactive) made changes - 20/Dec/17 08:31 AM

Time Spent	8.75h [ 31500 ]	9.5h [ 34200 ]
Worklog Id		97088 [ 97088 ]

Permalink

Prasad Patil (Inactive) logged work - 20/Dec/17 04:53 PM

Time Spent:

1h

Analysis and discussion with Harshada. scenario verification.

Prasad Patil (Inactive) made changes - 21/Dec/17 04:53 AM

Time Spent	9.5h [ 34200 ]	10.5h [ 37800 ]
Worklog Id		97263 [ 97263 ]

Harshada Borole (Inactive) made changes - 21/Dec/17 06:18 AM

Item State

Parent values: Development(10200)Level 1 values: In Analysis(10204)

Parent values: Development(10200)Level 1 values: On Hold(10207)

Jyoti Agrawal (Inactive) made changes - 26/Dec/17 11:57 AM

Assignee

Harshada Borole [ harshada.borole ]

Parmeshwar Jumbad [ parmeshwar.jumbade ]

Permalink

Parmeshwar Jumbad (Inactive) logged work - 27/Dec/17 05:17 AM

Time Spent:

1h

Analysis and discussion

Parmeshwar Jumbad (Inactive) made changes - 27/Dec/17 05:17 AM

Time Spent	10.5h [ 37800 ]	11.5h [ 41400 ]
Worklog Id		97954 [ 97954 ]

Parmeshwar Jumbad (Inactive) made changes - 27/Dec/17 08:36 AM

Dev Due Date		08/Jan/2018
Original Estimate		0h [ 0 ]

Permalink

Prasanna Karlekar (Inactive) logged work - 28/Dec/17 12:30 AM

Time Spent:

1h

Code go through to check how additional criteria string gets created while storing in DB
Discussion with Enrollment team regarding Mode effective date macro implementation

Prasanna Karlekar (Inactive) made changes - 28/Dec/17 06:24 AM

Time Spent	11.5h [ 41400 ]	12.5h [ 45000 ]
Worklog Id		98207 [ 98207 ]

Parmeshwar Jumbad (Inactive) made changes - 29/Dec/17 05:41 AM

Item State

Parent values: Development(10200)Level 1 values: On Hold(10207)

Parent values: Development(10200)

Hide

Permalink

Parmeshwar Jumbad (Inactive) added a comment - 29/Dec/17 05:46 AM

We are taking this up in sprint 42
Before start implementation of 'Mode Effective Date' macro for eligibility report need discussion with Enrollment Team.

CC: Jyoti Mayne Amruta Lohiya Prasanna Karlekar Gaurav Sodani

Show

Parmeshwar Jumbad (Inactive) added a comment - 29/Dec/17 05:46 AM We are taking this up in sprint 42 Before start implementation of 'Mode Effective Date' macro for eligibility report need discussion with Enrollment Team. CC: Jyoti Mayne Amruta Lohiya Prasanna Karlekar Gaurav Sodani

Permalink

Prasanna Karlekar (Inactive) logged work - 03/Jan/18 10:45 PM

Time Spent:

0.25h

Discussion on Mode Effective Date Macro

Permalink

Parmeshwar Jumbad (Inactive) logged work - 04/Jan/18 04:13 AM

Time Spent:

3h

Issue analysis and Try to reproduce issue
Discussion with Prasanna and Amruta

Parmeshwar Jumbad (Inactive) made changes - 04/Jan/18 04:13 AM

Item State

Parent values: Development(10200)

Parent values: Development(10200)Level 1 values: In Analysis(10204)

Parmeshwar Jumbad (Inactive) made changes - 04/Jan/18 04:13 AM

Time Spent	12.5h [ 45000 ]	15.5h [ 55800 ]
Worklog Id		99246 [ 99246 ]

Permalink

Parmeshwar Jumbad (Inactive) logged work - 04/Jan/18 08:24 AM

Time Spent:

6h

Internal discussion with Enrollment team
Issue Analysis
Reproduce issue

Prasanna Karlekar (Inactive) made changes - 04/Jan/18 08:31 AM

Time Spent	15.5h [ 55800 ]	15.75h [ 56700 ]
Worklog Id		99304 [ 99304 ]

Permalink

Parmeshwar Jumbad (Inactive) logged work - 05/Jan/18 08:21 AM

Time Spent:

4.5h

Try to reproduce issue
Internal discussion
Existing implementation Analysis
Code changes

Prasanna Karlekar (Inactive) made changes - 05/Jan/18 01:27 PM

Time Spent	15.75h [ 56700 ]	16h [ 57600 ]
Worklog Id		99528 [ 99528 ]

Permalink

Prasanna Karlekar (Inactive) logged work - 05/Jan/18 11:30 PM

Time Spent:

0.25h

Query resolution - Scenario repro

Parmeshwar Jumbad (Inactive) made changes - 08/Jan/18 06:08 AM

Item State

Parent values: Development(10200)Level 1 values: In Analysis(10204)

Parent values: Development(10200)Level 1 values: In Progress(10206)

Permalink

Parmeshwar Jumbad (Inactive) logged work - 08/Jan/18 08:20 AM

Time Spent:

3h

Code changes and Unit testing

Parmeshwar Jumbad (Inactive) made changes - 09/Jan/18 04:14 AM

Dev Due Date

08/Jan/2018

09/Jan/2018

Parmeshwar Jumbad (Inactive) made changes - 09/Jan/18 07:14 AM

Item State

Parent values: Development(10200)Level 1 values: In Progress(10206)

Parent values: Development(10200)Level 1 values: Ready for Review(10208)

Parmeshwar Jumbad (Inactive) made changes - 09/Jan/18 07:32 AM

Assignee

Parmeshwar Jumbad [ parmeshwar.jumbade ]

Prasanna Karlekar [ prasanna ]

Parmeshwar Jumbad (Inactive) made changes - 09/Jan/18 07:33 AM

Time Spent	16h [ 57600 ]	18h [ 64800 ]
Worklog Id		99705 [ 99705 ]

Parmeshwar Jumbad (Inactive) made changes - 09/Jan/18 07:33 AM

Worklog Id

99705 [ 99705 ]

Parmeshwar Jumbad (Inactive) made changes - 09/Jan/18 08:21 AM

Time Spent	18h [ 64800 ]	21h [ 75600 ]
Worklog Id		99714 [ 99714 ]

Parmeshwar Jumbad (Inactive) made changes - 09/Jan/18 08:22 AM

Time Spent	21h [ 75600 ]	25.5h [ 91800 ]
Worklog Id		99715 [ 99715 ]

Parmeshwar Jumbad (Inactive) made changes - 09/Jan/18 08:25 AM

Time Spent	25.5h [ 91800 ]	31.5h [ 113400 ]
Worklog Id		99716 [ 99716 ]

Permalink

Parmeshwar Jumbad (Inactive) logged work - 10/Jan/18 07:32 AM - edited

Time Spent:

2h

Unit testing
Review request

Hide

Permalink

Parmeshwar Jumbad (Inactive) added a comment - 10/Jan/18 09:39 AM

Below are the 3C's
Concern: Server error on plan eligibility report.
Cause: 'Mode Effective Date' macro was not implemented for reports. When any plan was configured with Eligibility rule having 'Mode Effective Date' macro, server error appeared. Error only occurs when other additional criteria rules are configured with this macro. No error appears, when this macro is the only additional criteria configured.
Correction: We have done code changes to implement 'Mode Effective Date' macro for eligibility report. Due to the fix done, report will work in all scenarios related to Mode Effective Date macro without any exception.
Affected Areas: Eligibility Reports (Company Level, Employee level)
Affected Files: EligibilityReason.vb
Tested Scenarios:
1. Verified Employee level - Employee plan eligibility report (With and without additional criteria)
2. Verified Employee level - Employee plan eligibility report (with eligible and non-eligible condition)
3. Verified company level Employee plan eligibility report.
4. Verified company level standard eligibility report and check ineligibility reason

Note: Ineligibility reason text will display in eglish only. (i.e. Text not referred from resources)

CC: Prasanna Karlekar Gaurav Sodani

Show

Parmeshwar Jumbad (Inactive) added a comment - 10/Jan/18 09:39 AM Below are the 3C's Concern : Server error on plan eligibility report. Cause : 'Mode Effective Date' macro was not implemented for reports. When any plan was configured with Eligibility rule having 'Mode Effective Date' macro, server error appeared. Error only occurs when other additional criteria rules are configured with this macro. No error appears, when this macro is the only additional criteria configured. Correction : We have done code changes to implement 'Mode Effective Date' macro for eligibility report. Due to the fix done, report will work in all scenarios related to Mode Effective Date macro without any exception. Affected Areas : Eligibility Reports (Company Level, Employee level) Affected Files : EligibilityReason.vb Tested Scenarios : 1. Verified Employee level - Employee plan eligibility report (With and without additional criteria) 2. Verified Employee level - Employee plan eligibility report (with eligible and non-eligible condition) 3. Verified company level Employee plan eligibility report. 4. Verified company level standard eligibility report and check ineligibility reason Note: Ineligibility reason text will display in eglish only. (i.e. Text not referred from resources) CC: Prasanna Karlekar Gaurav Sodani

Permalink

Prasanna Karlekar (Inactive) logged work - 10/Jan/18 08:00 PM - edited

Time Spent:

0.5h

Code and functionality review - changes suggested

Permalink

Parmeshwar Jumbad (Inactive) logged work - 11/Jan/18 04:01 AM

Time Spent:

1h

discussion while code review
Code changes for ineligibility reason
Unit testing
Code check-in

Parmeshwar Jumbad (Inactive) made changes - 11/Jan/18 04:02 AM

Time Spent	31.5h [ 113400 ]	32.5h [ 117000 ]
Worklog Id		99935 [ 99935 ]

Khandu Kshirsagar (Inactive) made changes - 11/Jan/18 06:05 AM

Item State

Parent values: Development(10200)Level 1 values: Ready for Review(10208)

Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)

Prasanna Karlekar (Inactive) made changes - 11/Jan/18 06:17 AM

Time Spent	32.5h [ 117000 ]	33h [ 118800 ]
Worklog Id		99969 [ 99969 ]

Prasanna Karlekar (Inactive) made changes - 11/Jan/18 06:18 AM

Assignee

Prasanna Karlekar [ prasanna ]

Sachin Hingole [ sachin.hingole ]

Prasanna Karlekar (Inactive) made changes - 11/Jan/18 06:19 AM

Worklog Id

99969 [ 99969 ]

Sachin Hingole (Inactive) made changes - 11/Jan/18 06:43 AM

Status

In Development [ 10007 ]

Local Testing [ 10200 ]

Sachin Hingole (Inactive) made changes - 11/Jan/18 06:44 AM

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 - 11/Jan/18 10:28 AM

Assignee

Sachin Hingole [ sachin.hingole ]

Jayshree Nagpure [ jayshree.nagpure ]

Permalink

Jayshree Nagpure (Inactive) logged work - 11/Jan/18 12:33 PM

Time Spent:

1h

Analysis and Testing

Hide

Permalink

Jayshree Nagpure (Inactive) added a comment - 11/Jan/18 12:33 PM

Verified on codemap
Company - QA kinder

Verified below scenario -

1. Verified Employee level - Employee plan eligibility report (With and without additional criteria) - Pass
2. Verified Employee level - Employee plan eligibility report (with eligible and non-eligible condition) - Pass
3. Verified company level Employee plan eligibility report - Pass
4. Verified company level standard eligibility report - Pass

Working fine
Marking item state as Ready for Stage

Thanks,
Jayshree

cc : Rakesh Roy Prasad Pise Sachin Hingole

Show

Jayshree Nagpure (Inactive) added a comment - 11/Jan/18 12:33 PM Verified on codemap Company - QA kinder Verified below scenario - 1. Verified Employee level - Employee plan eligibility report (With and without additional criteria) - Pass 2. Verified Employee level - Employee plan eligibility report (with eligible and non-eligible condition) - Pass 3. Verified company level Employee plan eligibility report - Pass 4. Verified company level standard eligibility report - Pass Working fine Marking item state as Ready for Stage Thanks, Jayshree cc : Rakesh Roy Prasad Pise Sachin Hingole

Jayshree Nagpure (Inactive) made changes - 11/Jan/18 12:33 PM

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)

Jayshree Nagpure (Inactive) made changes - 11/Jan/18 12:34 PM

Time Spent	33h [ 118800 ]	34h [ 122400 ]
Worklog Id		100061 [ 100061 ]

Khandu Kshirsagar (Inactive) made changes - 12/Jan/18 04:59 AM

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)

Sachin Hingole (Inactive) made changes - 12/Jan/18 10:30 AM

Status

Local Testing [ 10200 ]

Stage Testing [ 10201 ]

Sachin Hingole (Inactive) made changes - 12/Jan/18 10:32 AM

Item State

Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)

Parent values: Stage QA(10202)Level 1 values: Production Deployment on Hold(10224)

Parmeshwar Jumbad (Inactive) made changes - 17/Jan/18 09:09 AM

Link

This issue is duplicated by ~~WT-13112~~ [ ~~WT-13112~~ ]

Jayshree Nagpure (Inactive) made changes - 30/Mar/18 01:25 AM

Status

Stage Testing [ 10201 ]

In Production Testing [ 10202 ]

Hide

Permalink

Jayshree Nagpure (Inactive) added a comment - 30/Mar/18 01:27 AM

Verified on production
Company - Je dunn for hspl

Issue of server error is fixed on production
Closing this jira

Thanks,
Jayshree

cc - Prasad Pise Sachin Hingole Hrishikesh Deshpande Rakesh Roy

Show

Jayshree Nagpure (Inactive) added a comment - 30/Mar/18 01:27 AM Verified on production Company - Je dunn for hspl Issue of server error is fixed on production Closing this jira Thanks, Jayshree cc - Prasad Pise Sachin Hingole Hrishikesh Deshpande Rakesh Roy

Jayshree Nagpure (Inactive) made changes - 30/Mar/18 01:27 AM

Resolution		Bug Fixed [ 10402 ]
Status	In Production Testing [ 10202 ]	Production Complete [ 10028 ]

Jayshree Nagpure (Inactive) made changes - 30/Mar/18 01:27 AM

Status

Production Complete [ 10028 ]

Closed [ 6 ]

Transition	Time In Source Status	Execution Times

Harshada Borole (Inactive) made transition - 18/Dec/17 06:46 AM

Open

In Development

13d 21h

Sachin Hingole (Inactive) made transition - 11/Jan/18 06:43 AM

In Development

In LB Testing

23d 23h 56m

Sachin Hingole (Inactive) made transition - 12/Jan/18 10:30 AM

In LB Testing

Stage Testing

1d 3h 47m

Jayshree Nagpure (Inactive) made transition - 30/Mar/18 01:25 AM

Stage Testing

In Production Testing

76d 13h 54m

Jayshree Nagpure (Inactive) made transition - 30/Mar/18 01:27 AM

In Production Testing

Production Complete

1m 34s

Jayshree Nagpure (Inactive) made transition - 30/Mar/18 01:27 AM

Production Complete

Closed

People

Assignee:: Jayshree Nagpure (Inactive)

Reporter:: Prasad Patil (Inactive)

Developer:: Harshada Borole (Inactive)

Votes:: 0 Vote for this issue

Watchers:: 4 Start watching this issue

Dates

Created:: 04/Dec/17 09:46 AM

Updated:: 30/Mar/18 01:27 AM

Resolved:: 30/Mar/18 01:27 AM

Dev Due Date:: 09/Jan/2018

Time Tracking

Estimated:

Remaining:

Logged:

34h