topic Re: Dataflow Gen 2 Error in committing version in Dataflow

Dataflow Gen 2 Error in committing version

coverturfLSH — Wed, 12 Jun 2024 21:11:43 GMT

For the last week I've been getting the following error message when trying to refresh my dataflow gen 2.

[queryname]WriteToDataDestination: Mashup Exception Data Source Error Couldn't refresh the entity because of an issue with the mashup document MashupException.Error: Error in comitting version., InnerException: We can't update the value. The operation or its arguments aren't supported by the value., Underlying error: We can't update the value. The operation or its arguments aren't supported by the value. Details: Reason = DataSource.Error;Message = We can't update the value. The operation or its arguments aren't supported by the value.;Detail = #table({"Version", "Published", "Data", "Modified"}, {});Message.Format = We can't update the value. The operation or its arguments aren't supported by the value.;Microsoft.Data.Mashup.Error.Context = User GatewayObjectId:[xxxxxx-xxxxx-xxxx-xxx....]

The dataflow uses an on-premise gateway to run a SELECT SQL statement from Amazon Redshifft.

Thank you,

Re: Dataflow Gen 2 Error in committing version

JillianHay — Wed, 12 Jun 2024 23:09:19 GMT

I'm getting the same error, however it is my very first gen 2 dataflow (I've got hundreds of gen 1), so it might be something I'm missing. Connecting to a SQL database and running a simple proc.

Re: Dataflow Gen 2 Error in committing version

coverturfLSH — Wed, 12 Jun 2024 23:18:18 GMT

Do you also have a warning at the bottom that your gateway version is lower than recommended?

Re: Dataflow Gen 2 Error in committing version

JillianHay — Wed, 12 Jun 2024 23:19:57 GMT

Yes, but it's not a long way out.... worth testing that, good thought.

Re: Dataflow Gen 2 Error in committing version

coverturfLSH — Wed, 12 Jun 2024 23:20:59 GMT

I've asked my admin about upgrading. Will let you know if that solves it, but you may consider asking your folks to upgrade too.

Re: Dataflow Gen 2 Error in committing version

coverturfLSH — Fri, 14 Jun 2024 01:44:29 GMT

JillianHay - Confirmed that the On-premise gateway to the latest version 3000.222.5 (May 2024) resolved the issue I was having with my data flow. Hopefully your admin can update your version for you!

Re: Dataflow Gen 2 Error in committing version

v-cboorla-msft — Fri, 14 Jun 2024 05:22:42 GMT

Hi coverturfLSH

Glad that your query got resolved 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.

Re: Dataflow Gen 2 Error in committing version

JillianHay — Fri, 14 Jun 2024 07:26:38 GMT

Update also resolved it for me.