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
          niteen.surwase Niteen Surwase (Inactive) created issue -
          niteen.surwase Niteen Surwase (Inactive) made changes -
          Field Original Value New Value
          Assignee Jaideep Vinchurkar [ jaideep.vinchurkar ] Niteen Surwase [ niteen.surwase ]
          niteen.surwase Niteen Surwase (Inactive) made changes -
          Module Parent values: BenAdmin(10100) Parent values: Platform(10106)
          niteen.surwase Niteen Surwase (Inactive) made changes -
          Assignee Niteen Surwase [ niteen.surwase ] Swapnil Pandhare [ swapnil.pandhare ]
          niteen.surwase Niteen Surwase (Inactive) made changes -
          Description Below error throws on admin user deletetion:

          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

          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)
          niteen.surwase Niteen Surwase (Inactive) made changes -
          Description SP : OES_SP_DeleteAdminUser

          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)
          		 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
          swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
          Assignee Swapnil Pandhare [ swapnil.pandhare ] Sheetal Bodhale [ sheetal.bodhale ]
          rakeshr Rakesh Roy (Inactive) made changes -
          Issue Category Harbinger [ 10700 ] EBS [ 10350 ]
          rakeshr Rakesh Roy (Inactive) made changes -
          Account Executive Deborah Mascot [ deborah.mascot@ebsbenefits.com ]
          Bug Type Functional [ 15402 ]
          Environment Stage [ 10004 ]
          Level Partner [ 15802 ]
          Stage Company Name Lily
          sheetal.bodhale Sheetal Bodhale (Inactive) made changes -
          Status Open [ 1 ] In Development [ 10007 ]
          sheetal.bodhale Sheetal Bodhale (Inactive) made changes -
          Item State Parent values: Development(10200)Level 1 values: In Analysis(10204)
          sheetal.bodhale Sheetal Bodhale (Inactive) made changes -
          Assignee Sheetal Bodhale [ sheetal.bodhale ] Indraprakash Tiwari [ indraprakash ]
          indraprakash Indraprakash Tiwari (Inactive) made changes -
          Assignee Indraprakash Tiwari [ indraprakash ] Niteen Surwase [ niteen.surwase ]
          swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
          Assignee Niteen Surwase [ niteen.surwase ] Deborah Mascot [ deborah.mascot@ebsbenefits.com ]
          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 ]
          sheetal.bodhale Sheetal Bodhale (Inactive) made changes -
          Remaining Estimate 0h [ 0 ]
          Time Spent 6.7h [ 24120 ]
          Worklog Id 84763 [ 84763 ]
          niteen.surwase Niteen Surwase (Inactive) made changes -
          Time Spent 6.7h [ 24120 ] 9.7h [ 34920 ]
          Worklog Id 85023 [ 85023 ]
          niteen.surwase Niteen Surwase (Inactive) made changes -
          Worklog Id 85023 [ 85023 ]
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
          Time Spent 9.7h [ 34920 ] 11.7h [ 42120 ]
          Worklog Id 87893 [ 87893 ]
          satyap Satya made changes -
          Environment_New Stage [ 18443 ]
          rakeshr Rakesh Roy (Inactive) made changes -
          Item State Parent values: Development(10200)Level 1 values: In Analysis(10204) Parent values: Production Complete(10222)Level 1 values: Closed(10223)
          rakeshr Rakesh Roy (Inactive) made changes -
          Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
          rakeshr Rakesh Roy (Inactive) made changes -
          Resolution Done [ 10000 ]
          Status Production Testing [ 10202 ] Production Complete [ 10028 ]
          rakeshr Rakesh Roy (Inactive) made changes -
          Resolution Done [ 10000 ] Fixed [ 1 ]
          Status Production Complete [ 10028 ] Closed [ 6 ]

            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