org.pentaho.agilebi.modeler.ModelerException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • 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.
    via by Rob Fellows,
  • 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.
    via by Rob Fellows,
  • 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 ) ;
    via by Jeffrey Thomas,
    • 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)
    No Bugmate found.