WORKTERRAProject Type: software

WORKTERRA

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

          Ascending order - Click to sort in descending order
          smita.pawar Smita Pawar (Inactive) created issue -
          Permalink
          kumar.chhajed Kumar Chhajed (Inactive) logged work - 09/Aug/17 02:25 PM
          • Time Spent:
            0.5h
             

            Analysis

          kumar.chhajed Kumar Chhajed (Inactive) made changes -
          Field Original Value New Value
          Remaining Estimate 8h [ 28800 ]
          Original Estimate 8h [ 28800 ]
          kumar.chhajed Kumar Chhajed (Inactive) made changes -
          Remaining Estimate 8h [ 28800 ] 7.5h [ 27000 ]
          Time Spent 0.5h [ 1800 ]
          Worklog Id 70590 [ 70590 ]
          kumar.chhajed Kumar Chhajed (Inactive) made changes -
          Status Open [ 1 ] In Development [ 10007 ]
          kumar.chhajed Kumar Chhajed (Inactive) made changes -
          Item State Parent values: Development(10200)Level 1 values: In Analysis(10204)
          kumar.chhajed Kumar Chhajed (Inactive) made changes -
          Item State Parent values: Development(10200)Level 1 values: In Analysis(10204) Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209)
          kumar.chhajed Kumar Chhajed (Inactive) made changes -
          Code Review Date 10/Aug/2017
          Code Reviewed By Nandkumar Karlekar [ 11904 ]
          Hide
          Permalink
          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
          kumar.chhajed Kumar Chhajed (Inactive) made changes -
          Assignee Kumar Chhajed [ kumar.chhajed ] Smita Pawar [ smita.pawar ]
          khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
          Item State Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
          Permalink
          kumar.chhajed Kumar Chhajed (Inactive) logged work - 10/Aug/17 02:02 PM
          • Time Spent:
            4h
             

            Analysis
            Coding
            Unit testing
            Internal discussion
            Code Check-ins

          kumar.chhajed Kumar Chhajed (Inactive) made changes -
          Remaining Estimate 7.5h [ 27000 ] 3.5h [ 12600 ]
          Time Spent 0.5h [ 1800 ] 4.5h [ 16200 ]
          Worklog Id 70935 [ 70935 ]
          smita.pawar Smita Pawar (Inactive) made changes -
          Production Due Date 31/Aug/2017
          Stage Due Date 28/Aug/17 [ 2017-08-28 ]
          smita.pawar Smita Pawar (Inactive) made changes -
          Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: In Testing(10210)
          Permalink
          smita.pawar Smita Pawar (Inactive) logged work - 23/Aug/17 01:46 PM
          • Time Spent:
            1.25h
             

            Internal discussion
            LB testing
            Azure testing

          Hide
          Permalink
          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.
          smita.pawar Smita Pawar (Inactive) made changes -
          Remaining Estimate 3.5h [ 12600 ] 2.25h [ 8100 ]
          Time Spent 4.5h [ 16200 ] 5.75h [ 20700 ]
          Worklog Id 73881 [ 73881 ]
          Permalink
          kumar.chhajed Kumar Chhajed (Inactive) logged work - 23/Aug/17 02:35 PM
          • Time Spent:
            1h
             

            Internal discussion with QA

          kumar.chhajed Kumar Chhajed (Inactive) made changes -
          Remaining Estimate 2.25h [ 8100 ] 1.25h [ 4500 ]
          Time Spent 5.75h [ 20700 ] 6.75h [ 24300 ]
          Worklog Id 73900 [ 73900 ]
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Status In Development [ 10007 ] Local Testing [ 10200 ]
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Item State Parent values: LB QA(10201)Level 1 values: In Testing(10210) Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Stage Due Date 28/Aug/17 [ 2017-08-28 ] 18/Sep/17 [ 2017-09-18 ]
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Production Due Date 31/Aug/2017 19/Sep/2017
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Assignee Smita Pawar [ smita.pawar ] Rutuja Chilwar [ rutuja.chilwar ]
          Permalink
          rutuja.chilwar Rutuja Chilwar (Inactive) logged work - 16/Sep/17 04:39 AM
          • Time Spent:
            0.5h
             
            <No comment>
          rakeshr Rakesh Roy (Inactive) made changes -
          Code Review Date 10/Aug/2017 10/Aug/2017
          Developer Kumar Chhajed [ kumar.chhajed ]
          khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
          Item State Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)
          rutuja.chilwar Rutuja Chilwar (Inactive) made changes -
          Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) Parent values: Stage QA(10202)Level 1 values: In Testing(10214)
          Hide
          Permalink
          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
          rutuja.chilwar Rutuja Chilwar (Inactive) made changes -
          Status Local Testing [ 10200 ] Reopen in Local [ 10018 ]
          rutuja.chilwar Rutuja Chilwar (Inactive) made changes -
          Assignee Rutuja Chilwar [ rutuja.chilwar ] Kumar Chhajed [ kumar.chhajed ]
          rutuja.chilwar Rutuja Chilwar (Inactive) made changes -
          Item State Parent values: Stage QA(10202)Level 1 values: In Testing(10214) Parent values: Stage QA(10202)Level 1 values: Re-open(10216)
          Hide
          Permalink
          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
          rutuja.chilwar Rutuja Chilwar (Inactive) made changes -
          Item State Parent values: Stage QA(10202)Level 1 values: Re-open(10216) Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)
          kumar.chhajed Kumar Chhajed (Inactive) made changes -
          Assignee Kumar Chhajed [ kumar.chhajed ] Rutuja Chilwar [ rutuja.chilwar ]
          rutuja.chilwar Rutuja Chilwar (Inactive) made changes -
          Status Reopen in Local [ 10018 ] In Development [ 10007 ]
          rutuja.chilwar Rutuja Chilwar (Inactive) made changes -
          Status In Development [ 10007 ] Local Testing [ 10200 ]
          rutuja.chilwar Rutuja Chilwar (Inactive) made changes -
          Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
          Permalink
          rutuja.chilwar Rutuja Chilwar (Inactive) logged work - 19/Sep/17 04:28 AM - edited
          • Time Spent:
            0.75h
             
            <No comment>
          rutuja.chilwar Rutuja Chilwar (Inactive) made changes -
          Remaining Estimate 1.25h [ 4500 ] 0.25h [ 900 ]
          Time Spent 6.75h [ 24300 ] 7.75h [ 27900 ]
          Worklog Id 79366 [ 79366 ]
          rutuja.chilwar Rutuja Chilwar (Inactive) made changes -
          Remaining Estimate 0.25h [ 900 ] 0.5h [ 1800 ]
          Time Spent 7.75h [ 27900 ] 7.5h [ 27000 ]
          Worklog Id 79366 [ 79366 ]
          khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
          Item State Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) Parent values: Production QA(10203)Level 1 values: Production Deployed(10221)
          rutuja.chilwar Rutuja Chilwar (Inactive) made changes -
          Attachment WT-10520_done_prod.png [ 61906 ]
          rutuja.chilwar Rutuja Chilwar (Inactive) made changes -
          Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
          rutuja.chilwar Rutuja Chilwar (Inactive) made changes -
          Item State Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) Parent values: Production Complete(10222)Level 1 values: Closed(10223)
          rutuja.chilwar Rutuja Chilwar (Inactive) made changes -
          Resolution Fixed [ 1 ]
          Status Production Testing [ 10202 ] Production Complete [ 10028 ]
          Hide
          Permalink
          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
          Permalink
          rutuja.chilwar Rutuja Chilwar (Inactive) logged work - 19/Sep/17 09:13 AM
          • Time Spent:
            0.5h
             

            verified & updated issue

          rutuja.chilwar Rutuja Chilwar (Inactive) made changes -
          Remaining Estimate 0.5h [ 1800 ] 0h [ 0 ]
          Time Spent 7.5h [ 27000 ] 8h [ 28800 ]
          Worklog Id 79623 [ 79623 ]
          rutuja.chilwar Rutuja Chilwar (Inactive) made changes -
          Time Spent 8h [ 28800 ] 8.5h [ 30600 ]
          Worklog Id 80071 [ 80071 ]
          satyap Satya made changes -
          Environment_New Stage [ 18443 ]
          Transition Time In Source Status Execution Times
          Kumar Chhajed (Inactive) made transition -
          Open In Development
          		18h 50m 1
          Rutuja Chilwar (Inactive) made transition -
          In LB Testing Reopen in Local
          		3d 20h 31m 1
          Rutuja Chilwar (Inactive) made transition -
          Reopen in Local In Development
          		2h 24m 1
          Rutuja Chilwar (Inactive) made transition -
          In Development In LB Testing
          		35d 8h 2
          Rutuja Chilwar (Inactive) made transition -
          In LB Testing Stage Testing
          		3s 1
          Rutuja Chilwar (Inactive) made transition -
          Stage Testing In Production Testing
          		20h 53m 1
          Rutuja Chilwar (Inactive) made transition -
          In Production Testing Production Complete
          		47s 1

            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