You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I am trying to use the pluging but I am getting this error:
2018/01/14 17:55:43 - get_metadata - Dispatching started for transformation [get_metadata]
org.pentaho.di.core.exception.KettleDatabaseException:
An error occurred executing SQL:
SELECT ^M
"LAST_UPDATE",^M
"NUMBER_ROWS",^M
"USER" ^M
FROM "PENTAHO_CE_AUDIT_METADATA"^M
^M
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '"PENTAHO_CE_AUDIT_METADATA"' at line 5
at org.pentaho.di.core.database.Database.openQuery(Database.java:1768)
at org.pentaho.di.trans.steps.tableinput.TableInput.doQuery(TableInput.java:236)
at org.pentaho.di.trans.steps.tableinput.TableInput.processRow(TableInput.java:140)
at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
at java.lang.Thread.run(Thread.java:748)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '"PENTAHO_CE_AUDIT_METADATA"' at line 5
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
at com.mysql.jdbc.Util.getInstance(Util.java:408)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:943)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2486)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2444)
at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1381)
at org.pentaho.di.core.database.Database.openQuery(Database.java:1757)
The text was updated successfully, but these errors were encountered:
The plugin for now is available only for postgresql databases, but if you have any experience in Pentaho App Builder applications you can change the connection type...
Hi,
I am trying to use the pluging but I am getting this error:
2018/01/14 17:55:43 - get_metadata - Dispatching started for transformation [get_metadata]
org.pentaho.di.core.exception.KettleDatabaseException:
An error occurred executing SQL:
SELECT ^M
"LAST_UPDATE",^M
"NUMBER_ROWS",^M
"USER" ^M
FROM "PENTAHO_CE_AUDIT_METADATA"^M
^M
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '"PENTAHO_CE_AUDIT_METADATA"' at line 5
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '"PENTAHO_CE_AUDIT_METADATA"' at line 5
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
at com.mysql.jdbc.Util.getInstance(Util.java:408)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:943)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2486)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2444)
at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1381)
at org.pentaho.di.core.database.Database.openQuery(Database.java:1757)
The text was updated successfully, but these errors were encountered: