If you want to unlock any Siebel object locked in Sample/Local DB by any other user. Don't be depressed. Just follow these steps and you will get pleasure.
Go to siebel bin folder and search "dbisqlc.exe". Just open this fine and select Database file. Go to Login Tab and enter credentials and click on OK.
After successful connection to db, you will get SQL editor. Just copy and paste below SQL command by updating object name and table to be unlocked.
select t.row_id, t.name, t.obj_locked_flg,t.locked_flg,t.locked_date,t.locked_by, t.locked_langfrom s_project twhere name ='Object Name'
Just update the object locks flag or lock flag, and your object is free again,
Most used objects tables:-
a. S_TABLE
b. S_BUSCOMP
c. S_BUSOBJ
d. S_APPLET
e. S_VIEW
f. S_SCREEN
g. S_SERVICE
h. S_PROJECT
i. S_REPORT
j. S_PICKLIST
k. S_LINK
No comments:
Post a Comment