topic Re: Mashup.Error while trying to publish my Dataflow Gen2 in Dataflow

Mashup.Error while trying to publish my Dataflow Gen2

CrhIT — Tue, 25 Jun 2024 15:46:35 GMT

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

Re: Mashup.Error while trying to publish my Dataflow Gen2

v-cboorla-msft — Wed, 26 Jun 2024 07:01:11 GMT

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.

Re: Mashup.Error while trying to publish my Dataflow Gen2

v-cboorla-msft — Thu, 27 Jun 2024 12:44:18 GMT

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.

Re: Mashup.Error while trying to publish my Dataflow Gen2

CrhIT — Thu, 27 Jun 2024 15:02:04 GMT

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

Re: Mashup.Error while trying to publish my Dataflow Gen2

v-cboorla-msft — Thu, 27 Jun 2024 16:02:07 GMT

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.