org.pentaho.di.core.exception.KettleDatabaseException: Couldn't get field info from [SELECT * FROM iso_country_dim limit 1] ERROR: relation "iso_country_dim" does not exist Position: 15

Pentaho BI Platform Tracking | Chris Deptula | 4 years ago
  1. 0

    In the get table names step I want to be able to pull tables from a particular schema without having to "Add schema in object name". If I do not include "Add schema in object name" I get the following error as the table does not exist in the default schema and when it is running the select to get the fields for the creation SQL it does not include the schema. So I want the output Tablename fieldname to not include the schema, but when the step runs the SQL to get the creation SQL it needs to include the schema or it will not find the table. If I tell the step to Add schema in object name I do not get this errror. 2012/10/18 09:27:32 - Get table names.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : Unexpected error 2012/10/18 09:27:32 - Get table names.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseException: 2012/10/18 09:27:32 - Get table names.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : Couldn't get field info from [SELECT * FROM iso_country_dim limit 1] 2012/10/18 09:27:32 - Get table names.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : 2012/10/18 09:27:32 - Get table names.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : ERROR: relation "iso_country_dim" does not exist Position: 15 2012/10/18 09:27:32 - Get table names.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : 2012/10/18 09:27:32 - Get table names.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.pentaho.di.core.database.Database.getQueryFieldsFallback(Database.java:2396) 2012/10/18 09:27:32 - Get table names.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.pentaho.di.core.database.Database.getQueryFields(Database.java:2308) 2012/10/18 09:27:32 - Get table names.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.pentaho.di.core.database.Database.getQueryFields(Database.java:2005) 2012/10/18 09:27:32 - Get table names.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.pentaho.di.core.database.Database.getTableFields(Database.java:2000) 2012/10/18 09:27:32 - Get table names.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.pentaho.di.trans.steps.gettablenames.GetTableNames.processRow(GetTableNames.java:242) 2012/10/18 09:27:32 - Get table names.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.pentaho.di.trans.step.RunThread.run(RunThread.java:50) 2012/10/18 09:27:32 - Get table names.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at java.lang.Thread.run(Unknown Source) 2012/10/18 09:27:32 - Get table names.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : Caused by: org.postgresql.util.PSQLException: ERROR: relation "iso_country_dim" does not exist Position: 15 2012/10/18 09:27:32 - Get table names.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2101) 2012/10/18 09:27:32 - Get table names.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1834) 2012/10/18 09:27:32 - Get table names.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) 2012/10/18 09:27:32 - Get table names.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:510) 2012/10/18 09:27:32 - Get table names.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:386) 2012/10/18 09:27:32 - Get table names.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:271) 2012/10/18 09:27:32 - Get table names.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.pentaho.di.core.database.Database.getQueryFieldsFallback(Database.java:2388) 2012/10/18 09:27:32 - Get table names.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : ... 6 more

    Pentaho BI Platform Tracking | 4 years ago | Chris Deptula
    org.pentaho.di.core.exception.KettleDatabaseException: Couldn't get field info from [SELECT * FROM iso_country_dim limit 1] ERROR: relation "iso_country_dim" does not exist Position: 15
  2. 0

    In the get table names step I want to be able to pull tables from a particular schema without having to "Add schema in object name". If I do not include "Add schema in object name" I get the following error as the table does not exist in the default schema and when it is running the select to get the fields for the creation SQL it does not include the schema. So I want the output Tablename fieldname to not include the schema, but when the step runs the SQL to get the creation SQL it needs to include the schema or it will not find the table. If I tell the step to Add schema in object name I do not get this errror. 2012/10/18 09:27:32 - Get table names.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : Unexpected error 2012/10/18 09:27:32 - Get table names.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseException: 2012/10/18 09:27:32 - Get table names.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : Couldn't get field info from [SELECT * FROM iso_country_dim limit 1] 2012/10/18 09:27:32 - Get table names.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : 2012/10/18 09:27:32 - Get table names.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : ERROR: relation "iso_country_dim" does not exist Position: 15 2012/10/18 09:27:32 - Get table names.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : 2012/10/18 09:27:32 - Get table names.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.pentaho.di.core.database.Database.getQueryFieldsFallback(Database.java:2396) 2012/10/18 09:27:32 - Get table names.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.pentaho.di.core.database.Database.getQueryFields(Database.java:2308) 2012/10/18 09:27:32 - Get table names.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.pentaho.di.core.database.Database.getQueryFields(Database.java:2005) 2012/10/18 09:27:32 - Get table names.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.pentaho.di.core.database.Database.getTableFields(Database.java:2000) 2012/10/18 09:27:32 - Get table names.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.pentaho.di.trans.steps.gettablenames.GetTableNames.processRow(GetTableNames.java:242) 2012/10/18 09:27:32 - Get table names.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.pentaho.di.trans.step.RunThread.run(RunThread.java:50) 2012/10/18 09:27:32 - Get table names.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at java.lang.Thread.run(Unknown Source) 2012/10/18 09:27:32 - Get table names.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : Caused by: org.postgresql.util.PSQLException: ERROR: relation "iso_country_dim" does not exist Position: 15 2012/10/18 09:27:32 - Get table names.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2101) 2012/10/18 09:27:32 - Get table names.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1834) 2012/10/18 09:27:32 - Get table names.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) 2012/10/18 09:27:32 - Get table names.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:510) 2012/10/18 09:27:32 - Get table names.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:386) 2012/10/18 09:27:32 - Get table names.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:271) 2012/10/18 09:27:32 - Get table names.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.pentaho.di.core.database.Database.getQueryFieldsFallback(Database.java:2388) 2012/10/18 09:27:32 - Get table names.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : ... 6 more

    Pentaho BI Platform Tracking | 4 years ago | Chris Deptula
    org.pentaho.di.core.exception.KettleDatabaseException: Couldn't get field info from [SELECT * FROM iso_country_dim limit 1] ERROR: relation "iso_country_dim" does not exist Position: 15
  3. 0

    Pentaho: String to SQL Select Statement

    Stack Overflow | 2 years ago | oneofakind
    org.pentaho.di.core.exception.KettleDatabaseException: An error occurred executing SQL: ? ERROR: syntax error at or near "$1" Position: 1
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Spring tiles jsp table records from other class

    Stack Overflow | 3 years ago | kamirru
    org.postgresql.util.PSQLException: org.postgresql.util.psqlexception error syntax error at end of input (Position 44)

  1. csanyigabor 4 times, last 3 months ago
  2. Tahir 1 times, last 4 months ago
  3. RoiOtero 3 times, last 5 months ago
  4. haerick 8 times, last 6 months ago
  5. silex 15 times, last 6 months ago
2 more registered users
33 unregistered visitors
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.postgresql.util.PSQLException

    ERROR: relation "iso_country_dim" does not exist Position: 15

    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse()
  2. PostgreSQL JDBC Driver
    AbstractJdbc2Statement.executeQuery
    1. org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2101)
    2. org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1834)
    3. org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
    4. org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:510)
    5. org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:386)
    6. org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:271)
    6 frames
  3. org.pentaho.di
    RunThread.run
    1. org.pentaho.di.core.database.Database.getQueryFieldsFallback(Database.java:2388)
    2. org.pentaho.di.core.database.Database.getQueryFields(Database.java:2308)
    3. org.pentaho.di.core.database.Database.getQueryFields(Database.java:2005)
    4. org.pentaho.di.core.database.Database.getTableFields(Database.java:2000)
    5. org.pentaho.di.trans.steps.gettablenames.GetTableNames.processRow(GetTableNames.java:242)
    6. org.pentaho.di.trans.step.RunThread.run(RunThread.java:50)
    6 frames
  4. Java RT
    Thread.run
    1. java.lang.Thread.run(Unknown Source)
    1 frame