question

ParepalliNaveenKrishnaHCLTECHNOLOG-5114 avatar image
0 Votes"
ParepalliNaveenKrishnaHCLTECHNOLOG-5114 asked NavtejSaini-MSFT commented

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

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
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@ParepalliNaveenKrishnaHCLTECHNOLOG-5114

Please let us know if you need any further help with this.

Regards
Navtej S

0 Votes 0 ·

1 Answer

VaibhavChaudhari avatar image
0 Votes"
VaibhavChaudhari answered

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.