Migration of File Tracking entries after upgrade to ST 5.3.3 for Oracle Database

Due to a structural change of database tables related to File Tracking, the data related to transfers, made before upgrade, should be migrated to the new tables created on upgrade in order to be visible in SecureTransport 5.3.3 File Tracking. If the migration is skipped all the details related to transfers made before upgrade will NOT be visible on the File Tracking page.

If migration is NOT needed, skip the migration instructions and go directly to section Dropping the old tables.

For instructions regarding File Tracking migration on Microsoft SQL or the embedded MySQL DB, refer to the following articles:

• for embedded MySQL DB
• for Microsoft SQL

Prerequisites

IMPORTANT NOTE: Make a backup of your database before proceeding with the migration.

Make sure that all SecureTransport services are stopped.

Execute the following command to stop all services:

<FILEDRIVEHOME>/bin/stop_all

Migrating the File Tracking records

1. Connect to database with the user SecureTransport is running with.

2. Open the filetracking-migration-oracle.sql migration script that can be found attached to this article.

3. Copy and paste it as a new single query in Oracle SQL Developer.

4. Execute it and verify the script output in the Oracle SQL Developer console.

After the migration is successfully completed, old tables should be dropped using the instructions in the next section.

Dropping the old tables

As the old tables won’t be used after upgrade they should be dropped using the the attached filetracking-migration-oracle-drop-old.sql script.

1. Open the filetracking-migration-oracle-drop-old.sql script and copy its content.

2. Paste it as a single query in Oracle SQL Developer and execute.