Thursday, June 2, 2011

Siebel - Unlock Repository Objects Using Database Queries

UNLOCK REPOSITORY OBJECTS

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-CDGI-1MIPC’;
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-CDGI-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-CDGI-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-CDGI-1I9E2';
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 AS PROJ SET PROJ.LOCKED_FLG = 'N', PROJ.LOCKED_DATE = NULL
WHERE PROJ.NAME = 'Account Hierarchy';
COMMIT;

Note:-
How to find out the row id of any object?
Go to Siebel tools
Select object(Applet/BC/View) -> Help -> About Record -> Details
Row# will give the Row Id details.

Most cases is because of the object (BC/BO/Applet/Project/etc..) were locked by "" or invalid user id. If the user exists.. do ask the person to unlocked for u first :)

No comments: