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
          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
          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.
          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.

            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