Siebel SQLs/Error Messages >  How to delete a lock in Siebel Tools

How to delete a lock in Siebel Tools

It is quite common for programmers to lock a Project/Workflow/Business Component and forget to unlock it when the programming is over. Or maybe some colleague is not cooperative and wants to control the situation, you can reset this lock quite easily using SQLs.

Here are the SQLs to delete locks on

VIEW

UPDATE SIEBEL.S_VIEW BC SET BC.OBJ_LOCKED_FLG = 'N', BC.OBJ_LOCKED_DATE = NULL,
BC.OBJ_LOCKED_BY = NULL, BC.OBJ_LOCKED_LANG = NULL WHERE BC.ROW_ID = '1-AFTR56';

COMMIT;

TABLE

UPDATE SIEBEL.S_TABLE TAB SET TAB.OBJ_LOCKED_FLG = 'N', TAB.OBJ_LOCKED_DATE =
NULL, TAB.OBJ_LOCKED_BY = NULL, TAB.OBJ_LOCKED_LANG = NULL
WHERE TAB.NAME = 'S_APPLICATION'
AND TAB.ROW_ID = '1-AFTR56-E5E5';

COMMIT;

BUSCOMP

UPDATE SIEBEL.S_BUSCOMP BC SET BC.OBJ_LOCKED_FLG = 'N', BC.OBJ_LOCKED_DATE =
NULL, BC.OBJ_LOCKED_BY = NULL, BC.OBJ_LOCKED_LANG = NULL
WHERE BC.ROW_ID = '1-MMN9-CD6C';

COMMIT;

BUSSERVICE

UPDATE SIEBEL.S_SERVICE SERV SET SERV.OBJ_LOCKED_FLG = 'N',
SERV.OBJ_LOCKED_DATE = NULL, SERV.OBJ_LOCKED_BY = NULL, SERV.OBJ_LOCKED_LANG = NULL WHERE SERV.ROW_ID = '1-AFTR56';

COMMIT;

APPLET

UPDATE SIEBEL.S_APPLET APPL SET APPL.OBJ_LOCKED_FLG = 'N', APPL.OBJ_LOCKED_DATE
= NULL, APPL.OBJ_LOCKED_BY = NULL, APPL.OBJ_LOCKED_LANG = NULL WHERE APPL.ROW_ID = '1-CDGI-D8I';

COMMIT;

PROJECT

UPDATE SIEBEL.S_PROJECT  PROJ SET PROJ.LOCKED_FLG = 'N', PROJ.LOCKED_DATE =
NULL WHERE PROJ.NAME = 'Account Hierarchy';

COMMIT;

WORKFLOWS

UPDATE siebel.s_wfr_proc wfp
SET OBJ_LOCKED_FLG = 'N', OBJ_LOCKED_DATE = NULL, wfp.obj_locked_by = null,
wfp.obj_locked_lang = null
WHERE wfp.proc_name = 'NC Agreement Check WF';

COMMIT;

TASKS

update siebel.s_tu_task set  obj_locked_date= NULL,

obj_locked_flg = 'N'obj_locked_by = NULL, obj_locked_lang = NULL

where row_id = 'task record id';

commit;

You can find the row ID from Siebel Tools -> Help -> About Record -> Details