Forum Discussion
DM_GWPipeline_Gateway_MashupDataAccessError (Not like other post)
- 3 years ago
I fixed it, it was actualy the query itself causeing it to time out. I re-ajusted the query and no more issues.
If you can, go back to 8.0.28 . There was a bug in 8.0.29 and I don't know if 8.0.30 fixed it.
How do you downgrade? Do I uninstall then choose the 8.0.28 version, do I need to do it on all MySQL apps? Like the workbench and all of that or just the Net connecter?
- lbendlin3 years ago
Super User
just the .Net connector
- eTribble3 years ago
Advocate II
Ok downgraded the net connector, and restarted my gateway. I manually refreshed one of the reports to make sure it still manually refreshed and its good.
So I will see if I get any more errors during the auto refreshes, hope this fixed it. Thank you for your help. - eTribble3 years ago
Advocate II
An error occurred while processing the data in the dataset. Refresh failed: LeadTracker 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":"<ccon>MySQL: Fatal error encountered during command execution.</ccon>"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"MySql"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"<ccon>[Removed for Security].database.azure.com;crm</ccon>"}},{"code":"Microsoft.Data.Mashup.ValueError.ErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Message","detail":{"type":1,"value":"Fatal error encountered during command execution."}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: Payment. Refresh Start Time: January 11, 2023 20:04 UTC Refresh End Time: January 11, 2023 20:06 UTCGot the Error again after the downgrade and reset. the Error is above but I put [Removed for Security] in the host name spot, the actual full host is there in the original message.