org.pentaho.agilebi.modeler.ModelerException: Failed to get the fields of the table "SDRtest". Either the table does not exist, or the database may require the exact case for the table and schema name. Failed to get the fields of the table "SDRtest". Either the table does not exist, or the database may require the exact case for the table and schema name.

Pentaho BI Platform Tracking | Brandon Bruce | 2 years ago
  1. 0

    Run the attached job with the attached transformation and you get the following error: 2014/09/16 07:15:02 - Build Model - ERROR (version 5.2.0.0, build 1 from 2014-09-14_19-13-21 by buildguy) : 2014/09/16 07:15:02 - Build Model - org.pentaho.agilebi.modeler.ModelerException: Failed to get the fields of the table "SDRtest". Either the table does not exist, or the database may require the exact case for the table and schema name. 2014/09/16 07:15:02 - Build Model - Failed to get the fields of the table "SDRtest". Either the table does not exist, or the database may require the exact case for the table and schema name. 2014/09/16 07:15:02 - Build Model - ERROR (version 5.2.0.0, build 1 from 2014-09-14_19-13-21 by buildguy) : org.pentaho.di.core.exception.KettleException: 2014/09/16 07:15:02 - Build Model - org.pentaho.agilebi.modeler.ModelerException: Failed to get the fields of the table "SDRtest". Either the table does not exist, or the database may require the exact case for the table and schema name. 2014/09/16 07:15:02 - Build Model - Failed to get the fields of the table "SDRtest". Either the table does not exist, or the database may require the exact case for the table and schema name. 2014/09/16 07:15:02 - Build Model - 2014/09/16 07:15:02 - Build Model - at org.pentaho.di.job.entries.build.JobEntryBuildModel.a(SourceFile:274) 2014/09/16 07:15:02 - Build Model - at org.pentaho.di.job.entries.build.JobEntryBuildModel.execute(SourceFile:297) 2014/09/16 07:15:02 - Build Model - at org.pentaho.di.job.Job.execute(Job.java:716) 2014/09/16 07:15:02 - Build Model - at org.pentaho.di.job.Job.execute(Job.java:859) 2014/09/16 07:15:02 - Build Model - at org.pentaho.di.job.Job.execute(Job.java:859) 2014/09/16 07:15:02 - Build Model - at org.pentaho.di.job.Job.execute(Job.java:532) 2014/09/16 07:15:02 - Build Model - at org.pentaho.di.job.Job.run(Job.java:424) 2014/09/16 07:15:02 - Build Model - Caused by: org.pentaho.agilebi.modeler.ModelerException: Failed to get the fields of the table "SDRtest". Either the table does not exist, or the database may require the exact case for the table and schema name. 2014/09/16 07:15:02 - Build Model - at org.pentaho.agilebi.modeler.util.ModelerSourceUtil.verifyTableExistsAndMayBeQuoted(ModelerSourceUtil.java:64) 2014/09/16 07:15:02 - Build Model - at org.pentaho.agilebi.modeler.util.ModelerSourceUtil.generateDomain(ModelerSourceUtil.java:86) 2014/09/16 07:15:02 - Build Model - at org.pentaho.agilebi.modeler.util.TableModelerSource.generateDomain(TableModelerSource.java:67) 2014/09/16 07:15:02 - Build Model - at org.pentaho.di.job.entries.build.JobEntryBuildModel.a(SourceFile:233) 2014/09/16 07:15:02 - Build Model - ... 6 more 2014/09/16 07:15:02 - Build Model - Caused by: org.pentaho.di.core.exception.KettleDatabaseException: 2014/09/16 07:15:02 - Build Model - Couldn't get field info from [SELECT * FROM "SDRtest" limit 1] 2014/09/16 07:15:02 - Build Model - 2014/09/16 07:15:02 - Build Model - ERROR: relation "SDRtest" does not exist 2014/09/16 07:15:02 - Build Model - 2014/09/16 07:15:02 - Build Model - at org.pentaho.di.core.database.Database.getQueryFieldsFallback(Database.java:2198) 2014/09/16 07:15:02 - Build Model - at org.pentaho.di.core.database.Database.getQueryFields(Database.java:2120) 2014/09/16 07:15:02 - Build Model - at org.pentaho.di.core.database.Database.getQueryFields(Database.java:1812) 2014/09/16 07:15:02 - Build Model - at org.pentaho.di.core.database.Database.getTableFields(Database.java:1808) 2014/09/16 07:15:02 - Build Model - at org.pentaho.agilebi.modeler.util.ModelerSourceUtil.verifyTableExistsAndMayBeQuoted(ModelerSourceUtil.java:62) 2014/09/16 07:15:02 - Build Model - ... 9 more 2014/09/16 07:15:02 - Build Model - Caused by: org.postgresql.util.PSQLException: ERROR: relation "SDRtest" does not exist 2014/09/16 07:15:02 - Build Model - at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198) 2014/09/16 07:15:02 - Build Model - at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927) 2014/09/16 07:15:02 - Build Model - at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) 2014/09/16 07:15:02 - Build Model - at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:561) 2014/09/16 07:15:02 - Build Model - at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:419) 2014/09/16 07:15:02 - Build Model - at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:304) 2014/09/16 07:15:02 - Build Model - at org.pentaho.di.core.database.Database.getQueryFieldsFallback(Database.java:2192) 2014/09/16 07:15:02 - Build Model - ... 13 more

    Pentaho BI Platform Tracking | 2 years ago | Brandon Bruce
    org.pentaho.agilebi.modeler.ModelerException: Failed to get the fields of the table "SDRtest". Either the table does not exist, or the database may require the exact case for the table and schema name. Failed to get the fields of the table "SDRtest". Either the table does not exist, or the database may require the exact case for the table and schema name.
  2. 0

    Run the attached job with the attached transformation and you get the following error: 2014/09/16 07:15:02 - Build Model - ERROR (version 5.2.0.0, build 1 from 2014-09-14_19-13-21 by buildguy) : 2014/09/16 07:15:02 - Build Model - org.pentaho.agilebi.modeler.ModelerException: Failed to get the fields of the table "SDRtest". Either the table does not exist, or the database may require the exact case for the table and schema name. 2014/09/16 07:15:02 - Build Model - Failed to get the fields of the table "SDRtest". Either the table does not exist, or the database may require the exact case for the table and schema name. 2014/09/16 07:15:02 - Build Model - ERROR (version 5.2.0.0, build 1 from 2014-09-14_19-13-21 by buildguy) : org.pentaho.di.core.exception.KettleException: 2014/09/16 07:15:02 - Build Model - org.pentaho.agilebi.modeler.ModelerException: Failed to get the fields of the table "SDRtest". Either the table does not exist, or the database may require the exact case for the table and schema name. 2014/09/16 07:15:02 - Build Model - Failed to get the fields of the table "SDRtest". Either the table does not exist, or the database may require the exact case for the table and schema name. 2014/09/16 07:15:02 - Build Model - 2014/09/16 07:15:02 - Build Model - at org.pentaho.di.job.entries.build.JobEntryBuildModel.a(SourceFile:274) 2014/09/16 07:15:02 - Build Model - at org.pentaho.di.job.entries.build.JobEntryBuildModel.execute(SourceFile:297) 2014/09/16 07:15:02 - Build Model - at org.pentaho.di.job.Job.execute(Job.java:716) 2014/09/16 07:15:02 - Build Model - at org.pentaho.di.job.Job.execute(Job.java:859) 2014/09/16 07:15:02 - Build Model - at org.pentaho.di.job.Job.execute(Job.java:859) 2014/09/16 07:15:02 - Build Model - at org.pentaho.di.job.Job.execute(Job.java:532) 2014/09/16 07:15:02 - Build Model - at org.pentaho.di.job.Job.run(Job.java:424) 2014/09/16 07:15:02 - Build Model - Caused by: org.pentaho.agilebi.modeler.ModelerException: Failed to get the fields of the table "SDRtest". Either the table does not exist, or the database may require the exact case for the table and schema name. 2014/09/16 07:15:02 - Build Model - at org.pentaho.agilebi.modeler.util.ModelerSourceUtil.verifyTableExistsAndMayBeQuoted(ModelerSourceUtil.java:64) 2014/09/16 07:15:02 - Build Model - at org.pentaho.agilebi.modeler.util.ModelerSourceUtil.generateDomain(ModelerSourceUtil.java:86) 2014/09/16 07:15:02 - Build Model - at org.pentaho.agilebi.modeler.util.TableModelerSource.generateDomain(TableModelerSource.java:67) 2014/09/16 07:15:02 - Build Model - at org.pentaho.di.job.entries.build.JobEntryBuildModel.a(SourceFile:233) 2014/09/16 07:15:02 - Build Model - ... 6 more 2014/09/16 07:15:02 - Build Model - Caused by: org.pentaho.di.core.exception.KettleDatabaseException: 2014/09/16 07:15:02 - Build Model - Couldn't get field info from [SELECT * FROM "SDRtest" limit 1] 2014/09/16 07:15:02 - Build Model - 2014/09/16 07:15:02 - Build Model - ERROR: relation "SDRtest" does not exist 2014/09/16 07:15:02 - Build Model - 2014/09/16 07:15:02 - Build Model - at org.pentaho.di.core.database.Database.getQueryFieldsFallback(Database.java:2198) 2014/09/16 07:15:02 - Build Model - at org.pentaho.di.core.database.Database.getQueryFields(Database.java:2120) 2014/09/16 07:15:02 - Build Model - at org.pentaho.di.core.database.Database.getQueryFields(Database.java:1812) 2014/09/16 07:15:02 - Build Model - at org.pentaho.di.core.database.Database.getTableFields(Database.java:1808) 2014/09/16 07:15:02 - Build Model - at org.pentaho.agilebi.modeler.util.ModelerSourceUtil.verifyTableExistsAndMayBeQuoted(ModelerSourceUtil.java:62) 2014/09/16 07:15:02 - Build Model - ... 9 more 2014/09/16 07:15:02 - Build Model - Caused by: org.postgresql.util.PSQLException: ERROR: relation "SDRtest" does not exist 2014/09/16 07:15:02 - Build Model - at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198) 2014/09/16 07:15:02 - Build Model - at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927) 2014/09/16 07:15:02 - Build Model - at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) 2014/09/16 07:15:02 - Build Model - at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:561) 2014/09/16 07:15:02 - Build Model - at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:419) 2014/09/16 07:15:02 - Build Model - at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:304) 2014/09/16 07:15:02 - Build Model - at org.pentaho.di.core.database.Database.getQueryFieldsFallback(Database.java:2192) 2014/09/16 07:15:02 - Build Model - ... 13 more

    Pentaho BI Platform Tracking | 2 years ago | Brandon Bruce
    org.pentaho.agilebi.modeler.ModelerException: Failed to get the fields of the table "SDRtest". Either the table does not exist, or the database may require the exact case for the table and schema name. Failed to get the fields of the table "SDRtest". Either the table does not exist, or the database may require the exact case for the table and schema name.
  3. 0

    Default schema not set in Metadata connection: "table 'xxx' does not exist" errors

    pentaho.com | 1 year ago
    org.pentaho.di.core.exception.KettleDatabaseException: Couldn't get field info from [SELECT * FROM a_registrationvalue limit 1] ERROR: relation "a_registrationvalue" does not exist
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    New records not added in Simple polling mode

    GitHub | 4 years ago | troyschneringer
    org.postgresql.util.PSQLException: ERROR: cannot execute INSERT in a read-only transaction
  6. 0

    PreparedStatement.setDate() can't deal with "?+1"

    GitHub | 2 years ago | undertook
    org.postgresql.util.PSQLException: ERROR: invalid input syntax for integer: "1970-01-01 +08:00:00"

  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 "SDRtest" does not exist

    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse()
  2. PostgreSQL JDBC Driver
    AbstractJdbc2Statement.executeQuery
    1. org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198)
    2. org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927)
    3. org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
    4. org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:561)
    5. org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:419)
    6. org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:304)
    6 frames
  3. org.pentaho.di
    Database.getTableFields
    1. org.pentaho.di.core.database.Database.getQueryFieldsFallback(Database.java:2192)
    2. org.pentaho.di.core.database.Database.getQueryFields(Database.java:2120)
    3. org.pentaho.di.core.database.Database.getQueryFields(Database.java:1812)
    4. org.pentaho.di.core.database.Database.getTableFields(Database.java:1808)
    4 frames
  4. org.pentaho.agilebi
    TableModelerSource.generateDomain
    1. org.pentaho.agilebi.modeler.util.ModelerSourceUtil.verifyTableExistsAndMayBeQuoted(ModelerSourceUtil.java:62)
    2. org.pentaho.agilebi.modeler.util.ModelerSourceUtil.generateDomain(ModelerSourceUtil.java:86)
    3. org.pentaho.agilebi.modeler.util.TableModelerSource.generateDomain(TableModelerSource.java:67)
    3 frames
  5. org.pentaho.di
    Job.run
    1. org.pentaho.di.job.entries.build.JobEntryBuildModel.a(SourceFile:233)
    2. org.pentaho.di.job.entries.build.JobEntryBuildModel.execute(SourceFile:297)
    3. org.pentaho.di.job.Job.execute(Job.java:716)
    4. org.pentaho.di.job.Job.execute(Job.java:859)
    5. org.pentaho.di.job.Job.execute(Job.java:859)
    6. org.pentaho.di.job.Job.execute(Job.java:532)
    7. org.pentaho.di.job.Job.run(Job.java:424)
    7 frames