ATG BCC cleanup projects

How to clean ATG BCC open projects?


Please do the following steps.

1. Execute the below SQL scripts

--Project Clean UP
delete from EPUB_PROJECT;
delete from EPUB_PR_TG_AP_TS;
delete from EPUB_DEPLOYMENT;
delete from EPUB_PR_TG_DP_TS;
delete from EPUB_PROC_HISTORY;
delete from EPUB_PR_TG_DP_ID;
delete from EPUB_INT_PRJ_HIST;
delete from EPUB_PROC_TASKINFO;
delete from EPUB_WORKFLOW_STRS;
delete from EPUB_IND_WORKFLOW;
delete from EPUB_PROCESS;
delete from EPUB_PR_HISTORY;
delete from EPUB_PROC_HISTORY;
delete from avm_asset_lock;

commit;

2. Restart BCC.  You can avoid a restart by clearing pushing repository and product catalog version repository but restart is only recommended.