Data load to ADX (Kusto) fails with error - UserErrorKustoWriteFailed

Siresh Peesa (HCL America Inc) 1 Reputation point Microsoft Employee
2021-01-11T07:09:52.93+00:00

Failure happened on 'Sink' side. ErrorCode=UserErrorKustoWriteFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Failure status of the first blob that failed: Mapping reference 'TestTable' of type 'mappingReference' in database 'XXXXX' could not be found.,Source=Microsoft.DataTransfer.Runtime.KustoConnector,'

Azure Data Explorer
Azure Data Explorer
An Azure data analytics service for real-time analysis on large volumes of data streaming from sources including applications, websites, and internet of things devices.
479 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,515 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Vaibhav Chaudhari 38,576 Reputation points
    2021-01-11T07:11:26.647+00:00

    What is the source? Have you checked the mapping tab of copy activity? Ensure you have source columns mapped to target Kusto columns.

    0 comments No comments

  2. Janine Lodewick 1 Reputation point
    2021-04-16T06:43:59.93+00:00

    I had the same issue, I had to go into ADX user permissions and add the ADF as a "user"(app) with write permissions

    0 comments No comments