Forum Discussion

tulasirambalu's avatar
tulasirambalu
Frequent Visitor
2 years ago
Solved

Unable to publish Dataflow Gen2 - Throws Error: issue with the mashup document MashupException.Error

Hi All,   Yesterday, it workds fine. But today, I am getting this error while publishing the Dataflow Gen2.   Latest On Premise Gateway installed. 3000.198.9 (Nov 2023)   Error Code: 999999, Er...
Dataflows
Need Help
  • tulasirambalu's avatar
    tulasirambalu
    2 years ago

    Hi, For me, this issue go away on its own. But I tried the Install latest On premise Gateway if you already have it Please restart it and try one more time.

    Later I came to know that some work is going on by microsoft on Dataflow Gen2 which may causes this issue becuase it is not consistent.

MarioDiaz's avatar
MarioDiaz
Frequent Visitor
2 years ago

Hi there,

 

I got the same issue when trying to use a Dataflow Gen2 pulling data from Azure Gen2 into a table.
Error Code: 999999, Error Details: The refresh for this entity was canceled. A task was canceled. (Request ID: 6a60f675-9602-4e58-8429-705783529f9d).

Regards,

acitsme's avatar
acitsme
Icon for Helper II rankHelper II
2 years ago

Testing Fabric connecting it to on-premisis Oracle db. Enterprise gateway works with power BI with no issue at all. 

Enterprise Gateway is the latest one: 3000.202.16.

Editing the DataflowGen2 connecting Oracle, I can see data in the oreview window but when I publish and refresh it I get this error in Fabric:

 

There was a problem refreshing the dataflow. Please review the error message(s) below, fix the problem, and try again. (Request ID: 6fcbe8f2-b8d7-4525-b368-6b5380b77f03).

Query: Error Code: 999999, Error Details: Couldn't refresh the entity because of an issue with the mashup document MashupException.Error: External component has thrown an exception. Details: GatewayObjectId: 0da5bc6c-8063-4dd3-a60e-bee3274db1b7 (Request ID: 6fcbe8f2-b8d7-4525-b368-6b5380b77f03).

 

Here below is the error logged by Enterprise Gateway (just a portion ). Please Help!

 

Antonio

 


GatewayPipelineErrorCode=DM_GWPipeline_UnknownError
GatewayVersion=
InnerType=ErrorException
InnerMessage=<ccon>External component has thrown an exception.</ccon>
InnerToString=<ccon>System.Runtime.InteropServices.SEHException: External component has thrown an exception.
at ParquetSharp.RowGroupWriter.RowGroupWriter_Close(IntPtr rowGroupWriter)
at Microsoft.Mashup.Engine1.Library.Parquet.ParquetScalableTableWriter.WriteRowGroup(ParquetFileWriter writer, ParquetRecordWriter recordWriter, Func`2 addRows, Func`1 moveNext, Action accumulate, Int64& count)
at Microsoft.Mashup.Engine1.Library.Parquet.ParquetScalableTableWriter.Write(BinaryValue destination, Func`2 addRows, Func`1 moveNext, SchemaElement schema, WriterProperties properties, Action accumulate)
at Microsoft.Mashup.Engine1.Library.Parquet.ParquetScalableTableWriter.Write(BinaryValue destination, TableValue table, SchemaElement schema, WriterProperties properties, IAccumulator accumulator)
at Microsoft.Mashup.Engine1.Library.Parquet.ParquetQuery.<>c__DisplayClass33_1.<Replace>b__2()
at Microsoft.Mashup.Engine1.Library.Parquet.ParquetExceptionHandler.Invoke[T](Func`1 action)
at Microsoft.Mashup.Engine1.Runtime.ActionValue.BindActionValue.ExecuteBindings()
at Microsoft.Mashup.Engine1.Runtime.ActionValue.BindActionValue.ExecuteBindings()
at Microsoft.Mashup.Engine1.Runtime.ActionValue.BindActionValue.Execute()
at Microsoft.Mashup.Engine1.Library.PersistentCacheExtensions.ClearCacheActionValue.Execute()