WORKTERRAProject Type: software

WORKTERRA

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

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

          Error Log -

          ErrorID : 0
          ErrorSource : ControllerAppTier.GetCollection->BenAdminControllerAppTier.GetData->CollectionManager.GetCollection->CollectionManager.GetSAUtilityEmployeeLookUpWithCompanyClassesCollection->CommonBusinessRoutines.CopyFileToWebServer
          ErrorMessage: The network path was not found.

          StackTrace: at WORKTERRA.BenAdmin.BenAdminControllerAppTier.GetCollection(BenAdminControllerWebTierEntity objBenAdminControllerWebTierEntity)
          at WORKTERRA.ControllerAppTier.GetCollection(Int32 intProjectsId, String strInput)
          TargetSite: System.String GetCollection(ValueObjects.BenAdminControllerWebTierEntity)

          Show
          hrishikesh.deshpande Hrishikesh Deshpande (Inactive) added a comment - Error Log - ErrorID : 0 ErrorSource : ControllerAppTier.GetCollection->BenAdminControllerAppTier.GetData->CollectionManager.GetCollection->CollectionManager.GetSAUtilityEmployeeLookUpWithCompanyClassesCollection->CommonBusinessRoutines.CopyFileToWebServer ErrorMessage: The network path was not found. StackTrace: at WORKTERRA.BenAdmin.BenAdminControllerAppTier.GetCollection(BenAdminControllerWebTierEntity objBenAdminControllerWebTierEntity) at WORKTERRA.ControllerAppTier.GetCollection(Int32 intProjectsId, String strInput) TargetSite: System.String GetCollection(ValueObjects.BenAdminControllerWebTierEntity)
          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 ]
          Hide
          Permalink
          swapnil.pandhare Swapnil Pandhare (Inactive) added a comment -

          Hi Hrishikesh Deshpande ,

          We have corrected data for EHMC ,CHMC, Rogers memorial hospital and Prime healthcare.
          This will be permanently fixed when SA utility error patch will be moved to production.

          Thanks,
          Swapnil P.

          Show
          swapnil.pandhare Swapnil Pandhare (Inactive) added a comment - Hi Hrishikesh Deshpande , We have corrected data for EHMC ,CHMC, Rogers memorial hospital and Prime healthcare. This will be permanently fixed when SA utility error patch will be moved to production. Thanks, Swapnil P.
          swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
          Assignee Satya [ ID10004 ] Hrishikesh Deshpande [ hrishikesh.deshpande ]
          Hide
          Permalink
          hrishikesh.deshpande Hrishikesh Deshpande (Inactive) added a comment -

          Issue is Fixed on Production.

          Show
          hrishikesh.deshpande Hrishikesh Deshpande (Inactive) added a comment - Issue is Fixed on Production.
          hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
          Resolution Fixed [ 1 ]
          Status Production Testing [ 10202 ] Production Complete [ 10028 ]
          Permalink
          hrishikesh.deshpande Hrishikesh Deshpande (Inactive) logged work - 09/Oct/17 12:01 PM
          • Time Spent:
            0.5h
             
            <No comment>
          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 ]
          Permalink
          swapnil.pandhare Swapnil Pandhare (Inactive) logged work - 09/Oct/17 12:02 PM
          • Time Spent:
            1.5h
             

            Analysis and correction

          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 ]
          Transition Time In Source Status Execution Times
          Swapnil Pandhare (Inactive) made transition -
          Open In Development
          		1d 21h 13m 1
          Swapnil Pandhare (Inactive) made transition -
          In Development In LB Testing
          		6s 1
          Swapnil Pandhare (Inactive) made transition -
          In LB Testing Stage Testing
          		2s 1
          Swapnil Pandhare (Inactive) made transition -
          Stage Testing In Production Testing
          		2s 1
          Hrishikesh Deshpande (Inactive) made transition -
          In Production Testing Production Complete
          		9m 52s 1
          Hrishikesh Deshpande (Inactive) made transition -
          Production Complete Closed
          		1m 3s 1

            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