Migrating the Transact SharedFolders location

This section guides through migrating Transact SharedFolders location to a new path.

  1. Update property files.

    Modify the following files with the new UNC path:

    application.properties located at [Transact Installation Directory]\Application\WEB-INF\classes\META-INF\

    Line 28:

    plugin_upload_folder_path=\\\\NEW_UNC_PATH\\SharedFolders/plugin-upload-folder
    dcma-batch.properties located at [Transact Installation Directory]\Application\WEB-INF\classes\META-INF\dcma-batch\

    Update the following lines:

    • Line 1:

      batch.base_folder=\\\\NEW_UNC_PATH\\SharedFolders
    • Line 2:

      batch.local_folder=\\\\NEW_UNC_PATH\\SharedFolders/ephesoft-system-folder
    • Line 4:

      batch.export_folder=\\\\NEW_UNC_PATH\\SharedFolders/final-drop-folder
    • Line 17:

      batch.export_import_folder=\\\\NEW_UNC_PATH\\SharedFolders/export-batch-folder
    • Line 24:

      batch.test_folder=\\\\NEW_UNC_PATH\\SharedFolders/ephesoft-test-data
    dcma-db.properties located at [Transact Installation Directory]\Application\WEB-INF\classes\META-INF\dcma-data-access\

    Line 17:

    upgradePatch.folder=\\\\NEW_UNC_PATH\\SharedFolders/database-update
    dcma-backup-service.properties located at [Transact Installation Directory]\Application\WEB-INF\classes\META-INF\dcma-util\

    Line 1:

    backup.local_folder=\\\\NEW_UNC_PATH\\SharedFolders/ephesoft-system-folder

    Line 8:

    backup.report_folder=\\\\NEW_UNC_PATH\\SharedFolders/report-data
    dcma-workflows.properties located at [Transact Installation Directory]\Application\WEB-INF\classes\META-INF\dcma-workflows\

    Line 15:

    newWorkflows.basePath=\\\\NEW_UNC_PATH\\SharedFolders/workflows
    etl-variables.properties located at [Transact Installation Directory]\Application\WEB-INF\classes\META-INF\dcma-reporting\

    Line 1:

    reportdata.path=\\\\NEW_UNC_PATH\\SharedFolders/report-data
    server.xml located at [Transact Installation Directory]\JavaAppServer\conf\

    Line 156:

    <Context path="/dcma-batches" docBase="\\\\NEW_UNC_PATH\\SharedFolders" debug="10" privileged="false"/>
  2. Update the Transact application database.

    Update all batch classes listed in the batch_class table. Use the following SQL statement to update each batch class record:

    
    UPDATE batch_class SET unc_folder = Replace(unc_folder, '\\\\OLD_UNC_PATH\\SharedFolders', '\\\\NEW_UNC_PATH\\SharedFolders') WHERE local_folder LIKE '%SharedFolders%';
                        
    You need to update each record individually.

    Update the batch_instance table with the new SharedFolders location. Use the following SQL statements:

    
    UPDATE batch_instance SET local_folder='\\\\NEW_UNC_PATH\\SharedFolders\\ephesoft-system-folder';
    UPDATE batch_instance SET unc_subfolder = Replace(unc_subfolder, '\\\\OLD_UNC_PATH\\SharedFolders', '\\\\NEW_UNC_PATH\\SharedFolders') WHERE local_folder LIKE '%SharedFolders%';
                        
    You must run these queries for all UNC subfolders inside the UNC folder. If you do not update this table, ensure that all batch instances are in the FINISHED or DELETED state.
  3. Update Windows registry information.

    Update the registry key HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Temp\Ephesoft with the new SharedFolders location. This ensures future upgrades are performed correctly.

  4. Perform additional configurations.

    Depending on your database application, update the default DB property files located at [Transact Installation Directory]\Application\WEB-INF\classes\META-INF\dcma-data-access

    For MSSQL:

    dcma-db.properties located at dcma-data-access\MSSQL\

    Line 16:

    upgradePatch.folder=\\\\NEW_UNC_PATH\\SharedFolders/database-update

    For MySQL:

    dcma-db.properties located at dcma-data-access\MYSQL\

    Line 26:

    upgradePatch.folder=\\\\NEW_UNC_PATH\\SharedFolders/database-update
    post-schema.sql located at dcma-data-access\MYSQL\

    Update the following lines:

    • Line 150:

      update batch_class set unc_folder='\\\\NEW_UNC_PATH\\SharedFolders\\mailroom-import' where batch_class_name='MailroomAutomationTemplate';
    • Line 151:

      update batch_class set unc_folder='\\\\NEW_UNC_PATH\\SharedFolders\\searchablepdf-import' where batch_class_name='SearchablePDFTemplate';
    • Line 152:

      update batch_class set unc_folder='\\\\NEW_UNC_PATH\\SharedFolders\\grid-computing-import' where batch_class_name='GridComputingTemplate';
    • Line 156:

      update batch_class_plugin_config set batch_class_plugin_config.plugin_config_value='\\\\NEW_UNC_PATH\\SharedFolders\\final-drop-folder';
    • Line 164:

      update batch_class_plugin_config set batch_class_plugin_config.plugin_config_value='\\\\NEW_UNC_PATH\\SharedFolders\\csv-export-folder';
    • Line 172:

      update batch_class_plugin_config set batch_class_plugin_config.plugin_config_value='\\\\NEW_UNC_PATH\\SharedFolders\\ibm-cm-export-folder';
    • Line 180:

      update batch_class_plugin_config set batch_class_plugin_config.plugin_config_value='\\\\NEW_UNC_PATH\\SharedFolders\\export-script.properties';
    • Line 188:

      update batch_class_plugin_config set batch_class_plugin_config.plugin_config_value='\\\\NEW_UNC_PATH\\SharedFolders\\tabbed-pdf-export-folder';
    • Line 196:

      update batch_class_plugin_config set batch_class_plugin_config.plugin_config_value='\\\\NEW_UNC_PATH\\SharedFolders\\NSI-export-folder';
    For a local disk, use a path like C:\Folder\Path. Note that mapped network drives will not work with Transact; only local disks are supported for drive letter formats.

    Additionally, update the following settings and files:

    • EphesoftTransact.exe located at [Transact Installation Directory]\JavaAppServer\bin

      • Right-click EphesoftTransact.exe and select Run as administrator.

      • Select the Java tab.

      • In the Java Options field, update the -Dshared.folders parameter with the new path.

    • startup.bat located at [Transact Installation Directory]\JavaAppServer\bin

      • Open startup.bat in an editor.

      • Locate and update the SHARED_FOLDERS entry to point to the new SharedFolders path.

    • applicationContext.xml located at [Transact Installation Directory]\Application\

      • Open applicationContext.xml in an editor.

      • Locate and update the import resource parameter with the new path.

  5. Restart batch instances.

    After completing the updates, restart your batch instances from the first module.