Tuesday, October 16, 2018

ATG BCC Agents Clean up


 How to clean up ATG BCC agents?
Step1: execute the below sql scripts
--Agents Clean UP
delete from EPUB_TR_REP_TBL_MP;
delete from EPUB_TR_AGENTS;
delete from EPUB_TARGET;
delete from EPUB_TL_TARGETS;
delete from EPUB_PRJ_TG_SNSHT;
delete from EPUB_PR_HISTORY;
delete from EPUB_AGENT_TRNPRT;
delete from EPUB_INCLUD_ASSET;
delete from EPUB_PRINC_ASSET;
delete from EPUB_AGENT;
delete from EPUB_PR_TG_STATUS;

commit;

Step2: restart BCC 
at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

zip an empty folder structure

  find . -maxdepth 1000 -type d -exec zip ftpeu.zip {} +

  • 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...
  • zip an empty folder structure
      find . -maxdepth 1000 -type d -exec zip ftpeu.zip {} +
  • ATG BCC Agents Clean up
     How to clean up ATG BCC agents? Step1: execute the below sql scripts --Agents Clean UP delete from EPUB_TR_REP_TBL_MP; delete from E...