When using Skyvia Data Integration product, you may encounter two distinct types of integration failures:
These occur when one or more individual records fail to process during an integration task. For example, in operations like Synchronization and Replication, which rely on the LastSyncTime parameter, this can have specific implications. The LastSyncTime parameter tracks changes since the last successful replication. During the initial execution, Skyvia sets this parameter to the current time, and subsequent runs only process changes made after that point. If some records fail, the LastSyncTime advances despite the failure. As a result, failed records are skipped in future runs until they are updated. Once updated, these records will be processed again in the next execution.
These occur when an error impacts the entire integration process, preventing it from completing successfully. In this case, no records are processed, and the LastSyncTime parameter remains unchanged. On the next successful run, no records will be skipped, and the integration will attempt to process all relevant data again.