Failure happened on 'Sink' side. ErrorCode=UserErrorInvalidDataValue

Question

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?

Answer 1

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