When Stitch replicates data from an Oracle-backed database, it will check for the required user permissions and database server settings. If permissions or server settings aren’t properly defined, you may receive an error during the Extraction phase of the replication process. These errors will surface in the integration’s Extraction Logs.
The errors and troubleshooting steps in this article are applicable to the following database integrations:
Extraction errors and troubleshooting
Below are the errors you might see if Stitch has trouble replicating data from an Oracle-backed database, as well as how to resolve them.
The source object is a database view. Binary logging doesn’t track events that occur in database views, so Stitch is unable to use Log-based Replication for views.
To replicate the view, its Replication Method must be Full Table Replication.
Supplemental logging is incorrectly defined either for the database or the table. Supplemental logging is required by Oracle to use LogMiner, which Stitch uses to perform Log-based Incremental Replication.
Stitch supports supplemental logging at the database and table level:
If enabled at the database level, tables do not need to be individually configured:
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS
If enabled at the table level, tables need to be individually configured. Run the following for every table you want to replicate through Stitch:
ALTER TABLE <SCHEMA_NAME>.<TABLE_NAME> ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS
Refer to the Oracle documentation for more info.
The requested log file has been removed from the server. When a log file is removed before Stitch can read from it, replicaiton will be unable to proceed.
This error typically arises due to insufficient RMAN retention policy settings, which define how long log files remain on a server before they’re automatically purged.
It can also be caused by log files being purged before historical replication completes or critical errors that prevent Stitch from replicating data. When this occurs, it means Stitch was unable to proceed to the log file before the retention period passed and the log was purged.
To resolve the error, you’ll need to perform an integration-level reset. To do this, open the Integration Settings page and click the Reset Table button. This will clear the integration’s Replication Keys and queue a full re-replication of the integration.
To prevent this error in the future, verify your RMAN retention policy settings and update them if needed. Stitch recommends a minimum of 3 days, but 7 days is preferred. This ensures that you have time to resolve any issues that arise before logs age out and are purged. Refer to the Oracle documentation for more info.
In addition, make sure you resolve any connection or replication issues quickly. This will reduce the likelihood that log files will age out and cause this error.
LogMiner is unable to locate the System Change Number (SCN) value Stitch has saved. SCNs are used to identify data in log files for incremental replication.
This may occur for a few reasons:
- No new data is logged for the length of the RMAN retention window. For example: If the RMAN retention window is set to 2 days and no new data is created for two successive days, this error may occur.
- The integration is paused for longer than the RMAN retention window. For example: If the RMAN retention window is set to 2 days and the integration is paused in Stitch for longer than two days, this error may occur.
- Verify the current RMAN retention window length.
- Increase the RMAN retention window. For example: Increase the window from 2 days to 7.
- Perform an integration level reset. To do this, open the Integration Settings page and click the Reset This Integration button. This will clear the integration’s Replication Keys and queue a full re-replication of the integration.