-
Type:
Bug
-
Status: Closed
-
Priority:
Medium
-
Resolution: Bug Fixed
-
Labels:
-
Environment:Stage
-
Categories:Report
-
Company:Softchoice
-
Reported by:Support
-
Level:Admin
ErrorID : 0
ErrorSource : ControllerAppTier.SaveAndGetData->BenAdminControllerAppTier.SaveAndGetData->StaticReports.SaveAndGetData->AdminUser.GetData->EligibilityReason.FetchEmployeePlanEligibility->EligibilityReason.FetchEligibleEmployeeForReport
ErrorMessage: Invalid object name 'AdminUserClass1'.
StackTrace: at WORKTERRA.BenAdmin.BenAdminControllerAppTier.SaveAndGetData(BenAdminControllerWebTierEntity objBenAdminControllerWebTierEntity)
We will be working on this issue in Sprint-40, starting from 23-Oct-2017.
Thank you!
cc: Gaurav Sodani
Below are the 3C's:
Concern:- Server error on Employee plan eligibility report
Cause:- Incorrect database connection string was formed.
Connection string was pointing to OnlineEnrollment database instead of Company database.
Database query for Company Admin included 'AdminUserClass' tables. These tables are present in Company DB. The query was getting executed in OnlineEnrollment and could not find 'AdminUserClass' tables.
Correction:- Corrected the connection string, pointing to Company Database
Files affected:-
EligibilityReason.vb
Affected Area:-
Employee Plan Eligibility Report.
Tested Scenario's:- Tested for Admin login and Company Admin.
Harshada Borole (Inactive)
added a comment - Below are the 3C's:
Concern:- Server error on Employee plan eligibility report
Cause:- Incorrect database connection string was formed.
Connection string was pointing to OnlineEnrollment database instead of Company database.
Database query for Company Admin included 'AdminUserClass' tables. These tables are present in Company DB. The query was getting executed in OnlineEnrollment and could not find 'AdminUserClass' tables.
Correction:- Corrected the connection string, pointing to Company Database
Files affected:-
EligibilityReason.vb
Affected Area:-
Employee Plan Eligibility Report.
Tested Scenario's:- Tested for Admin login and Company Admin. Verified above issue on LB through Admin and Partner Login with combination of Some Classes , Some Benefit Type and Plan and All Classes , All Benefit Types.
Working Fine
CC - Sachin Hingole
Harshada Borole
IS this fixed in new UI as well?
Nidhi Kaul (Inactive)
added a comment - Harshada Borole
IS this fixed in new UI as well? Hi Nidhi Kaul,
We haven't deployed the changes in new UI as it is on LB Hold.
We will deploy it once it is ready for stage.
Harshada Borole (Inactive)
added a comment - Hi Nidhi Kaul ,
We haven't deployed the changes in new UI as it is on LB Hold.
We will deploy it once it is ready for stage.
cc: Jyoti Agrawal , Prasanna Karlekar Rakesh Roy
I guess this issue was raised by UAT group while testing UI refresh. Shouldn't it be created in NF?
Nidhi.
Nidhi Kaul (Inactive)
added a comment - Rakesh Roy
I guess this issue was raised by UAT group while testing UI refresh. Shouldn't it be created in NF?
Nidhi. Nidhi Kaul This issue was on stage as well, that's why created WT ticket.
This is fixed on production.
We will be taking this in Sprint-41 starting from 6-Nov-2017.
Thank you!
cc: Gaurav Sodani