-
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
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)
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.
Verified in employee login on CPS demo company on stage. This issue is resolved now.
Rajendra Joshi (Inactive)
added a comment - Verified in employee login on CPS demo company on stage. This issue is resolved now. Hi Rakesh Roy,
Assigning JIRA to you as this is deployed on Production.
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