-
Type:
Bug
-
Status: In Development
-
Priority:
Low
-
Resolution: Unresolved
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: UI Refresh
-
Labels:None
-
Environment:Others
-
Bug Type:Functional
-
Bug Severity:Blocker
-
Module:BenAdmin - Enrollment
-
Reported by:Harbinger
-
Company:All Clients/Multiple Clients
-
Item State:Development - On Hold
Code map
Company name: For QA KinderCare
Upload EOI
Map filed - Date Of Birth as Allow Blank DOB
Mapped same file Plan
Employee login or Partner login -> Employee level Enroll now Screen
Select Plan --> Click on enroll now button with EIO pending value
Getting Server error:
Exception : Invalid column name `AllowBlankDOB`.
App Error Log : ControllerAppTier.GetData->BenAdminControllerAppTier.GetData->EOIForm.GetData
Employee ID : 1270
Action Name : SaveEnrollNowObject
Model : System.Web.Mvc.HandleErrorInfo
Controller : UserDetails
Web Error Log : at WORKTERRA.BenAdmin.BenAdminControllerWebTier.GetData(ObjectType I_objectType, Hashtable I_criteria, Object I_context, Boolean I_mode, Boolean I_needCollection) in c:\WT\branches\UiRefresh-LB\Web\ControllerWebTier\ControllerWebTier\BenAdminControllerWebTier.cs:line 101
at WORKTERRA.BenAdmin.Areas.UserDetails.Models.EnrollNowPVModel.AutoLaunchEOIForm(String EOIFormID, String FileName, Int32 count, String IsPopupWindow, Boolean fileCopyStatus, String IsCarrierLink, String CarrierName) in c:\WT\branches\UiRefresh-LB\Web\Web Projects\BenAdmin\Areas\UserDetails\Models\EnrollNow\EnrollNowPVModel.cs:line 1405
at WORKTERRA.BenAdmin.Areas.UserDetails.Models.EnrollNowPVModel.GetEOIFormPopUpInfo(String strForEOIFile) in c:\WT\branches\UiRefresh-LB\Web\Web Projects\BenAdmin\Areas\UserDetails\Models\EnrollNow\EnrollNowPVModel.cs:line 1384
at WORKTERRA.BenAdmin.Areas.UserDetails.Models.EnrollNowPVModel.GetEnrollNowResponseArray(EnrollNowSave EnrollNowSaveObj, String status, StringBuilder sbPlanNames, EnrollNowSave[] EnrollNowSaveObjArray) in c:\WT\branches\UiRefresh-LB\Web\Web Projects\BenAdmin\Areas\UserDetails\Models\EnrollNow\EnrollNowPVModel.cs:line 1207
at WORKTERRA.BenAdmin.Areas.UserDetails.Models.EnrollNowPVModel.SaveEnrollNowObject(EnrollNowSave EnrollNowSaveObj, EnrollNowSave[] EnrollNowSaveObjArray) in c:\WT\branches\UiRefresh-LB\Web\Web Projects\BenAdmin\Areas\UserDetails\Models\EnrollNow\EnrollNowPVModel.cs:line 1056
at WORKTERRA.BenAdmin.Areas.UserDetails.Controllers.UserDetailsController.SaveEnrollNowObject(EnrollNowSave EnrollNowSaveObj, EnrollNowSave[] EnrollNowSaveObjArray) in c:\WT\branches\UiRefresh-LB\Web\Web Projects\BenAdmin\Areas\UserDetails\Controllers\EnrollNow\EnrollNowController.cs:line 274
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.Async.AsyncControllerActionInvoker.b__39(IAsyncResult asyncResult, ActionInvocation innerInvokeState)
at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResult`2.CallEndDelegate(IAsyncResult asyncResult)
at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResultBase`1.End()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethod(IAsyncResult asyncResult)
at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.b__3d()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c_DisplayClass46.b_3f()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c_DisplayClass46.b_3f()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c_DisplayClass33.b_32(IAsyncResult asyncResult)
at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResult`1.CallEndDelegate(IAsyncResult asyncResult)
at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResultBase`1.End()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethodWithFilters(IAsyncResult asyncResult)
at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c_DisplayClass21.<>cDisplayClass2b.b_1c()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c_DisplayClass21.b_1e(IAsyncResult asyncResult)
Please check.
Hi Jyoti Mayne and Rashmita Dudhe,
I have test the same scenario on stage as well, stage also throwing server error for same scenario.
Jyoti Mayne as discussed with Rohan J Khandave assigning this JIRA to you please look into this.
Analysis: AllowBlankDOB is not present in table Employee and in Fiels table FieldName txtAllowBlankDOB should be inactive as it is not getting used in any where in system.
Please look into this and take appropriate action.
Thanks,
Harshawardhan.
CC: Rohan J Khandave, Nidhi Kaul
Hi Sheetal Bodhale,
Please find below details:
- FieldName column'value txtAllowBlankDOB is present in Fields table with PageID =36 (Import Export Page Information) and TableRefID=75 (Employee)
- On upload EOI Form , The 'Acrobat Field Name' is mapped with 'Data Field Name' . Data Field Names are getting referred from Fields table whose TableRefID is 1 or 75. Here in this case, Allow Blank DOB is mapped with one of the 'Acrobat Field Name' on EOI form.
- On Enroll Now Page, the mapped 'Data Field Names' are checked in respective tables depending on TableRefID.
- System is checking 'Allow Blank DOB' field in Employee table hence it throwing an exception.
Could you please confirm why system is checking Allow Blank DOB filed in employee table as this is not present in Employee Table,
We have checked this on other companies too and issue is reproducing,
Thanks ,
Snehal Shabade
Snehal Shabade (Inactive)
added a comment - Hi Sheetal Bodhale ,
Please find below details:
FieldName column'value txtAllowBlankDOB is present in Fields table with PageID =36 (Import Export Page Information) and TableRefID=75 (Employee)
On upload EOI Form , The 'Acrobat Field Name' is mapped with 'Data Field Name' . Data Field Names are getting referred from Fields table whose TableRefID is 1 or 75. Here in this case, Allow Blank DOB is mapped with one of the 'Acrobat Field Name' on EOI form.
On Enroll Now Page, the mapped 'Data Field Names' are checked in respective tables depending on TableRefID.
System is checking 'Allow Blank DOB' field in Employee table hence it throwing an exception.
Could you please confirm why system is checking Allow Blank DOB filed in employee table as this is not present in Employee Table,
We have checked this on other companies too and issue is reproducing,
Thanks ,
Snehal Shabade
Cc: Jyoti Mayne , Swapnil Pandhare Hi Snehal Shabade,
Allow Blank DOB field is used in Import.When we map this on EOI ,it will give error as no physical column present for that column.
Ideally system should not fetch fields of import and export on EOI screen because physical columns are not created for import and export fields.
Rashmita Dudhe,It is working for other field except import and export fields.You can map and check the same.
CC:SatyaSwapnil PandhareNidhi KaulGaurav SodaniUmesh KadamJyoti MayneSuraj Sokasane
Thanks,
Sheetal Bodhale
Sheetal Bodhale (Inactive)
added a comment - Hi Snehal Shabade ,
Allow Blank DOB field is used in Import.When we map this on EOI ,it will give error as no physical column present for that column.
Ideally system should not fetch fields of import and export on EOI screen because physical columns are not created for import and export fields.
Rashmita Dudhe ,It is working for other field except import and export fields.You can map and check the same.
CC: Satya Swapnil Pandhare Nidhi Kaul Gaurav Sodani Umesh Kadam Jyoti Mayne Suraj Sokasane
Thanks,
Sheetal Bodhale Please check.
CC:Rakesh Roy,Hrishikesh Deshpande,Sachin Hingole,Rohan J Khandave