Error: Broken Pipe F_JT04A1

Issue

High-Volume Agent Db2 for i connection syncs fail with the following error:

Capture failed: fivetran-cap-ftsource: Write of <bytes> to file '' failed. Error: Broken pipe. F_JT04A1.

Environment

• Connector: High-Volume Agent Db2 for i
• Source: IBM Db2 for i (AS/400)

Resolution

To resolve this issue, update the journal settings on the affected tables to capture both before- and after-images:

1. Set the IBM i table attribute IMAGES to *BOTH for all replicated tables, especially those listed in the connection logs. To update a single table:

   ENDJRNPF FILE(<schema>/<table>) JRN(<schema>/<journal>)
   STRJRNPF FILE(<schema>/<table>) JRN(<schema>/<journal>) IMAGES(*BOTH)
   

   To update all tables in a library:

   CHGJRNOBJ OBJ((<schema>/*ALL *FILE)) ATR(*IMAGES) IMAGES(*BOTH)
   

2. Stop and restart journaling to apply the changes.
3. In Fivetran, go to your High-Volume Agent Db2 for i connection page and click Sync.

If the connection log identifies only one table, check and apply the IMAGES update on all other replicated tables as well. Manually audit the IMAGES attribute for each table to confirm the settings are applied correctly.

For more information, see our High-Volume Agent Db2 for i setup guide.

Cause

Fivetran requires both before- and after-images (IMAGES(*BOTH)) for all replicated tables. This issue occurs when one or more replicated tables are journaled with after-images only. When this happens, we encounter an update operation we can't process, which interrupts the capture stream, resulting in the above error.