WORKTERRAProject Type: software

WORKTERRA

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

Admin user delete issue

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Platform
    • Labels:
      None
    • Environment:
      Stage
    • Bug Type:
      Functional
    • Bug Severity:
      Medium
    • Level:
      Partner
    • Module:
      Platform
    • Reported by:
      Support
    • Stage Company Name:
      Lily
    • Item State:
      Production Complete - Closed

      Description

      Loader is disappearing before getting response from server.
      It took time to delete admin user and throws following error on deletion:

      ErrorID : 0
      ErrorSource : ControllerAppTier.Delete->WORKTERRAControllerAppTier.Delete->AdminUser.Delete->AdminUser.DeleteAdminUser
      ErrorMessage: Cannot get the data of the row from the OLE DB provider "SQLNCLI10" for linked server "MORELLOSR\MORELLOSR".
      OLE DB provider "SQLNCLI10" for linked server "MORELLOSR\MORELLOSR" returned message "Row handle referred to a deleted row or a row marked for deletion.".
      StackTrace: at WORKTERRA.Shared.WORKTERRAControllerAppTier.Delete(WORKTERRAControllerWebTierEntity objWORKTERRAControllerWebTierEntity)
      at WORKTERRA.ControllerAppTier.Delete(Int32 intProjectsId, String strInput)
      TargetSite: System.String Delete(WORKTERRA.Shared.WORKTERRAControllerWebTierEntity)

      SP : OES_SP_DeleteAdminUser
      Tables: Users, SystemUsers, CompanyAdminDataScreen, CompanySystemUser, SystemUsersAdministrativeTools

        Attachments

          Activity

          Ascending order - Click to sort in descending order
          Hide
          Permalink
          niteen.surwase Niteen Surwase (Inactive) added a comment - - edited

          Hi Swapnil Pandhare

          Please look into this issue. We are not able to reproduce this on Stage.
          It is occurred on company Lily on Stage, however it is not occurring on other companies.

          Thanks,
          Niteen

          Cc: Vinayak Kulkarni

          Show
          niteen.surwase Niteen Surwase (Inactive) added a comment - - edited Hi Swapnil Pandhare Please look into this issue. We are not able to reproduce this on Stage. It is occurred on company Lily on Stage, however it is not occurring on other companies. Thanks, Niteen Cc: Vinayak Kulkarni
          Hide
          Permalink
          swapnil.pandhare Swapnil Pandhare (Inactive) added a comment -

          CC : Satya ,

          Hi Sheetal Bodhale ,

          Please check this issue on priority.

          Thanks,
          Swapnil P.

          Show
          swapnil.pandhare Swapnil Pandhare (Inactive) added a comment - CC : Satya , Hi Sheetal Bodhale , Please check this issue on priority. Thanks, Swapnil P.
          Hide
          Permalink
          sheetal.bodhale Sheetal Bodhale (Inactive) added a comment -

          Hi Indraprakash Tiwari,

          As discussed,Please reply to client for the same.
          CC:Swapnil PandhareSatya

          Thanks,
          Sheetal Bodhale

          Show
          sheetal.bodhale Sheetal Bodhale (Inactive) added a comment - Hi Indraprakash Tiwari , As discussed,Please reply to client for the same. CC: Swapnil Pandhare Satya Thanks, Sheetal Bodhale
          Hide
          Permalink
          indraprakash Indraprakash Tiwari (Inactive) added a comment -

          I have checked database server and found error in event viewer that "Distributed Transaction Coordinator" was not responding (failed) due to utilization of other resource and network slowness. Now it is working perfectly fine.

          Please check and let us know if you still face same issue.
          Swapnil PandhareSatyaSheetal Bodhale

          Show
          indraprakash Indraprakash Tiwari (Inactive) added a comment - I have checked database server and found error in event viewer that "Distributed Transaction Coordinator" was not responding (failed) due to utilization of other resource and network slowness. Now it is working perfectly fine. Please check and let us know if you still face same issue. Swapnil Pandhare Satya Sheetal Bodhale
          Hide
          Permalink
          swapnil.pandhare Swapnil Pandhare (Inactive) added a comment -

          CC : Satya Samir

          Hi Deborah Mascot ,

          Please find details below :
          Concern : Server error while deleting admin users.

          Cause : While deleting admin users, record is deleted from another cluster. This issue occurred as distributed transaction failed. We have checked this issue with Indraprakash(DBA) and found that "Distributed Transaction Coordinator" was not responding (failed) due to utilization of other resource and network slowness when this issue occurred.

          Correction : Now , DTC("Distributed Transaction Coordinator") is working fine and this issue won’t occur as per discussion with Indraprakash.

          Please let us know if you face this issue again.

          Thanks,
          Swapnil P.

          Show
          swapnil.pandhare Swapnil Pandhare (Inactive) added a comment - CC : Satya Samir Hi Deborah Mascot , Please find details below : Concern : Server error while deleting admin users. Cause : While deleting admin users, record is deleted from another cluster. This issue occurred as distributed transaction failed. We have checked this issue with Indraprakash(DBA) and found that "Distributed Transaction Coordinator" was not responding (failed) due to utilization of other resource and network slowness when this issue occurred. Correction : Now , DTC("Distributed Transaction Coordinator") is working fine and this issue won’t occur as per discussion with Indraprakash. Please let us know if you face this issue again. Thanks, Swapnil P.

            People

            Assignee:
            Deborah.Mascot@ebsbenefits.com Deborah Mascot (Inactive)
            Reporter:
            niteen.surwase Niteen Surwase (Inactive)
            Account Executive:
            Deborah Mascot (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0h
                0h
                Logged:
                Time Spent - 11.7h
                11.7h