cancel
Showing results for 
Search instead for 
Did you mean: 

Random Refresh Error DM_GWPipeline_Gateway_MashupDataAccessError to a Sharepoint library

Figure 1.1 shows the error message from the service which seems to pick a different file in the library each failure.  Also without making any changes in the service or the library the next refresh could be successful or fail (figure 1.2).  We have seen the random failures in the refresh history since June 17th.  Thank you for any assistance or guidance in helping to resolve our refresh issue


Figure 1.1 - Failure Error sent from failed Refresh


Report xxxx has failed to refresh.
Failure details: 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_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":"<pi>SharePoint: Request failed: xxx Randomly selected File from the Sharepoint Library _api/contextinfo</pi>"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"SharePoint"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":" Enterprise SharePoint Site"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}},{"code":"Microsoft.Data.Mashup.ValueError.SPRequestGuid","detail":{"type":1,"value":"f877659f-8091-a000-8e4c-96c2f09a5d1b"}}],"exceptionCulprit":1}}} Table: xxxx Table.

 

Figure 1.2 - Refresh history

 

Status: New
Comments
Community Support

@Cheyenne_Jacobi ,

 

I would suggest you create a support ticket here for further analysis.

Support Ticket.gif 

Regards,

Jimmy Tao

New Member

Thank you, entered the support ticket

Regular Visitor

Hi @Cheyenne_Jacobi , did you get a solution for the issue?

we have the same exact problem with one of our datasets, albeit with another source (postgresql).

Thanks.
Claudio

Helper V

Also having similar issue reported with random failures in the service and also now appearing on desktop refreshes using August 2020 version

 

Has this been solved yet? @Cheyenne_Jacobi  @v-yuta-msft @csabia