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