Forum Discussion

eTribble's avatar
eTribble
Icon for Advocate II rankAdvocate II
3 years ago
Solved

DM_GWPipeline_Gateway_MashupDataAccessError (Not like other post)

So I have multiple reports that pull from 1 or 2 MySQL databases, Most pull from the same database in which I get this error. The "table" at the end of the error varies. And this error is not constin...
"error" "reports"
Auto Refresh
  • eTribble's avatar
    eTribble
    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.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
3 years ago

just the .Net connector

eTribble's avatar
eTribble
Icon for Advocate II rankAdvocate II
3 years ago
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 UTC

 

Got 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.