Topic:

Database

Ephesoft Versions:

All

Issue:

You are having issues with your database similar to the following:

  1. The Ephesoft Database has become corrupt
  2. The Database it too large
  3. You need to reload the default database for the Ephesoft application

Root Cause:

NA

Solution:

  1. Important: Before you proceed please backup Everything (Ephesoft folder and Database)
  2. Export all the batch classes from Ephesoft running on MySQL if the customer wants to move them to MSSQL
  3. Drop all the current tables in the Ephesoft Database. For this you will use the following SQL scripts.

For MS SQL:

EXEC sp_MSForEachTable ‘ALTER TABLE ? NOCHECK CONSTRAINT ALL’

GO

DROP TABLE module_plugin;

DROP TABLE advanced_kv_extraction;

DROP TABLE page_type;

DROP TABLE batch_class;

DROP TABLE plugin;

DROP TABLE batch_class_cloud_config;

DROP TABLE plugin_config;

DROP TABLE batch_class_cmis_configuration;

DROP TABLE batch_class_dynamic_plugin_config;

DROP TABLE plugin_config_sample_value;

DROP TABLE batch_class_email_configuration;

DROP TABLE plugin_dependency;

DROP TABLE batch_class_field;

DROP TABLE regex_group;

DROP TABLE batch_class_groups;

DROP TABLE regex_pattern;

DROP TABLE batch_class_module;

DROP TABLE us_invoice;

DROP TABLE regex_validation;

DROP TABLE batch_class_module_config;

DROP TABLE remote_batch_instance;

DROP TABLE batch_class_plugin;

DROP TABLE role;

DROP TABLE us_invoice_data;

DROP TABLE batch_class_plugin_config;

DROP TABLE scanner_master_config_sample_value;

DROP TABLE batch_class_scanner_configuration;

DROP TABLE scanner_master_configuration;

DROP TABLE application_checklist;

DROP TABLE batch_instance;

DROP TABLE security_group;

DROP TABLE batch_instance_error_details;

DROP TABLE vFBValidation;

DROP TABLE security_user;

DROP TABLE batch_instance_groups;

DROP TABLE security_user_group;

DROP TABLE batch_instance_retries;

DROP TABLE server_registry;

DROP TABLE service_status;

DROP TABLE document_type;

DROP TABLE table_columns_info;

DROP TABLE email_data;

DROP TABLE table_info;

DROP TABLE field_type;

DROP TABLE table_rule;

DROP TABLE user_information;

DROP TABLE function_key;

DROP TABLE hist_manual_steps_in_workflow;

DROP TABLE kv_extraction;

DROP TABLE kv_page_process;

DROP TABLE module_config;

DROP TABLE module;

DROP TABLE lock_status;

DROP TABLE JBPM4_VARIABLE;

DROP TABLE JBPM4_DEPLOYMENT;

DROP TABLE JBPM4_DEPLOYPROP;

DROP TABLE JBPM4_EXECUTION;

DROP TABLE JBPM4_HIST_VAR;

DROP TABLE JBPM4_HIST_DETAIL;

DROP TABLE JBPM4_HIST_PROCINST;

DROP TABLE JBPM4_HIST_ACTINST;

DROP TABLE JBPM4_HIST_TASK;

DROP TABLE JBPM4_SWIMLANE;

DROP TABLE JBPM4_TASK;

DROP TABLE JBPM4_PARTICIPATION;

DROP TABLE JBPM4_PROPERTY;

DROP TABLE JBPM4_LOB;

DROP TABLE JBPM4_JOB;

EXEC sp_MSForEachTable ‘ALTER TABLE ? CHECK CONSTRAINT ALL’

GO

For MySQL:

SET foreign_key_checks = 0;

DROP TABLE module_plugin;

DROP TABLE advanced_kv_extraction;

DROP TABLE page_type;

DROP TABLE batch_class;

DROP TABLE plugin;

DROP TABLE batch_class_cloud_config;

