org.pentaho.di.core.exception.KettleDatabaseException: Couldn't execute SQL: DROP TABLE "pg1" ERROR: table "pg1" does not exist

Pentaho BI Platform Tracking | Mat Lowery | 6 years ago
  1. 0

    Repro: 1. Create a new datasource. 2. Inspect log for error message like the one below. I used PostgreSQL as a staging datasource. I assume that this error is normal, but maybe we should suppress it since there's nothing the user should do about it. 0:19:34,414 ERROR [CsvTransformGenerator] Error Start: Pentaho Pentaho Platform Engine Core 3.7-SNAPSHOT.development 10:19:34,427 ERROR [CsvTransformGenerator] ::: Error executing DDL org.pentaho.di.core.exception.KettleDatabaseException: Couldn't execute SQL: DROP TABLE "pg1" ERROR: table "pg1" does not exist at org.pentaho.di.core.database.Database.execStatement(Database.java:1631) at org.pentaho.di.core.database.Database.execStatement(Database.java:1576) at org.pentaho.platform.dataaccess.datasource.wizard.service.agile.StagingTransformGenerator.execSqlStatement(StagingTransformGenerator.java:488) at org.pentaho.platform.dataaccess.datasource.wizard.service.agile.StagingTransformGenerator.dropTable(StagingTransformGenerator.java:121) at org.pentaho.platform.dataaccess.datasource.wizard.service.impl.CsvDatasourceServiceImpl.stageData(CsvDatasourceServiceImpl.java:113) ...omitted... at java.lang.Thread.run(Thread.java:662) Caused by: org.postgresql.util.PSQLException: ERROR: table "pg1" does not exist at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:353) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:345) at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:261) at org.pentaho.di.core.database.Database.execStatement(Database.java:1599) ... 75 more

    Pentaho BI Platform Tracking | 6 years ago | Mat Lowery
    org.pentaho.di.core.exception.KettleDatabaseException: Couldn't execute SQL: DROP TABLE "pg1" ERROR: table "pg1" does not exist
  2. 0

    Repro: 1. Create a new datasource. 2. Inspect log for error message like the one below. I used PostgreSQL as a staging datasource. I assume that this error is normal, but maybe we should suppress it since there's nothing the user should do about it. 0:19:34,414 ERROR [CsvTransformGenerator] Error Start: Pentaho Pentaho Platform Engine Core 3.7-SNAPSHOT.development 10:19:34,427 ERROR [CsvTransformGenerator] ::: Error executing DDL org.pentaho.di.core.exception.KettleDatabaseException: Couldn't execute SQL: DROP TABLE "pg1" ERROR: table "pg1" does not exist at org.pentaho.di.core.database.Database.execStatement(Database.java:1631) at org.pentaho.di.core.database.Database.execStatement(Database.java:1576) at org.pentaho.platform.dataaccess.datasource.wizard.service.agile.StagingTransformGenerator.execSqlStatement(StagingTransformGenerator.java:488) at org.pentaho.platform.dataaccess.datasource.wizard.service.agile.StagingTransformGenerator.dropTable(StagingTransformGenerator.java:121) at org.pentaho.platform.dataaccess.datasource.wizard.service.impl.CsvDatasourceServiceImpl.stageData(CsvDatasourceServiceImpl.java:113) ...omitted... at java.lang.Thread.run(Thread.java:662) Caused by: org.postgresql.util.PSQLException: ERROR: table "pg1" does not exist at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:353) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:345) at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:261) at org.pentaho.di.core.database.Database.execStatement(Database.java:1599) ... 75 more

    Pentaho BI Platform Tracking | 6 years ago | Mat Lowery
    org.pentaho.di.core.exception.KettleDatabaseException: Couldn't execute SQL: DROP TABLE "pg1" ERROR: table "pg1" does not exist
  3. 0

    Value '0000-00-0' can not be represented as java.sql.Date

    Google Groups | 2 years ago | Tomo Suryolaksono
    org.pentaho.di.core.exception.KettleDatabaseException: 2014/10/30 10:19:47 - Transaksi.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 11:32:36) : Couldn't get row from result set 2014/10/30 10:19:47 - Transaksi.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 11:32:36) : Value '0000-00-00' can not be represented as java.sql.Timestamp 2014/10/30 10:19:47 - Transaksi.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 11:32:36) : 2014/10/30 10:19:47 - Transaksi.0 - ERROR (version 3.1.0, build 826 from
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Reproduction: - In Spoon 4.4 create a log table in a simple transformation (see attachment) - let it run in Spoon 4.4 - look at the execution history (refresh) and see one log line - Close Spoon 4.4 - Open Spoon 5.0 (on Windows, use SpoonConsole.bat to see the exception mentioned below) - it automatically opens the previous transformation - It opens the Execution history but this is empty The following exception is shown on the console: Unable to get rows of data from logging table test_dbx-log_table4_5_test org.pentaho.di.core.exception.KettleDatabaseException: An error occurred executing SQL: SELECT ID_JOB, STATUS, LINES_READ, LINES_WRITTEN, LINES_UPDATED, LINES_INPUT, LINES_OUTPUT, LINES_REJECTED, ERRORS, STARTDATE, ENDDATE, LOGDATE, DEPDATE, REPLAYDATE, LOG_FIELD, EXECUTING_SERVER, EXECUTING_USER, START_JOB_ENTRY, CLIENT FROM log_table4_5_test WHERE JOBNAME LIKE ? ORDER BY ID_JOB DESC Unknown column 'EXECUTING_SERVER' in 'field list' at org.pentaho.di.core.database.Database.openQuery(Database.java:1610) [...] Note: - We added the fields EXECUTING_SERVER, EXECUTING_USER and CLIENT to the log table in 5.0 - I propose to make these fields disabled by default to keep compatible with previous log tables

    Pentaho BI Platform Tracking | 4 years ago | Jens Bleuel
    org.pentaho.di.core.exception.KettleDatabaseException: An error occurred executing SQL: SELECT ID_JOB, STATUS, LINES_READ, LINES_WRITTEN, LINES_UPDATED, LINES_INPUT, LINES_OUTPUT, LINES_REJECTED, ERRORS, STARTDATE, ENDDATE, LOGDATE, DEPDATE, REPLAYDATE, LOG_FIELD, EXECUTING_SERVER, EXECUTING_USER, START_JOB_ENTRY, CLIENT FROM log_table4_5_test WHERE JOBNAME LIKE ? ORDER BY ID_JOB DESC Unknown column 'EXECUTING_SERVER' in 'field list'
  6. 0

    Apache thrift transportaion TTransportException error while using Hive data integration using Pentaho

    Stack Overflow | 2 years ago | Jiten Patel
    org.pentaho.di.core.exception.KettleDatabaseException: Error occured while trying to connect to the database</p> <p>Error connecting to database: (using class org.apache.hadoop.hive.jdbc.HiveDriver) org.apache.thrift.transport.TTransportException</p> <pre><code>at org.pentaho.di.core.database.Database.normalConnect(Database.java:428)

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. org.pentaho.di.core.exception.KettleDatabaseException

      Couldn't execute SQL: DROP TABLE "pg1" ERROR: table "pg1" does not exist

      at org.pentaho.di.core.database.Database.execStatement()
    2. org.pentaho.di
      Database.execStatement
      1. org.pentaho.di.core.database.Database.execStatement(Database.java:1631)
      2. org.pentaho.di.core.database.Database.execStatement(Database.java:1576)
      2 frames
    3. org.pentaho.platform
      CsvDatasourceServiceImpl.stageData
      1. org.pentaho.platform.dataaccess.datasource.wizard.service.agile.StagingTransformGenerator.execSqlStatement(StagingTransformGenerator.java:488)
      2. org.pentaho.platform.dataaccess.datasource.wizard.service.agile.StagingTransformGenerator.dropTable(StagingTransformGenerator.java:121)
      3. org.pentaho.platform.dataaccess.datasource.wizard.service.impl.CsvDatasourceServiceImpl.stageData(CsvDatasourceServiceImpl.java:113)
      3 frames