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

Pentaho BI Platform Tracking | Roland Bouman | 3 years ago
  1. 0

    pdi-ee-client-5.0-RC2-b266. Repro path: Requires MySQL driver and sakila sample database, 1) Instaview > Create New 2) Samples > RDBMS 3) New Connection (type: MySQL (native JDBC), name: sakila, host: localhost, port: 3306, user sakila, password: sakila). Test to verify that connection works (requires MySQL driver) 4) SQL query: SELECT * FROM rental, Preview to verify a result 5) Ok > Error: "Error Creating model" "There was an error while creating the metadata Model" (screenshot attached) Command line output: ERROR 15-08 16:07:37,156 - Error creating model org.pentaho.agilebi.modeler.ModelerException: Failed to get the fields of the table "instaview_20130815040736030". Either the table does not exist, or the database may require the exact case for the table and schema name. at org.pentaho.agilebi.modeler.util.ModelerSourceUtil.verifyTableExistsAndMayBeQuoted(ModelerSourceUtil.java:47) at org.pentaho.agilebi.modeler.util.ModelerSourceUtil.generateDomain(ModelerSourceUtil.java:67) at org.pentaho.agilebi.modeler.util.TableModelerSource.generateDomain(TableModelerSource.java:50) at org.pentaho.agilebi.modeler.util.ModelerWorkspaceUtil.populateModelFromSource(ModelerWorkspaceUtil.java:28) at org.pentaho.agilebi.insta.PdiRunnerBase.createModel(PdiRunnerBase.java:446) at org.pentaho.agilebi.insta.PdiRunner.run(PdiRunner.java:57) at java.lang.Thread.run(Thread.java:722) Caused by: org.pentaho.di.core.exception.KettleDatabaseException: Couldn't get field info from [SELECT * FROM "instaview_20130815040736030";] SELECT: no such table 'instaview_20130815040736030' at org.pentaho.di.core.database.Database.getQueryFieldsFallback(Database.java:2088) at org.pentaho.di.core.database.Database.getQueryFields(Database.java:2015) at org.pentaho.di.core.database.Database.getQueryFields(Database.java:1712) at org.pentaho.di.core.database.Database.getTableFields(Database.java:1708) at org.pentaho.agilebi.modeler.util.ModelerSourceUtil.verifyTableExistsAndMayBeQuoted(ModelerSourceUtil.java:45) ... 6 more Caused by: java.sql.SQLException: SELECT: no such table 'instaview_20130815040736030' at nl.cwi.monetdb.jdbc.MonetConnection$ResponseList.executeQuery(MonetConnection.java:2535) at nl.cwi.monetdb.jdbc.MonetConnection$ResponseList.processQuery(MonetConnection.java:2284) at nl.cwi.monetdb.jdbc.MonetStatement.internalExecute(MonetStatement.java:508) at nl.cwi.monetdb.jdbc.MonetStatement.execute(MonetStatement.java:349) at nl.cwi.monetdb.jdbc.MonetStatement.executeQuery(MonetStatement.java:525) at org.pentaho.di.core.database.Database.getQueryFieldsFallback(Database.java:2064) ... 10 more ERROR 15-08 16:07:37,379 - operation failed: MODE_CREATE_MODEL This error does not occur when querying a system database, for isntance, using "information_schema" as database and "SELECT * FROM schemata" as query works; using "mysql" as database and "SELECT * FROM user" as query also works.

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

    pdi-ee-client-5.0-RC2-b266. Repro path: Requires MySQL driver and sakila sample database, 1) Instaview > Create New 2) Samples > RDBMS 3) New Connection (type: MySQL (native JDBC), name: sakila, host: localhost, port: 3306, user sakila, password: sakila). Test to verify that connection works (requires MySQL driver) 4) SQL query: SELECT * FROM rental, Preview to verify a result 5) Ok > Error: "Error Creating model" "There was an error while creating the metadata Model" (screenshot attached) Command line output: ERROR 15-08 16:07:37,156 - Error creating model org.pentaho.agilebi.modeler.ModelerException: Failed to get the fields of the table "instaview_20130815040736030". Either the table does not exist, or the database may require the exact case for the table and schema name. at org.pentaho.agilebi.modeler.util.ModelerSourceUtil.verifyTableExistsAndMayBeQuoted(ModelerSourceUtil.java:47) at org.pentaho.agilebi.modeler.util.ModelerSourceUtil.generateDomain(ModelerSourceUtil.java:67) at org.pentaho.agilebi.modeler.util.TableModelerSource.generateDomain(TableModelerSource.java:50) at org.pentaho.agilebi.modeler.util.ModelerWorkspaceUtil.populateModelFromSource(ModelerWorkspaceUtil.java:28) at org.pentaho.agilebi.insta.PdiRunnerBase.createModel(PdiRunnerBase.java:446) at org.pentaho.agilebi.insta.PdiRunner.run(PdiRunner.java:57) at java.lang.Thread.run(Thread.java:722) Caused by: org.pentaho.di.core.exception.KettleDatabaseException: Couldn't get field info from [SELECT * FROM "instaview_20130815040736030";] SELECT: no such table 'instaview_20130815040736030' at org.pentaho.di.core.database.Database.getQueryFieldsFallback(Database.java:2088) at org.pentaho.di.core.database.Database.getQueryFields(Database.java:2015) at org.pentaho.di.core.database.Database.getQueryFields(Database.java:1712) at org.pentaho.di.core.database.Database.getTableFields(Database.java:1708) at org.pentaho.agilebi.modeler.util.ModelerSourceUtil.verifyTableExistsAndMayBeQuoted(ModelerSourceUtil.java:45) ... 6 more Caused by: java.sql.SQLException: SELECT: no such table 'instaview_20130815040736030' at nl.cwi.monetdb.jdbc.MonetConnection$ResponseList.executeQuery(MonetConnection.java:2535) at nl.cwi.monetdb.jdbc.MonetConnection$ResponseList.processQuery(MonetConnection.java:2284) at nl.cwi.monetdb.jdbc.MonetStatement.internalExecute(MonetStatement.java:508) at nl.cwi.monetdb.jdbc.MonetStatement.execute(MonetStatement.java:349) at nl.cwi.monetdb.jdbc.MonetStatement.executeQuery(MonetStatement.java:525) at org.pentaho.di.core.database.Database.getQueryFieldsFallback(Database.java:2064) ... 10 more ERROR 15-08 16:07:37,379 - operation failed: MODE_CREATE_MODEL This error does not occur when querying a system database, for isntance, using "information_schema" as database and "SELECT * FROM schemata" as query works; using "mysql" as database and "SELECT * FROM user" as query also works.

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

    SQLException: no such table

    Stack Overflow | 6 years ago | Bnjmn
    java.sql.SQLException: no such table: complexTask
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    [SOLVED] NetBeans and SQLite error

    javaprogrammingforums.com | 12 months ago
    java.sql.SQLException: no such table: CoachInfo
  6. 0

    Spring Sqlite in memory database broken?

    Stack Overflow | 1 year ago | Tiim
    org.springframework.jdbc.UncategorizedSQLException: StatementCallback; uncategorized SQLException for SQL [INSERT INTO test (id) VALUES (1), (2)]; SQL state [null]; error code [0]; no such table: test; nested exception is java.sql.SQLException: no such table: test

    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. java.sql.SQLException

      SELECT: no such table 'instaview_20130815040736030'

      at nl.cwi.monetdb.jdbc.MonetConnection$ResponseList.executeQuery()
    2. nl.cwi.monetdb
      MonetStatement.executeQuery
      1. nl.cwi.monetdb.jdbc.MonetConnection$ResponseList.executeQuery(MonetConnection.java:2535)
      2. nl.cwi.monetdb.jdbc.MonetConnection$ResponseList.processQuery(MonetConnection.java:2284)
      3. nl.cwi.monetdb.jdbc.MonetStatement.internalExecute(MonetStatement.java:508)
      4. nl.cwi.monetdb.jdbc.MonetStatement.execute(MonetStatement.java:349)
      5. nl.cwi.monetdb.jdbc.MonetStatement.executeQuery(MonetStatement.java:525)
      5 frames
    3. org.pentaho.di
      Database.getTableFields
      1. org.pentaho.di.core.database.Database.getQueryFieldsFallback(Database.java:2064)
      2. org.pentaho.di.core.database.Database.getQueryFields(Database.java:2015)
      3. org.pentaho.di.core.database.Database.getQueryFields(Database.java:1712)
      4. org.pentaho.di.core.database.Database.getTableFields(Database.java:1708)
      4 frames
    4. org.pentaho.agilebi
      PdiRunner.run
      1. org.pentaho.agilebi.modeler.util.ModelerSourceUtil.verifyTableExistsAndMayBeQuoted(ModelerSourceUtil.java:45)
      2. org.pentaho.agilebi.modeler.util.ModelerSourceUtil.generateDomain(ModelerSourceUtil.java:67)
      3. org.pentaho.agilebi.modeler.util.TableModelerSource.generateDomain(TableModelerSource.java:50)
      4. org.pentaho.agilebi.modeler.util.ModelerWorkspaceUtil.populateModelFromSource(ModelerWorkspaceUtil.java:28)
      5. org.pentaho.agilebi.insta.PdiRunnerBase.createModel(PdiRunnerBase.java:446)
      6. org.pentaho.agilebi.insta.PdiRunner.run(PdiRunner.java:57)
      6 frames
    5. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:722)
      1 frame