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

SA Utility - server error on deleting employee for CHMC

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Platform
    • Labels:
      None
    • Environment:
      Production
    • Bug Type:
      Functional
    • Bug Severity:
      Medium
    • Level:
      Partner
    • Module:
      Platform
    • Reported by:
      Harbinger

      Description

      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 "Prime_Centinela_Hospital_Medical_Center_12380", table "dbo.RaisedEventBuilder", column 'EmployeeID'.
      The statement has been terminated.
      StackTrace: at WORKTERRA.BenAdmin.BenAdminControllerAppTier.Delete(BenAdminControllerWebTierEntity objBenAdminControllerWebTierEntity)

        Attachments

          Activity

          rakeshr Rakesh Roy (Inactive) created issue -
          rakeshr Rakesh Roy (Inactive) made changes -
          Field Original Value New Value
          Environment Production [ 10005 ]
          hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
          Assignee Jaideep Vinchurkar [ jaideep.vinchurkar ] Satya [ ID10004 ]
          hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
          Priority High [ 2 ] Highest [ 1 ]
          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 ]
          swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
          Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
          swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
          Assignee Satya [ ID10004 ] Hrishikesh Deshpande [ hrishikesh.deshpande ]
          hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
          Resolution Fixed [ 1 ]
          Status Production Testing [ 10202 ] Production Complete [ 10028 ]
          hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
          Remaining Estimate 0.5h [ 1800 ]
          Original Estimate 0.5h [ 1800 ]
          hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
          Remaining Estimate 0.5h [ 1800 ] 0h [ 0 ]
          Time Spent 0.5h [ 1800 ]
          Worklog Id 83888 [ 83888 ]
          hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
          Status Production Complete [ 10028 ] Closed [ 6 ]
          swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
          Time Spent 0.5h [ 1800 ] 2h [ 7200 ]
          Worklog Id 83890 [ 83890 ]
          satyap Satya made changes -
          Environment_New Production [ 18442 ]

            People

            Assignee:
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive)
            Reporter:
            rakeshr Rakesh Roy (Inactive)
            QA:
            Hrishikesh Deshpande (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Time Tracking

                Estimated:
                Original Estimate - 0.5h Original Estimate - 0.5h
                0.5h
                Remaining:
                Remaining Estimate - 0h
                0h
                Logged:
                Time Spent - 2h
                2h