Forum Discussion

eTribble's avatar
eTribble
Advocate 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.

eTribble's avatar
eTribble
Advocate II
3 years ago

Im not, I use Direct Query to a MySQL Database, The MySQL version of the database is 5.7 but thats what the company wants.

I direct query to the database through the On-Premises Data Gateway (which is up-to-date).

So I am not using ODBC. ODBC is slower than Direct Query. And with the queries I run I need speed.

Unless Im mistaken, im not using a driver. And I have have been doing it this way for months without issues.
This is all just new and only in the last month, and its random.

lbendlin's avatar
lbendlin
Super User
3 years ago

Check your installed apps list.  You will find something like 

 

 

  • eTribble's avatar
    eTribble
    Advocate II
    3 years ago


    Oh mybad, sorry its an early morning. Here it is, its 8.0.30 and I check for updates on it as well, and it says its up-to date.

    • lbendlin's avatar
      lbendlin
      Super User
      3 years ago

      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.

      • eTribble's avatar
        eTribble
        Advocate II
        3 years ago

        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?