cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI dataset refresh failing

Last refresh failed: Thu Jun 21 2018 12:50:21 GMT+1200 (New Zealand Standard Time) 
There was an error when processing the data in the dataset.
Hide details

ata source error:The CancellationTokenSource has been disposed.. The exception was raised by the IDataReader interface. Table: AccountTransaction.
Cluster URI:WABI-AUSTRALIA-SOUTHEAST-redirect.analysis.windows.net
Activity ID:23ea7396-9662-4c44-acd8-722b742b7a35
Request ID:a0f6dc12-a326-429d-accc-bc68fa809c20
Time:2018-06-21 00:50:21Z

Error.jpg

Status: New
Comments
v-qiuyu-msft
Community Support

Hi @Elirot,

 

It seems there is a issue with table AccountTransaction. Would you please download the report from Power BI service and refresh in Power BI service to see if refresh can be successful?

 

Best Regards,
Qiuyun Yu

Elirot
Frequent Visitor

Hi Qiuyun,

Thanks for your feedback.

Working with Power BI desktop, I've tried to refresh the PBIX inside Power BI Desktop and there was not any problem. I've also published it to the service and tried to use the Gateway again with no success.

Yes, I saw that there is a problem with the table AccountTransaction, and I guess as this table includes around 25M records it is quite heavy on the Gateway, but from my understanding it shouldn't be a problem.

Thanks

 

Eli

v-qiuyu-msft
Community Support

Hi @Elirot,

 

Please update the gateway to the latest version then test again. 

 

If the issue still occurs, please share the gateway log files around the time issue occurs with us. 

 

Best Regards,
Qiuyun Yu

Elirot
Frequent Visitor

Hi Qiuyun,

The gateway runs the latest version.

I've excluded the AccountTransaction table from updates so really doesn't know what's the issue with this.

I've attached part of the last log as it is too long to include all of it. I didn't find any error in the log.

Many thanks

 

Eli

 

DM.EnterpriseGateway Verbose: 0 : 2018-06-25T06:09:22.5464002Z DM.EnterpriseGateway 2aeab7d7-24f8-487c-8d5a-799435e2d7d6 c215c19b-60da-97e5-cd1d-b81d60fac881 MGST 0b269750-02b4-f12d-9bef-55cff63ce3df 593F7EBF [DM.Pipeline.Common.TracingTelemetryService] Event: FireActivityCompletedSuccessfullyEvent (duration=2)
DM.EnterpriseGateway Verbose: 0 : 2018-06-25T06:09:22.5473989Z DM.EnterpriseGateway 73ad2f44-1eae-4028-877c-9f732b9636ad c215c19b-60da-97e5-cd1d-b81d60fac881 MDSR 0b269750-02b4-f12d-9bef-55cff63ce3df 7AA8AF5F [DM.Pipeline.Common.TracingTelemetryService] Event: FireActivityCorrelationEvent (parentActivityId=30f31a21-0e52-4f71-a081-d9f18ad82f1e)
DM.EnterpriseGateway Verbose: 0 : 2018-06-25T06:09:22.5484004Z DM.EnterpriseGateway 73ad2f44-1eae-4028-877c-9f732b9636ad c215c19b-60da-97e5-cd1d-b81d60fac881 MDSR 0b269750-02b4-f12d-9bef-55cff63ce3df BB5F1B73 [DM.Pipeline.Common.TracingTelemetryService] Event: FireActivityStartedEvent ()
DM.EnterpriseGateway Verbose: 0 : 2018-06-25T06:09:22.5484004Z DM.EnterpriseGateway 73ad2f44-1eae-4028-877c-9f732b9636ad c215c19b-60da-97e5-cd1d-b81d60fac881 MDSR 0b269750-02b4-f12d-9bef-55cff63ce3df 13F09589 [DM.Pipeline.Common.TracingTelemetryService] Event: FireActivityCompletedSuccessfullyEvent (duration=0)

