It is very common that people lock projects and forget to unlock before leaving the company. There could also be situation where the project has to be forcibly unlocked for some reason. Yes it is possible to unlock a project where some other user has locked it.
There are two ways to do this:
- If you know the users password, login to the server using that login and unlock. But most of the times the passwords would have been changed. In this case request for a password change and then login using this new password unlock it. If this is not possible and some reason you are not able to login, then use the second method.
- This is a sure shot method of unlocking. Login to the Siebel server database with table owner siebel. Unlock the project using a SQL update on the table S_PROJECT. The NAME column of this table has the project name.
Example:
UPDATE siebel.s_project
SET locked_flg = ‘N’
WHERE NAME = ‘Account’;Seek the help of Siebel Admin if you need.
I have tried this and it has worked. Though this is very simple, do this very carefully because the changes that the user had made will not be checked in. So be sure of what you are doing.
Share with me if you know of any other tips and tricks. Send it either using the participate form or email sridhar at siebelguide dot com.
Your comments are valuable. Subscribe to RSS for more tips like this.
Related posts(Auto Generated):
June 3rd, 2008 at 6:21 pm
If you have multiple repositories, make sure you only unlock the project in the intended repository:
UPDATE SIEBEL.S_PROJECT
SET LOCKED_FLG = ‘N’
WHERE NAME = ‘Account’
AND REPOSITORY_ID = (
SELECT ROW_ID
FROM SIEBEL.S_REPOSITORY
WHERE NAME = ‘The Intended Repository’);
June 3rd, 2008 at 10:07 pm
Good point Mike. You are correct. We have to make sure the update is on the intended repository.
Thanks for Participating. If you have more ideas and would like to share, please write a blog that I can publish it over here. Thanks!
April 13th, 2010 at 6:44 pm
I think additional columns need to be updated to avoid future confusion:
update .S_PROJECT
set
locked_date = null,
locked_by = null,
locked_lang = null,
locked_flg = ‘N’
where name = ‘Project Name’
and repository_id = ‘x_xxx’;