New Features 2017Project Type: software

New Features 2017

Uploaded image for project: 'New Features 2017'
  1. New Features 2017
  2. NF-5550

Code map-Upload EOI- Allow blank date of birth- Employee login -getting server error

    Details

    • 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

      Description

      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)

        Attachments

        1. Austin EOI.PDF
          108 kB
        2. Blank_DOB_EOI.png
          Blank_DOB_EOI.png
          189 kB
        3. FLX980220_SI Change EOI.pdf
          152 kB
        4. Stage.png
          Stage.png
          217 kB

          Issue Links

          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. NF-5592 Codemap | CA | NE + OE flow | Server error in flow | Unable to proceed further

          • Medium - Has the potential to affect progress.
          • Closed
          relates to

          New Feature - A new feature of the product, which has yet to be developed. NF-1413 EOI Popup

          • Medium - Has the potential to affect progress.
          • Resolution Setting

            Activity

            Ascending order - Click to sort in descending order
            rashmita.dudhe Rashmita Dudhe (Inactive) created issue -
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Field Original Value New Value
            Link This issue relates to NF-1413 [ NF-1413 ]
            Hide
            Permalink
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment -

            CC:Rakesh Roy,Hrishikesh Deshpande,Sachin Hingole,Rohan J Khandave

            Show
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - CC: Rakesh Roy , Hrishikesh Deshpande , Sachin Hingole , Rohan J Khandave
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Assignee Nidhi Kaul [ nidhi.kaul ] Vishal Yadav [ vishal.yadav ]
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Attachment Blank_DOB_EOI.png [ 70448 ]
            Hide
            Permalink
            rohan.khandave Rohan J Khandave (Inactive) added a comment -

            Please check.

            Show
            rohan.khandave Rohan J Khandave (Inactive) added a comment - Please check.
            rohan.khandave Rohan J Khandave (Inactive) made changes -
            Assignee Vishal Yadav [ vishal.yadav ] Harshawardhan Phalake [ harshawardhan ]
            Permalink
            vishal.yadav Vishal Yadav (Inactive) logged work - 20/Dec/17 01:53 PM
            • Time Spent:
              1h
               

              Analysis
              Issue reproduce on local
              discussion with Rohan and Harshwardhan

            vishal.yadav Vishal Yadav (Inactive) made changes -
            Remaining Estimate 0h [ 0 ]
            Time Spent 1h [ 3600 ]
            Worklog Id 97217 [ 97217 ]
            harshawardhan Harshawardhan Phalake (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            harshawardhan Harshawardhan Phalake (Inactive) made changes -
            Original Estimate 12h [ 43200 ]
            Permalink
            harshawardhan Harshawardhan Phalake (Inactive) logged work - 20/Dec/17 02:29 PM
            • Time Spent:
              6h
               

              Analysis and debugging

            harshawardhan Harshawardhan Phalake (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Analysis(10204)
            harshawardhan Harshawardhan Phalake (Inactive) made changes -
            Time Spent 1h [ 3600 ] 7h [ 25200 ]
            Worklog Id 97231 [ 97231 ]
            Permalink
            harshawardhan Harshawardhan Phalake (Inactive) logged work - 21/Dec/17 07:30 AM
            • Time Spent:
              1h
               

              Analysis

            harshawardhan Harshawardhan Phalake (Inactive) made changes -
            Attachment Stage.png [ 70547 ]
            Hide
            Permalink
            harshawardhan Harshawardhan Phalake (Inactive) added a comment -

            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

            Show
            harshawardhan Harshawardhan Phalake (Inactive) added a comment - 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
            harshawardhan Harshawardhan Phalake (Inactive) made changes -
            Time Spent 7h [ 25200 ] 8h [ 28800 ]
            Worklog Id 97315 [ 97315 ]
            harshawardhan Harshawardhan Phalake (Inactive) made changes -
            Assignee Harshawardhan Phalake [ harshawardhan ] Jyoti Mayne [ jyoti.mayne ]
            jyoti.mayne Jyoti Mayne made changes -
            Assignee Jyoti Mayne [ jyoti.mayne ] Snehal Shabade [ snehal.shabade ]
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Attachment Austin EOI.PDF [ 70725 ]
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Attachment FLX980220_SI Change EOI.pdf [ 70726 ]
            Permalink
            snehal.shabade Snehal Shabade (Inactive) logged work - 26/Dec/17 04:23 PM - edited
            • Time Spent:
              4h
               

              -Discussion with jyoti related to the issue
              -Discussion with rashmita related to issue repro steps
              -Analysis on issue,
              -Discussion with sheetal and ganesh

            snehal.shabade Snehal Shabade (Inactive) made changes -
            Time Spent 8h [ 28800 ] 12h [ 43200 ]
            Worklog Id 97924 [ 97924 ]
            snehal.shabade Snehal Shabade (Inactive) made changes -
            Worklog Id 97924 [ 97924 ]
            Permalink
            sheetal.bodhale Sheetal Bodhale (Inactive) logged work - 27/Dec/17 07:38 AM
            • Time Spent:
              20m
               

              Discussion with Snehal

            Hide
            Permalink
            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

            Show
            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
            snehal.shabade Snehal Shabade (Inactive) made changes -
            Assignee Snehal Shabade [ snehal.shabade ] Sheetal Bodhale [ sheetal.bodhale ]
            jyoti.mayne Jyoti Mayne made changes -
            Dev Due Date 05/Jan/2018
            Permalink
            jyoti.mayne Jyoti Mayne logged work - 27/Dec/17 03:37 PM
            • Time Spent:
              0.5h
               

              discussion and comment review

            jyoti.mayne Jyoti Mayne made changes -
            Time Spent 12h [ 43200 ] 12.5h [ 45000 ]
            Worklog Id 98132 [ 98132 ]
            Permalink
            snehal.shabade Snehal Shabade (Inactive) logged work - 27/Dec/17 04:18 PM
            • Time Spent:
              6h
               

              -Analysis on backend data
              -code debugging
              -discussion with jyoti and sheetal
              -update the jira accordingly

            snehal.shabade Snehal Shabade (Inactive) made changes -
            Time Spent 12.5h [ 45000 ] 18.5h [ 66600 ]
            Worklog Id 98149 [ 98149 ]
            Permalink
            sheetal.bodhale Sheetal Bodhale (Inactive) logged work - 28/Dec/17 07:38 AM
            • Time Spent:
              0.25h
               

              Discussion with Snehal

            sheetal.bodhale Sheetal Bodhale (Inactive) made changes -
            Time Spent 18.5h [ 66600 ] 18h 50m [ 67800 ]
            Worklog Id 98225 [ 98225 ]
            sheetal.bodhale Sheetal Bodhale (Inactive) made changes -
            Time Spent 18h 50m [ 67800 ] 19h 5m [ 68700 ]
            Worklog Id 98226 [ 98226 ]
            sheetal.bodhale Sheetal Bodhale (Inactive) made changes -
            Assignee Sheetal Bodhale [ sheetal.bodhale ] Niteen Surwase [ niteen.surwase ]
            jyotibala Jyotibala Pardeshi (Inactive) made changes -
            Assignee Niteen Surwase [ niteen.surwase ] Jyotibala Pardeshi [ jyotibala ]
            jyotibala Jyotibala Pardeshi (Inactive) made changes -
            Developer Jyotibala Pardeshi [ jyotibala ]
            Hide
            Permalink
            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:SatyaSwapnil PandhareNidhi KaulGaurav SodaniUmesh KadamJyoti MayneSuraj Sokasane

            Thanks,
            Sheetal Bodhale

            Show
            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
            sheetal.bodhale Sheetal Bodhale (Inactive) made changes -
            Assignee Jyotibala Pardeshi [ jyotibala ] Snehal Shabade [ snehal.shabade ]
            sheetal.bodhale Sheetal Bodhale (Inactive) made changes -
            Time Spent 19h 5m [ 68700 ] 20h 5m [ 72300 ]
            Worklog Id 98506 [ 98506 ]
            jyotibala Jyotibala Pardeshi (Inactive) made changes -
            Time Spent 20h 5m [ 72300 ] 22h 5m [ 79500 ]
            Worklog Id 98509 [ 98509 ]
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Priority High [ 2 ] Medium [ 3 ]
            jyotibala Jyotibala Pardeshi (Inactive) made changes -
            Link This issue is duplicated by NF-5592 [ NF-5592 ]
            Permalink
            snehal.shabade Snehal Shabade (Inactive) logged work - 29/Dec/17 04:25 PM
            • Time Spent:
              0.5h
               

              Discussion with jyotibala related to the issue repro and my finding

            Permalink
            sheetal.bodhale Sheetal Bodhale (Inactive) logged work - 30/Dec/17 06:57 AM
            • Time Spent:
              1h
               

              Analysis
              Discussion with Ganesh and Jyotibala
              Updated the comments

            Permalink
            jyotibala Jyotibala Pardeshi (Inactive) logged work - 30/Dec/17 06:57 AM
            • Time Spent:
              2h
               

              Debugging and analysis of issue.
              Discussion with Snehal and Sheetal.

            snehal.shabade Snehal Shabade (Inactive) made changes -
            Time Spent 22h 5m [ 79500 ] 22h 35m [ 81300 ]
            Worklog Id 98992 [ 98992 ]
            snehal.shabade Snehal Shabade (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Analysis(10204) Parent values: Development(10200)Level 1 values: On Hold(10207)
            jyoti.mayne Jyoti Mayne made changes -
            Dev Due Date 05/Jan/2018
            jyotibala Jyotibala Pardeshi (Inactive) made changes -
            Developer Jyotibala Pardeshi [ jyotibala ] Snehal Shabade [ snehal.shabade ]
            nidhi.kaul Nidhi Kaul (Inactive) made changes -
            Priority Medium [ 3 ] Low [ 4 ]
            rohan.khandave Rohan J Khandave (Inactive) made changes -
            Assignee Snehal Shabade [ snehal.shabade ] Rohan J Khandave [ rohan.khandave ]
            Hide
            Permalink
            rohan.khandave Rohan J Khandave (Inactive) added a comment -

            Please check.

            Show
            rohan.khandave Rohan J Khandave (Inactive) added a comment - Please check.
            rohan.khandave Rohan J Khandave (Inactive) made changes -
            Assignee Rohan J Khandave [ rohan.khandave ] Harshawardhan Phalake [ harshawardhan ]
            Permalink
            harshawardhan Harshawardhan Phalake (Inactive) logged work - 30/Jan/18 03:01 PM
            • Time Spent:
              7h
               

              Analysis and script creation for Whole companyes data

            harshawardhan Harshawardhan Phalake (Inactive) made changes -
            Time Spent 22h 35m [ 81300 ] 29h 35m [ 106500 ]
            Worklog Id 102680 [ 102680 ]
            Permalink
            harshawardhan Harshawardhan Phalake (Inactive) logged work - 02/Feb/18 03:13 PM
            • Time Spent:
              3h
               

              Analysis and testing

            harshawardhan Harshawardhan Phalake (Inactive) made changes -
            Time Spent 29h 35m [ 106500 ] 32h 35m [ 117300 ]
            Worklog Id 103294 [ 103294 ]
            umesh.kadam Umesh Kadam (Inactive) made changes -
            Developer Snehal Shabade [ snehal.shabade ] Harshawardhan Phalake [ harshawardhan ]
            Transition Time In Source Status Execution Times
            Harshawardhan Phalake (Inactive) made transition -
            Open In Development
            		7h 29m 1

              People

              Assignee:
              harshawardhan Harshawardhan Phalake (Inactive)
              Reporter:
              rashmita.dudhe Rashmita Dudhe (Inactive)
              Developer:
              Harshawardhan Phalake (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

                Created:
                Updated:

                  Time Tracking

                  Estimated:
                  Original Estimate - 12h Original Estimate - 12h
                  12h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 32h 35m
                  32h 35m