Accelerating the deployments in BCC

Clean up the Publishing DB using following scripts to accelerate deployments in BCC. Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 ...

Retaining Project to previous stage in BCC

Retaining Project to previous stage in BCC Normal 0 false false false EN-US X-NONE X-NONE ...

Completely delete project from versioned DB

Completely delete project from versioned DB Find out the Project Id using the following query. select project_id from epub_project where display_name='<Your Project Name>'; Execute the following queries using the project id. -- 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 = '<Your Project ID>')); -- delete history of the project delete from EPUB_PR_HISTORY where project_id in (select project_id...

Delete all Server Ids and Workflows in BCC

Delete all Server Ids and Workflows in BCC To be done, when you are unable to create projects connecting to new publishing database OR when workflows not loading up. --delete server ids Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 ...

Delete all Projects & Agents in BCC

Delete all Project & Agents in BCC --Agents Clean UP 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; --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...

Non-versioned Repositories in BCC

Non-versioned Repositories in BCC This section explains about managing the non-versioned repositories (Orders, Inventory) in BCC. It includes series of steps, in which we will be updating the OOTB files as well as creating custom files too. BCC HomePage Inventory HomePage Step 1: Create custom GenericActiviy in following path. /config/my/activity/genericActivities.xml <?xml version="1.0" encoding="UTF-8" standalone="no"?> <!DOCTYPE...