On-Premise Gateway refresh issue with error "DM_GWPipeline_Client_GatewayUnreachable"

[dluo]

We just cloned a server and all a sudden the reports were failed to refresh even after uninstalled the Gateway from the cloned server. Very bizzared was that sometimes some sceduled reports were refreshed successfully while others failed. The main error message was "{"error":{"code":"DM_GWPipeline_Client_GatewayUnreachable","pbi.error":{"code":"DM_GWPipeline_Client_GatewayUnreachable","parameters":{},"details":[],"exceptionCulprit":1}}} Table: XXXX"

Anyone happened to have this issue and on how to fix it?

Thank you for your help

[Anonymous]

Hi @dluo 

Usually, these kinds of errors are related to the gateway.

You mentioned that "We just cloned a server and all a sudden the reports were failed to refresh even after uninstalled the Gateway from the cloned server. " , can you explain it in detail ? Why you uninstall the gateway ? After you uninstalled the gateway, what did the associated reports rely on for refreshing? Perhaps you can update the installation of the gateway on the server you are using.

Best Regards,
Community Support Team _ Ailsa Tao

[dluo]

Happy New Year and thanks for your help, Ailsa!

After we cloned the Prod server, I found that we had the same Gateway on both servers. So I uninstalled the Gateway in the cloned server while kept the one in Prod sever. All reports refreshing are relied on the one in Prod. Yeah the Gateway in the Prod server was updated to the latest version (Dec. 2022 version). 

Regards

David

Below is the detailed errror message I got this morning in case it helps.

Scheduled 1/3/2023, 7:31:07 AM 1/3/2023, 7:31:46 AM Failed There was an error when processing the data in the dataset.
Data source error: {"error":{"code":"DM_GWPipeline_Client_GatewayUnreachable","pbi.error":{"code":"DM_GWPipeline_Client_GatewayUnreachable","parameters":{},"details":[],"exceptionCulprit":1}}} Table: Users.
Cluster URI: WABI-WEST-US-C-PRIMARY-redirect.analysis.windows.net
Activity ID: 20568562-c799-4b8e-a0f8-6d22ebf684d9
Request ID: 4958f55d-0822-4cde-abe0-9c2a514061be
Time: 2023-01-03 15:31:46Z

[dluo]

Hello Alisa,

Could you please share some update on this issue?

It seems got worse those days and the common error message for the failure is:

The last refresh attempt failed because of an internal service error. This is usually a transient issue. If you try again later and still see this message, contact support.

{"error":{"code":"DM_GWPipeline_Client_GatewayUnreachable","pbi.error":{"code":"DM_GWPipeline_Client_GatewayUnreachable","parameters":{},"details":[],"exceptionCulprit":1}}}

Any ETA on when this could have a resolution?

Please let me know if you need any other details to dig into the issue.

Thanks in advance!

David

[AdvancedPbi]

Has anyone been able to solve this issue?

Im having the exact same problem, the file refreshes in the begining of the day (7am), and afterwards starts failing with the "gateway unreachable" error.

Note: the latest version of the gateway is installed.

[Data_Dasher]

Has anyone found a solution for this? I am having the same issue, and the latest version of the gateway is installed. Please help!

[johnson3]

I faced similar issue.

We migrated Gateway Server from On Premise to Azure using a VM Clone approach.

The Gateway was online in Azure, the on-premise server was shutdown.

But the report refreshes were failing with error message On-Premise Gateway refresh issue with error "DM_GWPipeline_Client_GatewayUnreachable"

I updated the Gateway to the latest version and refreshed all the shared connections and Issue was resseolved