-
Type:
Bug
-
Status: Closed
-
Priority:
Medium
-
Resolution: Done
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: BenAdmin
-
Labels:None
-
Environment:Stage
-
Bug Type:Functional
-
Bug Severity:Medium
-
Level:Partner
-
Module:BenAdmin - Report
-
Reported by:Harbinger
-
Item State:Production Complete - Closed
-
Issue Importance:Must Have
Issues :
Randomly, Getting server error on selecting all companies for Global Level Standard Report [ Any Report Type ]
ErrorID : 0
ErrorSource : ControllerAppTier.GetData->BenAdminControllerAppTier.GetData->ReportDetails.GetData->ReportDetails.GetReportListByCompanyIds
ErrorMessage: SQL Server Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF].
StackTrace: at WORKTERRA.BenAdmin.BenAdminControllerAppTier.GetData(BenAdminControllerWebTierEntity objBenAdminControllerWebTierEntity)
at WORKTERRA.ControllerAppTier.GetData(Int32 intProjectsId, String strInput)
TargetSite: System.String GetData(ValueObjects.BenAdminControllerWebTierEntity)
- relates to
-
WT-129 Ability to run an enrollment report across all companies
-
- Production Complete
-
3C's:
Concern: Global Level Standard Reports - Throws Server error on selecting all companies
Cause: Server name not considered before database name while form query. But on stage environment we have different companies database on different servers but it was trying to search database on same server.
Correction: We have added server name while generate query so this will not throw exceptions now.
Tested Scenarios:
1. Select and deselect company functionality for multiple report type.
Affected Files: This resolved under the main enhancement
WT-129.Affected Areas: Global level reports.
Note: Same issue will occur in case of any company is an active but database not available on mentioned server. Already discussed scenario with Ashwin Wankhede and according to them this case will handle at there side.
CC: Prasanna Karlekar Sachin Hingole