locked
Azure Data Factory Copy Activity stucks RRS feed

  • 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


    
    • Edited by Eike Becher Thursday, March 7, 2019 11:55 AM
    Thursday, March 7, 2019 11:54 AM

Answers

  • 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.



    • Marked as answer by Eike Becher Thursday, March 7, 2019 12:34 PM
    • Edited by Eike Becher Thursday, March 7, 2019 12:35 PM
    Thursday, March 7, 2019 12:34 PM

All replies

  • 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.



    • Marked as answer by Eike Becher Thursday, March 7, 2019 12:34 PM
    • Edited by Eike Becher Thursday, March 7, 2019 12:35 PM
    Thursday, March 7, 2019 12:34 PM
  • 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. 

    Friday, March 8, 2019 5:48 AM