Unlock siebel repository object using SQL

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 = 'replace_your_object_ID';

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 = 'replace_your_object_ID' ;

COMMIT;

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 = 'replace_your_object_ID';

commit;


PROJECT

UPDATE siebel.s_project  AS proj SET proj.locked_flg = 'N', proj.locked_date = NULL WHERE proj.name = 'your project_name';

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 = 'replace_your_object_ID';

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 = 'your Table NAME' and tab.row_id = 'replace_your_object_ID';

COMMIT;

APPLICATION

UPDATE SIEBEL.S_APPLICATION app
  SET
    app.OBJ_LOCKED_FLG = 'N',
    app.OBJ_LOCKED_DATE = NULL,
    app.OBJ_LOCKED_BY = NULL,
    app.OBJ_LOCKED_LANG = NULL
  WHERE
    app.ROW_ID ='replace_your_object_ID';

COMMIT;