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

Valiant - Duplicate Dependent Child Records

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Environment:
      Stage
    • Bug Type:
      Functional
    • Bug Severity:
      Medium
    • Module:
      BenAdmin - EDS
    • Reported by:
      Client
    • Company:
      Valiant
    • Item State:
      Production Complete

      Description

      HI, Valiant is currently in UAT and having an issue when entering a child record, getting the error message "Server encountered an internal error, please contact your administrator” when trying to save, then the site is creating duplicate records. Screenshot of duplicate records created.

      Jennifer MelgozaRobyn Adkison

        Attachments

        1. Admin Login.png
          Admin Login.png
          231 kB
        2. Employee login.jpg
          Employee login.jpg
          148 kB
        3. Emplyee login.jpg
          Emplyee login.jpg
          154 kB
        4. FW Development approval for Bugs reported on 1031.msg
          32 kB
        5. image.png
          image.png
          150 kB
        6. LB Company Admin.jpg
          LB Company Admin.jpg
          108 kB
        7. LB Employee.jpg
          LB Employee.jpg
          119 kB
        8. LB Partner.jpg
          LB Partner.jpg
          126 kB
        9. Partner Login.jpg
          Partner Login.jpg
          131 kB
        10. Re Request for Production deployment - 25 Nov 2017.msg
          77 kB

          Activity

          Amanda.Hagan Amanda Hagan (Inactive) created issue -
          swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
          Field Original Value New Value
          Assignee Satya [ ID10004 ] Swapnil Pandhare [ swapnil.pandhare ]
          Hide
          swapnil.pandhare Swapnil Pandhare (Inactive) added a comment -

          CC : SatyaSamir Sudhir Kalikate Gaurav Sodani

          Hi Amanda Hagan ,

          Please find details below :
          Concern : Server error on child page .
          Cause : After adding child , while executing employee routines , one of the script was not accepting User ID which was throwing error after adding child.
          Correction : We have corrected the script on this company. On rest of companies, we will execute this SP in regular patch . You will not receive server error now.

          Please confirm.

          Thanks,
          Swapnil P.

          Show
          swapnil.pandhare Swapnil Pandhare (Inactive) added a comment - CC : Satya Samir Sudhir Kalikate Gaurav Sodani Hi Amanda Hagan , Please find details below : Concern : Server error on child page . Cause : After adding child , while executing employee routines , one of the script was not accepting User ID which was throwing error after adding child. Correction : We have corrected the script on this company. On rest of companies, we will execute this SP in regular patch . You will not receive server error now. Please confirm. Thanks, Swapnil P.
          swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
          Assignee Swapnil Pandhare [ swapnil.pandhare ] Amanda Hagan [ amanda.hagan ]
          swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
          Status Open [ 1 ] In Development [ 10007 ]
          swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
          Status In Development [ 10007 ] Local Testing [ 10200 ]
          swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
          Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
          Hide
          Amanda.Hagan Amanda Hagan (Inactive) added a comment -

          I have tested and was able to add child successfully and did not create a duplicate. Thanks!

          Show
          Amanda.Hagan Amanda Hagan (Inactive) added a comment - I have tested and was able to add child successfully and did not create a duplicate. Thanks!
          rakeshr Rakesh Roy (Inactive) made changes -
          Module Parent values: BenAdmin(10100) Parent values: BenAdmin(10100)Level 1 values: EDS(10108)
          satyap Satya made changes -
          Labels Employee_workflow
          satyap Satya made changes -
          Environment_New Stage [ 18443 ]
          rakeshr Rakesh Roy (Inactive) made changes -
          Bug Type Functional [ 15402 ]
          Item State Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209)
          Hide
          rakeshr Rakesh Roy (Inactive) added a comment -

          Swapnil Pandhare what's plan to fix and deployment on LB and stage?

          Sachin HingoleHrishikesh Deshpande

          Show
          rakeshr Rakesh Roy (Inactive) added a comment - Swapnil Pandhare what's plan to fix and deployment on LB and stage? Sachin Hingole Hrishikesh Deshpande
          rakeshr Rakesh Roy (Inactive) made changes -
          Assignee Amanda Hagan [ amanda.hagan ] Swapnil Pandhare [ swapnil.pandhare ]
          Hide
          swapnil.pandhare Swapnil Pandhare (Inactive) added a comment -

          CC: Sheetal Bodhale
          Hi Sudhir Kalikate ,

          If "OES_SP_EDS_RaisedEventBuilder" script is given on LB and stage , please update the patch status and assign to QA.

          Thanks,
          Swapnil P.

          Show
          swapnil.pandhare Swapnil Pandhare (Inactive) added a comment - CC: Sheetal Bodhale Hi Sudhir Kalikate , If "OES_SP_EDS_RaisedEventBuilder" script is given on LB and stage , please update the patch status and assign to QA. Thanks, Swapnil P.
          swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
          Assignee Swapnil Pandhare [ swapnil.pandhare ] Sudhir Kalikate [ sudhir.kalikate ]
          sudhir.kalikate Sudhir Kalikate (Inactive) made changes -
          Code Reviewed By Swapnil Pandhare [ 11900 ]
          Developer Sudhir Kalikate [ sudhir.kalikate ]
          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)
          QA Hrishikesh Deshpande [ hrishikesh.deshpande ]
          sudhir.kalikate Sudhir Kalikate (Inactive) made changes -
          Assignee Sudhir Kalikate [ sudhir.kalikate ] Hrishikesh Deshpande [ hrishikesh.deshpande ]
          hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
          Assignee Hrishikesh Deshpande [ hrishikesh.deshpande ] Sachin Hingole [ sachin.hingole ]
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Account Executive Amanda Hagan [ amanda.hagan ]
          Assignee Sachin Hingole [ sachin.hingole ] Priya Handepatil [ priya.handepatil ]
          Production Due Date 16/Nov/2017
          QA Hrishikesh Deshpande [ hrishikesh.deshpande ] Priya Handepatil [ priya.handepatil ]
          Stage Due Date 13/Nov/17 [ 2017-11-13 ]
          sachin.hingole Sachin Hingole (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)
          priya.handepatil Priya Handepatil (Inactive) made changes -
          Attachment LB Partner.jpg [ 67054 ]
          priya.handepatil Priya Handepatil (Inactive) made changes -
          Attachment LB Company Admin.jpg [ 67055 ]
          priya.handepatil Priya Handepatil (Inactive) made changes -
          Attachment LB Employee.jpg [ 67056 ]
          Hide
          priya.handepatil Priya Handepatil (Inactive) added a comment -

          Hi Sudhir Kalikate

          I have verifie dthis issue on LB

          Verified with Company " For QA FDU For HSPL"

          Verified with Partner Login

          Verified with Company Admin Login

          Verified with Employee Login

          Its working fine

          Hence, Marking ticket as Ready for Stage

          CC:Sachin Hingole Prasad Pise Rakesh Roy Hrishikesh Deshpande

          Thank you !

          Show
          priya.handepatil Priya Handepatil (Inactive) added a comment - Hi Sudhir Kalikate I have verifie dthis issue on LB Verified with Company " For QA FDU For HSPL" Verified with Partner Login Verified with Company Admin Login Verified with Employee Login Its working fine Hence, Marking ticket as Ready for Stage CC: Sachin Hingole Prasad Pise Rakesh Roy Hrishikesh Deshpande Thank you !
          priya.handepatil Priya Handepatil (Inactive) logged work - 07/Nov/17 11:18 AM
          • Time Spent:
            1.5h
             

            Analysis
            Internal Communication with Sachin
            Customization
            Testing for different scenario
            JIRA Updates

          priya.handepatil Priya Handepatil (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)
          priya.handepatil Priya Handepatil (Inactive) made changes -
          Remaining Estimate 0h [ 0 ]
          Time Spent 1.5h [ 5400 ]
          Worklog Id 89449 [ 89449 ]
          swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
          Root Cause Bug [ 18430 ]
          Original Estimate 0h [ 0 ]
          sudhir.kalikate Sudhir Kalikate (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)
          priya.handepatil Priya Handepatil (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)
          priya.handepatil Priya Handepatil (Inactive) made changes -
          Attachment Partner Login.jpg [ 67397 ]
          priya.handepatil Priya Handepatil (Inactive) made changes -
          Attachment Admin Login.png [ 67398 ]
          priya.handepatil Priya Handepatil (Inactive) made changes -
          Attachment Employee login.jpg [ 67399 ]
          priya.handepatil Priya Handepatil (Inactive) made changes -
          Attachment Emplyee login.jpg [ 67400 ]
          Hide
          priya.handepatil Priya Handepatil (Inactive) added a comment -

          Hi Sudhir Kalikate

          I have verified this issue on Stage

          Verified with Company " City Of durham For hspl "

          Verified with Partner Login

          Verified with Company Admin login

          Verified with Employee Login

          Its working fine

          Hence, Marking it as ready for production

          cc: Rakesh Roy Sachin Hingole Prasad Pise

          Thank You !

          Show
          priya.handepatil Priya Handepatil (Inactive) added a comment - Hi Sudhir Kalikate I have verified this issue on Stage Verified with Company " City Of durham For hspl " Verified with Partner Login Verified with Company Admin login Verified with Employee Login Its working fine Hence, Marking it as ready for production cc: Rakesh Roy Sachin Hingole Prasad Pise Thank You !
          priya.handepatil Priya Handepatil (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)
          priya.handepatil Priya Handepatil (Inactive) made changes -
          Time Spent 1.5h [ 5400 ] 2.5h [ 9000 ]
          Worklog Id 90078 [ 90078 ]
          priya.handepatil Priya Handepatil (Inactive) logged work - 11/Nov/17 07:15 AM
          • Time Spent:
            1h
             

            Customization
            Testing for different Logins
            internal communication
            Screenshots
            Jira Updates

          gaurav.sodani Gaurav Sodani (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: On Hold(10215)
          gaurav.sodani Gaurav Sodani (Inactive) made changes -
          Item State Parent values: Stage QA(10202)Level 1 values: On Hold(10215) Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)
          gaurav.sodani Gaurav Sodani (Inactive) made changes -
          Hide
          gaurav.sodani Gaurav Sodani (Inactive) added a comment - - edited

          Hi All,

          Attaching development approval email to work on this ticket: FW Development approval for Bugs reported on 1031.msg

          Regards
          Gaurav

          Show
          gaurav.sodani Gaurav Sodani (Inactive) added a comment - - edited Hi All, Attaching development approval email to work on this ticket: FW Development approval for Bugs reported on 1031.msg Regards Gaurav
          gaurav.sodani Gaurav Sodani (Inactive) made changes -
          Approval status Approved for development [ 18453 ]
          gaurav.sodani Gaurav Sodani (Inactive) made changes -
          Production Due Date 16/Nov/2017 25/Nov/2017
          gaurav.sodani Gaurav Sodani (Inactive) made changes -
          Hide
          gaurav.sodani Gaurav Sodani (Inactive) added a comment - - edited

          Hi All,
          Attaching production deployment approval email for reference:
          Re Request for Production deployment - 25 Nov 2017.msg
          Regards
          Gaurav

          Show
          gaurav.sodani Gaurav Sodani (Inactive) added a comment - - edited Hi All, Attaching production deployment approval email for reference: Re Request for Production deployment - 25 Nov 2017.msg Regards Gaurav
          gaurav.sodani Gaurav Sodani (Inactive) made changes -
          Approval status Approved for development [ 18453 ] Approved for production deployment [ 18457 ]
          khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
          Item State Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) Parent values: Production QA(10203)Level 1 values: Production Deployed(10221)
          jaideep.vinchurkar Jaideep Vinchurkar (Inactive) logged work - 27/Nov/17 07:11 PM
          • Time Spent:
            2.5h
             

            script revert and testing

          jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
          Time Spent 2.5h [ 9000 ] 5h [ 18000 ]
          Worklog Id 93032 [ 93032 ]
          hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
          Assignee Priya Handepatil [ priya.handepatil ] Hrishikesh Deshpande [ hrishikesh.deshpande ]
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Assignee Hrishikesh Deshpande [ hrishikesh.deshpande ] Mahendra Mungase [ mahendra.mungase ]
          mahendra.mungase Mahendra Mungase (Inactive) made changes -
          Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
          mahendra.mungase Mahendra Mungase (Inactive) made changes -
          Item State Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) Parent values: Production QA(10203)Level 1 values: In Testing(10218)
          mahendra.mungase Mahendra Mungase (Inactive) made changes -
          Resolution Done [ 10000 ]
          Status Production Testing [ 10202 ] Production Complete [ 10028 ]
          mahendra.mungase Mahendra Mungase (Inactive) made changes -
          Item State Parent values: Production QA(10203)Level 1 values: In Testing(10218) Parent values: Production Complete(10222)
          mahendra.mungase Mahendra Mungase (Inactive) made changes -
          Item State Parent values: Production Complete(10222) Parent values: Production Complete(10222)Level 1 values: Closed(10223)
          mahendra.mungase Mahendra Mungase (Inactive) made changes -
          Resolution Done [ 10000 ] Fixed [ 1 ]
          Status Production Complete [ 10028 ] Closed [ 6 ]
          mahendra.mungase Mahendra Mungase (Inactive) logged work - 30/Nov/17 04:19 AM
          • Time Spent:
            1h
             

            Bug verification on Azure

          mahendra.mungase Mahendra Mungase (Inactive) made changes -
          Time Spent 5h [ 18000 ] 6h [ 21600 ]
          Worklog Id 93796 [ 93796 ]
          rakeshr Rakesh Roy (Inactive) made changes -
          Status Closed [ 6 ] Reopen in Production [ 10027 ]
          rakeshr Rakesh Roy (Inactive) made changes -
          Item State Parent values: Production Complete(10222)Level 1 values: Closed(10223) Parent values: Production QA(10203)
          rakeshr Rakesh Roy (Inactive) made changes -
          Item State Parent values: Production QA(10203) Parent values: Production QA(10203)Level 1 values: Re-open(10220)
          rakeshr Rakesh Roy (Inactive) made changes -
          Assignee Mahendra Mungase [ mahendra.mungase ] Sudhir Kalikate [ sudhir.kalikate ]
          mahendra.mungase Mahendra Mungase (Inactive) made changes -
          Comment [ We have verified this issue on production and observed that it's working as expected.Hence closing the same.

          Thanks,
          Mahendra ]
          hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
          Item State Parent values: Production QA(10203)Level 1 values: Re-open(10220) Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)
          hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
          Status Reopen in Production [ 10027 ] In Development [ 10007 ]
          hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
          Status In Development [ 10007 ] Local Testing [ 10200 ]
          hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
          Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
          Hide
          hrishikesh.deshpande Hrishikesh Deshpande (Inactive) added a comment -

          This fix is working as expected on Stage. We will move it on production in Next build and test it on production.

          The File Check-in was missed in Production which causes issue on Production.
          Swapnil Pandhare, can you please check-in code on production in next build and assign back to QA?

          Thanks,
          Hrishikesh.

          Show
          hrishikesh.deshpande Hrishikesh Deshpande (Inactive) added a comment - This fix is working as expected on Stage. We will move it on production in Next build and test it on production. The File Check-in was missed in Production which causes issue on Production. Swapnil Pandhare , can you please check-in code on production in next build and assign back to QA? Thanks, Hrishikesh.
          sudhir.kalikate Sudhir Kalikate (Inactive) made changes -
          Item State Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) Parent values: Production QA(10203)Level 1 values: Production Deployed(10221)
          Hide
          sudhir.kalikate Sudhir Kalikate (Inactive) added a comment -

          Production deployed. Please test on Production.

          Show
          sudhir.kalikate Sudhir Kalikate (Inactive) added a comment - Production deployed. Please test on Production.
          sudhir.kalikate Sudhir Kalikate (Inactive) made changes -
          Assignee Sudhir Kalikate [ sudhir.kalikate ] Hrishikesh Deshpande [ hrishikesh.deshpande ]
          sudhir.kalikate Sudhir Kalikate (Inactive) logged work - 02/Jan/18 12:15 PM
          • Time Spent:
            3h
             

            Analysis for the issue on Production.
            Checking databases. Discussion with Khandu, Swapnil.

          hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
          Assignee Hrishikesh Deshpande [ hrishikesh.deshpande ] Priya Dhamande [ priya.dhamande ]
          priya.dhamande Priya Dhamande (Inactive) made changes -
          Item State Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) Parent values: Production QA(10203)Level 1 values: In Testing(10218)
          priya.dhamande Priya Dhamande (Inactive) logged work - 02/Jan/18 01:25 PM
          • Time Spent:
            1h
             

            Production testing

          Hide
          priya.dhamande Priya Dhamande (Inactive) added a comment -

          Environment: Production
          Company: Valiant for hspl
          Login: Partner and Employee

          The issue of server error is checked on Production for server error and multiple child addition. The issue is not existing now.
          Checked with Partner and Employee login for both existing and new Employee.

          As the issue is resolved and verified assigning jira to Amanda Hagan for confirmation.

          Show
          priya.dhamande Priya Dhamande (Inactive) added a comment - Environment: Production Company: Valiant for hspl Login: Partner and Employee The issue of server error is checked on Production for server error and multiple child addition. The issue is not existing now. Checked with Partner and Employee login for both existing and new Employee. As the issue is resolved and verified assigning jira to Amanda Hagan for confirmation.
          priya.dhamande Priya Dhamande (Inactive) made changes -
          Time Spent 6h [ 21600 ] 7h [ 25200 ]
          Worklog Id 99056 [ 99056 ]
          priya.dhamande Priya Dhamande (Inactive) made changes -
          Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
          priya.dhamande Priya Dhamande (Inactive) made changes -
          Status Production Testing [ 10202 ] Production Complete [ 10028 ]
          priya.dhamande Priya Dhamande (Inactive) made changes -
          Item State Parent values: Production QA(10203)Level 1 values: In Testing(10218) Parent values: Production QA(10203)
          priya.dhamande Priya Dhamande (Inactive) made changes -
          Item State Parent values: Production QA(10203) Parent values: Production Complete(10222)
          priya.dhamande Priya Dhamande (Inactive) made changes -
          Assignee Priya Dhamande [ priya.dhamande ] Amanda Hagan [ amanda.hagan ]
          jayshree.nagpure Jayshree Nagpure (Inactive) logged work - 03/Jan/18 12:56 PM
          • Time Spent:
            2h
             

            Import Testing on production

          jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
          Status Production Complete [ 10028 ] Closed [ 6 ]
          jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
          Time Spent 7h [ 25200 ] 9h [ 32400 ]
          Worklog Id 99180 [ 99180 ]
          sudhir.kalikate Sudhir Kalikate (Inactive) made changes -
          Time Spent 9h [ 32400 ] 12h [ 43200 ]
          Worklog Id 100231 [ 100231 ]
          Transition Time In Source Status Execution Times
          Swapnil Pandhare (Inactive) made transition -
          Open In Development
          2h 1m 1
          Rakesh Roy (Inactive) made transition -
          Closed Reopen in Production
          2d 15m 1
          Hrishikesh Deshpande (Inactive) made transition -
          Reopen in Production In Development
          3d 3h 54m 1
          Hrishikesh Deshpande (Inactive) made transition -
          In Development In LB Testing
          5s 2
          Hrishikesh Deshpande (Inactive) made transition -
          In LB Testing Stage Testing
          6s 2
          Priya Dhamande (Inactive) made transition -
          Stage Testing In Production Testing
          58d 11h 23m 2
          Priya Dhamande (Inactive) made transition -
          In Production Testing Production Complete
          23m 16s 2
          Jayshree Nagpure (Inactive) made transition -
          Production Complete Closed
          23h 30m 2

            People

            Assignee:
            Amanda.Hagan Amanda Hagan (Inactive)
            Reporter:
            Amanda.Hagan Amanda Hagan (Inactive)
            Account Executive:
            Amanda Hagan (Inactive)
            Developer:
            Sudhir Kalikate (Inactive)
            QA:
            Priya Handepatil (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            10 Start watching this issue

              Dates

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

                Time Tracking

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