Error: Object in Library Not Found

Issue

The connection fails with an error similar to the following, indicating that an object wasn't found in the database journal library:

SQL0443 - Object o in library l not found.

Environment

Connector: High-Volume Agent Db2 for i

Resolution

To resolve this issue, do the following:

1. Work with your database administrator (DBA) to restore the journal receiver.
2. If it can't be recovered, trigger a historical re-sync in Fivetran. To learn how, see How to Trigger Historical Re-Syncs for Fivetran Connections and Tables.
3. Ensure the journal receiver retention duration is long enough for us to process the data.
   • We require a journal receiver retention duration of at least 48 hours. However, we recommend keeping them for 7 days to ensure enough data is available to recover from downtime. For more information, see our db2 for i database configuration documentation.

Cause

This issue occurs when a required log object is missing from the source database journal library. This may happen if it was deleted or archived before we could process the data.