Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Something went wrong
It looks like scheduled refresh failed because the on-premises gateway restarted while refresh was happening. Double-check that the data gateway is continuously running for the next scheduled refresh.
Please try again later or contact support. If you contact support, please provide these details.
Cluster URI: WABI-US-EAST-A-PRIMARY-redirect.analysis.windows.net
Activity ID: 604efcf1-ec1c-4a26-8246-d04194900a0f
Request ID: 68a0f4f6-cf43-10cd-73a4-fb063d97809d
Time: 2019-06-03 19:44:36Z
I've confirmed the gateway is up and running.
In going to Power BI Service, Settings, and testing the gateway connection, the test is successfull.
The log from the gateway shows errors:
DM.EnterpriseGateway Error: 0 : 2019-06-03T15:45:40.6806426Z DM.EnterpriseGateway b67620b8-4767-4f73-a9a9-a7e5a82cf67c ac2e7fcd-958e-d152-c340-e896fcde8686 MGAA 604efcf1-ec1c-4a26-8246-d04194900a0f 2d4eadd9-c70b-450c-b4b9-fcc4c0dd6cab 2a25be4c-69cd-4e08-97c9-d18a0e9b8001 84547463 [DM.Pipeline.Diagnostics] Exception object created [IsBenign=True]: Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.UnknownSpooledOperationIdException: The spooled operation id c43f8838-9037-48c7-a327-3672072c746c does not exist. Evict code: -1.; ErrorShortName: UnknownSpooledOperationIdException DM.EnterpriseGateway Error: 0 : 2019-06-03T15:45:40.6806426Z DM.EnterpriseGateway 3e7472ef-17bd-469f-b46a-bd644a4d9214 ac2e7fcd-958e-d152-c340-e896fcde8686 MGAA 604efcf1-ec1c-4a26-8246-d04194900a0f d0ca45da-a6d6-4317-9fbd-72a4f97f666c ba5137f3-5a85-4a2a-9898-529033b9380f 7EA0E95E [DM.Pipeline.Diagnostics] Exception object created [IsBenign=True]: Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.UnknownSpooledOperationIdException: The spooled operation id 22255cce-6078-412c-ada3-b6b583bc5adb does not exist. Evict code: -1.; ErrorShortName: UnknownSpooledOperationIdException DM.EnterpriseGateway Error: 0 : 2019-06-03T15:45:40.6806426Z DM.EnterpriseGateway 3e7472ef-17bd-469f-b46a-bd644a4d9214 ac2e7fcd-958e-d152-c340-e896fcde8686 MGAA 604efcf1-ec1c-4a26-8246-d04194900a0f d0ca45da-a6d6-4317-9fbd-72a4f97f666c ba5137f3-5a85-4a2a-9898-529033b9380f A7D01B74 [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__DisplayClass13_0.<<AcknowledgeAsyncPacket>b__0>d.MoveNext() at System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.Start[TStateMachine](TStateMachine& stateMachine) at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.GatewayProcessor.<>c__DisplayClass13_0.<AcknowledgeAsyncPacket>b__0() at Microsoft.PowerBI.DataMovement.Pipeline.GatewayPipelineTelemetry.PipelineTelemetryService.<ExecuteInActivity>d__7`1.MoveNext() at System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.Start[TStateMachine](TStateMachine& stateMachine) at Microsoft.PowerBI.DataMovement.Pipeline.GatewayPipelineTelemetry.PipelineTelemetryService.ExecuteInActivity[T](PipelineActivityType pipelineActivityType, Func`1 action) at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.GatewayProcessor.<AcknowledgeAsyncPacket>d__13.MoveNext() at System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.Start[TStateMachine](TStateMachine& stateMachine) at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.GatewayProcessor.AcknowledgeAsyncPacket(GatewaySerializationContext responseContext, AcknowledgeAsyncPacketRequest 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.GatewayPipelineTelemetry.PipelineTelemetryService.<ExecuteInActivity>d__7`1.MoveNext() at System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.Start[TStateMachine](TStateMachine& stateMachine) at Microsoft.PowerBI.DataMovement.Pipeline.GatewayPipelineTelemetry.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 Error: 0 : 2019-06-03T15:45:40.6806426Z DM.EnterpriseGateway b67620b8-4767-4f73-a9a9-a7e5a82cf67c ac2e7fcd-958e-d152-c340-e896fcde8686 MGAA 604efcf1-ec1c-4a26-8246-d04194900a0f 2d4eadd9-c70b-450c-b4b9-fcc4c0dd6cab 2a25be4c-69cd-4e08-97c9-d18a0e9b8001 A7D01B74 [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__DisplayClass13_0.<<AcknowledgeAsyncPacket>b__0>d.MoveNext() at System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.Start[TStateMachine](TStateMachine& stateMachine) at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.GatewayProcessor.<>c__DisplayClass13_0.<AcknowledgeAsyncPacket>b__0() at Microsoft.PowerBI.DataMovement.Pipeline.GatewayPipelineTelemetry.PipelineTelemetryService.<ExecuteInActivity>d__7`1.MoveNext() at System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.Start[TStateMachine](TStateMachine& stateMachine) at Microsoft.PowerBI.DataMovement.Pipeline.GatewayPipelineTelemetry.PipelineTelemetryService.ExecuteInActivity[T](PipelineActivityType pipelineActivityType, Func`1 action) at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.GatewayProcessor.<AcknowledgeAsyncPacket>d__13.MoveNext() at System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.Start[TStateMachine](TStateMachine& stateMachine) at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.GatewayProcessor.AcknowledgeAsyncPacket(GatewaySerializationContext responseContext, AcknowledgeAsyncPacketRequest 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.GatewayPipelineTelemetry.PipelineTelemetryService.<ExecuteInActivity>d__7`1.MoveNext() at System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.Start[TStateMachine](TStateMachine& stateMachine) at Microsoft.PowerBI.DataMovement.Pipeline.GatewayPipelineTelemetry.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() ...
...
...
Solved! Go to Solution.
Hi @therealomacoder ,
I trace your request id and find out this issue is related to 'as service'. I'd like to suggest you open a support ticket to get further support.
Model refresh failed for modelId='1892886': [0]Microsoft.PowerBI.Common.PowerBIDataMovementBasedRefreshFailure: AS Engine received from Data Movement Service. HttpStatus: 400. PowerBIErrorCode: DM_GWPipeline_Gateway_SpooledOperationMissing
Regards,
Xiaoxin Sheng
Hi @therealomacoder ,
I trace your request id and find out this issue is related to 'as service'. I'd like to suggest you open a support ticket to get further support.
Model refresh failed for modelId='1892886': [0]Microsoft.PowerBI.Common.PowerBIDataMovementBasedRefreshFailure: AS Engine received from Data Movement Service. HttpStatus: 400. PowerBIErrorCode: DM_GWPipeline_Gateway_SpooledOperationMissing
Regards,
Xiaoxin Sheng
Thank you. I opened an incident and they asked me to uninstall and reinstall the gateway, even though we were running the latest version of the gateway.
This resolved the issue.
I asked the support person how we prevent this from happneing in the future, or what caused this in the first place. Their response was that we're sending too much data through the gateway. Hmm... didn't know there was a limitation, and there's probably 15 tables in the model, only a few of them have over 50K rows. Not a lot of data, IMO....
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.