Uploaded image for project: 'WORKTERRA'
  1. WORKTERRA
  2. WT-10290

WT ->Import-> Forced Contingency -> Spouse Child plans are not getting enrolled by the system with the minimum coverage amounts

    Details

    • Type: Bug
    • Status: In Development
    • Priority: Medium
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
    • Environment:
      Production, Stage, QA
    • Bug Type:
      Functional
    • Bug Severity:
      Medium
    • Module:
      BenAdmin - Import
    • Reported by:
      Harbinger
    • Company:
      All Clients/Multiple Clients
    • Item State:
      Development - On Hold
    • Issue Importance:
      Must Have
    • Sprint:
      WT Sprint 35 - Bugs

      Description

      Lb For Qa ASML Company

      Consider there is a life EE plan & a dependent life plan (enrollment allowed for EE = NO | enrollment allowed for CH and SP = Yes). Refer the dependent life plan's customization in the attached screenshot.

      Through import try to enroll on EE plan
      Actual Result : import getting failed.

      Refer below error log:

      ErrorID : 0
      ErrorSource : ControllerAppTier.SaveAndGetData->WORKTERRAControllerAppTier.SaveAndGetData->ExecuteImportDTS.ImportData_Isolated->WTIsolatedRoutines.Main->ExecuteImportDTS.ImportData->ImportEmployeeEnrollment.ImportData->ImportEmployeeEnrollment.GenerateRatesPolicyNoHealthTierQueryStringForAll->ImportEmployeeEnrollment.ExecuteEnrollmentQuery
      ErrorMessage: Conversion failed when converting date and/or time from character string.

        Attachments

        1. Customization2.png
          Customization2.png
          240 kB
        2. El1.png
          El1.png
          240 kB
        3. el2.png
          el2.png
          232 kB
        4. El3.png
          El3.png
          224 kB
        5. eligibity.txt
          0.1 kB
        6. Enroll_Now.png
          Enroll_Now.png
          203 kB
        7. Import Data.txt
          0.1 kB
        8. Plan customization1.png
          Plan customization1.png
          225 kB

          Issue Links

            Activity

            rashmita.dudhe Rashmita Dudhe (Inactive) created issue -
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Field Original Value New Value
            Link This issue relates to WT-9635 [ WT-9635 ]
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Assignee Vijay Siddha [ vijays ] Jaideep Vinchurkar [ jaideep.vinchurkar ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Assignee Jaideep Vinchurkar [ jaideep.vinchurkar ] Suraj Sokasane [ suraj.sokasane ]
            vishal.bajad Vishal Bajad (Inactive) made changes -
            Assignee Suraj Sokasane [ suraj.sokasane ] Vishal Bajad [ vishal.bajad ]
            vishal.bajad Vishal Bajad (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            vishal.bajad Vishal Bajad (Inactive) made changes -
            Dev Due Date 16/Aug/2017
            Developer Vishal Bajad [ vishal.bajad ]
            Item State Parent values: Development(10200)Level 1 values: In Analysis(10204)
            QA Rashmita Dudhe [ rashmita.dudhe ]
            vishal.bajad Vishal Bajad (Inactive) made changes -
            Remaining Estimate 0h [ 0 ]
            Time Spent 8h [ 28800 ]
            Worklog Id 71525 [ 71525 ]
            vishal.bajad Vishal Bajad (Inactive) made changes -
            Attachment Import Data.txt [ 58663 ]
            vishal.bajad Vishal Bajad (Inactive) made changes -
            Assignee Vishal Bajad [ vishal.bajad ] Rashmita Dudhe [ rashmita.dudhe ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Time Spent 8h [ 28800 ] 8.5h [ 30600 ]
            Worklog Id 71809 [ 71809 ]
            vishal.bajad Vishal Bajad (Inactive) made changes -
            Time Spent 8.5h [ 30600 ] 10.5h [ 37800 ]
            Worklog Id 71834 [ 71834 ]
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Sprint WT Sprint 35 - Bugs [ 81 ]
            Original Estimate 0h [ 0 ]
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Attachment eligibity.txt [ 59342 ]
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Time Spent 10.5h [ 37800 ] 13.5h [ 48600 ]
            Worklog Id 73095 [ 73095 ]
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Assignee Rashmita Dudhe [ rashmita.dudhe ] Vishal Bajad [ vishal.bajad ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Assignee Vishal Bajad [ vishal.bajad ] Suraj Sokasane [ suraj.sokasane ]
            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Description Lb For Qa ASML Company

            consider there is a life EE plan & a dependent life plan (enrollment allowed for EE = NO | enrollment allowed for CH and SP = Yes)
            refer the dependent life plan's customization in the attached screenshot
            through import try to enrolled on EE plan
            Expected Result : import getting failed

            refer below error log:

            ErrorID : 0
            ErrorSource : ControllerAppTier.SaveAndGetData->WORKTERRAControllerAppTier.SaveAndGetData->ExecuteImportDTS.ImportData_Isolated->WTIsolatedRoutines.Main->ExecuteImportDTS.ImportData->ImportEmployeeEnrollment.ImportData->ImportEmployeeEnrollment.GenerateRatesPolicyNoHealthTierQueryStringForAll->ImportEmployeeEnrollment.ExecuteEnrollmentQuery
            ErrorMessage: Conversion failed when converting date and/or time from character string.
            Lb For Qa ASML Company

            consider there is a life EE plan & a dependent life plan (enrollment allowed for EE = NO | enrollment allowed for CH and SP = Yes)
            refer the dependent life plan's customization in the attached screenshot
            through import try to enroll on EE plan
            Expected Result : import getting failed

            refer below error log:

            ErrorID : 0
            ErrorSource : ControllerAppTier.SaveAndGetData->WORKTERRAControllerAppTier.SaveAndGetData->ExecuteImportDTS.ImportData_Isolated->WTIsolatedRoutines.Main->ExecuteImportDTS.ImportData->ImportEmployeeEnrollment.ImportData->ImportEmployeeEnrollment.GenerateRatesPolicyNoHealthTierQueryStringForAll->ImportEmployeeEnrollment.ExecuteEnrollmentQuery
            ErrorMessage: Conversion failed when converting date and/or time from character string.
            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Description Lb For Qa ASML Company

            consider there is a life EE plan & a dependent life plan (enrollment allowed for EE = NO | enrollment allowed for CH and SP = Yes)
            refer the dependent life plan's customization in the attached screenshot
            through import try to enroll on EE plan
            Expected Result : import getting failed

            refer below error log:

            ErrorID : 0
            ErrorSource : ControllerAppTier.SaveAndGetData->WORKTERRAControllerAppTier.SaveAndGetData->ExecuteImportDTS.ImportData_Isolated->WTIsolatedRoutines.Main->ExecuteImportDTS.ImportData->ImportEmployeeEnrollment.ImportData->ImportEmployeeEnrollment.GenerateRatesPolicyNoHealthTierQueryStringForAll->ImportEmployeeEnrollment.ExecuteEnrollmentQuery
            ErrorMessage: Conversion failed when converting date and/or time from character string.
            Lb For Qa ASML Company

            Consider there is a life EE plan & a dependent life plan (enrollment allowed for EE = NO | enrollment allowed for CH and SP = Yes). Refer the dependent life plan's customization in the attached screenshot.

            Through import try to enroll on EE plan
            Actual Result : import getting failed.

            Refer below error log:

            ErrorID : 0
            ErrorSource : ControllerAppTier.SaveAndGetData->WORKTERRAControllerAppTier.SaveAndGetData->ExecuteImportDTS.ImportData_Isolated->WTIsolatedRoutines.Main->ExecuteImportDTS.ImportData->ImportEmployeeEnrollment.ImportData->ImportEmployeeEnrollment.GenerateRatesPolicyNoHealthTierQueryStringForAll->ImportEmployeeEnrollment.ExecuteEnrollmentQuery
            ErrorMessage: Conversion failed when converting date and/or time from character string.
            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Assignee Suraj Sokasane [ suraj.sokasane ] Rashmita Dudhe [ rashmita.dudhe ]
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Assignee Rashmita Dudhe [ rashmita.dudhe ] Jayshree Nagpure [ jayshree.nagpure ]
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Attachment Plan customization1.png [ 59713 ]
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Attachment Customization2.png [ 59714 ]
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Attachment Enroll_Now.png [ 59715 ]
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Time Spent 13.5h [ 48600 ] 14.5h [ 52200 ]
            Worklog Id 74017 [ 74017 ]
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Assignee Jayshree Nagpure [ jayshree.nagpure ] Suraj Sokasane [ suraj.sokasane ]
            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Assignee Suraj Sokasane [ suraj.sokasane ] Ankur Deshpande [ ankur.deshpande ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Time Spent 14.5h [ 52200 ] 15h [ 54000 ]
            Worklog Id 74095 [ 74095 ]
            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Time Spent 15h [ 54000 ] 16.5h [ 59400 ]
            Worklog Id 74144 [ 74144 ]
            ankur.deshpande Ankur Deshpande (Inactive) made changes -
            Code Reviewed By Jaideep Vinchurkar [ 11908 ]
            Dev Due Date 16/Aug/2017 16/Aug/2017
            ankur.deshpande Ankur Deshpande (Inactive) made changes -
            Assignee Ankur Deshpande [ ankur.deshpande ] Rashmita Dudhe [ rashmita.dudhe ]
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Analysis(10204) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: In Testing(10210)
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Attachment El1.png [ 59974 ]
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Attachment el2.png [ 59975 ]
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Attachment El3.png [ 59976 ]
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Time Spent 16.5h [ 59400 ] 17.5h [ 63000 ]
            Worklog Id 74587 [ 74587 ]
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Status Local Testing [ 10200 ] Reopen in Local [ 10018 ]
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Assignee Rashmita Dudhe [ rashmita.dudhe ] Jaideep Vinchurkar [ jaideep.vinchurkar ]
            ankur.deshpande Ankur Deshpande (Inactive) made changes -
            Time Spent 17.5h [ 63000 ] 20h [ 72000 ]
            Worklog Id 75597 [ 75597 ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Status Reopen in Local [ 10018 ] In Development [ 10007 ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: In Testing(10210) Parent values: Development(10200)Level 1 values: In Analysis(10204)
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Labels Manual_import
            jaideep.vinchurkar Jaideep Vinchurkar (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)
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Company All Clients/Multiple Clients [ 18434 ]
            Environment Production,Stage,LB [ 18442, 18443, 18444 ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Assignee Jaideep Vinchurkar [ jaideep.vinchurkar ] Ganesh Sadawarte [ ganesh.sadawarte ]
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
            Assignee Ganesh Sadawarte [ ganesh.sadawarte ] Suraj Sokasane [ suraj.sokasane ]

              People

              Assignee:
              suraj.sokasane Suraj Sokasane (Inactive)
              Reporter:
              rashmita.dudhe Rashmita Dudhe (Inactive)
              Developer:
              Vishal Bajad (Inactive)
              QA:
              Rashmita Dudhe (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

                Created:
                Updated:
                Dev Due Date:

                  Time Tracking

                  Estimated:
                  Original Estimate - 0h
                  0h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 20h
                  20h