Error: F_JT4600: Column Is Longer Than 30 Symbols

Issue

While activating a channel, the following error appears:

F_JT4600: The column '<column_name>' of the table '<table_name>' is longer than 30 symbols. It is necessary to have the parameter 'enable_goldengate_replication' set to 'TRUE' on the capture location in order to capture data correctly from such a table. Please, be aware that enabling the parameter may require additional licensing from Oracle.

Environment

• HVR 6
• Source: Oracle

Resolution

You can resolve the issue in one of the following ways:

1. Rename the column in the source Oracle database so that it contains fewer than 30 characters.
2. Set the ENABLE_GOLDENGATE_REPLICATION parameter to true on the source Oracle database:

   ALTER SYSTEM SET enable_goldengate_replication=TRUE SCOPE=BOTH;
   

   • Ensure that you have the necessary license to use this parameter.
   • This allows Oracle to perform supplemental logging on tables with identifiers longer than 30 characters.
3. Remove the affected table from the replication channel.
   Removing individual columns does not resolve the issue. If any column name exceeds 30 characters, Oracle disables supplemental logging for the entire table. As a result, channel activation fails even if you exclude the column from the HVR table definition.

Cause

We require the supplemental logging feature for change data capture. When a column or table name exceeds 30 characters, and the ENABLE_GOLDENGATE_REPLICATION parameter is set to false, Oracle does not perform supplemental logging on the affected table, resulting in the above error.

For more information, see our Oracle as Source documentation.