Scheduler Failed Running: DM_GWPipeline_Gateway_SpooledOperationMissing

[XIOFEN_LIM]

Hi,

I may need help about issue below. 

Scheduler failed running by shwing this Gateway_SpooledOperationMissing error. 

This issue happen since yesterday afternoon. This morning I have tried to restart the gateway and schedule auto refresh at 930am and it running successfully. When come to next auto refresh, the same error shown.

{"error":{"code":"DM_GWPipeline_Gateway_SpooledOperationMissing","pbi.error":{"code":"DM_GWPipeline_Gateway_SpooledOperationMissing","parameters":{},"details":[],"exceptionCulprit":1}}} Table: V_QA.

[XIOFEN_LIM · Accepted solution]

Hi,

I have fixed the issue by changing the source database name to IP in Power BI files, republish them and reset the gateway connection.

It happened because yesterday my colleague hav setup Azure could server with VPN and cloning from on premises server.

both DB showing same name causing gateway failed to reconigze which DB to refer.

[jcastr02]

@XIOFEN_LIM   Hello, how do you change source database names to IP In power bi files?

[XIOFEN_LIM]

Hi @jcastr02 ,

Open the pbx file --> click "File" tab -->select "Options & settings" -->click "Data Source Settings" --> select the source then click "change source" button --> change the info then save

[Anonymous]

'Changing the source database name to IP'

What is meant by IP in here?

[V-lianl-msft]

Hi @XIOFEN_LIM ,

It's glad that you have solved your problem.
Please accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.