Share via

Failure happened on 'Source' side. Failure because of DatetimeOffset formatting

Parepalli Naveen Krishna (HCL TECHNOLOGIES LTD) 1 Reputation point
2021-02-10T14:00:35.907+00:00

Failure happened on 'Source' side. ErrorCode=UserErrorKustoWriteFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Write to Kusto failed with following error: An error occurred for source: 'DataReader'. Error: 'Column 'DueDate' contains an invalid value '2020-12-27T08:44:25.143'.'.,Source=Microsoft.DataTransfer.Runtime.KustoConnector,''Type=Kusto.Ingest.Exceptions.IngestClientException,Message=An error occurred for source: 'DataReader'. Error: 'Column 'DueDate' contains an invalid value '2020-12-27T08:44:25.143'.',Source=Kusto.Ingest,''Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Column 'DueDate' contains an invalid value '2020-12-27T08:44:25.143'.,Source=Microsoft.DataTransfer.ClientLibrary,''Type=System.ArgumentException,Message=Specified cast is not valid.Couldn't store <2020-12-27T08:44:25.143> in DueDate Column. Expected type is DateTimeOffset.,Source=System.Data,''Type=System.InvalidCastException,Message=Specified cast is not valid.,Source=System.Data,'

Azure Table Storage
Azure Table Storage
An Azure service that stores structured NoSQL data in the cloud.
171 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Vaibhav Chaudhari 38,751 Reputation points
    2021-02-10T14:07:28.323+00:00

    In the target Kusto table, could you try changing the data type of DueDate column to string and see if it works

    Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.