-
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)
We are getting server Error when we do not select company , It is working fine after selection of the company , This issue is logged under JIRA WT-11158
Hence marking this ticket to Ready for Production
Rutuja Chilwar (Inactive)
added a comment - We are getting server Error when we do not select company , It is working fine after selection of the company , This issue is logged under JIRA WT-11158
Hence marking this ticket to Ready for Production
CC- Rakesh Roy Sachin Hingole Hi Kumar Chhajed,
Verified this issue, it is reproducible ,
We are getting server error for Preview action
Please find below Error Log:
Exception : Value cannot be null.Parameter name: source
App Error Log : -
Employee ID : 0
Action Name : PCORIReport
Model : System.Web.Mvc.HandleErrorInfo
Controller : ACA
Web Error Log : at System.Linq.Enumerable.Select[TSource,TResult](IEnumerable`1 source, Func`2 selector)
at WORKTERRA.BenAdmin.Areas.ACA.Models.ACAAnalytics.PCORIModel.GetPCORIReport(Boolean IsGlobalLevel)
at WORKTERRA.BenAdmin.Areas.ACA.Controllers.ACAController.PCORIReport(Boolean IsGlobalLevel)
at lambda_method(Closure , ControllerBase , Object[] )
at System.Web.Mvc.ActionMethodDispatcher.Execute(ControllerBase controller, Object[] parameters)
at System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary`2 parameters)
at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters)
at System.Web.Mvc.ControllerActionInvoker.<>c_DisplayClass15.b_12()
at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation)
at System.Web.Mvc.ControllerActionInvoker.<>c_DisplayClass15.<>cDisplayClass17.b_14()
at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation)
at System.Web.Mvc.ControllerActionInvoker.<>c_DisplayClass15.<>cDisplayClass17.b_14()
at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodWithFilters(ControllerContext controllerContext, IList`1 filters, ActionDescriptor actionDescriptor, IDictionary`2 parameters)
at System.Web.Mvc.ControllerActionInvoker.InvokeAction(ControllerContext controllerContext, String actionName)
CC- Rakesh Roy Sachin Hingole Smita Pawar ,
Thanks,
Rutuja
Rutuja Chilwar (Inactive)
added a comment - Hi Kumar Chhajed ,
Verified this issue, it is reproducible ,
We are getting server error for Preview action
Please find below Error Log :
Exception : Value cannot be null.Parameter name: source
App Error Log : -
Employee ID : 0
Action Name : PCORIReport
Model : System.Web.Mvc.HandleErrorInfo
Controller : ACA
Web Error Log : at System.Linq.Enumerable.Select [TSource,TResult] (IEnumerable`1 source, Func`2 selector)
at WORKTERRA.BenAdmin.Areas.ACA.Models.ACAAnalytics.PCORIModel.GetPCORIReport(Boolean IsGlobalLevel)
at WORKTERRA.BenAdmin.Areas.ACA.Controllers.ACAController.PCORIReport(Boolean IsGlobalLevel)
at lambda_method(Closure , ControllerBase , Object[] )
at System.Web.Mvc.ActionMethodDispatcher.Execute(ControllerBase controller, Object[] parameters)
at System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary`2 parameters)
at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters)
at System.Web.Mvc.ControllerActionInvoker.<>c_ DisplayClass15.b _12()
at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation)
at System.Web.Mvc.ControllerActionInvoker.<>c_ DisplayClass15.<>c DisplayClass17.b _14()
at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation)
at System.Web.Mvc.ControllerActionInvoker.<>c_ DisplayClass15.<>c DisplayClass17.b _14()
at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodWithFilters(ControllerContext controllerContext, IList`1 filters, ActionDescriptor actionDescriptor, IDictionary`2 parameters)
at System.Web.Mvc.ControllerActionInvoker.InvokeAction(ControllerContext controllerContext, String actionName)
CC- Rakesh Roy Sachin Hingole Smita Pawar ,
Thanks,
Rutuja We have verified above mentioned issue on LB[Old]. Its working fine.
Tested scenarios are as follows.
1.Save
2.Preview
3.Reset
4.Cancel
5.Back.
Smita Pawar (Inactive)
added a comment - We have verified above mentioned issue on LB [Old] . Its working fine.
Tested scenarios are as follows.
1.Save
2.Preview
3.Reset
4.Cancel
5.Back.
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.
We have verified this point on Production Environment , we acen view report without getting any server error when we click on preview .
Tested scenarios are as follows.
1.Save
2.Preview
3.Reset
4.Cancel
5.Back.
CC- Rakesh Roy Sachin Hingole Smita Pawar