cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
gary_townsend Frequent Visitor
Frequent Visitor

UnknownSpooledOperationIdException

 

I've got a user who has been unable to schedule refresh some of his Power BI reports. I got a copy of one of his reports and tried scheduling it for refresh and even tried using the refresh now option all to no avail the error message below has no information about the error. So i went to the gateway service log and using the Request ID was able to find the entry in the log file.

2018-03-02 11_02_57-Power BI.png

Thing is the entry in the log file isn't much more help:

DM.EnterpriseGateway Error: 0 : 2018-03-02T18:57:11.5121998Z DM.EnterpriseGateway	8187d0a3-c00d-4f4e-a9f3-cdafe5041df4	5f7e73ac-24f6-089e-cf83-836b7beba321	MGAP	bd8d603f-c931-4deb-8984-adbfce972f04	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()

has anyone run across this issue before? 

Full log file can be found here.

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-qiuyu-msft
Moderator

Re: UnknownSpooledOperationIdException

Hi @gary_townsend,

 

1. Please download the report and open in Power BI desktop, check if you can refresh data successfully in Power BI desktop. 

2. Please update on-premise data gateway to the latest version. 

3. From gateway log files, I find a warning: "[DM.Pipeline.Common] Failed to parse gateway core config file: Object reference not set to an instance of an object."

 

It seems that the gateway service account has problem to read the config file. Please check which service account gateway used. Please try to change the service account to a Local Admin to see if the refresh can be completed: https://docs.microsoft.com/en-us/power-bi/service-gateway-proxy#changing-the-gateway-service-account...

 

Best Regards,
Qiuyun Yu 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
5 REPLIES 5
Moderator v-qiuyu-msft
Moderator

Re: UnknownSpooledOperationIdException

Hi @gary_townsend,

 

1. Please download the report and open in Power BI desktop, check if you can refresh data successfully in Power BI desktop. 

2. Please update on-premise data gateway to the latest version. 

3. From gateway log files, I find a warning: "[DM.Pipeline.Common] Failed to parse gateway core config file: Object reference not set to an instance of an object."

 

It seems that the gateway service account has problem to read the config file. Please check which service account gateway used. Please try to change the service account to a Local Admin to see if the refresh can be completed: https://docs.microsoft.com/en-us/power-bi/service-gateway-proxy#changing-the-gateway-service-account...

 

Best Regards,
Qiuyun Yu 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Vicky_Song Established Member
Established Member

Re: UnknownSpooledOperationIdException - Status changed to: Needs Info

 
Highlighted
gary_townsend Frequent Visitor
Frequent Visitor

Re: UnknownSpooledOperationIdException

 Your suggestions of changing the service account to a local admin account worked. I had updated the service after posting this message and the results were the same as previous, the scheduled refresh failed.

 

However one i changed the service account, this did work for me.

 

Thank you.

Moderator v-qiuyu-msft
Moderator

Re: UnknownSpooledOperationIdException

Hi @gary_townsend,

 

Thanks for your update. As the issue is solved now, I will close this thread. 

 

Best Regards,
Qiuyun Yu 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
gsakai New Member
New Member

Re: UnknownSpooledOperationIdException

Hello @v-qiuyu-msft

 

Your solution helped me yesterday.

 

Thank you.

 

Kind regards,

Gabriel Sakai