Scheduled refresh fails due to DM_GWPipeline_Gateway_MashupDataAccessError

[8jesse]

Hello, I'm using Premium P3 and schedule refresh twice a day through the on-premise data gateway.

It is successful normally, but sometimes refresh is failed due the following error. Can someone help to fix this?

{"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"We're sorry, an error occurred during evaluation."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}}],"exceptionCulprit":1}}} Table: gp_account.

[v-janeyg-msft]

Hi, @8jesse 

If the refresh fails occasionally, it may be caused by insufficient memory or machine space allocation. You can check it.

Best Regards

Janey Guo

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

[8jesse]

I have upgraded the gateway to version 3000.86.1 (June 2021), but I'm still getting the same error.

This is the error code after the upgrade.

Data source error{"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"We're sorry, an error occurred during evaluation."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}}],"exceptionCulprit":1}}} Table: gp_account.
Cluster URIWABI-CANADA-CENTRAL-redirect.analysis.windows.net
Activity ID12c38e78-7324-4635-b440-2f6fbaac5163
Request IDec7cb7f0-c197-413d-98e1-df291e722947
Time2021-06-18 06:10:13Z

[collinq]

Hi @8jesse ,

We recently had this problem as well and the fix was to upgrade the gateway.

[8jesse]

Hello @collinq 

I have updated the gateway to the latest version but still having the same problem. I'm getting the same error message. Can you help please?

[8jesse]

I'm using 3000.68.15 and will update gateway to see the problem is fixed 🙂

Thank you.