DROP TABLE plugin_config;

DROP TABLE batch_class_cmis_configuration;

DROP TABLE batch_class_dynamic_plugin_config;

DROP TABLE plugin_config_sample_value;

DROP TABLE batch_class_email_configuration;

DROP TABLE plugin_dependency;

DROP TABLE batch_class_field;

DROP TABLE regex_group;

DROP TABLE batch_class_groups;

DROP TABLE regex_pattern;

DROP TABLE batch_class_module;

DROP TABLE us_invoice;

DROP TABLE regex_validation;

DROP TABLE batch_class_module_config;

DROP TABLE remote_batch_instance;

DROP TABLE batch_class_plugin;

DROP TABLE role;

DROP TABLE us_invoice_data;

DROP TABLE batch_class_plugin_config;

DROP TABLE scanner_master_config_sample_value;

DROP TABLE batch_class_scanner_configuration;

DROP TABLE scanner_master_configuration;

DROP TABLE application_checklist;

DROP TABLE batch_instance;

DROP TABLE security_group;

DROP TABLE batch_instance_error_details;

DROP TABLE vFBValidation;

DROP TABLE security_user;

DROP TABLE batch_instance_groups;

DROP TABLE security_user_group;

DROP TABLE batch_instance_retries;

DROP TABLE server_registry;

DROP TABLE service_status;

DROP TABLE document_type;

DROP TABLE table_columns_info;

DROP TABLE email_data;

DROP TABLE table_info;

DROP TABLE field_type;

DROP TABLE table_rule;

DROP TABLE user_information;

DROP TABLE function_key;

DROP TABLE hist_manual_steps_in_workflow;

DROP TABLE kv_extraction;

DROP TABLE kv_page_process;

DROP TABLE module_config;

DROP TABLE module;

DROP TABLE lock_status;

DROP TABLE JBPM4_VARIABLE;

DROP TABLE JBPM4_DEPLOYMENT;

DROP TABLE JBPM4_DEPLOYPROP;

DROP TABLE JBPM4_EXECUTION;

DROP TABLE JBPM4_HIST_VAR;

DROP TABLE JBPM4_HIST_DETAIL;

DROP TABLE JBPM4_HIST_PROCINST;

DROP TABLE JBPM4_HIST_ACTINST;

DROP TABLE JBPM4_HIST_TASK;

DROP TABLE JBPM4_SWIMLANE;

DROP TABLE JBPM4_TASK;

DROP TABLE JBPM4_PARTICIPATION;

DROP TABLE JBPM4_PROPERTY;

DROP TABLE JBPM4_LOB;

DROP TABLE JBPM4_JOB;

SET foreign_key_checks = 1;

 

 

  1. Create a database in MSSQL or MySQL using SQL file in [Ephesoft Installation Folder]\Dependencies\<MsSQLSetup or MysqlSetup>\ephesoft-*-config.sql (Depending on the DB Application being used)
  2. Edit the following line located in the [Ephesoft Installation Folder]\Application\WEB-INF\classes\META-INF\dcma-data-access\dcma-db.properties
    upgradePatch.enable=true
  3. Edit the following line located in the [Ephesoft Installation Folder]\Application\WEB-INF\classes\META-INF\dcma-workflows\dcma-workflows.properties file.
    workflow.deploy=true
  4. Reset all SER files in the Ephesoft\SharedFolders\database-update by Removing the “-Executed” portion of the file.
  5. Delete the non standard Batch class folders from SharedFolders such as BC4, BC5, etc.
  6. Also Clear out all BC# directories in the following locations:
    Ephesoft\SharedFolders\workflows\workflows
    Ephesoft\SharedFolders\workflows\modules
  7. Start Ephesoft and make sure all the Ephesoft tables are created with three default batch classes.
  8. Import the batch classes that you have exported in step #2 above

< Back|KB Main Page

Was this article helpful to you?

wikiadmin

Comments are closed.