WORKTERRAProject Type: software

WORKTERRA

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

City of Bellevue - Server Error on EE Record

    Details

    • Type: Bug
    • Status: Production Complete
    • Priority: High
    • Resolution: Bug Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Environment:
      Production
    • Bug Severity:
      Medium
    • Module:
      BenAdmin - EDS
    • Reported by:
      Client
    • Company:
      City of Bellevue
    • Sprint:
      WT Sprint 40 - Bugs

      Description

      We are getting the attached server error on Kristina Galloway's record on the demographic record. Please advise as this group is currently in OE

        Attachments

          Issue Links

          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. WT-11829 City of Bellevue - Server Error

          • Critical - This problem will block progress.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. WT-11791 Qualifying Event : Validation for selecting Waiting Period if Effective Date Rule is selected as "Use Waiting Period"

          • High - Serious problem that could block progress.
          • Closed

            Activity

            Ascending order - Click to sort in descending order
            dkulling Debbie Kulling created issue -
            Permalink
            umesh.kadam Umesh Kadam (Inactive) logged work - 24/Oct/17 04:30 PM
            • Time Spent:
              5h
               

              DB backup
              Attach DB in local
              Code debugging to get exact root cause
              Reproduced this issue in local
              Discussion with Satya and Amruta
              Assigned task to day team to add validation on UI for Qualifying event

            umesh.kadam Umesh Kadam (Inactive) made changes -
            Field Original Value New Value
            Status Open [ 1 ] In Development [ 10007 ]
            amruta.lohiya Amruta Lohiya made changes -
            Assignee Amruta Lohiya [ amruta.baheti ] Umesh Kadam [ umesh.kadam ]
            umesh.kadam Umesh Kadam (Inactive) made changes -
            Dev Due Date 25/Oct/2017
            Developer Umesh Kadam [ umesh.kadam ]
            Item State Parent values: Development(10200)Level 1 values: In Analysis(10204)
            Sprint WT Sprint 40 - Bugs [ 94 ]
            umesh.kadam Umesh Kadam (Inactive) made changes -
            Attachment Waiting_Period_Option_Is_Not_Selected.png [ 65553 ]
            umesh.kadam Umesh Kadam (Inactive) made changes -
            Link This issue relates to WT-11791 [ WT-11791 ]
            Hide
            Permalink
            umesh.kadam Umesh Kadam (Inactive) added a comment -

            Hi Debbie Kulling,

            Please find below 3Cs :

            Concern Getting server error on Demographics page of employee Kristina Galloway
            Cause
            • While showing Demographics page, system tries to get effective date using QE raised for an employee
            • For Krishinia Galloway, "Employee Change - Declaration of DP (Enter Date of DP Declaration)" QE has been raised with effective date "07/18/2017".
            • For this QE "Effective Date Rule" has been selected as "Use Waiting Period" but no any option selected under "Waiting Period"
            • Hence system is getting NULL value for effective date of this QE which is causing server error on demographics page
            • Please find attached screenshot
            Correction Please select correct option under "Waiting Period, it will work.
            On Stage, "First of Month Following Event Date" has been selected under "Waiting Period"

            We have created WT-11791 to add validation to select "Waiting Period" if "Effective Date Rule" has been selected as "Use Waiting Period".

            Thanks and Regards,
            :: Umesh Kadam

            CC : Satya, Amruta Lohiya, Rakesh Shahane, Swapnil Pandhare

            Show
            umesh.kadam Umesh Kadam (Inactive) added a comment - Hi Debbie Kulling , Please find below 3Cs : Concern Getting server error on Demographics page of employee Kristina Galloway Cause While showing Demographics page, system tries to get effective date using QE raised for an employee For Krishinia Galloway, "Employee Change - Declaration of DP (Enter Date of DP Declaration)" QE has been raised with effective date "07/18/2017". For this QE "Effective Date Rule" has been selected as "Use Waiting Period" but no any option selected under "Waiting Period" Hence system is getting NULL value for effective date of this QE which is causing server error on demographics page Please find attached screenshot Correction Please select correct option under "Waiting Period, it will work. On Stage, "First of Month Following Event Date" has been selected under "Waiting Period" We have created WT-11791 to add validation to select "Waiting Period" if "Effective Date Rule" has been selected as "Use Waiting Period". Thanks and Regards, :: Umesh Kadam CC : Satya , Amruta Lohiya , Rakesh Shahane , Swapnil Pandhare
            umesh.kadam Umesh Kadam (Inactive) made changes -
            Assignee Umesh Kadam [ umesh.kadam ] Debbie Kulling [ dkulling ]
            umesh.kadam Umesh Kadam (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Analysis(10204)
            jyoti.mayne Jyoti Mayne made changes -
            Module Parent values: BenAdmin(10100) Parent values: BenAdmin(10100)Level 1 values: EDS(10108)
            satyap Satya made changes -
            Assignee Debbie Kulling [ dkulling ] Swapnil Pandhare [ swapnil.pandhare ]
            satyap Satya made changes -
            Link This issue is duplicated by WT-11829 [ WT-11829 ]
            satyap Satya made changes -
            Root Cause Scenario/Requirement Missed [ 18432 ]
            satyap Satya made changes -
            Attachment Re EE errors due to waiting period selections.msg [ 66040 ]
            Hide
            Permalink
            satyap Satya added a comment -

            Swapnil Pandhare,

            As permanent fix to avoid this scenario, we will make ‘waiting period option’ mandatory whenever ‘Use Waiting period’ option has been selected for qualifying event effective date rule.

            Please refer mail Unable to embed resource: Re EE errors due to waiting period selections.msg of type application/octet-stream for details.

            Regards,
            Satya Prakash

            Cc: Rajiv Rajan Gaurav Sodani

            Show
            satyap Satya added a comment - Swapnil Pandhare , As permanent fix to avoid this scenario, we will make ‘waiting period option’ mandatory whenever ‘Use Waiting period’ option has been selected for qualifying event effective date rule. Please refer mail Unable to embed resource: Re EE errors due to waiting period selections.msg of type application/octet-stream for details. Regards, Satya Prakash Cc: Rajiv Rajan Gaurav Sodani
            swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
            Assignee Swapnil Pandhare [ swapnil.pandhare ] Niteen Surwase [ niteen.surwase ]
            Hide
            Permalink
            niteen.surwase Niteen Surwase (Inactive) added a comment - - edited

            Hi Debbie Kulling

            I have checked for above validation on Production (City of Bellevue For HSPL).
            So, When we select Effective Date Rule as Use Waiting Period, then Waiting Period Option field is mandatory. This is already implemented.

            I've scanned for NULL Waiting Period through all companies. Not found any QE with null Waiting Period.

            Please see below screen-shot for Waiting Period validation.

            Please check and close the ticket.

            Thanks,
            Niteen S.

            Cc: Swapnil Pandhare Satya Sheetal Bodhale

            Show
            niteen.surwase Niteen Surwase (Inactive) added a comment - - edited Hi Debbie Kulling I have checked for above validation on Production (City of Bellevue For HSPL). So, When we select Effective Date Rule as Use Waiting Period , then Waiting Period Option field is mandatory. This is already implemented. I've scanned for NULL Waiting Period through all companies. Not found any QE with null Waiting Period. Please see below screen-shot for Waiting Period validation. Please check and close the ticket. Thanks, Niteen S. Cc: Swapnil Pandhare Satya Sheetal Bodhale
            Permalink
            niteen.surwase Niteen Surwase (Inactive) logged work - 28/Oct/17 05:00 PM
            • Time Spent:
              2h
               

              Analysis and Code changes

            niteen.surwase Niteen Surwase (Inactive) made changes -
            Remaining Estimate 5h [ 18000 ]
            Original Estimate 5h [ 18000 ]
            niteen.surwase Niteen Surwase (Inactive) made changes -
            Remaining Estimate 5h [ 18000 ] 3h [ 10800 ]
            Time Spent 2h [ 7200 ]
            Worklog Id 87811 [ 87811 ]
            niteen.surwase Niteen Surwase (Inactive) made changes -
            Attachment Screenshot (102).png [ 66190 ]
            niteen.surwase Niteen Surwase (Inactive) made changes -
            Assignee Niteen Surwase [ niteen.surwase ] Debbie Kulling [ dkulling ]
            Permalink
            niteen.surwase Niteen Surwase (Inactive) logged work - 30/Oct/17 01:13 PM
            • Time Spent:
              6h
               

              Call with Swapnil & Satya
              Checkin changes on Production

            niteen.surwase Niteen Surwase (Inactive) made changes -
            Remaining Estimate 3h [ 10800 ] 0h [ 0 ]
            Time Spent 2h [ 7200 ] 8h [ 28800 ]
            Worklog Id 87823 [ 87823 ]
            sheetal.bodhale Sheetal Bodhale (Inactive) made changes -
            Time Spent 8h [ 28800 ] 8h 20m [ 30000 ]
            Worklog Id 87905 [ 87905 ]
            umesh.kadam Umesh Kadam (Inactive) made changes -
            Time Spent 8h 20m [ 30000 ] 13h 20m [ 48000 ]
            Worklog Id 87960 [ 87960 ]
            Permalink
            sheetal.bodhale Sheetal Bodhale (Inactive) logged work - 31/Oct/17 02:57 AM
            • Time Spent:
              20m
               

              Discussion with Niteen
              Main review

            sheetal.bodhale Sheetal Bodhale (Inactive) made changes -
            Labels Employee_workflow
            sheetal.bodhale Sheetal Bodhale (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            sheetal.bodhale Sheetal Bodhale (Inactive) made changes -
            Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
            sheetal.bodhale Sheetal Bodhale (Inactive) made changes -
            Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
            Hide
            Permalink
            sheetal.bodhale Sheetal Bodhale (Inactive) added a comment -

            Correction is done,so closing the ticket

            Show
            sheetal.bodhale Sheetal Bodhale (Inactive) added a comment - Correction is done,so closing the ticket
            sheetal.bodhale Sheetal Bodhale (Inactive) made changes -
            Resolution Fixed [ 1 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            Hide
            Permalink
            Jennifer.Reed Jennifer Reed (Inactive) added a comment -

            Satya Did we do a code fix on this? I was under the impression that were supposed to make the ‘waiting period option’ mandatory. Has this been done?

            Show
            Jennifer.Reed Jennifer Reed (Inactive) added a comment - Satya Did we do a code fix on this? I was under the impression that were supposed to make the ‘waiting period option’ mandatory. Has this been done?
            Hide
            Permalink
            swapnil.pandhare Swapnil Pandhare (Inactive) added a comment - - edited

            CC : Satya
            Hi Jennifer Reed

            We have not done any code fix for this. It's already a mandatory field. We are working on why this was not updated . We have updated waiting period option for this.
            Thanks,
            Swapnil P.

            Cc: Satya Swapnil Pandhare

            Show
            swapnil.pandhare Swapnil Pandhare (Inactive) added a comment - - edited CC : Satya Hi Jennifer Reed We have not done any code fix for this. It's already a mandatory field. We are working on why this was not updated . We have updated waiting period option for this. Thanks, Swapnil P. Cc: Satya Swapnil Pandhare
            Hide
            Permalink
            Jennifer.Reed Jennifer Reed (Inactive) added a comment -

            Swapnil Pandhare Satya Oh interesting...so it was already mandatory? So, do we have another ticket open to understand why this scenario happened? I don't see any, and I'm not comfortable with closing this ticket if we haven't discovered the root cause of how this happened.

            Thanks,
            Jenn

            Show
            Jennifer.Reed Jennifer Reed (Inactive) added a comment - Swapnil Pandhare Satya Oh interesting...so it was already mandatory? So, do we have another ticket open to understand why this scenario happened? I don't see any, and I'm not comfortable with closing this ticket if we haven't discovered the root cause of how this happened. Thanks, Jenn
            Hide
            Permalink
            swapnil.pandhare Swapnil Pandhare (Inactive) added a comment -

            CC : Satya Samir

            Hi Rakesh Roy ,

            Can you please assign this to QA to try to reproduce this issue on various browsers ?

            Thanks,
            Swapnil P.

            Show
            swapnil.pandhare Swapnil Pandhare (Inactive) added a comment - CC : Satya Samir Hi Rakesh Roy , Can you please assign this to QA to try to reproduce this issue on various browsers ? Thanks, Swapnil P.
            swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
            Assignee Debbie Kulling [ dkulling ] Rakesh Roy [ rakeshr ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Assignee Rakesh Roy [ rakeshr ] Hrishikesh Deshpande [ hrishikesh.deshpande ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Assignee Hrishikesh Deshpande [ hrishikesh.deshpande ] Venkatesh Pujari [ venkatesh.pujari ]
            Hide
            Permalink
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            Hi Sachin Hingole,

            Tried to reproduce this issue on IE11,Chrome and Firefox browsers. I tried adding a new QE,editing an existing one but could not reproduce this issue.

            Thanks,
            Venkatesh

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - Hi Sachin Hingole , Tried to reproduce this issue on IE11,Chrome and Firefox browsers. I tried adding a new QE,editing an existing one but could not reproduce this issue. Thanks, Venkatesh
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Assignee Venkatesh Pujari [ venkatesh.pujari ] Sachin Hingole [ sachin.hingole ]
            satyap Satya made changes -
            Environment_New Production [ 18442 ]
            Hide
            Permalink
            Jennifer.Reed Jennifer Reed (Inactive) added a comment -

            Adding comment for clarification:
            The waiting period option field is already mandatory, so we need to figure out how this scenario happened. Therefore, the ticket is still open. The data has already been corrected, so it should no longer be an issue for the client.

            Satya Swapnil Pandhare If we are still testing scenarios to figure out how this happened, should the ticket status be in Production Complete?

            Show
            Jennifer.Reed Jennifer Reed (Inactive) added a comment - Adding comment for clarification: The waiting period option field is already mandatory, so we need to figure out how this scenario happened. Therefore, the ticket is still open. The data has already been corrected, so it should no longer be an issue for the client. Satya Swapnil Pandhare If we are still testing scenarios to figure out how this happened, should the ticket status be in Production Complete?
            dkulling Debbie Kulling made changes -
            Resolution Done [ 10000 ]
            Status Production Complete [ 10028 ] Closed [ 6 ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Status Closed [ 6 ] Reopen in Production [ 10027 ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Status Reopen in Production [ 10027 ] In Development [ 10007 ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Resolution Bug Fixed [ 10402 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            Transition Time In Source Status Execution Times
            Umesh Kadam (Inactive) made transition -
            Open In Development
            		1h 39m 1
            Debbie Kulling made transition -
            Production Complete Closed
            		118d 9h 43m 1
            Sachin Hingole (Inactive) made transition -
            Closed Reopen in Production
            		23d 17h 20m 1
            Sachin Hingole (Inactive) made transition -
            Reopen in Production In Development
            		1m 13s 1
            Sachin Hingole (Inactive) made transition -
            In Development In LB Testing
            		7d 13h 30m 2
            Sachin Hingole (Inactive) made transition -
            In LB Testing Stage Testing
            		2m 53s 2
            Sachin Hingole (Inactive) made transition -
            Stage Testing In Production Testing
            		2m 37s 2
            Sachin Hingole (Inactive) made transition -
            In Production Testing Production Complete
            		2m 2

              People

              Assignee:
              sachin.hingole Sachin Hingole (Inactive)
              Reporter:
              dkulling Debbie Kulling
              Account Executive:
              Debbie Kulling
              Developer:
              Umesh Kadam (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              8 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Dev Due Date:

                  Time Tracking

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