Any problems or issues? Let me know!

English Language - Forum SuiteCRM Analytics
37

I’m still struggling. Now, when I create a Data Source, after finishin the wizard I get the following message:

For some reason we are unable to query the selected table(s). Check your permissions and try again.
org.pentaho.agilebi.modeler.ModelerException: org.pentaho.di.core.exception.KettleDatabaseException:
Couldn’t get field info from [SELECT * FROM suitecrm_integration.S_CONTACTS LIMIT 0]
Error determining value metadata from SQL resultset metadata
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘OPTION SQL_SELECT_LIMIT=DEFAULT’ at line 1

The user that connects to the database is root, so I don’t think it’s a permissions issue.
The JDBC driver is the latest (5.145 implements specificaiton 4.2)

Any idea?