11-16-2012 02:09 PM
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.
01-01-2013 08:23 AM
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,
01-01-2013 07:06 PM
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.
01-01-2013 09:56 PM