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

            Show
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - CC: Hrishikesh Deshpande , Rakesh Roy , Jyoti Mayne , Rohit Shete
            Hide
            vishal.bajad Vishal Bajad (Inactive) added a comment -

            Hi Rashmita Dudhe ,

            We have tried to repro as per suggested customization , but it could not repro.

            Please help us or provide inputs to repro this issue.
            You can find customization on LB as we tried ,
            Company : For QA MATT
            Plans : voluntary employee life -> Parent and voluntary Spouse life > Child
            Import File : Import Data.txt
            Thanks!

            CC : Jaideep Vinchurkar, Satya

            Show
            vishal.bajad Vishal Bajad (Inactive) added a comment - Hi Rashmita Dudhe , We have tried to repro as per suggested customization , but it could not repro. Please help us or provide inputs to repro this issue. You can find customization on LB as we tried , Company : For QA MATT Plans : voluntary employee life -> Parent and voluntary Spouse life > Child Import File : Import Data.txt Thanks! CC : Jaideep Vinchurkar , Satya
            Hide
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment -

            Hi Vishal Bajad,

            This issue is getting reproduced done all customization On
            Company : For QA ASML for hspl Company
            Plan Name: Supplement employee life and supplement spouse life plan.

            Template name: ElectionImport.
            Refer attached File eligibity.txt

            Thanks
            Rashmita

            Show
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - Hi Vishal Bajad , This issue is getting reproduced done all customization On Company : For QA ASML for hspl Company Plan Name: Supplement employee life and supplement spouse life plan. Template name: ElectionImport. Refer attached File eligibity.txt Thanks Rashmita
            Hide
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) added a comment -

            Rashmita Dudhe, where are attached screen shots?

            Show
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) added a comment - Rashmita Dudhe , where are attached screen shots?
            Hide
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment -

            Hi Jaideep Vinchurkar,

            Screen shots attached in this WT-9635.

            Thanks,
            Rashmita

            Show
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - Hi Jaideep Vinchurkar , Screen shots attached in this WT-9635 . Thanks, Rashmita
            Hide
            suraj.sokasane Suraj Sokasane (Inactive) added a comment -

            Hi Rashmita Dudhe,

            The issue is not getting reproduced now. This might be some specific scenario. It'll be great if you check and provide bit more details.

            Show
            suraj.sokasane Suraj Sokasane (Inactive) added a comment - Hi Rashmita Dudhe , The issue is not getting reproduced now. This might be some specific scenario. It'll be great if you check and provide bit more details.
            Hide
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment -

            Hi Suraj Sokasane,

            CC:Jaideep Vinchurkar,Hrishikesh Deshpande

            This issue is getting reproduced and it is Braking functionality of wt-9635 please follow below steps and customization to reproduced it.
            Plan customization
            (enrollment allowed for EE = NO | enrollment allowed for CH and SP = Yes).

            1]Employee enrolled in to the Parent plan with effective date 01/01/2017 either UI or Import as child plan is forced contingent.
            Spouse and child enrolled in to the child plan with effective date 01/01/2017

            2]Again If we do import for parent plan with 07/01/2017 then Import is getting failed.

            But enrollment done in parent plan with Effective date 07/01/2017
            But child plan it showing Effective date 01/01/2017
            Syatem behavior is not correct in this scenario

            Refer attached screen shots.

            Refer error log:

            ErrorID : 0
            ErrorSource : ControllerAppTier.SaveAndGetData->WORKTERRAControllerAppTier.SaveAndGetData->ExecuteImportDTS.ImportData_Isolated->WTIsolatedRoutines.Main->ExecuteImportDTS.ImportData->ImportEmployeeEnrollment.ImportData->ImportEmployeeEnrollment.TerminateCurrentEnrollments
            ErrorMessage: Object reference not set to an instance of an object.

            Thanks,
            Rashmita

            Show
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - Hi Suraj Sokasane , CC: Jaideep Vinchurkar , Hrishikesh Deshpande This issue is getting reproduced and it is Braking functionality of wt-9635 please follow below steps and customization to reproduced it. Plan customization (enrollment allowed for EE = NO | enrollment allowed for CH and SP = Yes). 1]Employee enrolled in to the Parent plan with effective date 01/01/2017 either UI or Import as child plan is forced contingent. Spouse and child enrolled in to the child plan with effective date 01/01/2017 2]Again If we do import for parent plan with 07/01/2017 then Import is getting failed. But enrollment done in parent plan with Effective date 07/01/2017 But child plan it showing Effective date 01/01/2017 Syatem behavior is not correct in this scenario Refer attached screen shots. Refer error log: ErrorID : 0 ErrorSource : ControllerAppTier.SaveAndGetData->WORKTERRAControllerAppTier.SaveAndGetData->ExecuteImportDTS.ImportData_Isolated->WTIsolatedRoutines.Main->ExecuteImportDTS.ImportData->ImportEmployeeEnrollment.ImportData->ImportEmployeeEnrollment.TerminateCurrentEnrollments ErrorMessage: Object reference not set to an instance of an object. Thanks, Rashmita
            Hide
            ankur.deshpande Ankur Deshpande (Inactive) added a comment -

            Hi Rashmita Dudhe,

            I have solved the error that you were getting. Following are the 3c's.

            Concern : Object reference not set to an instance of an object.

            Cause : Error during closing the datareader.

            Correction : Applied check using if condition.

            Regards,
            Ankur

            Show
            ankur.deshpande Ankur Deshpande (Inactive) added a comment - Hi Rashmita Dudhe , I have solved the error that you were getting. Following are the 3c's. Concern : Object reference not set to an instance of an object. Cause : Error during closing the datareader. Correction : Applied check using if condition. Regards, Ankur
            Hide
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment -

            Hi Jaideep Vinchurkar,

            CC:Jyoti Mayne,Hrishikesh Deshpande,Rakesh Roy,Satya,Gaurav Sodani

            Import failed related issue is solved and when i am verifying actual issue which is related to this issue WT-9635. This issue is implemented recently for enrollment.

            Customization of plan is below:

            When we done fresh Election import for parent plan then contingent plan is enrolled with proper coverage and it showing on Enroll now screen

            But on view enrollment summary and confirmation statement it is not showing

            Thanks,
            Rashmita

            Show
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - Hi Jaideep Vinchurkar , CC: Jyoti Mayne , Hrishikesh Deshpande , Rakesh Roy , Satya , Gaurav Sodani Import failed related issue is solved and when i am verifying actual issue which is related to this issue WT-9635 . This issue is implemented recently for enrollment. Customization of plan is below: When we done fresh Election import for parent plan then contingent plan is enrolled with proper coverage and it showing on Enroll now screen But on view enrollment summary and confirmation statement it is not showing Thanks, Rashmita

              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