Modifying or deleting project state for blocked projects in BCC

Here are the commands for Deleting project from BCC

delete from avm_asset_lock where workspace_id in(select id from avm_devline where name in(select workspace from epub_project where project_id ='<<your project id>>'));

delete from EPUB_PR_HISTORY where project_id in(select project_id from epub_project where project_id = '<<your project id>>');

delete from epub_project where project_id = '<<your project id>>';

delete from EPUB_PROC_HISTORY where process_id in(select process_id from epub_process where project = '<<your project id>>');

delete from EPUB_PROC_TASKINFO where id in(select process_id from epub_process where project = '<<your project id>>');

delete  from EPUB_IND_WORKFLOW where process_id in (select process_id from epub_process where project = '<<your project id>>');

delete from epub_process where project = '<<your project id>>';

commit;

Here comes commands for Changing State of a project from blocked state

delete from avm_asset_lock where workspace_id =(select id from avm_devline where name =(select workspace from epub_project where project_id = '<<your project id>>'));

update epub_project set editable=1 where project_id = '<<your project id>>';

update avm_workspace set editable=1 where ws_id = (select id from avm_devline where name =(select workspace from epub_project where project_id = '<<your project id>>'));

update avm_workspace set locked=0 where ws_id = (select id from avm_devline where name =(select workspace from epub_project where project_id = '<<your project id>>'));

update epub_project set locked=0 where project_id = '<<your project id>>';

update epub_ind_workflow set state=3 where process_id =(select process_id from epub_process where project='<<your project id>>');

update epub_ind_workflow set state=11 where process_id =(select process_id from epub_process where project = '<<your project id>>');

commit;

For any changes done above, invalidatecaches of

/atg/epub/PublishingRepository/

/atg/epub/version/VersionManagerRepository/