Data Integration
The specified lookup is ambiguous. Lookup must return at most one row for the specified lookup condition
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’s not possible, this error is triggered. Possible Solutions: 1. Use "First ...
Integration Failure Types in Skyvia Data Integration
When using Skyvia Data Integration product, 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
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 of the following types: dbo.Account_2ade4447_5e11_4308_9e81_5eab62d9ed52 ...
Mapping Multi-Select Fields
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 complex ...
📊 Skyvia Data Flow Logs Explained: The Reason Errors and Successes Aren't Shown by Default
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 error or ...