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

Pentaho BI Platform Tracking | Jeffrey Thomas | 4 years ago
  1. 0

    This seems to be a threading issue dealing with some actions running on the UI thread and others not during createModel(). In testing, this only occurs on the first run, so a workaround is to just run it again. Also, this seems to only occur when using Windows 7. Stacktrace: ERROR 10-12 11:45:32,843 - Error creating model org.pentaho.agilebi.modeler.ModelerException: Failed to get the fields of the ta ble "instaview_20121210114531974". Either the table does not exist, or the data base may require the exact case for the table and schema name. at org.pentaho.agilebi.modeler.util.ModelerSourceUtil.verifyTableExistsA ndMayBeQuoted(ModelerSourceUtil.java:47) at org.pentaho.agilebi.modeler.util.ModelerSourceUtil.generateDomain(Mod elerSourceUtil.java:67) at org.pentaho.agilebi.modeler.util.TableModelerSource.generateDomain(Ta bleModelerSource.java:50) at org.pentaho.agilebi.modeler.util.ModelerWorkspaceUtil.populateModelFr omSource(ModelerWorkspaceUtil.java:26) at org.pentaho.agilebi.insta.PdiRunnerBase.createModel(PdiRunnerBase.jav a:394) at org.pentaho.agilebi.insta.PdiRunner.run(PdiRunner.java:47) at java.lang.Thread.run(Unknown Source) Caused by: org.pentaho.di.core.exception.KettleDatabaseException: Couldn't get field info from [SELECT * FROM "instaview_20121210114531974";] SELECT: no such table 'instaview_20121210114531974' at org.pentaho.di.core.database.Database.getQueryFieldsFallback(Database .java:2377) at org.pentaho.di.core.database.Database.getQueryFields(Database.java:22 88) at org.pentaho.di.core.database.Database.getQueryFields(Database.java:19 84) at org.pentaho.di.core.database.Database.getTableFields(Database.java:19 79) at org.pentaho.agilebi.modeler.util.ModelerSourceUtil.verifyTableExistsA ndMayBeQuoted(ModelerSourceUtil.java:45) ... 6 more Caused by: java.sql.SQLException: SELECT: no such table 'instaview_2012121011453 1974' at nl.cwi.monetdb.jdbc.MonetConnection$ResponseList.executeQuery(MonetCo nnection.java:2508) at nl.cwi.monetdb.jdbc.MonetConnection$ResponseList.processQuery(MonetCo nnection.java:2258) at nl.cwi.monetdb.jdbc.MonetStatement.internalExecute(MonetStatement.jav a:501) at nl.cwi.monetdb.jdbc.MonetStatement.execute(MonetStatement.java:342) at nl.cwi.monetdb.jdbc.MonetStatement.executeQuery(MonetStatement.java:5 18) at org.pentaho.di.core.database.Database.getQueryFieldsFallback(Database .java:2350) ... 10 more CREATE TABLE instaview_20121210114531974 ( iduser BIGINT , eventhour BIGINT , event VARCHAR(19) , ecount BIGINT , gender VARCHAR(1) , language VARCHAR(7) , primaryuse VARCHAR(8) , registrationreferringurl VARCHAR(18) , flagoptinemailmarketing BIGINT ) ;

    Pentaho BI Platform Tracking | 4 years ago | Jeffrey Thomas
    org.pentaho.agilebi.modeler.ModelerException: Failed to get the fields of the ta ble "instaview_20121210114531974". Either the table does not exist, or the data base may require the exact case for the table and schema name.
  2. 0

    This seems to be a threading issue dealing with some actions running on the UI thread and others not during createModel(). In testing, this only occurs on the first run, so a workaround is to just run it again. Also, this seems to only occur when using Windows 7. Stacktrace: ERROR 10-12 11:45:32,843 - Error creating model org.pentaho.agilebi.modeler.ModelerException: Failed to get the fields of the ta ble "instaview_20121210114531974". Either the table does not exist, or the data base may require the exact case for the table and schema name. at org.pentaho.agilebi.modeler.util.ModelerSourceUtil.verifyTableExistsA ndMayBeQuoted(ModelerSourceUtil.java:47) at org.pentaho.agilebi.modeler.util.ModelerSourceUtil.generateDomain(Mod elerSourceUtil.java:67) at org.pentaho.agilebi.modeler.util.TableModelerSource.generateDomain(Ta bleModelerSource.java:50) at org.pentaho.agilebi.modeler.util.ModelerWorkspaceUtil.populateModelFr omSource(ModelerWorkspaceUtil.java:26) at org.pentaho.agilebi.insta.PdiRunnerBase.createModel(PdiRunnerBase.jav a:394) at org.pentaho.agilebi.insta.PdiRunner.run(PdiRunner.java:47) at java.lang.Thread.run(Unknown Source) Caused by: org.pentaho.di.core.exception.KettleDatabaseException: Couldn't get field info from [SELECT * FROM "instaview_20121210114531974";] SELECT: no such table 'instaview_20121210114531974' at org.pentaho.di.core.database.Database.getQueryFieldsFallback(Database .java:2377) at org.pentaho.di.core.database.Database.getQueryFields(Database.java:22 88) at org.pentaho.di.core.database.Database.getQueryFields(Database.java:19 84) at org.pentaho.di.core.database.Database.getTableFields(Database.java:19 79) at org.pentaho.agilebi.modeler.util.ModelerSourceUtil.verifyTableExistsA ndMayBeQuoted(ModelerSourceUtil.java:45) ... 6 more Caused by: java.sql.SQLException: SELECT: no such table 'instaview_2012121011453 1974' at nl.cwi.monetdb.jdbc.MonetConnection$ResponseList.executeQuery(MonetCo nnection.java:2508) at nl.cwi.monetdb.jdbc.MonetConnection$ResponseList.processQuery(MonetCo nnection.java:2258) at nl.cwi.monetdb.jdbc.MonetStatement.internalExecute(MonetStatement.jav a:501) at nl.cwi.monetdb.jdbc.MonetStatement.execute(MonetStatement.java:342) at nl.cwi.monetdb.jdbc.MonetStatement.executeQuery(MonetStatement.java:5 18) at org.pentaho.di.core.database.Database.getQueryFieldsFallback(Database .java:2350) ... 10 more CREATE TABLE instaview_20121210114531974 ( iduser BIGINT , eventhour BIGINT , event VARCHAR(19) , ecount BIGINT , gender VARCHAR(1) , language VARCHAR(7) , primaryuse VARCHAR(8) , registrationreferringurl VARCHAR(18) , flagoptinemailmarketing BIGINT ) ;

    Pentaho BI Platform Tracking | 4 years ago | Jeffrey Thomas
    org.pentaho.agilebi.modeler.ModelerException: Failed to get the fields of the ta ble "instaview_20121210114531974". Either the table does not exist, or the data base may require the exact case for the table and schema name.
  3. 0

    If you create a use a csv file that has field names that start with a numeric, it fails to create the table in Instaview. Repro: 1. Create a new CSV-based project 2. pick the Batting.csv file (attached to this case) as the source. 3. get the fields, accept the defaults given, hit OK. as it runs, you will notice a dialog pop up indicating that there was an error -- "There was an error while creating the metadata Model." 4. if you check the console output, you will see an error similar to the following, indicating that the table might not exist: ERROR 04-03 16:01:57,327 - Error creating model org.pentaho.agilebi.modeler.ModelerException: Failed to get the fields of the table "instaview_20130304040156607". 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:443) at org.pentaho.agilebi.insta.PdiRunner.run(PdiRunner.java:56) at java.lang.Thread.run(Thread.java:680) Caused by: org.pentaho.di.core.exception.KettleDatabaseException: Couldn't get field info from [SELECT * FROM "instaview_20130304040156607";] in fact, the table doesn't exist because the create table statement fails previously but isn't logged. the DDL generated for this particular example is this: CREATE TABLE instaview_20130222105112398 ( playerID VARCHAR(9) , yearID BIGINT , stint BIGINT , teamID VARCHAR(3) , lgID VARCHAR(2) , G BIGINT , Gbatting BIGINT , AB BIGINT , R BIGINT , H BIGINT , 2B BIGINT , 3B BIGINT , HR BIGINT , RBI BIGINT , SB BIGINT , CS BIGINT , BB BIGINT , SO BIGINT , IBB BIGINT , HBP BIGINT , SH BIGINT , SF BIGINT , GIDP BIGINT , Gold BIGINT ) ; it's the 2B and 3B field names that are the problem.

    Pentaho BI Platform Tracking | 4 years ago | Rob Fellows
    org.pentaho.agilebi.modeler.ModelerException: Failed to get the fields of the table "instaview_20130304040156607". Either the table does not exist, or the database may require the exact case for the table and schema name.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    If you create a use a csv file that has field names that start with a numeric, it fails to create the table in Instaview. Repro: 1. Create a new CSV-based project 2. pick the Batting.csv file (attached to this case) as the source. 3. get the fields, accept the defaults given, hit OK. as it runs, you will notice a dialog pop up indicating that there was an error -- "There was an error while creating the metadata Model." 4. if you check the console output, you will see an error similar to the following, indicating that the table might not exist: ERROR 04-03 16:01:57,327 - Error creating model org.pentaho.agilebi.modeler.ModelerException: Failed to get the fields of the table "instaview_20130304040156607". 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:443) at org.pentaho.agilebi.insta.PdiRunner.run(PdiRunner.java:56) at java.lang.Thread.run(Thread.java:680) Caused by: org.pentaho.di.core.exception.KettleDatabaseException: Couldn't get field info from [SELECT * FROM "instaview_20130304040156607";] in fact, the table doesn't exist because the create table statement fails previously but isn't logged. the DDL generated for this particular example is this: CREATE TABLE instaview_20130222105112398 ( playerID VARCHAR(9) , yearID BIGINT , stint BIGINT , teamID VARCHAR(3) , lgID VARCHAR(2) , G BIGINT , Gbatting BIGINT , AB BIGINT , R BIGINT , H BIGINT , 2B BIGINT , 3B BIGINT , HR BIGINT , RBI BIGINT , SB BIGINT , CS BIGINT , BB BIGINT , SO BIGINT , IBB BIGINT , HBP BIGINT , SH BIGINT , SF BIGINT , GIDP BIGINT , Gold BIGINT ) ; it's the 2B and 3B field names that are the problem.

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

    MySQL datasource could be added to the list successfully. But when trying to create Analysis report using the datasource application hangs with the message: "Just a few moments please. Creating/Updating Data Source..." and exception flow onto log file: 2014-07-29 17:38:16,314 ERROR [org.pentaho.platform.dataaccess.datasource.wizard.service.impl.MultitableDatasourceService] Error serializing joins org.pentaho.agilebi.modeler.ModelerException: org.pentaho.di.core.exception.KettleDatabaseException: Unable to close prepared statement after determining SQL layout You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OPTION SQL_SELECT_LIMIT=DEFAULT' at line 1 at org.pentaho.agilebi.modeler.util.MultiTableModelerSource.generateDomain(MultiTableModelerSource.java:193) at org.pentaho.platform.dataaccess.datasource.wizard.service.impl.MultitableDatasourceService.serializeJoins(MultitableDatasourceService.java:142) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source)

    Pentaho BI Platform Tracking | 2 years ago | Pavel Mikhnevich
    org.pentaho.agilebi.modeler.ModelerException: org.pentaho.di.core.exception.KettleDatabaseException: Unable to close prepared statement after determining SQL layout You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OPTION SQL_SELECT_LIMIT=DEFAULT' at line 1

    Root Cause Analysis

    1. org.pentaho.agilebi.modeler.ModelerException

      Failed to get the fields of the ta ble "instaview_20121210114531974". Either the table does not exist, or the data base may require the exact case for the table and schema name.

      at org.pentaho.agilebi.modeler.util.ModelerSourceUtil.verifyTableExistsAndMayBeQuoted()
    2. org.pentaho.agilebi
      PdiRunner.run
      1. org.pentaho.agilebi.modeler.util.ModelerSourceUtil.verifyTableExistsAndMayBeQuoted(ModelerSourceUtil.java:47)
      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:26)
      5. org.pentaho.agilebi.insta.PdiRunnerBase.createModel(PdiRunnerBase.java:394)
      6. org.pentaho.agilebi.insta.PdiRunner.run(PdiRunner.java:47)
      6 frames
    3. Java RT
      Thread.run
      1. java.lang.Thread.run(Unknown Source)
      1 frame