Forum Discussion

daniele_tiles's avatar
daniele_tiles
Icon for Helper IV rankHelper IV
2 years ago

Weird\poor performance with Copy Activity

Hi, we've tried to make a simple Copy Activity from one of our SQL Server to a Lakehouse.  It's only 6 table, and the biggest is about 680k rows (not even millions). So the first run went great, i...
data engineering
Data Integration
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi daniele_tiles ,

Apologies for the issue you have been facing. I would like to check are you still facing this issue? 

It's difficult to tell what could be the reason for this performance. I would request you to wait for sometime or stop the pipeline and do a re-try.

 

If the issue still persists, please reach out to our support team so they can do a more thorough investigation on why this it is happening: Link 

 

After creating a Support ticket please provide the ticket number as it would help us to track for more information.

 

Hope this helps. Please let us know if you have any other queries.



  • daniele_tiles's avatar
    daniele_tiles
    Icon for Helper IV rankHelper IV
    2 years ago

    Hi,

    yes we're still facing the issue. We've got here the execution history:

     

    The first time it ran correctly in about 2 minutes. but adter that it's been hanging for hours.

     

     

  • daniele_tiles's avatar
    daniele_tiles
    Icon for Helper IV rankHelper IV
    2 years ago

    Hi Anonymous ,

    it just failed with the following error:

     

    "Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Lakehouse operation failed for: The stream was already consumed. It cannot be read again"

     

    Really strange. Any idea?