-
Type:
Bug
-
Status: Production Complete
-
Priority:
Medium
-
Resolution: Done
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: BenAdmin
-
Labels:None
-
Environment:QA
-
Bug Type:Functional
-
Bug Severity:Critical
-
Level:Partner
-
Module:BenAdmin - Report
-
Reported by:Harbinger
-
Item State:Production Complete - Closed
-
Browser:Google Chrome
-
Sprint:WT Sprint 32-Bugs
Replication Steps :
1) SA Login
2) Navigate to Global level Standard Report
3) Add new Report
4) Create New Report
5) Ran Report then it throws server error
Issue : Same issue exist on EXCEL , PDF, HTML and Download files button.
Error Log :
ErrorID : 0
ErrorSource : ControllerAppTier.GetData->BenAdminControllerAppTier.GetData->ReportDetails.GetData->ReportDetails.GetDataForCaseAndComponent
ErrorMessage: Invalid column name 'TransactionTypeID'.
Invalid column name 'GroupBenefitsYesNoID'.
Invalid column name 'LoginStatusOfUsersID'.
Invalid column name 'ShowTerminatedRecordsID'.
Invalid column name 'GroupBenefits'.
Invalid column name 'EmployeeName'.
Invalid column name 'IsApplyDemoGraphicsHistory'.
- relates to
-
WT-129 Ability to run an enrollment report across all companies
-
- Production Complete
-
Parmeshwar Jumbad (Inactive)
logged work - 10/Jul/17 12:56 PM -
- Time Spent:
- 0.75h
-
Discussion with QA
Check issue on local environment and discussion
Parmeshwar Jumbad (Inactive)
made changes -
| Remaining Estimate | 0h [ 0 ] | |
| Time Spent | 0.75h [ 2700 ] | |
| Worklog Id | 62072 [ 62072 ] |
Parmeshwar Jumbad (Inactive)
made changes -
| Item State | Parent values: Development(10200)Level 1 values: Ready for Review(10208) | |
| Original Estimate | 0h [ 0 ] |
Parmeshwar Jumbad (Inactive)
made changes -
| Developer | Parmeshwar Jumbad [ parmeshwar.jumbade ] |
3C's:
Concern: Global Report - Standard Report - Server error on Report
Cause: One file remains while merging code
Correction: Missing code file merged.
Description: This issue came due to while merging changes file were not properly merged.
Affected Areas: Global Reports and Reports
*Affected Files: *
StandardReportsModel.cs
*Tested Scenarios: *
1. Verified preview report
2. Checked PDF, HTML, EXCEL action for global level report
3. Checked Run functionality.
Note: i have checked download functionality, Exception not appear on screen but getting in console related to JS. But Download file button not available to company level reports so need to check what actually happens on it.
Parmeshwar Jumbad (Inactive)
added a comment - - edited 3C's:
Concern: Global Report - Standard Report - Server error on Report
Cause: One file remains while merging code
Correction: Missing code file merged.
Description: This issue came due to while merging changes file were not properly merged.
Affected Areas: Global Reports and Reports
*Affected Files: *
StandardReportsModel.cs
*Tested Scenarios: *
1. Verified preview report
2. Checked PDF, HTML, EXCEL action for global level report
3. Checked Run functionality.
Note: i have checked download functionality, Exception not appear on screen but getting in console related to JS. But Download file button not available to company level reports so need to check what actually happens on it.
CC: Prasanna Karlekar Parmeshwar Jumbad (Inactive)
made changes -
| Code Review Date | 11/Jul/2017 | |
| Code Reviewed By | Prasanna Karlekar [ 11907 ] |
| Status | Open [ 1 ] | In Development [ 10007 ] |
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 -
| Item State | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) | Parent values: LB QA(10201)Level 1 values: On Hold(10211) |
Parmeshwar Jumbad (Inactive)
logged work - 11/Jul/17 12:49 PM -
- Time Spent:
- 2.5h
-
1. Find out Problem
2. Discussion and Merge code change
3. Verify reports on LB, Local
Parmeshwar Jumbad (Inactive)
made changes -
| Time Spent | 0.75h [ 2700 ] | 3.25h [ 11700 ] |
| Worklog Id | 62406 [ 62406 ] |
| Item State | Parent values: LB QA(10201)Level 1 values: On Hold(10211) | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) |
On LB one column not available so it will not work.
Parmeshwar Jumbad (Inactive)
added a comment - On LB one column not available so it will not work. Parmeshwar Jumbad (Inactive)
made changes -
| Item State | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) | Parent values: LB QA(10201)Level 1 values: On Hold(10211) |
| Item State | Parent values: LB QA(10201)Level 1 values: On Hold(10211) | Parent values: Development(10200)Level 1 values: Ready for Review(10208) |
Gaurav Sodani (Inactive)
made changes -
| Sprint | WT Sprint 32-Bugs [ 76 ] |
| Item State | Parent values: Development(10200)Level 1 values: Ready for Review(10208) | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) |
While working on this issue found that all bubble values were read hard-coded so made some changes to read it from based on configuration.
Affected Areas: Global level standard reports
Affected Files:
\Database Objects\OnlineEnrollment\01_DDL\138_WT-10074_WTB_Report_ModTable_ReportDetails.sql
\Database Objects\OnlineEnrollment\04_Stored Procedures\dbo.OES_SP_Report_GetGlobalLevelSavedReport.StoredProcedure.sql
Tested scenarios:
1. Verified existing reports Edit and Run functionality.
2. Check bubbles are showing on screen based on the configurations.
Parmeshwar Jumbad (Inactive)
added a comment - While working on this issue found that all bubble values were read hard-coded so made some changes to read it from based on configuration.
Affected Areas : Global level standard reports
Affected Files :
\Database Objects\OnlineEnrollment\01_DDL\138_ WT-10074 _WTB_Report_ModTable_ReportDetails.sql
\Database Objects\OnlineEnrollment\04_Stored Procedures\dbo.OES_SP_Report_GetGlobalLevelSavedReport.StoredProcedure.sql
Tested scenarios :
1. Verified existing reports Edit and Run functionality.
2. Check bubbles are showing on screen based on the configurations. Gaurav Sodani (Inactive)
made changes -
| Status | In Development [ 10007 ] | Local Testing [ 10200 ] |
Parmeshwar Jumbad (Inactive)
made changes -
| Assignee | Parmeshwar Jumbad [ parmeshwar.jumbade ] | Sachin Hingole [ sachin.hingole ] |
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 -
| Assignee | Sachin Hingole [ sachin.hingole ] | Meghana Joshi [ meghana.kulkarni ] |
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) |
Testing is not started yet on LB due to other highest priority issue WT-3377 and WT-10102
CC - Sachin Hingole
| Production Due Date | 10/Aug/2017 | |
| Stage Due Date | 7/Aug/17 [ 2017-08-07 ] |
| Item State | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) | Parent values: LB QA(10201)Level 1 values: In Testing(10210) |
| Item State | Parent values: LB QA(10201)Level 1 values: In Testing(10210) | Parent values: LB QA(10201)Level 1 values: On Hold(10211) |
Verified on LB.
Working Fine.
Will update testing status one's main enhancement WT-129 is completed on LB
CC - Sachin Hingole
| Production Due Date | 10/Aug/2017 | 15/Aug/2017 |
| Stage Due Date | 7/Aug/17 [ 2017-08-07 ] | 9/Aug/17 [ 2017-08-09 ] |
| Production Due Date | 15/Aug/2017 | 16/Aug/2017 |
| Production Due Date | 16/Aug/2017 | 18/Aug/2017 |
| Stage Due Date | 9/Aug/17 [ 2017-08-09 ] | 14/Aug/17 [ 2017-08-14 ] |
| Production Due Date | 18/Aug/2017 | 24/Aug/2017 |
| Stage Due Date | 14/Aug/17 [ 2017-08-14 ] | 17/Aug/17 [ 2017-08-17 ] |
| QA | Meghana Joshi [ meghana.kulkarni ] |
Ready for Stage
CC - Sachin Hingole
| 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) |
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) |
| Item State | Parent values: Stage QA(10202)Level 1 values: In Testing(10214) | Parent values: Stage QA(10202)Level 1 values: On Hold(10215) |
Verified on Stage.
Working Fine.
Will update testing status one's main enhancement WT-129 Stage Testing is completed on Stage
CC - Sachin Hingole
| Time Spent | 3.25h [ 11700 ] | 3.75h [ 13500 ] |
| Worklog Id | 73021 [ 73021 ] |
| Code Review Date | 11/Jul/2017 | 11/Jul/2017 |
| Production Due Date | 24/Aug/2017 | 29/Aug/2017 |
| Stage Due Date | 17/Aug/17 [ 2017-08-17 ] | 17/Aug/17 [ 2017-08-17 ] |
-
- Time Spent:
- 0.25h
-
Issue fix verification on Azure
| Production Due Date | 29/Aug/2017 |
| Time Spent | 3.75h [ 13500 ] | 4h [ 14400 ] |
| Worklog Id | 75518 [ 75518 ] |
As discussed with Prasanna Karlekar and [~parmeshwar.jumbade] , All Enhancement WT-129, WT-9377 and WT-9223 move at same time on Production. So, We will move all enhancement on 09/19/2017
CC - Sachin Hingole
| Production Due Date | 19/Sep/2017 |
| Item State | Parent values: Stage QA(10202)Level 1 values: On Hold(10215) | Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) |
Khandu Kshirsagar (Inactive)
made changes -
| 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) |
| Time Spent | 4h [ 14400 ] | 5h [ 18000 ] |
| Worklog Id | 80219 [ 80219 ] |
Verified on Production.
Working Fine
| Resolution | 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) |
| Environment_New | LB [ 18444 ] |
| Transition | Time In Source Status | Execution Times |
|---|
|
1d 48m | 1 |
Gaurav Sodani (Inactive)
made transition
-
|
6d 20h 55m | 1 |
|
33d 22h 57m | 1 |
|
30d 6h 2m | 1 |
|
21h 56m | 1 |
While run report on LB generated query executing on OnlineEnrollment DB and those columns are not available on it. Need to check code on LB for this.