| Error | Likely Cause | Solution | |---|---|---| | UserErrorFailedToConnectToSqlServer | Self-Hosted IR offline | Restart SHIR service, check firewall ports (1433). | | ActivityTimeout | Large data + default 7 days | Increase timeout in pipeline settings or optimize source query. | | PolyBaseRejectedRow | Data type mismatch in Synapse | Enable RejectRow settings (percentage or row count). | | FileNotFound | Dataset path wrong or file missing | Use GetMetadata activity to check existence before copy. | | InvalidParameter | Expression syntax error | Debug using @pipeline().parameters in dynamic content builder. |

: Think of these as connection strings that define the information needed to connect to external resources, such as an Azure SQL Database or a Blob Storage account.

: Connection strings that define how ADF connects to external resources like databases or cloud storage.