-
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)
Rajendra Joshi (Inactive)
created issue -
| Field | Original Value | New Value |
|---|---|---|
| Assignee | Avnish Yadav [ avnish.yadav ] | Prasanna Karlekar [ prasanna ] |
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. 
Khandu Kshirsagar (Inactive)
made changes -
| Item State | Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) |
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) |
-
- Time Spent:
- 1.25h
-
Issue discussion
Discussion on fix to be done
Code review
| Item State | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) | Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) |
| Assignee | Prasanna Karlekar [ prasanna ] | Rajendra Joshi [ rajendraj ] |
| Status | Open [ 1 ] | In Development [ 10007 ] |
| Status | In Development [ 10007 ] | Local Testing [ 10200 ] |
Hi Rakesh Roy,
Assigning JIRA to you as this is deployed on Production.
| Assignee | Rajendra Joshi [ rajendraj ] | Rakesh Roy [ rakeshr ] |
| Status | Local Testing [ 10200 ] | Stage Testing [ 10201 ] |
| Status | Stage Testing [ 10201 ] | Production Testing [ 10202 ] |
| Assignee | Rakesh Roy [ rakeshr ] | Prasad Pise [ prasadp ] |
| Resolution | Fixed [ 1 ] | |
| Status | Production Testing [ 10202 ] | Production Complete [ 10028 ] |
| Item State | Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) | Parent values: Production Complete(10222)Level 1 values: Closed(10223) |
| Status | Production Complete [ 10028 ] | Closed [ 6 ] |
| Assignee | Prasad Pise [ prasadp ] | Rajendra Joshi [ rajendraj ] |
| Remaining Estimate | 0h [ 0 ] | |
| Time Spent | 1.25h [ 4500 ] | |
| Worklog Id | 22203 [ 22203 ] |
| Bug Severity | Medium [ 16702 ] |
| Environment_New | Stage [ 18443 ] |
| Component/s | ACA [ 10004 ] | |
| Component/s | Exchange [ 10003 ] |
| Transition | Time In Source Status | Execution Times |
|---|
|
1d 1h 24m | 1 |
|
8s | 1 |
|
4h 39m | 1 |
|
7s | 1 |
|
1d 1h 50m | 1 |
|
14h 21m | 1 |
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