Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
ADF ADLS TO SYNAPSE DEDICATED POOL WRITING ERROR RECORD TO ADLS ISSUE
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(160, 30%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESP%3C/text%3E%3C/svg%3E)
Shukla, Prashant (Contractor)
0
Reputation points
I am writing data from adls to Synapse sql dedicated pool , with following error settings
SourceADLS
SINK Synapse Dedicated pool
but getting following error
tried with batch also but did not worked
Azure Data Factory
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(86.4, 36%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBM%3C/text%3E%3C/svg%3E)
Bhargava-MSFT 31,361 Reputation points Microsoft Employee Moderator2024-04-19T17:13:02.14+00:00 Hello Shukla, Prashant (Contractor),
The error message is explained in the Microsoft document. Please check the below and see if it helps.
Error code: DF-SQLDW-ExportErrorRowFailed
- Message: Exception is happened while writing error rows to storage.
- Cause: An exception happened while writing error rows to the storage.
- Recommendation: Check your rejected data linked service configuration.
Please test your linked service form the dataflow
I hope this helps.
-
Shukla, Prashant (Contractor) 0 Reputation points
2024-04-19T20:16:07.8866667+00:00 linked service to adls test connection successfully tested
-
Shukla, Prashant (Contractor) 0 Reputation points
2024-04-19T20:51:51.2766667+00:00 still facing same error. not able to write error rows to adls
-
Bhargava-MSFT 31,361 Reputation points Microsoft Employee Moderator
2024-04-19T22:00:45.43+00:00 Can you test with a different storage account and see?
Do you have firewall configured for the storage? if yes, can you please check the Firewall settings?
also, please check the permissions from IAM tab.
-
Shukla, Prashant (Contractor) 0 Reputation points
2024-04-20T07:54:20.8633333+00:00 tested , when i take dataflow source as synapse and sink as same adls i am able to write file in adls ,but error record feature not working
-
Bhargava-MSFT 31,361 Reputation points Microsoft Employee Moderator
2024-04-22T19:44:46.72+00:00 Are you getting any error when you tried with "continue on error" https://learn.microsoft.com/en-us/azure/data-factory/connector-azure-sql-data-warehouse?tabs=data-factory#error-row-handling
Sign in to comment
Sign in to answer