Elirot
Frequent Visitor

Hi Qiuyun,

Just found an error in the log. Here it is:

DM.EnterpriseGateway Verbose: 0 : 2018-06-25T03:09:28.1600466Z DM.EnterpriseGateway ce892740-d447-458f-b077-980dcc8dd7e2 fa8ea7ea-45f7-45be-b6aa-bee688b37d81 MGPP 82f86334-ce70-4dfb-8b92-c8491ce9f3e7 BB5F1B73 [DM.Pipeline.Common.TracingTelemetryService] Event: FireActivityStartedEvent ()
DM.EnterpriseGateway Information: 0 : 2018-06-25T03:09:28.1620445Z DM.EnterpriseGateway ce892740-d447-458f-b077-980dcc8dd7e2 fa8ea7ea-45f7-45be-b6aa-bee688b37d81 MGPP 82f86334-ce70-4dfb-8b92-c8491ce9f3e7 74548E79 [DM.GatewayCore] Deserialized AsyncOperationKeepAliveRequest, executing
DM.EnterpriseGateway Verbose: 0 : 2018-06-25T03:09:28.1620445Z DM.EnterpriseGateway e799c7ad-ce62-407e-b7c6-1da33312c1dc fa8ea7ea-45f7-45be-b6aa-bee688b37d81 MGAP 82f86334-ce70-4dfb-8b92-c8491ce9f3e7 C4453B40 [DM.Pipeline.Common.TracingTelemetryService] Event: FireActivityCorrelationEvent (parentActivityId=ce892740-d447-458f-b077-980dcc8dd7e2)
DM.EnterpriseGateway Verbose: 0 : 2018-06-25T03:09:28.1632541Z DM.EnterpriseGateway e799c7ad-ce62-407e-b7c6-1da33312c1dc fa8ea7ea-45f7-45be-b6aa-bee688b37d81 MGAP 82f86334-ce70-4dfb-8b92-c8491ce9f3e7 BB5F1B73 [DM.Pipeline.Common.TracingTelemetryService] Event: FireActivityStartedEvent ()
DM.EnterpriseGateway Error: 0 : 2018-06-25T03:09:28.1632541Z DM.EnterpriseGateway e799c7ad-ce62-407e-b7c6-1da33312c1dc fa8ea7ea-45f7-45be-b6aa-bee688b37d81 MGAP 82f86334-ce70-4dfb-8b92-c8491ce9f3e7 25BF45F6 [DM.Pipeline.Diagnostics] Exception object created [IsBenign=True]: Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.UnknownSpooledOperationIdException: The spooled operation id f977c2bc-21e4-4231-80be-6e6ca67b085a does not exist. Evict code: -1.; ErrorShortName: UnknownSpooledOperationIdException
DM.EnterpriseGateway Error: 0 : 2018-06-25T03:09:28.1632541Z DM.EnterpriseGateway e799c7ad-ce62-407e-b7c6-1da33312c1dc fa8ea7ea-45f7-45be-b6aa-bee688b37d81 MGAP 82f86334-ce70-4dfb-8b92-c8491ce9f3e7 630A8BC6 [DM.Pipeline.Diagnostics] StackTrace: at Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.UnknownSpooledOperationIdException.TraceConstructor()
at Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.UnknownSpooledOperationIdException..ctor(Guid spooledOperationId, Nullable`1 spooledOperationStatus, PowerBIErrorDetail[] errorDetails)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.GatewayOperationResultSpooler.GetOperationController(Guid asyncOperationId)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.GatewayProcessor.<>c__DisplayClass7_0.<<PingAsyncOperation>b__0>d.MoveNext()
at System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.Start[TStateMachine](TStateMachine& stateMachine)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.GatewayProcessor.<>c__DisplayClass7_0.<PingAsyncOperation>b__0()
at Microsoft.PowerBI.DataMovement.Pipeline.Common.Diagnostics.PipelineTelemetryService.<ExecuteInActivity>d__7`1.MoveNext()
at System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.Start[TStateMachine](TStateMachine& stateMachine)
at Microsoft.PowerBI.DataMovement.Pipeline.Common.Diagnostics.PipelineTelemetryService.ExecuteInActivity[T](PipelineActivityType pipelineActivityType, Func`1 action)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.GatewayProcessor.<PingAsyncOperation>d__7.MoveNext()
at System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.Start[TStateMachine](TStateMachine& stateMachine)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.GatewayProcessor.PingAsyncOperation(GatewaySerializationContext responseContext, PingAsyncOperationRequest requestPayload)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.GatewayProcessorDispatcher.<DispatchImpl>d__1.MoveNext()
at System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.Start[TStateMachine](TStateMachine& stateMachine)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.GatewayProcessorDispatcher.DispatchImpl(GatewaySerializationContext responseContext, OperationRequestBase requestObj)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.GatewayProcessorDispatcher.<Dispatch>d__0.MoveNext()
at System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.Start[TStateMachine](TStateMachine& stateMachine)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.GatewayProcessorDispatcher.Dispatch(GatewaySerializationContext serializationContext, OperationRequestBase requestObj)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.Serialization.GatewayDeserializer.<DeserializeImpl>d__9.MoveNext()
at System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.Start[TStateMachine](TStateMachine& stateMachine)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.Serialization.GatewayDeserializer.DeserializeImpl(GatewayRelayContext requestContext, GatewaySerializationContext responseContext)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.Serialization.GatewayDeserializer.<>c__DisplayClass8_0.<<Deserialize>b__0>d.MoveNext()
at System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.Start[TStateMachine](TStateMachine& stateMachine)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.Serialization.GatewayDeserializer.<>c__DisplayClass8_0.<Deserialize>b__0()
at Microsoft.PowerBI.DataMovement.Pipeline.Common.Diagnostics.PipelineTelemetryService.<ExecuteInActivity>d__7`1.MoveNext()
at System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.Start[TStateMachine](TStateMachine& stateMachine)
at Microsoft.PowerBI.DataMovement.Pipeline.Common.Diagnostics.PipelineTelemetryService.ExecuteInActivity[T](PipelineActivityType pipelineActivityType, Func`1 action)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.Serialization.GatewayDeserializer.<Deserialize>d__8.MoveNext()
at System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.Serialization.GatewayDeserializer.Deserialize(GatewayRelayContext requestContext)
at System.Threading.Tasks.Dataflow.ActionBlock`1.ProcessMessageWithTask(Func`2 action, KeyValuePair`2 messageWithId)
at System.Threading.Tasks.Dataflow.ActionBlock`1.<>c__DisplayClass7.<.ctor>b__1(KeyValuePair`2 messageWithId)
at System.Threading.Tasks.Dataflow.Internal.TargetCore`1.ProcessMessagesLoopCore()
at System.Threading.Tasks.Task.Execute()
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot)
at System.Threading.Tasks.Task.ExecuteEntry(Boolean bPreventDoubleExecution)
at System.Threading.ThreadPoolWorkQueue.Dispatch()

DM.EnterpriseGateway Verbose: 0 : 2018-06-25T03:09:28.1600466Z DM.EnterpriseGateway e6803437-f7c3-4e5e-bb58-aa85c5982bef fa8ea7ea-45f7-45be-b6aa-bee688b37d81 MGRF 82f86334-ce70-4dfb-8b92-c8491ce9f3e7 B9B54F77 [DM.Pipeline.Common.TracingTelemetryService] Event: FireActivityCorrelationEvent (parentActivityId=19e31800-64ba-4b71-86e5-559c493a6ae3)
DM.EnterpriseGateway Error: 0 : 2018-06-25T03:09:28.1632541Z DM.EnterpriseGateway e799c7ad-ce62-407e-b7c6-1da33312c1dc fa8ea7ea-45f7-45be-b6aa-bee688b37d81 MGAP 82f86334-ce70-4dfb-8b92-c8491ce9f3e7 8DEE9220 [DM.Pipeline.Common.TracingTelemetryService] Event: FireActivityCompletedWithFailureEvent (duration=0, err=UnknownSpooledOperationIdException, rootcauseErrorEventId=0)
DM.EnterpriseGateway Verbose: 0 : 2018-06-25T03:09:28.1632541Z DM.EnterpriseGateway e6803437-f7c3-4e5e-bb58-aa85c5982bef fa8ea7ea-45f7-45be-b6aa-bee688b37d81 MGRF 82f86334-ce70-4dfb-8b92-c8491ce9f3e7 BB5F1B73 [DM.Pipeline.Common.TracingTelemetryService] Event: FireActivityStartedEvent ()
DM.EnterpriseGateway Verbose: 0 : 2018-06-25T03:09:28.1632541Z DM.EnterpriseGateway b99227ca-f945-41e5-85cf-e102243f57c3 fa8ea7ea-45f7-45be-b6aa-bee688b37d81 MDGR 82f86334-ce70-4dfb-8b92-c8491ce9f3e7 D64E1E27 [DM.Pipeline.Common.TracingTelemetryService] Event: FireActivityCorrelationEvent (parentActivityId=e6803437-f7c3-4e5e-bb58-aa85c5982bef)
DM.EnterpriseGateway Verbose: 0 : 2018-06-25T03:09:28.1632541Z DM.EnterpriseGateway b99227ca-f945-41e5-85cf-e102243f57c3 fa8ea7ea-45f7-45be-b6aa-bee688b37d81 MDGR 82f86334-ce70-4dfb-8b92-c8491ce9f3e7 BB5F1B73 [DM.Pipeline.Common.TracingTelemetryService] Event: FireActivityStartedEvent ()
DM.EnterpriseGateway Error: 0 : 2018-06-25T03:09:28.1632541Z DM.EnterpriseGateway ce892740-d447-458f-b077-980dcc8dd7e2 fa8ea7ea-45f7-45be-b6aa-bee688b37d81 MGPP 82f86334-ce70-4dfb-8b92-c8491ce9f3e7 8DEE9220 [DM.Pipeline.Common.TracingTelemetryService] Event: FireActivityCompletedWithFailureEvent (duration=0, err=UnknownSpooledOperationIdException, rootcauseErrorEventId=0)
DM.EnterpriseGateway Error: 0 : 2018-06-25T03:09:28.1640453Z DM.EnterpriseGateway f9ae515f-4e1f-424e-9bac-e90df1ffd65a fa8ea7ea-45f7-45be-b6aa-bee688b37d81 MDSR 82f86334-ce70-4dfb-8b92-c8491ce9f3e7 EFC78DB9 [DM.GatewayCore] Error processing request: [0]Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.UnknownSpooledOperationIdException: The spooled operation id f977c2bc-21e4-4231-80be-6e6ca67b085a does not exist. Evict code: -1.

GatewayPipelineErrorCode=DM_GWPipeline_Gateway_SpooledOperationMissing
SpooledOperationId=f977c2bc-21e4-4231-80be-6e6ca67b085a
SpooledOperationStatus=-1
([0]Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.UnknownSpooledOperationIdException.StackTrace:)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.GatewayOperationResultSpooler.GetOperationController(Guid asyncOperationId)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.GatewayProcessor.<>c__DisplayClass7_0.<<PingAsyncOperation>b__0>d.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.DataMovement.Pipeline.Common.Diagnostics.PipelineTelemetryService.<ExecuteInActivity>d__7`1.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.GatewayProcessor.<PingAsyncOperation>d__7.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.GatewayProcessorDispatcher.<DispatchImpl>d__1.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.GatewayProcessorDispatcher.<Dispatch>d__0.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.Serialization.GatewayDeserializer.<DeserializeImpl>d__9.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.Serialization.GatewayDeserializer.<>c__DisplayClass8_0.<<Deserialize>b__0>d.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.DataMovement.Pipeline.Common.Diagnostics.PipelineTelemetryService.<ExecuteInActivity>d__7`1.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.Serialization.GatewayDeserializer.<Deserialize>d__8.MoveNext()

Elirot
Frequent Visitor

Hi Quiyun,

I've tried to refresh with a different data source and I've got a different error message:

Cancellation occurred when sending or receiving a request.

This is the last log:

DM.EnterpriseGateway Verbose: 0 : 2018-06-29T00:50:26.2474870Z DM.EnterpriseGateway 71e9dddd-a4b1-45fc-b0fb-b6061042dd57 00000000-0000-0000-0000-000000000000 MFGC 00000000-0000-0000-0000-000000000000 BB5F1B73 [DM.Pipeline.Common.TracingTelemetryService] Event: FireActivityStartedEvent ()
DM.EnterpriseGateway Verbose: 0 : 2018-06-29T00:50:26.2524450Z DM.EnterpriseGateway 71e9dddd-a4b1-45fc-b0fb-b6061042dd57 00000000-0000-0000-0000-000000000000 MFGC 00000000-0000-0000-0000-000000000000 593F7EBF [DM.Pipeline.Common.TracingTelemetryService] Event: FireActivityCompletedSuccessfullyEvent (duration=2)
DM.EnterpriseGateway Verbose: 0 : 2018-06-29T00:50:26.2784444Z DM.EnterpriseGateway 8d791e21-a5f1-4ccb-adb4-5b72e7c6060f 00000000-0000-0000-0000-000000000000 MFSC 00000000-0000-0000-0000-000000000000 BB5F1B73 [DM.Pipeline.Common.TracingTelemetryService] Event: FireActivityStartedEvent ()
DM.EnterpriseGateway Verbose: 0 : 2018-06-29T00:50:26.2814471Z DM.EnterpriseGateway 8d791e21-a5f1-4ccb-adb4-5b72e7c6060f 00000000-0000-0000-0000-000000000000 MFSC 00000000-0000-0000-0000-000000000000 13F09589 [DM.Pipeline.Common.TracingTelemetryService] Event: FireActivityCompletedSuccessfullyEvent (duration=0)
DM.EnterpriseGateway Information: 0 : 2018-06-29T00:50:29.7564488Z DM.EnterpriseGateway 5355ac9d-c8ba-4f1a-b612-3308035341ca 620f79b9-fa9e-c56c-c292-c52f650c828e MGPP 55966955-ff53-b4b7-b0be-ac58bde938f3 53919EF5 [DM.GatewayCore] Async operation 42cc3c8d-bff6-4c73-bda0-ef01d78cc390 transitioned into Cancelled state after 300 seconds timeout
DM.EnterpriseGateway Information: 0 : 2018-06-29T00:50:29.7584499Z DM.EnterpriseGateway 5355ac9d-c8ba-4f1a-b612-3308035341ca 620f79b9-fa9e-c56c-c292-c52f650c828e MGPP 55966955-ff53-b4b7-b0be-ac58bde938f3 B0F88F9A [DM.GatewayCore] Cleaning up 0 outstanding packets for spooled job 42cc3c8d-bff6-4c73-bda0-ef01d78cc390 for state transition to Closed
DM.EnterpriseGateway Information: 0 : 2018-06-29T00:50:33.3634446Z DM.EnterpriseGateway 440f26ea-cfad-4e23-a358-577a4416818c 620f79b9-fa9e-c56c-c292-c52f650c828e MGPP 55966955-ff53-b4b7-b0be-ac58bde938f3 7D57A244 [DM.GatewayCore] Async operation 637cbf8e-5441-49b3-974f-ea0d28d2c8e0 transitioned into Cancelled state after 300 seconds timeout
DM.EnterpriseGateway Information: 0 : 2018-06-29T00:50:33.3654449Z DM.EnterpriseGateway 440f26ea-cfad-4e23-a358-577a4416818c 620f79b9-fa9e-c56c-c292-c52f650c828e MGPP 55966955-ff53-b4b7-b0be-ac58bde938f3 6EDF32B2 [DM.GatewayCore] CleanupPackets - Cancelling in-progress streaming. Current job ID: 637cbf8e-5441-49b3-974f-ea0d28d2c8e0
DM.EnterpriseGateway Error: 0 : 2018-06-29T00:50:33.3704459Z DM.EnterpriseGateway de01eb50-3c47-4c12-b048-3a46cd165562 620f79b9-fa9e-c56c-c292-c52f650c828e MGAS 55966955-ff53-b4b7-b0be-ac58bde938f3 577CA30E [DM.Pipeline.Diagnostics] Exception object created [IsBenign=False]: Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.AsyncOperationStreamingCancelledException: The async operation id 637cbf8e-5441-49b3-974f-ea0d28d2c8e0 streaming was cancelled.; ErrorShortName: AsyncOperationStreamingCancelledException
DM.EnterpriseGateway Error: 0 : 2018-06-29T00:50:33.3754482Z DM.EnterpriseGateway de01eb50-3c47-4c12-b048-3a46cd165562 620f79b9-fa9e-c56c-c292-c52f650c828e MGAS 55966955-ff53-b4b7-b0be-ac58bde938f3 3313CF76 [DM.Pipeline.Diagnostics] StackTrace: at Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.AsyncOperationStreamingCancelledException.TraceConstructor()
at Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.AsyncOperationStreamingCancelledException..ctor(Guid asyncOperationId, PowerBIErrorDetail[] errorDetails)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.GatewayOperationResultSpooler.SpooledOperationController.SpooledOperationPacketManager.<StreamAsync>d__18.MoveNext()
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Runtime.CompilerServices.AsyncMethodBuilderCore.MoveNextRunner.Run()
at System.Threading.Tasks.AwaitTaskContinuation.RunOrScheduleAction(Action action, Boolean allowInlining, Task& currentTask)
at System.Threading.Tasks.Task.FinishContinuations()
at System.Threading.Tasks.Task`1.TrySetCanceled(CancellationToken tokenToRecord, Object cancellationException)
at System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.SetException(Exception exception)
at System.Threading.SemaphoreSlim.<WaitUntilCountOrTimeoutAsync>d__31.MoveNext()
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Runtime.CompilerServices.AsyncMethodBuilderCore.MoveNextRunner.Run()
at System.Threading.Tasks.AwaitTaskContinuation.RunOrScheduleAction(Action action, Boolean allowInlining, Task& currentTask)
at System.Threading.Tasks.Task.FinishContinuations()
at System.Threading.Tasks.Task`1.TrySetResult(TResult result)
at System.Threading.Tasks.TaskFactory.CompleteOnInvokePromise.Invoke(Task completingTask)
at System.Threading.Tasks.Task.FinishContinuations()
at System.Threading.Tasks.Task`1.TrySetCanceled(CancellationToken tokenToRecord, Object cancellationException)
at System.Threading.Tasks.Task.DelayPromise.Complete()
at System.Threading.CancellationCallbackInfo.ExecuteCallback()
at System.Threading.CancellationTokenSource.ExecuteCallbackHandlers(Boolean throwOnFirstException)
at System.Threading.CancellationTokenSource.NotifyCancellation(Boolean throwOnFirstException)
at System.Threading.CancellationTokenSource.LinkedTokenCancelDelegate(Object source)
at System.Threading.CancellationCallbackInfo.ExecuteCallback()
at System.Threading.CancellationTokenSource.ExecuteCallbackHandlers(Boolean throwOnFirstException)
at System.Threading.CancellationTokenSource.NotifyCancellation(Boolean throwOnFirstException)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.GatewayOperationResultSpooler.SpooledOperationController.SpooledOperationPacketManager.<CleanupPacketsAsync>d__17.MoveNext()
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Runtime.CompilerServices.AsyncMethodBuilderCore.MoveNextRunner.Run()
at System.Threading.QueueUserWorkItemCallback.System.Threading.IThreadPoolWorkItem.ExecuteWorkItem()
at System.Threading.ThreadPoolWorkQueue.Dispatch()

DM.EnterpriseGateway Error: 0 : 2018-06-29T00:50:33.3814471Z DM.EnterpriseGateway de01eb50-3c47-4c12-b048-3a46cd165562 620f79b9-fa9e-c56c-c292-c52f650c828e MGAS 55966955-ff53-b4b7-b0be-ac58bde938f3 2DBE9A5A [DM.Pipeline.Common.TracingTelemetryService] Event: FireActivityCompletedWithFailureEvent (duration=1365119, err=AsyncOperationStreamingCancelledException, rootcauseErrorEventId=0)
DM.EnterpriseGateway Error: 0 : 2018-06-29T00:50:33.3834476Z DM.EnterpriseGateway 97b6cca4-ebb2-4e74-8e33-b3af9b00297e 620f79b9-fa9e-c56c-c292-c52f650c828e MGPS 55966955-ff53-b4b7-b0be-ac58bde938f3 C1938565 [DM.Pipeline.Common.TracingTelemetryService] Event: FireActivityCompletedWithFailureEvent (duration=1365125, err=AsyncOperationStreamingCancelledException, rootcauseErrorEventId=0)
DM.EnterpriseGateway Error: 0 : 2018-06-29T00:50:33.3884454Z DM.EnterpriseGateway 5b2dfe3a-59f9-497d-9a2a-5b9ee1de8e64 620f79b9-fa9e-c56c-c292-c52f650c828e MDSR 55966955-ff53-b4b7-b0be-ac58bde938f3 A7575071 [DM.GatewayCore] Error serializing response: [0]Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.AsyncOperationStreamingCancelledException: The async operation id 637cbf8e-5441-49b3-974f-ea0d28d2c8e0 streaming was cancelled.

GatewayPipelineErrorCode=DM_GWPipeline_UnknownError
AsyncOperationId=637cbf8e-5441-49b3-974f-ea0d28d2c8e0
([0]Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.AsyncOperationStreamingCancelledException.StackTrace:)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.GatewayOperationResultSpooler.SpooledOperationController.SpooledOperationPacketManager.<StreamAsync>d__18.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.GatewayOperationResultSpooler.SpooledOperationController.<StreamAsync>d__31.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.Serialization.GatewaySerializer.<>c__DisplayClass14_0.<<SerializeImpl>b__0>d.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.DataMovement.Pipeline.Common.Diagnostics.PipelineTelemetryService.<ExecuteInActivity>d__5.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.Serialization.GatewaySerializer.<SerializeImpl>d__14.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.Serialization.GatewaySerializer.<>c__DisplayClass13_0.<<Serialize>b__0>d.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.DataMovement.Pipeline.Common.Diagnostics.PipelineTelemetryService.<ExecuteInActivity>d__5.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.Serialization.GatewaySerializer.<Serialize>d__13.MoveNext()

 

Any help is appreciated.

Thanks

Eli

alexandre_rowup
Frequent Visitor

@Elirot , I have the same problem on PowerBI Gateway!

You problem has solved?

You can help-me?

Thank you!

GGNOGUEIRA
Regular Visitor

Hey guys, im taking the same issue here. Already updated to the last version and do not goes around. Any new ideas?

 

5C8E5D31 [DM.GatewayCore] Error processing request: [0]Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.UnknownSpooledOperationIdException: The spooled operation id 5b8c4b7c-6b3a-4e4f-9537-3d3e548b55da does not exist.