Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
languagesql
titleDelete execution data in target FlexDeploy database
delete from FD.TEST_DEF_QUALIFIER_VALUE;
delete from FD.ARC_TEST_DEF_QUAL_VALUE;
delete from FD.TEST_RESULT;
delete from FD.ARC_TEST_RESULT;
delete from FD.TEST_DEFINITION_RUN;
delete from FD.ARC_TEST_DEFINITION_RUN;
delete from FD.TEST_SET_QUALIFIER_VALUE;
delete from FD.ARC_TEST_SET_QUALIFIER_VALUE;
delete from FD.TEST_SET_RUN;
delete from FD.ARC_TEST_SET_RUN;
delete from FD.TEST_RUN;
delete from FD.ARC_TEST_RUN;
delete from FD.PLUGIN_EXECUTION_OUTPUT_VALUE;
delete from FD.ARC_PLUGIN_EXEC_OUTPUT_VALUE;
delete from FD.PLUGIN_EXECUTION_OUTPUT;
delete from FD.ARC_PLUGIN_EXECUTION_OUTPUT;
delete from FD.PLUGIN_EXECUTION_LOG;
delete from FD.ARC_PLUGIN_EXECUTION_LOG;
delete from FD.PACKAGE_OBJECT_EXECUTION;
delete from FD.ARC_PACKAGE_OBJECT_EXECUTION;
delete from FD.PLUGIN_EXECUTION;
delete from FD.ARC_PLUGIN_EXECUTION;
delete from FD.WORKFLOW_EXECUTION_DATA;
delete from FD.ARC_WORKFLOW_EXECUTION_DATA;
delete from FD.WORKFLOW_EXECUTION;
delete from FD.ARC_WORKFLOW_EXECUTION;
delete from FD.WORKFLOW_REQUEST_INPUT;
delete from FD.ARC_WORKFLOW_REQUEST_INPUT;
delete from FD.SCHEDULED_TASK;
delete from FD.ARC_SCHEDULED_TASK;
delete from FD.HUMAN_TASK;
delete from FD.ARC_HUMAN_TASK;
delete from FD.FOLDER_REQUEST_CURRENT_STATE;
delete from FD.PROJECT_WF_CURRENT_STATUS;
delete from FD.PACKAGE_OBJ_CURRENT_STATUS;
delete from FD.WORKFLOW_REQUEST_INST;
delete from FD.ARC_WORKFLOW_REQUEST_INST;
delete from FD.WORKFLOW_REQUEST_CMS_ISSUE;
delete from FD.ARC_WORKFLOW_REQ_CMS_ISSUE;
delete from FD.WORKFLOW_REQUEST;
delete from FD.ARC_WORKFLOW_REQUEST;
delete from FD.FOLDER_REQUEST;
delete from FD.ARC_FOLDER_REQUEST;
delete from FD.FOLDER_PROJECT_VERSION;
delete from FD.ARC_FOLDER_PROJECT_VERSION;
delete from FD.PROJECT_VERSION_DATA_VAL;
delete from FD.ARC_PROJECT_VERSION_DATA_VAL;
delete from FD.PROJECT_VERSION_DATA;
delete from FD.ARC_PROJECT_VERSION_DATA;
delete from FD.PACKAGE_OBJECT;
delete from FD.ARC_PACKAGE_OBJECT;
delete from FD.PROJECT_VERSION; 
delete from FD.ARC_PROJECT_VERSION;
delete from FD.FOLDER_VERSION;
delete from FD.ARC_FOLDER_VERSION;
delete from FD.FOLDER_REQUEST_CURRENT_STATE;
delete from FD.PROJECT_WF_CURRENT_STATUS;
delete from FD.PACKAGE_OBJ_CURRENT_STATUS;
delete from FD.PURGE_FOLDER_VERSION_KEY;
delete from FD.PURGE_PROJ_VERSION_KEY;
delete from FF.SEQUENCE_BLOCK where SEQ_NAM like 'stream-%';
delete from FD_ADMIN.PS_TXN;
commit;

...