Cannot Delete User in DLO Console, stuck in "Delete Pending" state
Hello,
When using Backup Exec for Windows Servers Desktop and Laptop Option (DLO) - User or Computer is stuck in a Delete Pending State.
Details:
# The User Account is stuck at "DeletePending" State.
In Backup Exec for Windows 11d and 12d DLOusers do not get deleted from the console immediately after they areDeleted. They will stay in a Delete Pending state normally for about 15minutes. In some cases they may stay in this state and neverdelete. The most common reason for this is that the Network User DataFolder (NUDF) was manually deleted prior to removing the user from theconsole.
The following are steps to manually delete users from thedatabase.
NOTE: Use BEUTILITY to DUMP "backup" the DLOdatabase. Copy saved database X:\program files\Symantec\backupexec\data\BE_DLO.BAK to a safe location.
The delete userscript deletes by UserID so the first thing we have to do is find out the userID.
NOTE:Clean installs of Backup Exec 11 and 12 will use the BKUPEXEC instance for both the BE database and the DLO database. Upgrades from previous versionswill have separate instances and the DLO instance maybeBKUPEXECDLO. Verify the instance name is correct before running thecommands below.
From a CMDprompt type the following:
osql -E -S%COMPUTERNAME%\bkupexec -d BE_DLO
1> selectUserID from SUser where UserName = 'username'
2> go
(NOTE:'username' above = the name of the user)
Then take theUserID returned and type:
osql -E -S%COMPUTERNAME%\bkupexec -d BE_DLO
1> EXECUTEDelete_User 'ID'
2> go
You can run thedelete for multiple users after running the first part to get all the usernames.
osql -E -S%COMPUTERNAME%\bkupexec -d BE_DLO
1> EXECUTEDelete_User 'ID'
2> EXECUTEDelete_User 'ID2'
3> EXECUTEDelete_User 'ID3'
4>go
After the command gets executed refresh the DLO Administration console and verify that theuser/s are deleted and no longer shows up "Delete Pending"
# The Computer Account is stuck at "Delete Pending" State
The Cause of this is most likely to be the change inHostName of a Workstation. The following are steps to manually delete oldcomputers from the database which do not exist physically on the network and arestuck at "Delete Pending" state when an attempt is made to delete them from DLOConsole.
NOTE: Use BEUTILITY to DUMP "backup" the DLOdatabase. Copy saved database X:\program files\Symantec\backupexec\data\BE_DLO.BAK to a safe location.
The deletemachine script deletes by MachineID so the first thing we have to do is find outthe Machine ID.
NOTE:Clean installs of Backup Exec 11 and 12 will use the BKUPEXEC instance forboth the BE database and the DLO database. Upgrades from previous versionswill have separate instances and the DLO instance maybeBKUPEXECDLO. Verify the instance name is correct before running thecommands below.
From a CMDprompt type the following:
osql -E -S%COMPUTERNAME%\bkupexec -d BE_DLO
1> selectMSID from MachineSettings where MSName = 'ComputerName'
2> GO
(NOTE:'ComputerName' above = the Host Name of the Computer as it appears in DLOConsole)
Then take theMachineID returned and type:
1> EXECDelete_Machine 'MachineID'
e.g.EXEC Delete_Machine 43
2> GO
Launch DLOConsole and confirm that Computer Account no longer shows "Delete Pending" Stateand is deleted.
