Troubleshooting logger problems

Use the following tasks to help you to resolve issues with loggers.

Troubleshooting an update to your MFT database schema on Oracle
You 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.
MFT logger error handling and message rejection
The Managed File Transfer logger identifies two types of error: per-message errors and general errors.
Reprocessing MFT messages from the reject queue
When a per-message error is encountered, the logger rejects the message by placing the message on the reject queue. You can view the contents of the reject queue, see why a message was rejected, and (in some cases) reprocess the message.
Troubleshooting an MFT logger that cannot write to the database tables
The database tables used by the Managed File Transfer logger require the database to have a page size of 8 KB or larger. If the page size of the database is not large enough, the tables are not created properly and you see the error SQLSTATE=42704.

Parent topic: Troubleshooting Managed File Transfer problems

Related tasks