java.lang.reflect.InvocationTargetException: Couldn't find any rows because of an error :org.pentaho.di.core.exception.KettleDatabaseException: An error occurred executing SQL: SELECT * FROM char_types LIMIT 100 [Vertica][VJDBC](100081) ERROR: Relation "char_types" does not exist

Pentaho BI Platform Tracking | mark warner | 4 years ago
  1. 0

    when using the database explorer and vertica you have to pick a schema name or you will encounter the following error... Pick any table Pentaho kettle missing three part naming. java.lang.reflect.InvocationTargetException: Couldn't find any rows because of an error :org.pentaho.di.core.exception.KettleDatabaseException: An error occurred executing SQL: SELECT * FROM char_types LIMIT 100 [Vertica][VJDBC](100081) ERROR: Relation "char_types" does not exist at org.pentaho.di.ui.core.database.dialog.GetPreviewTableProgressDialog$1.run(GetPreviewTableProgressDialog.java:89) at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:113) Caused by: org.pentaho.di.core.exception.KettleDatabaseException: An error occurred executing SQL: SELECT * FROM char_types LIMIT 100 [Vertica][VJDBC](100081) ERROR: Relation "char_types" does not exist at org.pentaho.di.core.database.Database.openQuery(Database.java:1857) at org.pentaho.di.core.database.Database.openQuery(Database.java:1784) at org.pentaho.di.core.database.Database.openQuery(Database.java:1779) at org.pentaho.di.core.database.Database.openQuery(Database.java:1766) at org.pentaho.di.core.database.Database.getRows(Database.java:3748) at org.pentaho.di.core.database.Database.getFirstRows(Database.java:3833) at org.pentaho.di.ui.core.database.dialog.GetPreviewTableProgressDialog$1.run(GetPreviewTableProgressDialog.java:84) ... 1 more Caused by: java.sql.SQLException: [Vertica][VJDBC](100081) ERROR: Relation "char_types" does not exist at com.vertica.util.ServerErrorData.buildException(Unknown Source) at com.vertica.dataengine.VQueryExecutor.executeSimpleProtocol(Unknown Source) at com.vertica.dataengine.VQueryExecutor.execute(Unknown Source) at com.vertica.jdbc.SStatement.executeNoParams(Unknown Source) at com.vertica.jdbc.SStatement.executeQuery(Unknown Source) at org.pentaho.di.core.database.Database.openQuery(Database.java:1843) ... 7 more Caused by: com.vertica.util.ServerException: [Vertica][VJDBC](100081) ERROR: Relation "char_types" does not exist ... 13 more

    Pentaho BI Platform Tracking | 4 years ago | mark warner
    java.lang.reflect.InvocationTargetException: Couldn't find any rows because of an error :org.pentaho.di.core.exception.KettleDatabaseException: An error occurred executing SQL: SELECT * FROM char_types LIMIT 100 [Vertica][VJDBC](100081) ERROR: Relation "char_types" does not exist
  2. 0

    when using the database explorer and vertica you have to pick a schema name or you will encounter the following error... Pick any table Pentaho kettle missing three part naming. java.lang.reflect.InvocationTargetException: Couldn't find any rows because of an error :org.pentaho.di.core.exception.KettleDatabaseException: An error occurred executing SQL: SELECT * FROM char_types LIMIT 100 [Vertica][VJDBC](100081) ERROR: Relation "char_types" does not exist at org.pentaho.di.ui.core.database.dialog.GetPreviewTableProgressDialog$1.run(GetPreviewTableProgressDialog.java:89) at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:113) Caused by: org.pentaho.di.core.exception.KettleDatabaseException: An error occurred executing SQL: SELECT * FROM char_types LIMIT 100 [Vertica][VJDBC](100081) ERROR: Relation "char_types" does not exist at org.pentaho.di.core.database.Database.openQuery(Database.java:1857) at org.pentaho.di.core.database.Database.openQuery(Database.java:1784) at org.pentaho.di.core.database.Database.openQuery(Database.java:1779) at org.pentaho.di.core.database.Database.openQuery(Database.java:1766) at org.pentaho.di.core.database.Database.getRows(Database.java:3748) at org.pentaho.di.core.database.Database.getFirstRows(Database.java:3833) at org.pentaho.di.ui.core.database.dialog.GetPreviewTableProgressDialog$1.run(GetPreviewTableProgressDialog.java:84) ... 1 more Caused by: java.sql.SQLException: [Vertica][VJDBC](100081) ERROR: Relation "char_types" does not exist at com.vertica.util.ServerErrorData.buildException(Unknown Source) at com.vertica.dataengine.VQueryExecutor.executeSimpleProtocol(Unknown Source) at com.vertica.dataengine.VQueryExecutor.execute(Unknown Source) at com.vertica.jdbc.SStatement.executeNoParams(Unknown Source) at com.vertica.jdbc.SStatement.executeQuery(Unknown Source) at org.pentaho.di.core.database.Database.openQuery(Database.java:1843) ... 7 more Caused by: com.vertica.util.ServerException: [Vertica][VJDBC](100081) ERROR: Relation "char_types" does not exist ... 13 more

    Pentaho BI Platform Tracking | 4 years ago | mark warner
    java.lang.reflect.InvocationTargetException: Couldn't find any rows because of an error :org.pentaho.di.core.exception.KettleDatabaseException: An error occurred executing SQL: SELECT * FROM char_types LIMIT 100 [Vertica][VJDBC](100081) ERROR: Relation "char_types" does not exist
  3. 0

    Re: Exporting to non standard databases

    apache.org | 11 months ago
    java.io.IOException: java.sql.SQLException: [Vertica][VJDBC](4856) ERROR: Syntax error at or near ","
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. com.vertica.util.ServerException

      [Vertica][VJDBC](100081) ERROR: Relation "char_types" does not exist

      at com.vertica.util.ServerErrorData.buildException()
    2. com.vertica.util
      ServerErrorData.buildException
      1. com.vertica.util.ServerErrorData.buildException(Unknown Source)
      1 frame
    3. com.vertica.dataengine
      VQueryExecutor.execute
      1. com.vertica.dataengine.VQueryExecutor.executeSimpleProtocol(Unknown Source)
      2. com.vertica.dataengine.VQueryExecutor.execute(Unknown Source)
      2 frames
    4. com.vertica.jdbc
      SStatement.executeQuery
      1. com.vertica.jdbc.SStatement.executeNoParams(Unknown Source)
      2. com.vertica.jdbc.SStatement.executeQuery(Unknown Source)
      2 frames
    5. org.pentaho.di
      GetPreviewTableProgressDialog$1.run
      1. org.pentaho.di.core.database.Database.openQuery(Database.java:1843)
      2. org.pentaho.di.core.database.Database.openQuery(Database.java:1784)
      3. org.pentaho.di.core.database.Database.openQuery(Database.java:1779)
      4. org.pentaho.di.core.database.Database.openQuery(Database.java:1766)
      5. org.pentaho.di.core.database.Database.getRows(Database.java:3748)
      6. org.pentaho.di.core.database.Database.getFirstRows(Database.java:3833)
      7. org.pentaho.di.ui.core.database.dialog.GetPreviewTableProgressDialog$1.run(GetPreviewTableProgressDialog.java:84)
      7 frames
    6. JFace
      ModalContext$ModalContextThread.run
      1. org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:113)
      1 frame