-
Type:
Bug
-
Status: Production Complete
-
Priority:
Medium
-
Resolution: Done
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: BenAdmin
-
Labels:
-
Environment:Production
-
Bug Type:Functional
-
Bug Severity:Medium
-
Level:Partner
-
Module:BenAdmin - Report
-
Reported by:Harbinger
-
Company:EHMC
-
Item State:Production Complete - Closed
Check preview for 10/1/2017 to 10/312017--Server error
Error log--
ErrorID : 0
ErrorSource : ControllerAppTier.SaveAndGetData->BenAdminControllerAppTier.SaveAndGetData->StaticReports.SaveAndGetData->OpenEnrollmentChangesReport.GetData->OpenEnrollmentChangesReport.FetchOpenEnrollmentChangesData->OpenEnrollmentChangesReport.FetchEnrollmentAndRatesData
ErrorMessage: Item has already been added. Key in dictionary: '35022~10' Key being added: '35022~10'
StackTrace: at WORKTERRA.BenAdmin.BenAdminControllerAppTier.SaveAndGetData(BenAdminControllerWebTierEntity objBenAdminControllerWebTierEntity)
at WORKTERRA.ControllerAppTier.SaveAndGetData(Int32 intProjectsId, String strInput)
TargetSite: System.String SaveAndGetData(ValueObjects.BenAdminControllerWebTierEntity)
Concern:
Receiving a server error when attempting to preview the OE Changes Report.
Cause:
This company has setting for Classwise Open Enrollment. In system, there is a database table to save Classwise Open Enrollment rules. For this company, it has entries for previous year Open Enrollment also. Employees are eligible for current year as well as previous year rule. Due to which elections with effective date for current as well as previous Open enrollment are getting populated.
Correction:
Now we are considering OE rule which is recently active. We are returning result only for recent active OE rule. Please note that, whenever OE report is executed with Enrollment Opening and Closing Date after OE period ends, it should fetch only the changes that were done between specified OE span.
Affected files:
/MasterCompanyDB/04_Stored Procedures/dbo.OES_SP_Report_GetOEEffectiveDateForAllEmployees.StoredProcedure.sql
/MasterCompanyDB/04_Stored Procedures/dbo.OES_SP_Report_OpenEnrollmentChangesAllBenefits.StoredProcedure.sql
Impacted Areas:
OE report when executed for classwise OE.
Unit tested scenarios:
1. Verified OE changes report with and without classwise OE setting.
2. Verified OE report for class wise OE, after the OE period completion.