Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Connecting to MongoDB using ODBC

Hi, 

I have the data stored in a MongoDB. I use ODBC to bring the data to PowerBI.

It has worked for a few months, but suddenly when I try to refresh the data I get this error:

 

"ODBC: ERROR [42S21] [MySQL][ODBC 1.2(w) Driver][mysqld-5.7.12 mongosqld v2.11.0]Duplicate column name 'KEY_COLUMN_USAGE.CONSTRAINT_CATALOG'".

 

I tried in the Get Data advanced options, added a SQL statement ("SELECT * FROM robot-inits;") but the error still remains.

Any ideas what could be happening?

Thanks!

  • Anonymous's avatar
    Anonymous
    7 years ago

    The issue was because MongoDB released an update. The problem was solved by apllying the update to our DB.

    Thanks!

3 Replies

  • TeigeGao's avatar
    TeigeGao
    Icon for Solution Sage rankSolution Sage

    Hi Anonymous ,

    In this scenario, I would suggest you using other application to test this ODBC source for troubleshooting.

    Best Regards,

    Teige

  • Anonymous's avatar
    Anonymous
    Not applicable

    The issue was because MongoDB released an update. The problem was solved by apllying the update to our DB.

    Thanks!

    • Anonymous's avatar
      Anonymous
      Not applicable

      Can you tell me where you got the update from. We are facing similar issue and want to know where we can download the update.

       

      Thanks,

      Raj