org.hibernate.exception.SQLGrammarException

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.

  • Something wrong for hibernate!
    via by Peter Song,
  • Ajuda JPA
    via by Unknown author,
  • 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.
    via by Scott Gustafson,
  • 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.
    via by Scott Gustafson,
    • org.hibernate.exception.SQLGrammarException: could not fetch initial value for increment generator at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.id.IncrementGenerator.getNext(IncrementGenerator.java:107) at org.hibernate.id.IncrementGenerator.generate(IncrementGenerator.java:44) at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:91) at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:186) at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:33) at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:175) at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:27) at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70) at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:530) at org.hibernate.impl.SessionImpl.save(SessionImpl.java:518) at org.hibernate.impl.SessionImpl.save(SessionImpl.java:514) at com.lovo.epet.dao.impl.PetInfo.insertPet(PetInfo.java:45) at com.lovo.epet.service.impl.AddPet.addPetInfo(AddPet.java:22) at com.lovo.epet.struts.action.RegisterAction.execute(RegisterAction.java:57) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196) at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432) at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at java.lang.Thread.run(Thread.java:619) Caused by: java.sql.SQLException: Object 'PetInfo' is futile。 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.hibernate.id.IncrementGenerator.getNext(IncrementGenerator.java:85) ... 31 more

    Users with the same issue

    oddodd
    2 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    ruifungruifung
    1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    24 more bugmates