4 Feb 2016

Totally remove BCC project


If you unable to remove project in BCC menus,
please use sql below in case you need to remove a project from BCC

-- Removing locks of the project if any
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 = 'project488006'));
-- delete history of the project
delete from EPUB_PR_HISTORY where project_id in
(select project_id from epub_project where project_id = 'project488006');
-- delete the project
delete  from epub_project where project_id = 'project488006';
-- delete history of the process
delete from EPUB_PROC_HISTORY where process_id in
(select process_id from epub_process where project = 'project488006');
-- delete task information of process
delete from EPUB_PROC_TASKINFO where id in
(select process_id from epub_process where project = 'project488006');
-- delete states of project (if any)
delete  from EPUB_IND_WORKFLOW where process_id in
(select process_id from epub_process where project = 'project488006');
-- finally delete the process
delete from epub_process  where project = 'project488006';
commit;

You don't need to restart BCC but just invalidate below repository caches:
/atg/epub/PublishingRepository/
/atg/epub/version/VersionManagerRepository/