Data Integration
UPSERT Runs Successfully but Doesn't Insert or Update Data
Overview Sometimes an integration run in Skyvia finishes with Success, but no new data is inserted or updated in the target table. This situation most often occurs when using the UPSERT operation. Why This Happens UPSERT decides whether to Insert or ...
What is LastSyncTime in Skyvia?
What is LastSyncTime? LastSyncTime is the point when Skyvia last successfully transferred data during a Replication or Synchronization. It helps Skyvia remember what data has already been delivered, so next time, only new or updated records are ...
Skyvia Full (Initial) Replication
Overview Full Replication creates a complete copy of your source data in the target database. Use it for the first replication run, after schema changes, when refreshing all data, or if you encounter duplicate records. Requirements Valid Source and ...
Replication: MySQL Error: Row size too large (> 8126)
Overview When performing replication to MySQL you can encounter this error: An error occurred while creating table 'Invoice'. Error: Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 ...
Replication: Schema Validation Failed (Absent Columns / Redundant Columns)
Overview If you encounter the following errors in an integration, it means the schema of your data source no longer matches the schema Skyvia has cached: "Integration failed: Table 'TableName' schema validation failed: Absent columns: 'FieldName1', ...
Advantages of the New Replication Runtime
Overview The new Replication runtime introduces significant improvements over the old runtime in terms of performance, flexibility, and error handling. You can enable it by selecting Use new runtime in your Replication integration settings. Key ...
The specified lookup is ambiguous: Lookup must return at most one row
Overview This error occurs when a Lookup operation returns multiple matching records for the specified condition. Lookups are designed to find and act on only one record. When that is not possible, this error is triggered. Resolution Options Option ...
Integration Failure Types in Skyvia Data Integration
Overview When using Skyvia Data Integration, you may encounter two distinct types of integration failures: 1. Record-Level Errors These occur when one or more individual records fail to process during an integration task. For example, in operations ...
Replication creates extra tables in the database
Overview In some cases, as a result of Replication, in addition to the main tables (for example, dbo.Account), empty additional tables are created in the database with names like: dbo.Account_2ade4447_5e11_4308_9e81_5eab62d9ed52 ...
Mapping Multi-Select Fields
Overview When working with Import, Synchronization, or Data Flow integrations and needing to map multi-select fields with different values between the source and target, you can use Expression Mapping. Expression mapping allows using simple and ...
Skyvia Data Flow Logs: Why Errors Are Not Shown by Default
Overview In Data Flow, tracking execution success or failure can be challenging due to the nature of row processing. Rows that fail in one component may succeed in another, complicating error detection. By default, Skyvia logs do not provide detailed ...
Import: CSV file has invalid content or structure mismatch
Overview The error "CSV file has invalid content or its structure does not correspond to the mapping defined in the integration" typically occurs when the structure of the CSV file in the source does not match the structure of the file originally ...