Uploaded image for project: 'WORKTERRA'
  1. WORKTERRA
  2. WT-10520

ACA_Global level_PCORI report_Received server error when clicked on Preview

    Details

    • 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

      Description

      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)

        Attachments

          Activity

          Hide
          kumar.chhajed Kumar Chhajed (Inactive) added a comment -

          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

          Show
          kumar.chhajed Kumar Chhajed (Inactive) added a comment - 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
          Hide
          smita.pawar 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.

          Show
          smita.pawar 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.
          Hide
          rutuja.chilwar 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.<>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

          Show
          rutuja.chilwar 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
          Hide
          rutuja.chilwar 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

          Show
          rutuja.chilwar 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
          Hide
          rutuja.chilwar Rutuja Chilwar (Inactive) added a comment -

          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

          Show
          rutuja.chilwar Rutuja Chilwar (Inactive) added a comment - 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

            People

            Assignee:
            rutuja.chilwar Rutuja Chilwar (Inactive)
            Reporter:
            smita.pawar Smita Pawar (Inactive)
            Developer:
            Kumar Chhajed (Inactive)
            QA:
            Smita Pawar (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Pre-Prod Due Date:
              Production Due Date:
              Code Review Date:

                Time Tracking

                Estimated:
                Original Estimate - 8h Original Estimate - 8h
                8h
                Remaining:
                Remaining Estimate - 0h
                0h
                Logged:
                Time Spent - 8.5h
                8.5h