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,

  • v-cboorla-msft's avatar
    v-cboorla-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    2 years ago

    Hi MarioDiaz 

     

    Thanks for using Fabric Community.

    Apologies for the issue that you are facing here.

    Try to upgrade the gateway version to latest, this might help me in resolving your issue.

    For more details please refer Link.

     

    I hope this helps. Please do let us know if you have any further questions.

  • acitsme's avatar
    acitsme
    Icon for Advocate II rankAdvocate 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()