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

            swapnil.eksambekar Swapnil Eksambekar (Inactive) created issue -
            swapnil.eksambekar Swapnil Eksambekar (Inactive) made changes -
            Field Original Value New Value
            Link This issue is caused by WT-8875 [ WT-8875 ]
            swapnil.eksambekar Swapnil Eksambekar (Inactive) made changes -
            Comment [ We are unable to create medicare event scenarios . Due to this event builder for which WT-9346 is created. Can you please look into this , as we are blocked to test actual scenarios for which implementation is done ? ]
            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.
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
            Assignee Vinayak Kulkarni [ vinayak.kulkarni ] Swapnil Eksambekar [ swapnil.eksambekar ]
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Resolution System Behaviour [ 10100 ]
            Status In Development [ 10007 ] Rejected [ 10004 ]
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Status Rejected [ 10004 ] Closed [ 6 ]
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Comment [ Working as expected. ]
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Status Closed [ 6 ] Reopen in Production [ 10027 ]
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Module Parent values: BenAdmin(10100)Level 1 values: Export(10110) Parent values: BenAdmin(10100)Level 1 values: EDS(10108)
            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.
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Assignee Swapnil Eksambekar [ swapnil.eksambekar ] Sheetal Bodhale [ sheetal.bodhale ]
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Developer Vinayak Kulkarni [ vinayak.kulkarni ] Sheetal Bodhale [ sheetal.bodhale ]
            satyap Satya made changes -
            Status Reopen in Production [ 10027 ] In Development [ 10007 ]
            satyap Satya made changes -
            Item State Parent values: Development(10200)Level 1 values: Development Backlog(10205)
            sheetal.bodhale Sheetal Bodhale (Inactive) made changes -
            Assignee Sheetal Bodhale [ sheetal.bodhale ] Jyotibala Pardeshi [ jyotibala ]
            sheetal.bodhale Sheetal Bodhale (Inactive) made changes -
            Dev Due Date 18/Jul/2017
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Sprint WT Sprint 34-Bugs [ 79 ]
            sheetal.bodhale Sheetal Bodhale (Inactive) made changes -
            Assignee Jyotibala Pardeshi [ jyotibala ] Akshay Mukkawar [ akshay.mukkawar ]
            akshay.mukkawar Akshay Mukkawar (Inactive) made changes -
            Developer Sheetal Bodhale [ sheetal.bodhale ] Akshay Mukkawar [ akshay.mukkawar ]
            akshay.mukkawar Akshay Mukkawar (Inactive) made changes -
            Dev Due Date 18/Jul/2017 07/Aug/2017
            akshay.mukkawar Akshay Mukkawar (Inactive) made changes -
            Dev Due Date 07/Aug/2017 09/Aug/2017
            akshay.mukkawar Akshay Mukkawar (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: Development Backlog(10205) Parent values: Development(10200)Level 1 values: In Progress(10206)
            sheetal.bodhale Sheetal Bodhale (Inactive) logged work - 09/Aug/17 07:24 PM - edited
            • Time Spent:
              2h
               

              code debugging
              explained issue to Akshay
              discussion with satya and Vinayak

            akshay.mukkawar Akshay Mukkawar (Inactive) logged work - 10/Aug/17 01:40 AM
            • Time Spent:
              5h
               

              initial analysis
              Code changes

            akshay.mukkawar Akshay Mukkawar (Inactive) made changes -
            Remaining Estimate 0h [ 0 ]
            Time Spent 5h [ 18000 ]
            Worklog Id 70660 [ 70660 ]
            akshay.mukkawar Akshay Mukkawar (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Progress(10206) Parent values: Development(10200)Level 1 values: Ready for Review(10208)
            Original Estimate 0h [ 0 ]
            akshay.mukkawar Akshay Mukkawar (Inactive) made changes -
            Time Spent 5h [ 18000 ] 8h [ 28800 ]
            Worklog Id 70707 [ 70707 ]
            sheetal.bodhale Sheetal Bodhale (Inactive) made changes -
            Attachment WT-9346-Review Checklist.doc [ 58231 ]
            sheetal.bodhale Sheetal Bodhale (Inactive) made changes -
            Time Spent 8h [ 28800 ] 8h 20m [ 30000 ]
            Worklog Id 70848 [ 70848 ]
            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
            akshay.mukkawar Akshay Mukkawar (Inactive) made changes -
            Code Reviewed By Sheetal Bodhale [ 11905 ]
            akshay.mukkawar Akshay Mukkawar (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: Ready for Review(10208) Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209)
            akshay.mukkawar Akshay Mukkawar (Inactive) made changes -
            Attachment WT-9346-FilesAffected.txt [ 58235 ]
            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
            akshay.mukkawar Akshay Mukkawar (Inactive) logged work - 10/Aug/17 09:39 PM
            • Time Spent:
              3h
               

              unit testing

            sheetal.bodhale Sheetal Bodhale (Inactive) logged work - 10/Aug/17 11:48 PM
            • Time Spent:
              20m
               

              code review
              attached review check list

            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            akshay.mukkawar Akshay Mukkawar (Inactive) made changes -
            Assignee Akshay Mukkawar [ akshay.mukkawar ] Swapnil Eksambekar [ swapnil.eksambekar ]
            sheetal.bodhale Sheetal Bodhale (Inactive) made changes -
            Time Spent 8h 20m [ 30000 ] 10h 20m [ 37200 ]
            Worklog Id 71029 [ 71029 ]
            sheetal.bodhale Sheetal Bodhale (Inactive) made changes -
            Worklog Id 71029 [ 71029 ]
            akshay.mukkawar Akshay Mukkawar (Inactive) made changes -
            Attachment WT-9346-FilesAffected.txt [ 58235 ]
            akshay.mukkawar Akshay Mukkawar (Inactive) made changes -
            Attachment WT-9346-FilesAffected.txt [ 58495 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Bug Severity Medium [ 16702 ]
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Production Due Date 05/Oct/2017
            Stage Due Date 3/Oct/17 [ 2017-10-03 ]
            swapnil.eksambekar Swapnil Eksambekar (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)
            swapnil.eksambekar Swapnil Eksambekar (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: In Testing(10210) Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)
            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
            swapnil.eksambekar Swapnil Eksambekar (Inactive) logged work - 03/Oct/17 09:20 AM
            • Time Spent:
              1.5h
               
              <No comment>
            swapnil.eksambekar Swapnil Eksambekar (Inactive) made changes -
            Time Spent 10h 20m [ 37200 ] 11h 50m [ 42600 ]
            Worklog Id 82958 [ 82958 ]
            swapnil.eksambekar Swapnil Eksambekar (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)
            swapnil.eksambekar Swapnil Eksambekar (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) Parent values: Stage QA(10202)Level 1 values: In Testing(10214)
            rakeshr Rakesh Roy (Inactive) made changes -
            Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
            swapnil.eksambekar Swapnil Eksambekar (Inactive) logged work - 12/Oct/17 01:28 PM
            • Time Spent:
              1h
               
              <No comment>
            swapnil.eksambekar Swapnil Eksambekar (Inactive) made changes -
            Time Spent 11h 50m [ 42600 ] 12h 50m [ 46200 ]
            Worklog Id 84612 [ 84612 ]
            swapnil.eksambekar Swapnil Eksambekar (Inactive) logged work - 13/Oct/17 12:49 PM
            • Time Spent:
              1h
               
              <No comment>
            swapnil.eksambekar Swapnil Eksambekar (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: In Testing(10214) Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)
            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
            swapnil.eksambekar Swapnil Eksambekar (Inactive) made changes -
            Time Spent 12h 50m [ 46200 ] 13h 50m [ 49800 ]
            Worklog Id 84897 [ 84897 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) Parent values: Stage QA(10202)Level 1 values: Production Deployment on Hold(10224)
            satyap Satya made changes -
            Labels Employee_workflow
            satyap Satya made changes -
            Environment_New LB [ 18444 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Production Due Date 05/Oct/2017 29/Jan/2018
            rakeshr Rakesh Roy (Inactive) made changes -
            Production Due Date 29/Jan/2018 05/Mar/2018
            rakeshr Rakesh Roy (Inactive) made changes -
            Production Due Date 05/Mar/2018
            rakeshr Rakesh Roy (Inactive) made changes -
            Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
            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.
            rakeshr Rakesh Roy (Inactive) made changes -
            Resolution System Behaviour [ 10100 ] Done [ 10000 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Resolution Done [ 10000 ] Fixed [ 1 ]
            Status Production Complete [ 10028 ] Closed [ 6 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Production Deployment on Hold(10224) Parent values: Production Complete(10222)Level 1 values: Closed(10223)
            swapnil.eksambekar Swapnil Eksambekar (Inactive) logged work - 07/Mar/18 05:37 AM
            • Time Spent:
              1h
               
              <No comment>
            swapnil.eksambekar Swapnil Eksambekar (Inactive) made changes -
            Time Spent 13h 50m [ 49800 ] 14h 50m [ 53400 ]
            Worklog Id 107328 [ 107328 ]
            amit.kumawat Amit Kumawat (Inactive) made changes -
            Time Spent 14h 50m [ 53400 ] 15h 50m [ 57000 ]
            Worklog Id 109092 [ 109092 ]
            amit.kumawat Amit Kumawat (Inactive) logged work - 21/Mar/18 12:54 AM
            • Time Spent:
              1h
               
              • Discussion with Swapnil
              • Script writing
              • Verify script at local
            Transition Time In Source Status Execution Times
            Hrishikesh Deshpande (Inactive) made transition -
            Open In Development
            16h 29m 1
            Hrishikesh Deshpande (Inactive) made transition -
            In Development Rejected
            17s 1
            Hrishikesh Deshpande (Inactive) made transition -
            Rejected Closed
            3s 1
            Hrishikesh Deshpande (Inactive) made transition -
            Closed Reopen in Production
            3h 9m 1
            Satya made transition -
            Reopen in Production In Development
            61d 21h 44m 1
            Swapnil Eksambekar (Inactive) made transition -
            In Development In LB Testing
            96d 2h 2m 1
            Rakesh Roy (Inactive) made transition -
            In LB Testing Stage Testing
            8d 21h 53m 1
            Rakesh Roy (Inactive) made transition -
            Stage Testing In Production Testing
            113d 2h 45m 1
            Rakesh Roy (Inactive) made transition -
            In Production Testing Production Complete
            33s 1
            Rakesh Roy (Inactive) made transition -
            Production Complete Closed
            4s 1

              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