-
Type:
Bug
-
Status: Production Complete
-
Priority:
High
-
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
- ASML
- created an template and generated invoice for month of November 2016 [please find attached screens shot for detail customization]
- tried downloading the invoice in excel
Excel file got downloaded - when tried to open - got an error
CC - Deepali Tidke Hrishikesh Deshpande Venkatesh Pujari Rakesh Roy
| Remaining Estimate | 28h [ 100800 ] | |
| Original Estimate | 28h [ 100800 ] |
| Remaining Estimate | 28h [ 100800 ] | 27.5h [ 99000 ] |
| Time Spent | 0.5h [ 1800 ] | |
| Worklog Id | 10620 [ 10620 ] |
-
- Time Spent:
- 7h
-
Root analysis and code fix.
-
- Time Spent:
- 7h
-
Root analysis and code fix.
-
- Time Spent:
- 7h
-
analysis and root cause finding and code fix.
3C
Concern:Input / Output Error on-while opening excel file after downloading invoice.
Cause: The code was not robust enough to handle large count of column and data.
Correction: Re coded the logic.
Difference with previous and current code: In the excel the company information , Data header and the adjustment area are now bold only there will be no background fill for this. This also apply in case viewing discrepancy Report in downloaded excel.
We are working on it. However it is not blocking the functionality to see data.
#WT-6335 is got also fixed in the same code.
| Remaining Estimate | 27.5h [ 99000 ] | 0h [ 0 ] |
| Time Spent | 0.5h [ 1800 ] | 34.5h [ 124200 ] |
| Worklog Id | 11309 [ 11309 ] |
| Assignee | Prasanna Karlekar [ prasanna ] | Aditya Vishwakarma [ aditya.vishwakarma ] |
| Item State | Parent values: LB QA(10201) |
| Assignee | Aditya Vishwakarma [ aditya.vishwakarma ] | Alankar Chavan [ alankar.chavan ] |
-
- Time Spent:
- 0.5h
-
Discussion on having few fields in bold with new implementation for export to excel.
| Time Spent | 34.5h [ 124200 ] | 35h [ 126000 ] |
| Worklog Id | 11362 [ 11362 ] |
| Item State | Parent values: LB QA(10201) | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) |
| Time Spent | 35h [ 126000 ] | 35.25h [ 126900 ] |
| Worklog Id | 11374 [ 11374 ] |
Verified this on LB environment .
Exported invoice by selecting all plans and all classes employee.
File is exported Properly on
1]Generate and view Invoice
2]View finalizes Invoice.
Column Header is showing Properly.
Not getting any error
| Original Estimate | 28h [ 100800 ] | 2h [ 7200 ] |
| Time Spent | 35.25h [ 126900 ] | 37.25h [ 134100 ] |
| Worklog Id | 11385 [ 11385 ] |
But one issue is fount to download excel mention in jira:WT-6335
| Item State | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) | Parent values: LB QA(10201)Level 1 values: In Testing(10210) |
| Time Spent | 37.25h [ 134100 ] | 39.25h [ 141300 ] |
| Worklog Id | 11386 [ 11386 ] |
| Description |
* ASML * created an template and generated invoice for month of November 2016 [please find attached screens hot for detail customization] * tried downloading the invoice in excel Excel file got downloaded - when tried to open - got an error CC - [~deepalit] [~hrishikesh.deshpande] [~venkatesh.pujari] [~rakeshr] |
* ASML * created an template and generated invoice for month of November 2016 [please find attached screens shot for detail customization] * tried downloading the invoice in excel Excel file got downloaded - when tried to open - got an error CC - [~deepalit] [~hrishikesh.deshpande] [~venkatesh.pujari] [~rakeshr] |
| Remaining Estimate | 0h [ 0 ] | 27h [ 97200 ] |
| Time Spent | 39.25h [ 141300 ] | 12.25h [ 44100 ] |
| Worklog Id | 11309 [ 11309 ] |
| Remaining Estimate | 27h [ 97200 ] | 20h [ 72000 ] |
| Time Spent | 12.25h [ 44100 ] | 19.25h [ 69300 ] |
| Worklog Id | 11514 [ 11514 ] |
| Remaining Estimate | 20h [ 72000 ] | 13h [ 46800 ] |
| Time Spent | 19.25h [ 69300 ] | 26.25h [ 94500 ] |
| Worklog Id | 11515 [ 11515 ] |
| Remaining Estimate | 13h [ 46800 ] | 6h [ 21600 ] |
| Time Spent | 26.25h [ 94500 ] | 33.25h [ 119700 ] |
| Worklog Id | 11516 [ 11516 ] |
-
- Time Spent:
- 7h
-
Root analysis and code fix.
| Remaining Estimate | 6h [ 21600 ] | 0h [ 0 ] |
| Time Spent | 33.25h [ 119700 ] | 40.25h [ 144900 ] |
| Worklog Id | 11518 [ 11518 ] |
Khandu Kshirsagar (Inactive)
made changes -
| Item State | Parent values: LB QA(10201)Level 1 values: In Testing(10210) | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) |
Verified this on LB environment .
Exported invoice by selecting all plans and all classes employee.
File is exported Properly on
1]Generate and view Invoice
2]View finalizes Invoice.
3]View discrepancy
Column Header is showing Properly.
Working fine as expected
| Original Estimate | 2h [ 7200 ] | 4h [ 14400 ] |
| Item State | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) | Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) |
| Time Spent | 40.25h [ 144900 ] | 42.25h [ 152100 ] |
| Worklog Id | 11614 [ 11614 ] |
-
- Time Spent:
- 1h
-
Check in code for stage
| Time Spent | 42.25h [ 152100 ] | 43.25h [ 155700 ] |
| Worklog Id | 11685 [ 11685 ] |
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) |
| Assignee | Alankar Chavan [ alankar.chavan ] | Aditya Vishwakarma [ aditya.vishwakarma ] |
| Assignee | Aditya Vishwakarma [ aditya.vishwakarma ] | Alankar Chavan [ alankar.chavan ] |
| Worklog Id | 11685 [ 11685 ] |
-
- Time Spent:
- 0.5h
-
Discussion on code changes done and pending items related to Discrepancy.
| Time Spent | 43.25h [ 155700 ] | 43.75h [ 157500 ] |
| Worklog Id | 11782 [ 11782 ] |
Khandu Kshirsagar (Inactive)
made changes -
| Item State | Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) |
Verified on Lb Environment.
Discrepancy Excel exported in single tab and also it showing in proper color coding format for ADD, Update and Delete.
Working fine as expected.
| Item State | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) | Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) |
| Time Spent | 43.75h [ 157500 ] | 44.75h [ 161100 ] |
| Worklog Id | 12644 [ 12644 ] |
| Status | Open [ 1 ] | In Development [ 10007 ] |
| Status | In Development [ 10007 ] | Local Testing [ 10200 ] |
| Developer | Aditya Vishwakarma [ aditya.vishwakarma ] |
Hello Aditya Vishwakarma,
We tried testing few more scenarios and those did not work properly -
Made a template for all classes and all plans.
1. added a new employee and enrolled him in a Medical Plan eff from 01/01/2017
2. fetched out invoices for Dec 2016 and Jan 2017
Expected Result : the newly added enrollment for my test employee should have been showed with a Green color
Actual Result : there was just a single entry with no color
1. the above employee was auto enrolled in STD plan (plan mentioned termination date is 12/31/216)
2. fetched out invoices for Dec 2016 and Jan 2017
Expected Result : the existing STD enrollment for my test employee should have been showed with a Red color as it was present in Dec 2016 invoice but absent in Jan 2017 invoice
Actual Result : there was just a single entry with no color
1. took an existing employee
2. enrolled in a new plan from 01/01/2017 - in which he was not enrolled ever
3. fetched out invoices for Dec 2016 and Jan 2017
Expected Result : the newly added enrollment for my employee should have been showed with a Green color as it was not present in Dec 2016 invoice but present in Jan 2017 invoice
Actual Result : there was just a single entry with no color
If these are issues - please let us know when we can expect it's fix/
Or else please let me know if we are making any mistake in understanding the discrepancy scenarios
CC - Rakesh Roy Deepali Tidke Hrishikesh Deshpande Venkatesh Pujari Prasanna Karlekar
| Item State | Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) | Parent values: LB QA(10201)Level 1 values: Re-open(10212) |
| Status | Local Testing [ 10200 ] | Reopen in Local [ 10018 ] |
| Assignee | Alankar Chavan [ alankar.chavan ] | Aditya Vishwakarma [ aditya.vishwakarma ] |
Closing this
Please refer WT-7146 for the problems in Discrepancy Report
Other than this - all errors mentioned above are fixed till production
| Item State | Parent values: LB QA(10201)Level 1 values: Re-open(10212) | Parent values: Production Complete(10222)Level 1 values: Closed(10223) |
| Status | Reopen in Local [ 10018 ] | In Development [ 10007 ] |
| Status | In Development [ 10007 ] | Local Testing [ 10200 ] |
| Status | Local Testing [ 10200 ] | Reopen in Local [ 10018 ] |
| Status | Reopen in Local [ 10018 ] | In Development [ 10007 ] |
| Status | In Development [ 10007 ] | Local Testing [ 10200 ] |
| Status | Local Testing [ 10200 ] | Stage Testing [ 10201 ] |
| Status | Stage Testing [ 10201 ] | Production Testing [ 10202 ] |
| Resolution | Fixed [ 1 ] | |
| Status | Production Testing [ 10202 ] | Production Complete [ 10028 ] |
| Time Spent | 44.75h [ 161100 ] | 45.75h [ 164700 ] |
| Worklog Id | 13067 [ 13067 ] |
| Original Estimate | 4h [ 14400 ] | 45.75h [ 164700 ] |
| Worklog Id | 12644 [ 12644 ] |
| Time Spent | 45.75h [ 164700 ] | 46.75h [ 168300 ] |
| Worklog Id | 12644 [ 12644 ] |
| Environment_New | LB [ 18444 ] |
| Transition | Time In Source Status | Execution Times |
|---|
|
27d 19h 3m | 1 |
|
1d 23m | 2 |
|
4h 57m | 2 |
|
8s | 3 |
|
2s | 1 |
|
2s | 1 |
|
5s | 1 |
Issue analysis