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

Export > Unable to change employee data when medicare event builder rule for retiree is created

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Environment:
      QA
    • Bug Type:
      Functional
    • Bug Severity:
      Medium
    • Module:
      BenAdmin - EDS
    • Reported by:
      Harbinger
    • Item State:
      Production Complete - Closed
    • Issue Importance:
      Must Have
    • Sprint:
      WT Sprint 34-Bugs

      Description

      Hi Vinayak Kulkarni,
      After copying City Of Durham Company again from production to LB today,We observed that after creating event builder rule for MEDICARE we are getting below error while changing Employee Demographics data such as date of Birth , Status etc :-

      Error LOG->
      ErrorID : 0
      ErrorSource : ControllerAppTier.Save->WORKTERRAControllerAppTier.Save->Employee.Save->Employee.UpdateEmployeeChangeStatus->EventBuilderRuleEngine.UpdateEventBuilderRuleEngineFromCriteria
      ErrorMessage: Conversion failed when converting character string to smalldatetime data type.

      NOTE: we are able to change employee data successfully after deleting MEDICARE event builder rule.
      Can you please look into this , as we are blocked to test actual scenarios for which implementation is done.
      CC-Aniruddha DevHrishikesh Deshpande

        Attachments

          Issue Links

            Activity

            Hide
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment -

            Hi Swapnil,

            As we checked, In the event builder, it was configured with Employee.Age which is why it was giving error as Employee.age is actually date of birth and while comparing date of birth with Number 66 it gave error.

            And we should use only "Age" macro in event builder for this scenario. There should not be Employee.age for date of birth, please update summary of this jira and assign to respective team to change its label.

            We have now modified event builder and it is working properly. Thanks.

            Show
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment - Hi Swapnil, As we checked, In the event builder, it was configured with Employee.Age which is why it was giving error as Employee.age is actually date of birth and while comparing date of birth with Number 66 it gave error. And we should use only "Age" macro in event builder for this scenario. There should not be Employee.age for date of birth, please update summary of this jira and assign to respective team to change its label. We have now modified event builder and it is working properly. Thanks.
            Hide
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) added a comment -

            Hi Sheetal Bodhale,

            Please check this and update Label.

            Thanks,
            Hrishikesh.

            Show
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) added a comment - Hi Sheetal Bodhale , Please check this and update Label. Thanks, Hrishikesh.
            Hide
            sheetal.bodhale Sheetal Bodhale (Inactive) added a comment -

            As discussed with Vinayak Kulkarni,
            We will be deleting 'Employee Age' field from eligibility criteria look up.

            CC:SatyaAkshay MukkawarGaurav Sodani

            Show
            sheetal.bodhale Sheetal Bodhale (Inactive) added a comment - As discussed with Vinayak Kulkarni , We will be deleting 'Employee Age' field from eligibility criteria look up. CC: Satya Akshay Mukkawar Gaurav Sodani
            Hide
            akshay.mukkawar Akshay Mukkawar (Inactive) added a comment -

            Please find below 3C's of the issue,
            Concern:Export > Unable to change employee data when medicare event builder rule for retiree is created
            Cause: Unable to change employee data when medicare event builder rule for retiree is created
            Correction: We have deleting 'Employee Age' field from eligibility criteria look up table.

            Thanks,
            Akshay
            -----------------------
            CC:Sheetal Bodhale,Satya

            Show
            akshay.mukkawar Akshay Mukkawar (Inactive) added a comment - Please find below 3C's of the issue, Concern:Export > Unable to change employee data when medicare event builder rule for retiree is created Cause: Unable to change employee data when medicare event builder rule for retiree is created Correction: We have deleting 'Employee Age' field from eligibility criteria look up table. Thanks, Akshay ----------------------- CC: Sheetal Bodhale , Satya
            Hide
            swapnil.eksambekar Swapnil Eksambekar (Inactive) added a comment -

            Verified this issue on LB,It is working as expected.
            Error is not occuring and Employee Age field is deleted.

            CC-Aniruddha DevHrishikesh Deshpande

            Show
            swapnil.eksambekar Swapnil Eksambekar (Inactive) added a comment - Verified this issue on LB,It is working as expected. Error is not occuring and Employee Age field is deleted. CC- Aniruddha Dev Hrishikesh Deshpande
            Hide
            swapnil.eksambekar Swapnil Eksambekar (Inactive) added a comment -

            Verified this issue on Stage
            Working as expected.

            Ready for Production

            CC-Aniruddha DevRakesh RoyHrishikesh Deshpande

            Show
            swapnil.eksambekar Swapnil Eksambekar (Inactive) added a comment - Verified this issue on Stage Working as expected. Ready for Production CC- Aniruddha Dev Rakesh Roy Hrishikesh Deshpande
            Hide
            rakeshr Rakesh Roy (Inactive) added a comment -

            Data correction done on stage..On production working fine.

            Show
            rakeshr Rakesh Roy (Inactive) added a comment - Data correction done on stage..On production working fine.

              People

              Assignee:
              swapnil.eksambekar Swapnil Eksambekar (Inactive)
              Reporter:
              swapnil.eksambekar Swapnil Eksambekar (Inactive)
              Developer:
              Akshay Mukkawar (Inactive)
              QA:
              Swapnil Eksambekar (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Dev Due Date:
                Pre-Prod Due Date:

                  Time Tracking

                  Estimated:
                  Original Estimate - 0h
                  0h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 15h 50m
                  15h 50m