Failure happened on 'Sink' side. ErrorCode=UserErrorInvalidDataValue

Sam Kersten 21 Reputation points
2022-03-22T14:22:41.67+00:00

Failure happened on 'Sink' side. ErrorCode=UserErrorInvalidDataValue,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Column 'when_updated_last_time' contains an invalid value 'Actual'.,Source=Microsoft.DataTransfer.ServiceLibrary,''Type=System.ArgumentException,Message=The string was not recognized as a valid DateTime. There is an unknown word starting at index 0.Couldn't store <Actual> in when_updated_last_time Column. Expected type is DateTime.,Source=System.Data,''Type=System.FormatException,Message=The string was not recognized as a valid DateTime. There is an unknown word starting at index 0.,Source=mscorlib,'

This error starting happening on our pipeline. We haven't changed anything and it was working fine before. Does anyone have any ideas on how to fix this?

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,717 questions
{count} votes

Accepted answer
  1. Pratik Somaiya 4,201 Reputation points
    2022-03-23T03:53:37.493+00:00

    Hello @Sam Kersten

    This error is due to the incoming data in the column when_updated_last_time

    The column is of type: DateTime and the value coming from source is <Actual>

    Can you check the source data / file for this column and see if it contains a value other than datetime type value

    If yes then you will need to clean the data first before executing the pipeline again

    0 comments No comments

0 additional answers

Sort by: Most helpful