If the initial load portion of a combined initial and incremental load job fails to load data from a source table to a target table, the

database ingestion

job retries the subtask for the table up to three times. The interval between retries is a minimum of 60 seconds. If all of the initial load retries fail, the subtask acquires the state of

Error

and the table is excluded from replication. The job then tries to proceed with incremental loading. In this case, the job status changes to

Running with Warning

.

If an initial load job detects inconsistencies between column definitions in the source and target tables, the job drops the target table and then re-creates it to be consistent with the source table, prior to loading source data to the target.

For initial load and combined tasks, the initial load might take a long time to perform if the source tables contain many rows.