-
Type:
Bug
-
Status: Closed
-
Priority:
Medium
-
Resolution: Done
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: BenAdmin
-
Labels:None
-
Environment:QA
-
Module:BenAdmin - Report
-
Reported by:Harbinger
-
Item State:Production Complete - Closed
- company - CEI for hspl company
- created a template - all classes - status and plans selected
- Select all employee fields for display fields
- tried generating invoice for Dec 2016
Error in generating report is displayed
- relates to
-
WT-6331 BCC Invoice Management - Adjustments in future Invoice
-
- Closed
-
| Item State | Parent values: Production Complete(10222)Level 1 values: Closed(10223) |
| Description |
* company - Symphony_Production_10272016 * created a template - all classes - status and plans selected * tried generating invoice for Dec 2016 Error refer Screen Shot NO ERROR LOG GENERATED CC - [~deepalit] [~rakeshr] [~hrishikesh.deshpande] [~venkatesh.pujari] |
* company - Symphony_Production_10272016 * created a template - all classes - status and plans selected * Select all employee fields for display fields * tried generating invoice for Dec 2016 Error in generating report is displayed CC - [~deepalit] [~rakeshr] [~hrishikesh.deshpande] |
| Description |
* company - Symphony_Production_10272016 * created a template - all classes - status and plans selected * Select all employee fields for display fields * tried generating invoice for Dec 2016 Error in generating report is displayed CC - [~deepalit] [~rakeshr] [~hrishikesh.deshpande] |
* company - CEI for hspl company * created a template - all classes - status and plans selected * Select all employee fields for display fields * tried generating invoice for Dec 2016 Error in generating report is displayed CC - [~deepalit] [~rakeshr] [~hrishikesh.deshpande] |
| Description |
* company - CEI for hspl company * created a template - all classes - status and plans selected * Select all employee fields for display fields * tried generating invoice for Dec 2016 Error in generating report is displayed CC - [~deepalit] [~rakeshr] [~hrishikesh.deshpande] |
* company - CEI for hspl company * created a template - all classes - status and plans selected * Select all employee fields for display fields * tried generating invoice for Dec 2016 Error in generating report is displayed CC - [~rakeshr] [~hrishikesh.deshpande],[~alankar.chavan] |
| Assignee | Venkatesh Pujari [ venkatesh.pujari ] | Prasanna Karlekar [ prasanna ] |
| Module | Parent values: BenAdmin(10100) | Parent values: BenAdmin(10100)Level 1 values: Report(10109) |
| Component/s | BenAdmin [ 10000 ] |
| Assignee | Prasanna Karlekar [ prasanna ] | Jyoti Agrawal [ jyoti.agrawal ] |
Jyoti Agrawal (Inactive)
made changes -
| Assignee | Jyoti Agrawal [ jyoti.agrawal ] | Harshada Borole [ harshada.borole ] |
| Dev Due Date | 09/Mar/2017 |
Harshada Borole (Inactive)
logged work - 03/Mar/17 12:54 PM -
- Time Spent:
- 3h
-
Analysis and study of code
Harshada Borole (Inactive)
made changes -
| Remaining Estimate | 0.25h [ 900 ] | 0h [ 0 ] |
| Time Spent | 3h [ 10800 ] | |
| Worklog Id | 28908 [ 28908 ] |
Jyoti Agrawal (Inactive)
made changes -
| Time Spent | 3h [ 10800 ] | 4h [ 14400 ] |
| Worklog Id | 28994 [ 28994 ] |
Harshada Borole (Inactive)
made changes -
| Status | Open [ 1 ] | In Development [ 10007 ] |
Harshada Borole (Inactive)
made changes -
| Item State | Parent values: Development(10200) |
Harshada Borole (Inactive)
made changes -
| Time Spent | 4h [ 14400 ] | 12h [ 43200 ] |
| Worklog Id | 29198 [ 29198 ] |
Harshada Borole (Inactive)
logged work - 07/Mar/17 12:48 PM -
- Time Spent:
- 6h
-
Analysis and coding.
Discussion with Jyoti A.
Harshada Borole (Inactive)
made changes -
| Time Spent | 12h [ 43200 ] | 18h [ 64800 ] |
| Worklog Id | 29472 [ 29472 ] |
Harshada Borole (Inactive)
made changes -
| Time Spent | 18h [ 64800 ] | 22h [ 79200 ] |
| Worklog Id | 29756 [ 29756 ] |
Harshada Borole (Inactive)
logged work - 09/Mar/17 12:41 PM -
- Time Spent:
- 5h
-
Analysis, coding and testing.
Harshada Borole (Inactive)
made changes -
| Time Spent | 22h [ 79200 ] | 27h [ 97200 ] |
| Worklog Id | 30010 [ 30010 ] |
Jyoti Agrawal (Inactive)
made changes -
| Time Spent | 27h [ 97200 ] | 28h [ 100800 ] |
| Worklog Id | 30098 [ 30098 ] |
Jyoti Agrawal (Inactive)
made changes -
| Time Spent | 28h [ 100800 ] | 28.5h [ 102600 ] |
| Worklog Id | 30395 [ 30395 ] |
| Time Spent | 28.5h [ 102600 ] | 29.25h [ 105300 ] |
| Worklog Id | 30874 [ 30874 ] |
Jyoti Agrawal (Inactive)
logged work - 14/Mar/17 01:31 PM -
- Time Spent:
- 7h
-
Analysis, discussion, coding, unit testing
Jyoti Agrawal (Inactive)
made changes -
| Time Spent | 29.25h [ 105300 ] | 36.25h [ 130500 ] |
| Worklog Id | 30958 [ 30958 ] |
-
- Time Spent:
- 0.75h
-
Analysis
Pair programming - Code debug for fix to be done.
Discussion
Harshada Borole (Inactive)
made changes -
| Time Spent | 36.25h [ 130500 ] | 38.25h [ 137700 ] |
| Worklog Id | 31041 [ 31041 ] |
Jyoti Agrawal (Inactive)
made changes -
| Time Spent | 38.25h [ 137700 ] | 39.25h [ 141300 ] |
| Worklog Id | 31355 [ 31355 ] |
Harshada Borole (Inactive)
logged work - 16/Mar/17 05:45 AM -
- Time Spent:
- 7h
-
Discussion,
Coding,
Testing
Harshada Borole (Inactive)
made changes -
| Time Spent | 39.25h [ 141300 ] | 46.25h [ 166500 ] |
| Worklog Id | 31422 [ 31422 ] |
Harshada Borole (Inactive)
logged work - 16/Mar/17 12:52 PM -
- Time Spent:
- 7h
-
Coding,testing,resolving the issue.
Harshada Borole (Inactive)
made changes -
| Time Spent | 46.25h [ 166500 ] | 53.25h [ 191700 ] |
| Worklog Id | 31786 [ 31786 ] |
Jyoti Agrawal (Inactive)
made changes -
| Time Spent | 53.25h [ 191700 ] | 54.25h [ 195300 ] |
| Worklog Id | 31844 [ 31844 ] |
Harshada Borole (Inactive)
made changes -
| Time Spent | 54.25h [ 195300 ] | 59.25h [ 213300 ] |
| Worklog Id | 32108 [ 32108 ] |
-
- Time Spent:
- 0.25h
-
Functionality Review - Issue related to Life count
Hi Venkatesh Pujari,
The employee fields No. of Working hours per day and Last Login have some DB query issue. These are reported under tickets WT-7290 and WT-8852.
Please test this item without selecting above mentioned fields.
Regards,
Harshada
Harshada Borole (Inactive)
added a comment - Hi Venkatesh Pujari ,
The employee fields No. of Working hours per day and Last Login have some DB query issue. These are reported under tickets WT-7290 and WT-8852 .
Please test this item without selecting above mentioned fields.
Regards,
Harshada Harshada Borole (Inactive)
made changes -
| Assignee | Harshada Borole [ harshada.borole ] | Venkatesh Pujari [ venkatesh.pujari ] |
Harshada Borole (Inactive)
made changes -
| Code Reviewed By | Prasanna Karlekar [ 11907 ] |
Harshada Borole (Inactive)
made changes -
| Item State | Parent values: Development(10200) | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) |
| Status | In Development [ 10007 ] | Local Testing [ 10200 ] |
| Item State | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) | Parent values: LB QA(10201)Level 1 values: In Testing(10210) |
Hi Harshada Borole,
I have tested this issue on LB on IE 11,Chrome and firefox browsers. Now when we select all the employee fields except no. of working hours and last login fields then the system is working as per expectation. This is ready for stage.
Thanks,
Venkatesh
| Time Spent | 59.25h [ 213300 ] | 60.25h [ 216900 ] |
| Worklog Id | 32316 [ 32316 ] |
| 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) |
Harshada Borole (Inactive)
logged work - 20/Mar/17 12:42 PM -
- Time Spent:
- 2h
-
Code testing and check-in.
Harshada Borole (Inactive)
made changes -
| Time Spent | 60.25h [ 216900 ] | 62.25h [ 224100 ] |
| Worklog Id | 32322 [ 32322 ] |
Jyoti Agrawal (Inactive)
made changes -
| Time Spent | 62.25h [ 224100 ] | 63.25h [ 227700 ] |
| Worklog Id | 32427 [ 32427 ] |
Harshada Borole (Inactive)
logged work - 21/Mar/17 10:36 AM -
- Time Spent:
- 0.25h
-
Production code check-in
Harshada Borole (Inactive)
made changes -
| Time Spent | 63.25h [ 227700 ] | 63.5h [ 228600 ] |
| Worklog Id | 32536 [ 32536 ] |
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) |
Harshada Borole (Inactive)
made changes -
| Time Spent | 63.5h [ 228600 ] | 63.75h [ 229500 ] |
| Worklog Id | 32942 [ 32942 ] |
| Status | Local Testing [ 10200 ] | Stage Testing [ 10201 ] |
Hi Harshada Borole,
I have tested this issue on Stage on IE 11,Chrome and firefox browsers. Now when we select all the employee fields except no. of working hours and last login fields then the system is working as per expectation. This is ready for Production.
Thanks,
Venkatesh
| Time Spent | 63.75h [ 229500 ] | 64.25h [ 231300 ] |
| Worklog Id | 32963 [ 32963 ] |
| Item State | Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) | Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) |
| Item State | Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) | Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) |
Harshada Borole (Inactive)
made changes -
| Time Spent | 64.25h [ 231300 ] | 64.5h [ 232200 ] |
| Worklog Id | 33211 [ 33211 ] |
Hi Harshada Borole,
Please could you verify this. I am still getting an error while generating a report for all fields except no. of working hours and login status as there is no last login field on production 3 companies.
Thanks,
Venkatesh
| Item State | Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) | Parent values: Production QA(10203)Level 1 values: Re-open(10220) |
| Status | Stage Testing [ 10201 ] | Production Testing [ 10202 ] |
| Resolution | Unresolved [ 10200 ] | |
| Status | Production Testing [ 10202 ] | Reopen in Production [ 10027 ] |
| Assignee | Venkatesh Pujari [ venkatesh.pujari ] | Harshada Borole [ harshada.borole ] |
-
- Time Spent:
- 0.5h
-
Issue verification on Stage if its working fine
Discussion on how it worked without deployment
| Time Spent | 64.5h [ 232200 ] | 65.5h [ 235800 ] |
| Worklog Id | 33376 [ 33376 ] |
Jyoti Agrawal (Inactive)
made changes -
| Developer | Jyoti Agrawal [ jyoti.agrawal ] |
Jyoti Agrawal (Inactive)
made changes -
| Code Review Date | 27/Mar/2017 |
Below are 3C's :-
Concern :- Error in generating invoice when we select all Employee fields for display fields in production
Cause :- There were discrepancies in fields ID in local and production database.
Correction :- We have remove few fields which were report specific but were not required in invoice. The IDs for these were causing issue.
Removed fields are :-
- Category Name
- Affordable Coverage
- Employee Monthly Average Working Hours
- Employee Stable Working Hours
- Document Name
Note :- We have also Changed the two 'Effective Date' fields that were appearing in Employee Fields. We have renamed them to 'Emergency Contact Effective Date', Employee Effective Date'. This was a new change in WT-7867 for Standard reports, which we have handled in invoice.
Affected Areas :-
1)Create Invoice Template page :-
Above mentioned removed fields will appear no more
Two Effective date fields Changed to respective 'Emergency Contact Effective Date' and 'Employee Effective Date'. Effective dates will appear with deployment of WT-7867.
2)Generation of invoice
3)Download of excel file
Affected DB Files :-
OES_UDF_GetBenefitInvoiceMappingFields
OES_SP_Get_EmployeeFieldsForReports
OES_SP_GetInvoiceMappingFields
Tested below scenarios :-
1) Fields 'Category Name,Affordable Coverage,Employee Monthly Average Working Hours,Employee Stable Working Hours,Document Name' do not appear for selection
2) Two Effective date fields renamed to respective 'Emergency Contact Effective Date' and 'Employee Effective Date'
3) Invoice generation by selecting all fields excluding 'No of working hours per day' and 'Last Login Date'.
4) If above change is affecting existing Invoice template in BCC companies
5) Download Excel file for Invoice
Jyoti Agrawal (Inactive)
added a comment - Below are 3C's :-
Concern :- Error in generating invoice when we select all Employee fields for display fields in production
Cause :- There were discrepancies in fields ID in local and production database.
Correction :- We have remove few fields which were report specific but were not required in invoice. The IDs for these were causing issue.
Removed fields are :-
Category Name
Affordable Coverage
Employee Monthly Average Working Hours
Employee Stable Working Hours
Document Name
Note :- We have also Changed the two 'Effective Date' fields that were appearing in Employee Fields. We have renamed them to 'Emergency Contact Effective Date', Employee Effective Date'. This was a new change in WT-7867 for Standard reports, which we have handled in invoice.
Affected Areas :-
1)Create Invoice Template page :-
Above mentioned removed fields will appear no more
Two Effective date fields Changed to respective 'Emergency Contact Effective Date' and 'Employee Effective Date'. Effective dates will appear with deployment of WT-7867 .
2)Generation of invoice
3)Download of excel file
Affected DB Files :-
OES_UDF_GetBenefitInvoiceMappingFields
OES_SP_Get_EmployeeFieldsForReports
OES_SP_GetInvoiceMappingFields
Tested below scenarios :-
1) Fields 'Category Name,Affordable Coverage,Employee Monthly Average Working Hours,Employee Stable Working Hours,Document Name' do not appear for selection
2) Two Effective date fields renamed to respective 'Emergency Contact Effective Date' and 'Employee Effective Date'
3) Invoice generation by selecting all fields excluding 'No of working hours per day' and 'Last Login Date'.
4) If above change is affecting existing Invoice template in BCC companies
5) Download Excel file for Invoice Jyoti Agrawal (Inactive)
made changes -
| Assignee | Harshada Borole [ harshada.borole ] | Jyoti Agrawal [ jyoti.agrawal ] |
Jyoti Agrawal (Inactive)
made changes -
| Item State | Parent values: Production QA(10203)Level 1 values: Re-open(10220) | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) |
Jyoti Agrawal (Inactive)
made changes -
| Assignee | Jyoti Agrawal [ jyoti.agrawal ] | Venkatesh Pujari [ venkatesh.pujari ] |
Jyoti Agrawal (Inactive)
logged work - 27/Mar/17 01:47 PM -
- Time Spent:
- 5h
-
Coding, testing, patch creation for code review, ticket updation
Jyoti Agrawal (Inactive)
made changes -
| Time Spent | 65.5h [ 235800 ] | 70.5h [ 253800 ] |
| Worklog Id | 34023 [ 34023 ] |
-
- Time Spent:
- 0.75h
-
Code review and discussion on changes done
| Time Spent | 70.5h [ 253800 ] | 70.75h [ 254700 ] |
| Worklog Id | 34275 [ 34275 ] |
| Status | Reopen in Production [ 10027 ] | In Development [ 10007 ] |
| Status | In Development [ 10007 ] | Local Testing [ 10200 ] |
| Item State | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) | Parent values: LB QA(10201)Level 1 values: In Testing(10210) |
Hi Jyoti Agrawal,
Tested this on LB on Caiso company. Working fine as expected. Ready for stage
Thanks,
Venkatesh
| 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) |
| Time Spent | 70.75h [ 254700 ] | 71.25h [ 256500 ] |
| Worklog Id | 34292 [ 34292 ] |
| Time Spent | 71.25h [ 256500 ] | 72h [ 259200 ] |
| Worklog Id | 35373 [ 35373 ] |
| Time Spent | 72h [ 259200 ] | 72.5h [ 261000 ] |
| Worklog Id | 35423 [ 35423 ] |
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) |
Hi Jyoti Agrawal,
Tested this on Stage on Austin For Hspl company.I have tested this issue on Stage on IE 11,Chrome and firefox browsers. Now when we select all the employee fields except no. of working hours and last login fields then the system is working as per expectation.
Ready for Production
Thanks,
Venkatesh
| Item State | Parent values: Stage QA(10202)Level 1 values: In Testing(10214) | Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) |
| Time Spent | 72.5h [ 261000 ] | 73.5h [ 264600 ] |
| Worklog Id | 35717 [ 35717 ] |
Jyoti Agrawal (Inactive)
made changes -
| Time Spent | 73.5h [ 264600 ] | 73.75h [ 265500 ] |
| Worklog Id | 35865 [ 35865 ] |
| Item State | Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) | Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) |
| Status | Stage Testing [ 10201 ] | Production Testing [ 10202 ] |
| Item State | Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) | Parent values: Production QA(10203)Level 1 values: In Testing(10218) |
Hi Jyoti Agrawal,
Tested this on Production on Austin For Hspl company.I have tested this issue on Stage on IE 11,Chrome and firefox browsers. Now when we select all the employee fields except no. of working hours and last login fields then the system is working as per expectation.
Thanks,
Venkatesh
| Resolution | Unresolved [ 10200 ] | Fixed [ 1 ] |
| Status | Production Testing [ 10202 ] | Production Complete [ 10028 ] |
| Item State | Parent values: Production QA(10203)Level 1 values: In Testing(10218) | Parent values: Production Complete(10222)Level 1 values: Closed(10223) |
| Status | Production Complete [ 10028 ] | Closed [ 6 ] |
| Time Spent | 73.75h [ 265500 ] | 74.75h [ 269100 ] |
| Worklog Id | 35921 [ 35921 ] |
Jyoti Agrawal (Inactive)
logged work - 04/Apr/17 05:20 PM -
- Time Spent:
- 0.25h
-
Production code check-in
| Environment_New | LB [ 18444 ] |
| Transition | Time In Source Status | Execution Times |
|---|
Harshada Borole (Inactive)
made transition
-
|
80d 23h 29m | 1 |
|
4s | 1 |
|
5d 20h 16m | 1 |
|
14d 4h 33m | 2 |
|
7d 52m | 2 |
|
2d 58m | 2 |
|
22m 38s | 1 |
|
14s | 1 |
This error appears when benefit field is selected at the top. We have provided proper validation for that as to select Employee fields at the top.
But when all fields are selected using moveall button, benefit fields goes to the top and employee fields appears at the bottom. To resolve this issue we need more time for analysis.
CC:Jyoti Agrawal, Prasanna Karlekar