What to do if you receive an error when updating your MFT database schema on an Oracle database

We might receive the following error message when updating your database schema to the latest level by using the ftelog_tables_oracle_702_703.sql file: ERROR at line 1: ORA-02289: sequence does not exist. This error occurs because the sequences and triggers used by the tables are not in the same schema as the tables.

About this task

To fix this problem, we must edit the contents of the ftelog_tables_oracle_702_703.sql before running it.

Procedure

1. Find out which schema the sequences and triggers used by the Managed File Transfer database logger tables are located in.
   • On Db2, we can use the Control Center to view the tables and schema.
   • On Oracle, we can use the Enterprise Manager to view the tables and schema.

2. Open the ftelog_tables_oracle_702_703.sql file in a text editor.
3. In each occurrence of the text SELECT FTELOG.sequence_name.nextval replace the text FTELOG with the name of the schema where your existing sequences are located.
4. Before each occurrence of the text CREATE OR REPLACE TRIGGER FTELOG.trigger_name, insert the text DROP TRIGGER schema_name.trigger_name, where schema_name is the name of the schema where your existing triggers are located.
5. Use the edited ftelog_tables_oracle_702_703.sql file to update the database tables.

Parent topic: MFT general troubleshooting