This issue needs a solution.

Pending Delete on User in Symantec DLO Server

Created: 16 Nov 2012
Login to vote
0 0 Votes

We are having a rash of users that hang in Pending Delete status on our Symantec DLO server.  They sit in this status forever.  We found the following resolution on Symantec forums, and successfully got this to work once on a user (after many attempts), but cannot get to work again on other cases.  Can anyone help with resolution to this?

osql -E -S%COMPUTERNAME%\bkupexec -d BE_DLO

1> selectUserID from SUser where UserName = <username> <- enter username

2> go

**Should get a record number ID for that user record**

osql -E -S%COMPUTERNAME%\bkupexec -d BE_DLO

1> EXECUTEDelete_User <enter user ID number> <- enter user ID number from above

2> go

When we enter "go" on first command set, we get following error:
Msg 156, Level 15, State 1, Server ROS1ITSBKP001\BKUPEXEC, Line 1
Incorrect syntax near the keyword 'from'.

Cannot figure out a way around this, or how we got this to work the first time.  Please advise.
 

Filed Under

Comments

Orionex's picture
Orionex
Symantec Employee
Accredited
01
Jan
2013
Votes
0

Hello, I advise to check in

Hello,

I advise to check in SQL by using  Microsoft SQL Server Management Studio Express what going on with the database . or to contact our Technical Support in order that they help you .

Best Regards,

eavinash's picture
eavinash
Symantec Employee
01
Jan
2013
Votes
0

Once the user status is

Once the user status is displayed as 'delete pending' could you restart both the database service and the DLO administrator service. Once the services are restarted, launch the agent. All the users should be deleted.

psj_symhelp's picture
psj_symhelp
Partner
01
Jan
2013
Votes
0

Hi Make sure the agent is

Hi

Make sure the agent is uninstall from client computer then unmap user to profile.
Now delete user from DLO management console and restart DLO services.