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

delete from DSI_SERVER_ID;

delete from DSS_SERVER_ID;

delete from EPUB_WF_SERVER_ID;

--delete workflows

delete from EPUB_PROC_TASKINFO;
delete from EPUB_WORKFLOW_STRS;
delete epub_workflow_info;
delete epub_coll_workflow;
delete from EPUB_IND_WORKFLOW;

Read More