Azure Data Factory Copy Activity stucks

Question

Hi,

I have an Http Source and an Azure SQL Database. 

Sometimes it works. But sometimes the data is loaded from the source but not written to the table. It does not fail. So I do not get any Message. Anybody has an idea?

Runid for an example is 91d17525-5e0b-474f-808c-580e24bc6c37

Thanks in advance

Eike



Answer 1

I found the solution by myself.

Some rows does not match the datatype length in the database.
I am new in using Data Factory.

I set the "Fault tolerace" to Skip and log incompatible rows. So I found the issue.

Hope this helps some others.

Answer 2

Hi Eike,

Glad to know that your issue has resolved. And thanks for sharing the solution, which might be beneficial to other community members reading this thread.