Forum Discussion

CrhIT's avatar
CrhIT
Frequent Visitor
2 years ago
Solved

Mashup.Error while trying to publish my Dataflow Gen2

I'm trying to publish a Dataflow2 saving the result into my datawarehouse however I always get the Mashup.Error. I followed the possible solutions in 

https://stackoverflow.com/questions/2962927/a-transport-level-error-has-occurred-when-receiving-results-from-the-server

https://community.fabric.microsoft.com/t5/Dataflows/Transport-level-Error-using-Dataflows-Gen2/m-p/3374550

 

However none of those seems to help me. I even write a ticket and still got no response.

 

I pase the error downbelow

Sales: Error Code: FailedToInsertATable, Error Details: Couldn't refresh the entity because of an issue with the mashup document MashupException.Error: DataSource.Error: Failed to insert a table., InnerException: #{0}: #{1}, Underlying error: Microsoft SQL: A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.) Details: Reason = DataSource.Error;Message = Microsoft SQL: A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.);Detail = [DataSourceKind = "Lakehouse", DataSourcePath = "Lakehouse", DataSourceKind.2 = "SQL", DataSourcePath.2 = "p6qjrwhwccquje2v5pai6zxfve-spqg6ly32hje3cc3jfnircrvyi.datawarehouse.fabric.microsoft.com;DataflowsStagingLakehouse", Message = "A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)", ErrorCode = -2146232060, Number = 10054, Class = 20, State = 0];Message.Format = #{0}: #{1};Message.Parameters = {"Microsoft SQL", "A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)"};Microsoft.Data.Mashup.Error.Context = System (Request ID: 690d41fc-5ea2-4701-8287-35f2c83cb63f).

  • If you facing this type of error, try disabling staging in Data flow Gen2 and organice your data flow to consume less resources.

4 Replies

  • v-cboorla-msft's avatar
    v-cboorla-msft
    Microsoft Employee

    Hi CrhIT 

     

    Thanks for using Microsoft Fabric Community.

    If you have opened a support ticket, a reference to the ticket number would be greatly appreciated. This will allow us to track the progress of your request and ensure you receive the most efficient support possible.

     

    Thank you.

    • v-cboorla-msft's avatar
      v-cboorla-msft
      Microsoft Employee

      Hi CrhIT 

       

      We haven’t heard from you on the last response, If you have opened a support ticket, a reference to the ticket number would be greatly appreciated. This will allow us to track the progress of your request and ensure you receive the most efficient support possible.

       

      Thank you.

  • CrhIT's avatar
    CrhIT
    Frequent Visitor

    If you facing this type of error, try disabling staging in Data flow Gen2 and organice your data flow to consume less resources.

    • v-cboorla-msft's avatar
      v-cboorla-msft
      Microsoft Employee

      Hi CrhIT 

       

      Glad that you were able to find some insights and thank you for sharing the same with the community as it can be helpful to others.
      Please continue using Fabric Community for further queries.

       

      Thank you.