-
Type:
Bug
-
Status: Production Complete
-
Priority:
Medium
-
Resolution: Done
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: ACA
-
Labels:None
-
Environment:Stage
-
Bug Type:Functional
-
Bug Severity:Medium
-
Level:Partner
-
Module:ACA - Reports
-
Reported by:Harbinger
-
Item State:Production Complete - Closed
1.Login to Stage.
2.Navigato to Home >> Benadmin Home >> PCORI report.
3.Add required details.
4.Click on Preview
Actual: Received server error.
Expected: Report should run without error.
Error log is as follows
ErrorID : 0
ErrorSource : ControllerAppTier.GetData->BenAdminControllerAppTier.GetData->PCORIReport.GetData=>PCORIReport.GetGlobalPCORIDetails
ErrorMessage: Invalid object name 'ASML_12017.dbo.Employee'.
Invalid object name 'ASML_12017.dbo.OES_VIEW_Enrollment'.
Invalid object name 'ASML_12017.dbo.OES_VIEW_Enrollment'.
Invalid object name 'ASML_12017.dbo.OES_VIEW_Enrollment'.
StackTrace: at WORKTERRA.BenAdmin.BenAdminControllerAppTier.GetData(BenAdminControllerWebTierEntity objBenAdminControllerWebTierEntity)
at WORKTERRA.ControllerAppTier.GetData(Int32 intProjectsId, String strInput)
TargetSite: System.String GetData(ValueObjects.BenAdminControllerWebTierEntity)
3C's -
Concern - Global level_PCORI report_Received server error when clicked on Preview
Cause - The DB server name was hard-coded in stored procedure used to fetch the data. This was an historic issue.
Correction - Changed the hard-coded DB server name to Fetch DB server name from company table itself.
Thanks,
Kumar Chhajed.
CC Nandkumar Prabhakar Karlekar Smita Pawar