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
            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.
            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.
            Permalink
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) logged work - 09/Oct/17 11:47 AM
            • Time Spent:
              0.5h
               
              <No comment>
            Permalink
            sudhir.kalikate Sudhir Kalikate (Inactive) logged work - 10/Oct/17 01:15 PM
            • Time Spent:
              1h
               
              <No comment>
            Permalink
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) logged work - 10/Oct/17 02:12 PM
            • Time Spent:
              1h
               
              <No comment>
            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.

            Permalink
            akshay.mukkawar Akshay Mukkawar (Inactive) logged work - 11/Oct/17 06:00 PM
            • Time Spent:
              0.5h
               
              <No comment>
            Permalink
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) logged work - 12/Oct/17 11:29 AM
            • Time Spent:
              0.5h
               
              <No comment>
            Permalink
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) logged work - 02/Nov/17 02:09 PM
            • Time Spent:
              0.5h
               
              <No comment>
            Permalink
            priya.dhamande Priya Dhamande (Inactive) logged work - 06/Mar/18 09:01 AM - edited
            • Time Spent:
              0.5h
               

              Production Testing

              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