Deleting the Ephesoft Database and Recreating it Manually

Issue

Some situations may require you to start with a new Ephesoft environment. Rather than performing a complete uninstall and reinstall, you may be able to delete the database contents and start fresh.

Important: This is recommended only for dev environments, as any production environments should be installed as cleanly as possible.

Solution

Perform the following steps to delete and manually recreate the Ephesoft database.

  1. Stop Ephesoft Transact.
  2. Take note of the database names and db_owner credentials for the following three databases:
    • ephesoft
    • report
    • report_archive

Note: If you lose the login credentials for the above databases, you will need to manually reconfigure the Ephesoft configuration files.

  1. Delete the above three databases.
  2. Recreate the databases with the following queries.
{path}\Ephesoft\Dependencies\MsSQLSetup\ephesoft-mssql-config.sql
{path}\Ephesoft\Dependencies\MySQLSetup\ephesoft-mysql-config.sql

Note: Ensure the database names match those in step 1. The above queries have a step for creating and associating credentials. Depending on your database policies, you may not want to use these queries. The query will error out on these lines if the user credentials already exist in the system.

  1. Verify that the previous credentials noted in step 1 are reassociated or recreated.
  2. Rename the serialized (.ser) files so Transact can perform database setup procedures. These files are located in SharedFolders\database-update.
BatchClassUpdate.ser-executed to BatchClassUpdate.ser
DependencyUpdate.ser-executed to DependencyUpdate.ser
PluginConfigUpdate.ser-executed to PluginConfigUpdate.ser
PluginUpdate.ser-executed to PluginUpdate.ser
ScannerConfigUpdate.ser-executed to ScannerConfigUpdate.ser
  1. Change the configuration flags.
{path}\Ephesoft\Application\WEB-INF\classes\META-INF\dcma-data-access\dcma-db.properties
upgradePatch.enable=true

{path}\Ephesoft\Application\WEB-INF\classes\META-INF\dcma-workflows\dcma-workflows.properties
workflow.deploy=true
  1. Start Ephesoft Transact.

Note: After Transact has restarted, the above .ser files should revert back to .ser-executed.

  1. Verify the default batch classes have been created in the batch_class table in the ephesoft database.