-
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
-
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 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. 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. Testing is not started yet on LB due to other highest priority issue WT-3377 and WT-10102
CC - Sachin Hingole
Verified on LB.
Working Fine.
Will update testing status one's main enhancement WT-129 is completed on LB
CC - Sachin Hingole
Ready for Stage
CC - Sachin Hingole
Verified on Stage.
Working Fine.
Will update testing status one's main enhancement WT-129 Stage Testing is completed on Stage
CC - Sachin Hingole
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
Verified on Production.
Working Fine
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.