-
Type:
Bug
-
Status: Resolution Setting
-
Priority:
Medium
-
Resolution: Done
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: UI Refresh
-
Labels:None
-
Environment:Pre Production
-
Bug Type:Functional
-
Bug Severity:Medium
-
Level:Partner
-
Module:BenAdmin - Report
-
Reported by:Harbinger
-
Company:All Clients/Multiple Clients
-
Item State:Stage QA - Production Deployment on Hold
Environment - Preprod
Company - Orchard school district, The packard companies
Browser - Chrome / IE
1) Login with partner
2) Select company
3) Reports -> Newly enrollment dependent report -> Preview reports -> throws error
Note - After clearing cache also issue exists
- relates to
-
NF-5728 Pre-Prod Company testing Time Update Jira
-
- Reopen
-
Jayshree Nagpure (Inactive)
created issue -
Jayshree Nagpure (Inactive)
made changes -
| Field | Original Value | New Value |
|---|---|---|
| Attachment | OrchardNewlyEnrolledDependentreport.jpg [ 71843 ] |
CC:Nidhi Kaul
| Assignee | Nidhi Kaul [ nidhi.kaul ] | Prasanna Karlekar [ prasanna ] |
| Assignee | Prasanna Karlekar [ prasanna ] | Parmeshwar Jumbad [ parmeshwar.jumbade ] |
Parmeshwar Jumbad (Inactive)
made changes -
| Status | Open [ 1 ] | In Development [ 10007 ] |
Parmeshwar Jumbad (Inactive)
made changes -
| Item State | Parent values: Development(10200)Level 1 values: In Analysis(10204) |
Parmeshwar Jumbad (Inactive)
logged work - 18/Jan/18 04:13 AM -
- Time Spent:
- 4h
-
Issue analysis
Check existing code to run report
Parmeshwar Jumbad (Inactive)
made changes -
| Remaining Estimate | 0h [ 0 ] | |
| Time Spent | 4h [ 14400 ] | |
| Worklog Id | 100868 [ 100868 ] |
Environment : Pre-Prod
Company: Colts for hspl
Same server error observed by partner/admin login.
---------------------------------
CC: Mandar Kulkarni, Satya, Rakesh Roy, Hrishikesh Deshpande, Sachin Hingole, Prasad Patil
Sumeet.Kolge (Inactive)
added a comment - Environment : Pre-Prod
Company: Colts for hspl
Same server error observed by partner/admin login.
---------------------------------
CC: Mandar Kulkarni , Satya , Rakesh Roy , Hrishikesh Deshpande , Sachin Hingole , Prasad Patil -
- Time Spent:
- 4h
-
Code analysis & Code changes
Unit testing
Review request
Parmeshwar Jumbad (Inactive)
made changes -
| Item State | Parent values: Development(10200)Level 1 values: In Analysis(10204) | Parent values: Development(10200)Level 1 values: Ready for Review(10208) |
Parmeshwar Jumbad (Inactive)
made changes -
| Assignee | Parmeshwar Jumbad [ parmeshwar.jumbade ] | Prasanna Karlekar [ prasanna ] |
| Time Spent | 4h [ 14400 ] | 4.5h [ 16200 ] |
| Worklog Id | 101417 [ 101417 ] |
-
- Time Spent:
- 0.5h
-
Email go through for 3Cs
Review Pending
| Item State | Parent values: Development(10200)Level 1 values: Ready for Review(10208) | Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209) |
| Assignee | Prasanna Karlekar [ prasanna ] | Parmeshwar Jumbad [ parmeshwar.jumbade ] |
| Time Spent | 4.5h [ 16200 ] | 5.25h [ 18900 ] |
| Worklog Id | 101677 [ 101677 ] |
-
- Time Spent:
- 0.75h
-
Code review
3Cs go through and update
Discussion on fix done
Functionality review - Observerd issue for EmployeeType field but need to check if we have to fix this or not
Below are the 3C's:
Concern: Newly Enrolled Dependent Report throws error on preview.
Cause: This issue was caused because of fix done in NF-5613. We did not verify the impact on Newly enrolled dependent Report.
While fixing issue for NF-5613 following was done:
- While creating JOIN clause, we removed the hard coded string that was used earlier for field name and instead used the selected field value as it is. While doing so, some of the space characters also got removed.
- As we removed the hardcoded value, while doing string comparison in further implementation, there was issue related to case sensitivity for same field name.
Because of these reasons, error appeared while previewing the report.
Correction:
Now we have done following two changes:
1. Added space in the string while creating JOIN clause.
2. While comparing query text, have capitalized characters, so that it will avoid case sensitivity problem.
Affected Areas: Reports (Newly dependent report, Standard report, dynamic report)
Affected Files: StandardReports.cshtml
Tested Scenarios:
1. Checked newly dependent report with preview option.
2. Verified Standard and Dynamic report with metadata fields like Relationship and Secondary relationship.
Known issues:
1. After click on any fields from select/display fields it scroll to the top of section. It should not.
2. Employee type field (I.e. Metadata field) returning number instead of name of type.
Parmeshwar Jumbad (Inactive)
added a comment - Below are the 3C's :
Concern : Newly Enrolled Dependent Report throws error on preview.
Cause : This issue was caused because of fix done in NF-5613 . We did not verify the impact on Newly enrolled dependent Report.
While fixing issue for NF-5613 following was done:
While creating JOIN clause, we removed the hard coded string that was used earlier for field name and instead used the selected field value as it is. While doing so, some of the space characters also got removed.
As we removed the hardcoded value, while doing string comparison in further implementation, there was issue related to case sensitivity for same field name.
Because of these reasons, error appeared while previewing the report.
Correction :
Now we have done following two changes:
1. Added space in the string while creating JOIN clause.
2. While comparing query text, have capitalized characters, so that it will avoid case sensitivity problem.
Affected Areas : Reports (Newly dependent report, Standard report, dynamic report)
Affected Files : StandardReports.cshtml
Tested Scenarios :
1. Checked newly dependent report with preview option.
2. Verified Standard and Dynamic report with metadata fields like Relationship and Secondary relationship.
Known issues :
1. After click on any fields from select/display fields it scroll to the top of section. It should not.
2. Employee type field (I.e. Metadata field) returning number instead of name of type.
CC: Prasanna Karlekar Amruta Lohiya Gaurav Sodani
Sachin Hingole (Inactive)
made changes -
Parmeshwar Jumbad (Inactive)
made changes -
| Time Spent | 5.25h [ 18900 ] | 9.25h [ 33300 ] |
| Worklog Id | 101916 [ 101916 ] |
Parmeshwar Jumbad (Inactive)
made changes -
| Worklog Id | 101916 [ 101916 ] |
Parmeshwar Jumbad (Inactive)
made changes -
| Assignee | Parmeshwar Jumbad [ parmeshwar.jumbade ] | Sachin Hingole [ sachin.hingole ] |
| Item State | Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209) | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) |
Sachin Hingole (Inactive)
made changes -
| Status | In Development [ 10007 ] | Local Testing [ 10200 ] |
Sachin Hingole (Inactive)
made changes -
| Assignee | Sachin Hingole [ sachin.hingole ] | Jayshree Nagpure [ jayshree.nagpure ] |
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) |
Verified on codemap
Company - QA kindercare
Verified newly enrolled dependent report - Pulling reports shows proper data
Also verified standard report and dynamic report.
Marking item state as Ready for stage
Thanks,
Jayshree
cc : Rakesh Roy Prasad Pise Sachin Hingole Hrishikesh Deshpande
Jayshree Nagpure (Inactive)
added a comment - Verified on codemap
Company - QA kindercare
Verified newly enrolled dependent report - Pulling reports shows proper data
Also verified standard report and dynamic report.
Marking item state as Ready for stage
Thanks,
Jayshree
cc : Rakesh Roy Prasad Pise Sachin Hingole Hrishikesh Deshpande Jayshree Nagpure (Inactive)
made changes -
| 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 -
| Time Spent | 9.25h [ 33300 ] | 10.25h [ 36900 ] |
| Worklog Id | 102021 [ 102021 ] |
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) |
Sachin Hingole (Inactive)
made changes -
| 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) |
Sachin Hingole (Inactive)
made changes -
| Status | Local Testing [ 10200 ] | Stage Testing [ 10201 ] |
Sachin Hingole (Inactive)
made changes -
| Resolution | Done [ 10000 ] | |
| Status | Stage Testing [ 10201 ] | Resolution Setting [ 11616 ] |
| Transition | Time In Source Status | Execution Times |
|---|
Parmeshwar Jumbad (Inactive)
made transition
-
|
1d 18h 49m | 1 |
Sachin Hingole (Inactive)
made transition
-
|
7d 4h 50m | 1 |
Sachin Hingole (Inactive)
made transition
-
|
4d 23h 22m | 1 |
Sachin Hingole (Inactive)
made transition
-
|
85d 18h 2m | 1 |
cc : Rakesh Roy Prasad Pise Sachin Hingole