WORKTERRAProject Type: software

WORKTERRA

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

Stage Marquette - SA Utility - Delete - Getting Server error

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
    • Environment:
      Stage
    • Bug Type:
      Functional
    • Bug Severity:
      Critical
    • Level:
      Partner
    • Module:
      BenAdmin - Customization
    • Reported by:
      Harbinger
    • Item State:
      Stage QA - On Hold

      Description

      Getting server error on Employee delete -

      Company - Marquette

      ErrorID : 0
      ErrorSource : ControllerAppTier.Delete->BenAdminControllerAppTier.Delete->SAUtilityToolBox.Delete->SAUtilityToolBox.DeleteEmployeesAndDependents
      ErrorMessage: The DELETE statement conflicted with the REFERENCE constraint "FK_pm.RaisedEventBuilder_dbo.Employee_ID". The conflict occurred in database "MarquetteTransportation_1310", table "dbo.RaisedEventBuilder", column 'EmployeeID'.
      The statement has been terminated.
      StackTrace: at WORKTERRA.BenAdmin.BenAdminControllerAppTier.Delete(BenAdminControllerWebTierEntity objBenAdminControllerWebTierEntity)
      at WORKTERRA.ControllerAppTier.Delete(Int32 intProjectsId, String strInput)
      TargetSite: System.String Delete(ValueObjects.BenAdminControllerWebTierEntity)

        Attachments

          Issue Links

          duplicates

          Bug - A problem which impairs or prevents the functions of the product. WT-11417 Intrepid USA - SA Utility- Server error on employee delete.

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

          Support Activity - Support Activity WT-11515 COB - SA Utility Not Deleting Employees

          • High - Serious problem that could block progress.
          • Resolved
          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. WT-11491 Charleys - please delete test members

          • Medium - Has the potential to affect progress.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. NF-5148 Marquette - SA Utility - Delete - Getting Server error

          • High - Serious problem that could block progress.
          • Production Complete

            Activity

            Ascending order - Click to sort in descending order
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) created issue -
            rakeshr Rakesh Roy (Inactive) made changes -
            Field Original Value New Value
            Link This issue duplicates WT-11417 [ WT-11417 ]
            Hide
            Permalink
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) added a comment -

            same issue observed on Intrepid USA company on stage.

            Show
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) added a comment - same issue observed on Intrepid USA company on stage.
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Assignee Jaideep Vinchurkar [ jaideep.vinchurkar ] Swapnil Pandhare [ swapnil.pandhare ]
            Hide
            Permalink
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) added a comment -

            Hi Swapnil Pandhare,

            This error is observed on 3 companies on stage. please look into this on priority.
            same error on Karma main company on Stage.

            Thanks,
            Hrishikesh.

            CC : Satya Rakesh Roy Jaideep Vinchurkar

            Show
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) added a comment - Hi Swapnil Pandhare , This error is observed on 3 companies on stage. please look into this on priority. same error on Karma main company on Stage. Thanks, Hrishikesh. CC : Satya Rakesh Roy Jaideep Vinchurkar
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Priority High [ 2 ] Highest [ 1 ]
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Bug Severity Critical [ 16701 ] Blocker [ 16700 ]
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Bug Severity Blocker [ 16700 ] Critical [ 16701 ]
            swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
            Assignee Swapnil Pandhare [ swapnil.pandhare ] Sudhir Kalikate [ sudhir.kalikate ]
            Permalink
            sudhir.kalikate Sudhir Kalikate (Inactive) logged work - 05/Oct/17 01:04 PM
            • Time Spent:
              3h
               
              1. Internal discussion with Akshay.
              2. Prepared database script.
              3. Unit tested on local.
              4. Review request.
            sudhir.kalikate Sudhir Kalikate (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            sudhir.kalikate Sudhir Kalikate (Inactive) made changes -
            Remaining Estimate 16h [ 57600 ]
            Original Estimate 16h [ 57600 ]
            sudhir.kalikate Sudhir Kalikate (Inactive) made changes -
            Remaining Estimate 16h [ 57600 ] 13h [ 46800 ]
            Time Spent 3h [ 10800 ]
            Worklog Id 83649 [ 83649 ]
            Permalink
            sudhir.kalikate Sudhir Kalikate (Inactive) logged work - 06/Oct/17 01:19 PM
            • Time Spent:
              3h
               
              1. Code changes.
              2. Unit test fro multiple employees on local.
              3. Code committed to trunk and LB.
            sudhir.kalikate Sudhir Kalikate (Inactive) made changes -
            Remaining Estimate 13h [ 46800 ] 10h [ 36000 ]
            Time Spent 3h [ 10800 ] 6h [ 21600 ]
            Worklog Id 83665 [ 83665 ]
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            sudhir.kalikate Sudhir Kalikate (Inactive) made changes -
            Assignee Sudhir Kalikate [ sudhir.kalikate ] Hrishikesh Deshpande [ hrishikesh.deshpande ]
            Hide
            Permalink
            sudhir.kalikate Sudhir Kalikate (Inactive) added a comment -

            Concern : Getting server error while deleting employee from SA Utility.
            Cause: Employee was not deleted from RaisedEventBuilder table. So, getting foreign key constraint error.
            Correction: Added delete employee statement from RaisedEventBuilder table at employee deletion for SA Utility.

            Show
            sudhir.kalikate Sudhir Kalikate (Inactive) added a comment - Concern : Getting server error while deleting employee from SA Utility. Cause: Employee was not deleted from RaisedEventBuilder table. So, getting foreign key constraint error. Correction: Added delete employee statement from RaisedEventBuilder table at employee deletion for SA Utility.
            Permalink
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) logged work - 09/Oct/17 11:47 AM
            • Time Spent:
              0.5h
               
              <No comment>
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Remaining Estimate 10h [ 36000 ] 9.5h [ 34200 ]
            Time Spent 6h [ 21600 ] 6.5h [ 23400 ]
            Worklog Id 83884 [ 83884 ]
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Production Due Date 11/Oct/2017
            Stage Due Date 10/Oct/17 [ 2017-10-10 ]
            Hide
            Permalink
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) added a comment -

            This issue is working as expected on LB. Ready for stage.

            Show
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) added a comment - This issue is working as expected on LB. Ready for stage.
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
            Link This issue duplicates WT-11515 [ WT-11515 ]
            swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
            Developer Sudhir Kalikate [ sudhir.kalikate ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Link This issue is duplicated by WT-11491 [ WT-11491 ]
            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)
            sudhir.kalikate Sudhir Kalikate (Inactive) made changes -
            Code Reviewed By Swapnil Pandhare [ 11900 ]
            Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
            akshay.mukkawar Akshay Mukkawar (Inactive) made changes -
            Remaining Estimate 9.5h [ 34200 ] 8.5h [ 30600 ]
            Time Spent 6.5h [ 23400 ] 7.5h [ 27000 ]
            Worklog Id 84148 [ 84148 ]
            Permalink
            sudhir.kalikate Sudhir Kalikate (Inactive) logged work - 10/Oct/17 01:15 PM
            • Time Spent:
              1h
               
              <No comment>
            sudhir.kalikate Sudhir Kalikate (Inactive) made changes -
            Remaining Estimate 8.5h [ 30600 ] 7.5h [ 27000 ]
            Time Spent 7.5h [ 27000 ] 8.5h [ 30600 ]
            Worklog Id 84171 [ 84171 ]
            hrishikesh.deshpande Hrishikesh Deshpande (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: Ready for Production(10217)
            Permalink
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) logged work - 10/Oct/17 02:12 PM
            • Time Spent:
              1h
               
              <No comment>
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Remaining Estimate 7.5h [ 27000 ] 6.5h [ 23400 ]
            Time Spent 8.5h [ 30600 ] 9.5h [ 34200 ]
            Worklog Id 84211 [ 84211 ]
            Permalink
            akshay.mukkawar Akshay Mukkawar (Inactive) logged work - 11/Oct/17 12:47 AM - edited
            • Time Spent:
              2h
               

              Internal discussion with Sudhir
              Create database script.

            akshay.mukkawar Akshay Mukkawar (Inactive) made changes -
            Remaining Estimate 6.5h [ 23400 ] 5.5h [ 19800 ]
            Time Spent 9.5h [ 34200 ] 10.5h [ 37800 ]
            Worklog Id 84148 [ 84148 ]
            akshay.mukkawar Akshay Mukkawar (Inactive) made changes -
            Remaining Estimate 5.5h [ 19800 ] 5h [ 18000 ]
            Time Spent 10.5h [ 37800 ] 11h [ 39600 ]
            Worklog Id 84250 [ 84250 ]
            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)
            Permalink
            akshay.mukkawar Akshay Mukkawar (Inactive) logged work - 11/Oct/17 06:00 PM
            • Time Spent:
              0.5h
               
              <No comment>
            rakeshr Rakesh Roy (Inactive) made changes -
            Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            Permalink
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) logged work - 12/Oct/17 11:29 AM
            • Time Spent:
              0.5h
               
              <No comment>
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Remaining Estimate 5h [ 18000 ] 4.5h [ 16200 ]
            Time Spent 11h [ 39600 ] 11.5h [ 41400 ]
            Worklog Id 84500 [ 84500 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Resolution Unresolved [ 10200 ]
            Status Production Testing [ 10202 ] Reopen in Production [ 10027 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Status Reopen in Production [ 10027 ] In Development [ 10007 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            QA Hrishikesh Deshpande [ hrishikesh.deshpande ]
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            rakeshr Rakesh Roy (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)
            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)
            satyap Satya made changes -
            Labels SA_Utility
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)
            Permalink
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) logged work - 02/Nov/17 02:09 PM
            • Time Spent:
              0.5h
               
              <No comment>
            Hide
            Permalink
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) added a comment -

            This issue is Working as expected on Stage. Ready for Production.

            Show
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) added a comment - This issue is Working as expected on Stage. Ready for Production.
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Remaining Estimate 4.5h [ 16200 ] 4h [ 14400 ]
            Time Spent 11.5h [ 41400 ] 12h [ 43200 ]
            Worklog Id 88880 [ 88880 ]
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
            satyap Satya made changes -
            Environment_New Stage [ 18443 ]
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Production Due Date 11/Oct/2017 25/Nov/2017
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Production Due Date 25/Nov/2017
            sudhir.kalikate Sudhir Kalikate (Inactive) made changes -
            Link This issue is cloned by NF-5148 [ NF-5148 ]
            sudhir.kalikate Sudhir Kalikate (Inactive) made changes -
            Link This issue is cloned by NF-5148 [ NF-5148 ]
            sudhir.kalikate Sudhir Kalikate (Inactive) made changes -
            Link This issue relates to NF-5148 [ NF-5148 ]
            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)
            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 ]
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Attachment Screenshot (172).png [ 74131 ]
            Permalink
            priya.dhamande Priya Dhamande (Inactive) logged work - 06/Mar/18 09:01 AM - edited
            • Time Spent:
              0.5h
               

              Production Testing

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

            Environment: Production
            Login: Partner

            The issue of deete employee with SA utility giving error is verified and resolved on poduction.

            Screen capture attached with jira. So, closing jira on production.

            Sachin Hingole Hrishikesh Deshpande

            Show
            priya.dhamande Priya Dhamande (Inactive) added a comment - Environment: Production Login: Partner The issue of deete employee with SA utility giving error is verified and resolved on poduction. Screen capture attached with jira. So, closing jira on production. Sachin Hingole Hrishikesh Deshpande
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Remaining Estimate 4h [ 14400 ] 3.75h [ 13500 ]
            Time Spent 12h [ 43200 ] 12.25h [ 44100 ]
            Worklog Id 107175 [ 107175 ]
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Resolution Unresolved [ 10200 ] Done [ 10000 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Status Production Complete [ 10028 ] Closed [ 6 ]
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Remaining Estimate 3.75h [ 13500 ] 3.5h [ 12600 ]
            Time Spent 12.25h [ 44100 ] 12.5h [ 45000 ]
            Worklog Id 107175 [ 107175 ]
            Transition Time In Source Status Execution Times
            Sudhir Kalikate (Inactive) made transition -
            Open In Development
            		8d 23h 35m 1
            Rakesh Roy (Inactive) made transition -
            In Production Testing Reopen in Production
            		9h 17m 1
            Rakesh Roy (Inactive) made transition -
            Reopen in Production In Development
            		6s 1
            Rakesh Roy (Inactive) made transition -
            In Development In LB Testing
            		3d 59m 2
            Gaurav Sodani (Inactive) made transition -
            In LB Testing Stage Testing
            		22d 18h 50m 2
            Rakesh Roy (Inactive) made transition -
            Stage Testing In Production Testing
            		124d 16h 46m 2
            Priya Dhamande (Inactive) made transition -
            In Production Testing Production Complete
            		1h 21m 1
            Priya Dhamande (Inactive) made transition -
            Production Complete Closed
            		3s 1

              People

              Assignee:
              hrishikesh.deshpande Hrishikesh Deshpande (Inactive)
              Reporter:
              hrishikesh.deshpande Hrishikesh Deshpande (Inactive)
              Developer:
              Sudhir Kalikate (Inactive)
              QA:
              Hrishikesh Deshpande (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

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

                  Time Tracking

                  Estimated:
                  Original Estimate - 16h
                  16h
                  Remaining:
                  Time Spent - 12.5h Remaining Estimate - 3.5h
                  3.5h
                  Logged:
                  Time Spent - 12.5h Remaining Estimate - 3.5h
                  12.5h