org.pentaho.di.core.exception.KettleDatabaseException: An error occurred executing SQL: SELECT * FROM acerLog WHERE TRANSNAME LIKE ? OR TRANSNAME LIKE ? ORDER BY ID_BATCH desc Invalid object name 'acerLog'.

Pentaho BI Platform Tracking | Scott Gustafson | 7 years ago
  1. 0

    The problems I am experiencing are related to using a schema when writing to a log table. The problems occur when :1) upon startup of Spoon gui, 2) when trying to clear the logs from the database. FYI -- I wish to use a schema called 'refresh' and I named the log table 'acerLog' (both without the single quotes), thus I would like to write to the refresh.acerlog table. database connection settings: Connection Type: MS SQl Server (using version 2005) Access: JDBC preferred schema name: refresh In order for logging to write any information, I had to create the log table in both the default (dbo) schema as well in my preferred schema (refresh). Doing so results in the dbo.acerLog table being populated. Whn launching Spoon, If the dbo.acerLog table IS present, but refresh.acerlog table is NOT present: 2010/04/14 10:58:39 - Spoon - Launching transformation [AmisysYearHistSpan]... 2010/04/14 10:58:39 - Spoon - Started the transformation execution. 2010/04/14 10:58:39 - AmisysYearHistSpan - Dispatching started for transformation [AmisysYearHistSpan] 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Preparing transformation execution failed 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : org.pentaho.di.core.exception.KettleTransException: 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Unable to begin processing transformation 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Error writing log record to table [acerLog] 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : An error occurred executing SQL: 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : SELECT top 0 * FROM refresh.acerLog WITH (TABLOCKX, HOLDLOCK) 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Invalid object name 'refresh.acerLog'. 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.trans.Trans.beginProcessing(Trans.java:1464) 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.trans.Trans.prepareExecution(Trans.java:523) 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.ui.spoon.trans.TransGraph$25.run(TransGraph.java:3192) 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at java.lang.Thread.run(Unknown Source) 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Caused by: org.pentaho.di.core.exception.KettleTransException: 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Error writing log record to table [acerLog] 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : An error occurred executing SQL: 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : SELECT top 0 * FROM refresh.acerLog WITH (TABLOCKX, HOLDLOCK) 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Invalid object name 'refresh.acerLog'. 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.trans.Trans.beginProcessing(Trans.java:1439) 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : ... 3 more 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Caused by: org.pentaho.di.core.exception.KettleDatabaseException: 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : An error occurred executing SQL: 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : SELECT top 0 * FROM refresh.acerLog WITH (TABLOCKX, HOLDLOCK) 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Invalid object name 'refresh.acerLog'. 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.core.database.Database.openQuery(Database.java:1790) 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.core.database.Database.openQuery(Database.java:1714) 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.core.database.Database.openQuery(Database.java:1709) 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.core.database.Database.openQuery(Database.java:1696) 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.core.database.Database.execStatements(Database.java:1638) 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.core.database.Database.lockTables(Database.java:4392) 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.trans.Trans.beginProcessing(Trans.java:1224) 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : ... 3 more 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Caused by: java.sql.SQLException: Invalid object name 'refresh.acerLog'. 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368) 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816) 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254) 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:631) 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:477) 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at net.sourceforge.jtds.jdbc.JtdsStatement.executeQuery(JtdsStatement.java:1301) 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.core.database.Database.openQuery(Database.java:1776) 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : ... 9 more If the dbo.acerLog table IS NOT present, but refresh.acerlog table IS present, after launching spoon gui I see: Invalid object name 'acerLog'. org.pentaho.di.core.exception.KettleDatabaseException: An error occurred executing SQL: SELECT * FROM acerLog WHERE TRANSNAME LIKE ? OR TRANSNAME LIKE ? ORDER BY ID_BATCH desc Invalid object name 'acerLog'. at org.pentaho.di.core.database.Database.openQuery(Database.java:1790) at org.pentaho.di.core.database.Database.openQuery(Database.java:1714) at org.pentaho.di.core.database.Database.openQuery(Database.java:1709) at org.pentaho.di.ui.spoon.trans.TransHistoryDelegate.getHistoryData(TransHistoryDelegate.java:389) at org.pentaho.di.ui.spoon.trans.TransHistoryDelegate$4.run(TransHistoryDelegate.java:362) at org.eclipse.swt.widgets.RunnableLock.run(Unknown Source) at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Unknown Source) at org.eclipse.swt.widgets.Display.runAsyncMessages(Unknown Source) at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source) at org.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:945) at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:5574) at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:412) Caused by: java.sql.SQLException: Invalid object name 'acerLog'. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254) at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:631) at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:477) at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:777) at org.pentaho.di.core.database.Database.openQuery(Database.java:1751) ... 11 more When the tables are in both schemas, the log is saved to the dbo schema. However, the Spoon gui (under Execution Results, Execution History tab) does not remove the log entries from the dbo log table -- it appears to try to delete it from the refresh schema. Pressing the Yes button on the Question dialog (Are you sure you want to remove all entries from the log table [acerLog]? does nothing but refresh the screen.

    Pentaho BI Platform Tracking | 7 years ago | Scott Gustafson
    org.pentaho.di.core.exception.KettleDatabaseException: An error occurred executing SQL: SELECT * FROM acerLog WHERE TRANSNAME LIKE ? OR TRANSNAME LIKE ? ORDER BY ID_BATCH desc Invalid object name 'acerLog'.
  2. 0

    The problems I am experiencing are related to using a schema when writing to a log table. The problems occur when :1) upon startup of Spoon gui, 2) when trying to clear the logs from the database. FYI -- I wish to use a schema called 'refresh' and I named the log table 'acerLog' (both without the single quotes), thus I would like to write to the refresh.acerlog table. database connection settings: Connection Type: MS SQl Server (using version 2005) Access: JDBC preferred schema name: refresh In order for logging to write any information, I had to create the log table in both the default (dbo) schema as well in my preferred schema (refresh). Doing so results in the dbo.acerLog table being populated. Whn launching Spoon, If the dbo.acerLog table IS present, but refresh.acerlog table is NOT present: 2010/04/14 10:58:39 - Spoon - Launching transformation [AmisysYearHistSpan]... 2010/04/14 10:58:39 - Spoon - Started the transformation execution. 2010/04/14 10:58:39 - AmisysYearHistSpan - Dispatching started for transformation [AmisysYearHistSpan] 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Preparing transformation execution failed 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : org.pentaho.di.core.exception.KettleTransException: 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Unable to begin processing transformation 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Error writing log record to table [acerLog] 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : An error occurred executing SQL: 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : SELECT top 0 * FROM refresh.acerLog WITH (TABLOCKX, HOLDLOCK) 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Invalid object name 'refresh.acerLog'. 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.trans.Trans.beginProcessing(Trans.java:1464) 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.trans.Trans.prepareExecution(Trans.java:523) 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.ui.spoon.trans.TransGraph$25.run(TransGraph.java:3192) 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at java.lang.Thread.run(Unknown Source) 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Caused by: org.pentaho.di.core.exception.KettleTransException: 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Error writing log record to table [acerLog] 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : An error occurred executing SQL: 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : SELECT top 0 * FROM refresh.acerLog WITH (TABLOCKX, HOLDLOCK) 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Invalid object name 'refresh.acerLog'. 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.trans.Trans.beginProcessing(Trans.java:1439) 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : ... 3 more 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Caused by: org.pentaho.di.core.exception.KettleDatabaseException: 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : An error occurred executing SQL: 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : SELECT top 0 * FROM refresh.acerLog WITH (TABLOCKX, HOLDLOCK) 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Invalid object name 'refresh.acerLog'. 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.core.database.Database.openQuery(Database.java:1790) 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.core.database.Database.openQuery(Database.java:1714) 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.core.database.Database.openQuery(Database.java:1709) 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.core.database.Database.openQuery(Database.java:1696) 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.core.database.Database.execStatements(Database.java:1638) 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.core.database.Database.lockTables(Database.java:4392) 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.trans.Trans.beginProcessing(Trans.java:1224) 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : ... 3 more 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Caused by: java.sql.SQLException: Invalid object name 'refresh.acerLog'. 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368) 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816) 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254) 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:631) 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:477) 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at net.sourceforge.jtds.jdbc.JtdsStatement.executeQuery(JtdsStatement.java:1301) 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.core.database.Database.openQuery(Database.java:1776) 2010/04/14 10:58:39 - AmisysYearHistSpan - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : ... 9 more If the dbo.acerLog table IS NOT present, but refresh.acerlog table IS present, after launching spoon gui I see: Invalid object name 'acerLog'. org.pentaho.di.core.exception.KettleDatabaseException: An error occurred executing SQL: SELECT * FROM acerLog WHERE TRANSNAME LIKE ? OR TRANSNAME LIKE ? ORDER BY ID_BATCH desc Invalid object name 'acerLog'. at org.pentaho.di.core.database.Database.openQuery(Database.java:1790) at org.pentaho.di.core.database.Database.openQuery(Database.java:1714) at org.pentaho.di.core.database.Database.openQuery(Database.java:1709) at org.pentaho.di.ui.spoon.trans.TransHistoryDelegate.getHistoryData(TransHistoryDelegate.java:389) at org.pentaho.di.ui.spoon.trans.TransHistoryDelegate$4.run(TransHistoryDelegate.java:362) at org.eclipse.swt.widgets.RunnableLock.run(Unknown Source) at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Unknown Source) at org.eclipse.swt.widgets.Display.runAsyncMessages(Unknown Source) at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source) at org.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:945) at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:5574) at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:412) Caused by: java.sql.SQLException: Invalid object name 'acerLog'. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254) at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:631) at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:477) at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:777) at org.pentaho.di.core.database.Database.openQuery(Database.java:1751) ... 11 more When the tables are in both schemas, the log is saved to the dbo schema. However, the Spoon gui (under Execution Results, Execution History tab) does not remove the log entries from the dbo log table -- it appears to try to delete it from the refresh schema. Pressing the Yes button on the Question dialog (Are you sure you want to remove all entries from the log table [acerLog]? does nothing but refresh the screen.

    Pentaho BI Platform Tracking | 7 years ago | Scott Gustafson
    org.pentaho.di.core.exception.KettleDatabaseException: An error occurred executing SQL: SELECT * FROM acerLog WHERE TRANSNAME LIKE ? OR TRANSNAME LIKE ? ORDER BY ID_BATCH desc Invalid object name 'acerLog'.
  3. 0

    [HHH-3797] Incorrect SQL syntax for EJB query involving Entity with composite Key - Hibernate JIRA

    atlassian.net | 1 year ago
    javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute query
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Ajuda JPA

    com.br | 1 year ago
    javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: Incorrect syntax near 'value'.

  1. ruifung 1 times, last 3 months ago
12 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. java.sql.SQLException

    Invalid object name 'acerLog'.

    at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic()
  2. jTDS
    JtdsPreparedStatement.executeQuery
    1. net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
    2. net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816)
    3. net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254)
    4. net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:631)
    5. net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:477)
    6. net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:777)
    6 frames
  3. org.pentaho.di
    TransHistoryDelegate$4.run
    1. org.pentaho.di.core.database.Database.openQuery(Database.java:1751)
    2. org.pentaho.di.core.database.Database.openQuery(Database.java:1714)
    3. org.pentaho.di.core.database.Database.openQuery(Database.java:1709)
    4. org.pentaho.di.ui.spoon.trans.TransHistoryDelegate.getHistoryData(TransHistoryDelegate.java:389)
    5. org.pentaho.di.ui.spoon.trans.TransHistoryDelegate$4.run(TransHistoryDelegate.java:362)
    5 frames
  4. RWT
    Display.readAndDispatch
    1. org.eclipse.swt.widgets.RunnableLock.run(Unknown Source)
    2. org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Unknown Source)
    3. org.eclipse.swt.widgets.Display.runAsyncMessages(Unknown Source)
    4. org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
    4 frames
  5. org.pentaho.di
    Spoon.main
    1. org.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:945)
    2. org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:5574)
    3. org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:412)
    3 frames