Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 6 Next »

These steps can be useful if you are installing a new FlexDeploy environment and want to load it with specific configurations from a different environment with same FlexDeploy version.

This process should only be followed to perform configuration setup for brand new installation of FlexDeploy from another installation of FlexDeploy. Purpose of this document is to only copy configuration details and not execution data. If you run this against active Production FlexDeploy, you will lose all execution details.

This process is only applied for 4.0, 4.0.x version of FlexDeploy. Also, source and target version of FlexDeploy must be same.

  • Export data from source FlexDeploy database. You will be prompted to enter password for system user.
    • This step will create fd_bkup.dmp file with all details from FD,FF and FD_ADMIN schemas. File should be in data pump directory, for example - C:\oraclexe\app\oracle\admin\XE\dpdump.
Export data from source FlexDeploy database
expdp system directory=DATA_PUMP_DIR dumpfile=fd_bkup.dmp schemas=FD,FF,FD_ADMIN
  • Copy fd_bkup.dmp file on to target FlexDeploy database server in to data pump directory, for example - C:\oraclexe\app\oracle\admin\XE\dpdump.
  • Import data in to target FlexDeploy database. You will be prompted to enter password for system user.
    • Make sure there are no errors in import process. If there are errors, make corrections appropriately and restart import process.
Import data in to target FlexDeploy database
impdp system directory=DATA_PUMP_DIR dumpfile=fd_bkup.dmp schemas=FD,FF,FD_ADMIN
  • At this point target FlexDeploy database should be copy of source database. But in this scenario, we do not need any execution details, so let's delete execution data using following commands. Make sure to run these commands on target FlexDeploy database.
Delete 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.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;
  • We will not copy any Artifact Repository in this process, as we are not copying any execution data.
  • FlexDeploy can now be installed in target environment as per FlexDeploy Installation Guide, but skip database tier as it was already copied from a different environment.
  • At the end of installation process, start FlexDeploy and validate that your configurations are present in various screens.


  • No labels