WORKTERRAProject Type: software

WORKTERRA

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

CPS demo >> Server error observed on Select Your plan screen onLoad

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: ACA
    • Labels:
      None
    • Environment:
      Stage
    • Bug Severity:
      Medium
    • Module:
      Exchange
    • Reported by:
      Harbinger
    • Item State:
      Production Complete - Closed

      Description

      In Employee flow, while 'Select your plans' is selected on landing page, server error occurred as Select Your Plan screen loads. PFA error log and screen shot

      Exception : Cursorfetch: The number of variables declared in the INTO list must match that of selected columns.The statement has been terminated.
      App Error Log : ControllerAppTier.Delete->BenAdminControllerAppTier.Delete->EmployeeEnrollment.DeletePreviousRecommendations
      Employee ID : 11605
      Action Name : ExSelectYourOwnPlans
      Model : System.Web.Mvc.HandleErrorInfo
      Controller : Exchange
      Web Error Log : at WORKTERRA.BenAdmin.BenAdminControllerWebTier.Delete(ObjectType I_objectType, Hashtable I_criteria, Object I_context)
      at WORKTERRA.BenAdmin.Areas.UserDetails.Models.ExSelectYourOwnPlan.DeletePreviousRecommendedPlans(String EmployeeID)
      at WORKTERRA.BenAdmin.Areas.UserDetails.Models.ExSelectYourOwnPlan..ctor(Boolean IsRecommendPlanParam, Boolean SkipQuestionnaireParam, String EffectiveDate1)
      at WORKTERRA.BenAdmin.Areas.UserDetails.Controllers.ExchangeController.ExSelectYourOwnPlans(String EffectiveDate, Boolean SkipQuestionnaire)
      at lambda_method(Closure , ControllerBase , Object[] )
      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_DisplayClass13.b_10()
      at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation)
      at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation)
      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)

        Attachments

          Activity

          Ascending order - Click to sort in descending order
          rajendraj Rajendra Joshi (Inactive) created issue -
          Hide
          Permalink
          avnish.yadav Avnish Yadav (Inactive) added a comment -

          Hi Prasanna Karlekar,

          We have verified above mentioned issue and observed that issue present in "trgDelBillingDetails_RateLog_Intermediate" trigger.

          Error Log:-
          Msg 16924, Level 16, State 1, Procedure trgDelBillingDetails_RateLog_Intermediate, Line 38
          Cursorfetch: The number of variables declared in the INTO list must match that of selected columns.
          The statement has been terminated.

          As per our discussion, we have disabled this "trgDelBillingDetails_RateLog_Intermediate" trigger for CPS demo in stage environment.

          Rajendra Joshi Could please verify this again and let us know in case of any issue/concern.

          Thanks,
          Avnish Y

          CC- Jyoti Mayne,Satya

          Show
          avnish.yadav Avnish Yadav (Inactive) added a comment - Hi Prasanna Karlekar , We have verified above mentioned issue and observed that issue present in "trgDelBillingDetails_RateLog_Intermediate" trigger. Error Log:- Msg 16924, Level 16, State 1, Procedure trgDelBillingDetails_RateLog_Intermediate, Line 38 Cursorfetch: The number of variables declared in the INTO list must match that of selected columns. The statement has been terminated. As per our discussion, we have disabled this "trgDelBillingDetails_RateLog_Intermediate" trigger for CPS demo in stage environment. Rajendra Joshi Could please verify this again and let us know in case of any issue/concern. Thanks, Avnish Y CC- Jyoti Mayne , Satya
          avnish.yadav Avnish Yadav (Inactive) made changes -
          Field Original Value New Value
          Assignee Avnish Yadav [ avnish.yadav ] Prasanna Karlekar [ prasanna ]
          Hide
          Permalink
          prasanna Prasanna Karlekar (Inactive) added a comment -

          Following are the 3C's:

          Concern:
          Server error observed on Select Your plan screen onLoad.

          Cause:
          The issue was with billing DELETE trigger set on Rates table.
          The number of variables declared in INTO list of cursor were not matching with selected columns.

          Correction:
          Code changes are done to fix this issue.

          Impacted areas:
          Rate and Billing table while deleting elections or deletion of record from Rates table.

          Show
          prasanna Prasanna Karlekar (Inactive) added a comment - Following are the 3C's: Concern: Server error observed on Select Your plan screen onLoad. Cause: The issue was with billing DELETE trigger set on Rates table. The number of variables declared in INTO list of cursor were not matching with selected columns. Correction: Code changes are done to fix this issue. Impacted areas: Rate and Billing table while deleting elections or deletion of record from Rates table.
          Hide
          Permalink
          rajendraj Rajendra Joshi (Inactive) added a comment -

          Verified in employee login on CPS demo company on stage. This issue is resolved now.

          Show
          rajendraj Rajendra Joshi (Inactive) added a comment - Verified in employee login on CPS demo company on stage. This issue is resolved now.
          khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
          Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)
          khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
          Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
          Permalink
          prasanna Prasanna Karlekar (Inactive) logged work - 24/Jan/17 11:00 PM
          • Time Spent:
            1.25h
             

            Issue discussion
            Discussion on fix to be done
            Code review

          ashwin.wankhede Ashwin Wankhede (Inactive) made changes -
          Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: Production QA(10203)Level 1 values: Production Deployed(10221)
          prasanna Prasanna Karlekar (Inactive) made changes -
          Assignee Prasanna Karlekar [ prasanna ] Rajendra Joshi [ rajendraj ]
          prasanna Prasanna Karlekar (Inactive) made changes -
          Status Open [ 1 ] In Development [ 10007 ]
          prasanna Prasanna Karlekar (Inactive) made changes -
          Status In Development [ 10007 ] Local Testing [ 10200 ]
          Hide
          Permalink
          prasanna Prasanna Karlekar (Inactive) added a comment -

          Hi Rakesh Roy,

          Assigning JIRA to you as this is deployed on Production.

          Show
          prasanna Prasanna Karlekar (Inactive) added a comment - Hi Rakesh Roy , Assigning JIRA to you as this is deployed on Production.
          prasanna Prasanna Karlekar (Inactive) made changes -
          Assignee Rajendra Joshi [ rajendraj ] Rakesh Roy [ rakeshr ]
          rakeshr Rakesh Roy (Inactive) made changes -
          Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
          rakeshr Rakesh Roy (Inactive) made changes -
          Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
          rakeshr Rakesh Roy (Inactive) made changes -
          Assignee Rakesh Roy [ rakeshr ] Prasad Pise [ prasadp ]
          rakeshr Rakesh Roy (Inactive) made changes -
          Resolution Fixed [ 1 ]
          Status Production Testing [ 10202 ] Production Complete [ 10028 ]
          rakeshr Rakesh Roy (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)
          prasadp Prasad Pise (Inactive) made changes -
          Status Production Complete [ 10028 ] Closed [ 6 ]
          prasadp Prasad Pise (Inactive) made changes -
          Assignee Prasad Pise [ prasadp ] Rajendra Joshi [ rajendraj ]
          prasanna Prasanna Karlekar (Inactive) made changes -
          Remaining Estimate 0h [ 0 ]
          Time Spent 1.25h [ 4500 ]
          Worklog Id 22203 [ 22203 ]
          rakeshr Rakesh Roy (Inactive) made changes -
          Bug Severity Medium [ 16702 ]
          satyap Satya made changes -
          Environment_New Stage [ 18443 ]
          Prashant.samal Prashant Samal (Inactive) made changes -
          Component/s ACA [ 10004 ]
          Component/s Exchange [ 10003 ]
          Transition Time In Source Status Execution Times
          Prasanna Karlekar (Inactive) made transition -
          Open In Development
          		1d 1h 24m 1
          Prasanna Karlekar (Inactive) made transition -
          In Development In LB Testing
          		8s 1
          Rakesh Roy (Inactive) made transition -
          In LB Testing Stage Testing
          		4h 39m 1
          Rakesh Roy (Inactive) made transition -
          Stage Testing In Production Testing
          		7s 1
          Rakesh Roy (Inactive) made transition -
          In Production Testing Production Complete
          		1d 1h 50m 1
          Prasad Pise (Inactive) made transition -
          Production Complete Closed
          		14h 21m 1

            People

            Assignee:
            rajendraj Rajendra Joshi (Inactive)
            Reporter:
            rajendraj Rajendra Joshi (Inactive)
            QA:
            Rajendra Joshi (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0h
                0h
                Logged:
                Time Spent - 1.25h
                1.25h