java.sql.SQLSyntaxErrorException

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.

  • Kafka vertica consumer and rejection table
    via Stack Overflow by juise
    ,
  • If we run a simple transformation that read data and publish in database using Vertica Bulk Loader, the transformation is hanged til we click in stop the transformation execution. *Steps to Reproduce* # Open spoon # Create a transformation # Add a CSV input step and Vertica Bulk Loader step. # Hop the steps # Configure the CSV input step to read data from a csv file (see attached) # Connect the Vertica step to a database instance # Checked the option Specify Database Fields and do not add any field. # Save the transformation and run it *Actual Result* An error occurs running the transformation but the transformation stills executing, doesn't stop until user press to stop. {code} 2015/07/22 18:24:26 - Vertica Bulk Loader.0 - ERROR (version 6.0-NIGHTLY, build 1 from 86 by buildguy) : SQL Error during statement execution. 2015/07/22 18:24:26 - Vertica Bulk Loader.0 - ERROR (version 6.0-NIGHTLY, build 1 from 86 by buildguy) : java.sql.SQLSyntaxErrorException: [Vertica][VJDBC](4856) ERROR: Syntax error at or near ")" 2015/07/22 18:24:26 - Vertica Bulk Loader.0 - at com.vertica.util.ServerErrorData.buildException(Unknown Source) 2015/07/22 18:24:26 - Vertica Bulk Loader.0 - at com.vertica.dataengine.VDataEngine.prepareImpl(Unknown Source) 2015/07/22 18:24:26 - Vertica Bulk Loader.0 - at com.vertica.dataengine.VDataEngine.prepare(Unknown Source) 2015/07/22 18:24:26 - Vertica Bulk Loader.0 - at com.vertica.jdbc.VerticaCopyStream.start(Unknown Source) 2015/07/22 18:24:26 - Vertica Bulk Loader.0 - at org.pentaho.di.verticabulkload.VerticaBulkLoader$1.run(VerticaBulkLoader.java:260) 2015/07/22 18:24:26 - Vertica Bulk Loader.0 - at java.lang.Thread.run(Unknown Source) 2015/07/22 18:24:26 - Vertica Bulk Loader.0 - Caused by: com.vertica.support.exceptions.SyntaxErrorException: [Vertica][VJDBC](4856) ERROR: Syntax error at or near ")" 2015/07/22 18:24:26 - Vertica Bulk Loader.0 - ... 6 more {code} *Expected Result* The transformation should stop after an error is detected.
    via by Emanuel Teixeira,
  • In a transformation, I have created a Table Input and Table Ouput. In the first settings I set the Table Input to read the table movielens and the TableOutput just read the data from Table Input and insert in a new table (called QAMovie). Then, I changed in Table Input to read ML_SDR_, and in Table Ouput I click in SQL and perform the changes in the created table, when I executed the SQL query with Alter Table several errors. The displayed error is corrected? And the error message 'Syntax error at or near (...)' is correct? See attached image. org.pentaho.di.core.exception.KettleDatabaseException: Couldn't execute SQL: ALTER TABLE QAMovie MODIFY UserID FLOAT [Vertica][VJDBC](4856) ERROR: Syntax error at or near "MODIFY" at org.pentaho.di.core.database.Database.execStatement(Database.java:1517) at org.pentaho.di.core.database.Database.execStatement(Database.java:1465) at org.pentaho.di.ui.core.database.dialog.SQLEditor.exec(SQLEditor.java:398) at org.pentaho.di.ui.core.database.dialog.SQLEditor.access$200(SQLEditor.java:81) at org.pentaho.di.ui.core.database.dialog.SQLEditor$7.handleEvent(SQLEditor.java:242) at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source) at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source) at org.pentaho.di.ui.trans.steps.tableoutput.TableOutputDialog.open(TableOutputDialog.java:884) at org.pentaho.di.ui.spoon.delegates.SpoonStepsDelegate.editStep(SpoonStepsDelegate.java:124) at org.pentaho.di.ui.spoon.Spoon.editStep(Spoon.java:8697) at org.pentaho.di.ui.spoon.trans.TransGraph.editStep(TransGraph.java:3027) at org.pentaho.di.ui.spoon.trans.TransGraph.mouseDoubleClick(TransGraph.java:744) at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source) at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source) at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source) at org.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:1310) at org.pentaho.di.ui.spoon.Spoon.waitForDispose(Spoon.java:7908) at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:9179) at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:648) 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) at org.pentaho.commons.launcher.Launcher.main(Launcher.java:92) Caused by: java.sql.SQLSyntaxErrorException: [Vertica][VJDBC](4856) ERROR: Syntax error at or near "MODIFY" at com.vertica.util.ServerErrorData.buildException(Unknown Source) at com.vertica.dataengine.VDataEngine.prepareImpl(Unknown Source) at com.vertica.dataengine.VDataEngine.prepare(Unknown Source) at com.vertica.dataengine.VDataEngine.prepare(Unknown Source) at com.vertica.jdbc.common.SStatement.executeNoParams(Unknown Source) at com.vertica.jdbc.common.SStatement.execute(Unknown Source) at org.pentaho.di.core.database.Database.execStatement(Database.java:1491) ... 27 more Caused by: com.vertica.support.exceptions.SyntaxErrorException: [Vertica][VJDBC](4856) ERROR: Syntax error at or near "MODIFY" ... 34 more
    via by Emanuel Teixeira,
  • If we run a simple transformation that read data and publish in database using Vertica Bulk Loader, the transformation is hanged til we click in stop the transformation execution. *Steps to Reproduce* # Open spoon # Create a transformation # Add a CSV input step and Vertica Bulk Loader step. # Hop the steps # Configure the CSV input step to read data from a csv file (see attached) # Connect the Vertica step to a database instance # Checked the option Specify Database Fields and do not add any field. # Save the transformation and run it *Actual Result* An error occurs running the transformation but the transformation stills executing, doesn't stop until user press to stop. {code} 2015/07/22 18:24:26 - Vertica Bulk Loader.0 - ERROR (version 6.0-NIGHTLY, build 1 from 86 by buildguy) : SQL Error during statement execution. 2015/07/22 18:24:26 - Vertica Bulk Loader.0 - ERROR (version 6.0-NIGHTLY, build 1 from 86 by buildguy) : java.sql.SQLSyntaxErrorException: [Vertica][VJDBC](4856) ERROR: Syntax error at or near ")" 2015/07/22 18:24:26 - Vertica Bulk Loader.0 - at com.vertica.util.ServerErrorData.buildException(Unknown Source) 2015/07/22 18:24:26 - Vertica Bulk Loader.0 - at com.vertica.dataengine.VDataEngine.prepareImpl(Unknown Source) 2015/07/22 18:24:26 - Vertica Bulk Loader.0 - at com.vertica.dataengine.VDataEngine.prepare(Unknown Source) 2015/07/22 18:24:26 - Vertica Bulk Loader.0 - at com.vertica.jdbc.VerticaCopyStream.start(Unknown Source) 2015/07/22 18:24:26 - Vertica Bulk Loader.0 - at org.pentaho.di.verticabulkload.VerticaBulkLoader$1.run(VerticaBulkLoader.java:260) 2015/07/22 18:24:26 - Vertica Bulk Loader.0 - at java.lang.Thread.run(Unknown Source) 2015/07/22 18:24:26 - Vertica Bulk Loader.0 - Caused by: com.vertica.support.exceptions.SyntaxErrorException: [Vertica][VJDBC](4856) ERROR: Syntax error at or near ")" 2015/07/22 18:24:26 - Vertica Bulk Loader.0 - ... 6 more {code} *Expected Result* The transformation should stop after an error is detected.
    via by Emanuel Teixeira,
  • In a transformation, I have created a Table Input and Table Ouput. In the first settings I set the Table Input to read the table movielens and the TableOutput just read the data from Table Input and insert in a new table (called QAMovie). Then, I changed in Table Input to read ML_SDR_, and in Table Ouput I click in SQL and perform the changes in the created table, when I executed the SQL query with Alter Table several errors. The displayed error is corrected? And the error message 'Syntax error at or near (...)' is correct? See attached image. org.pentaho.di.core.exception.KettleDatabaseException: Couldn't execute SQL: ALTER TABLE QAMovie MODIFY UserID FLOAT [Vertica][VJDBC](4856) ERROR: Syntax error at or near "MODIFY" at org.pentaho.di.core.database.Database.execStatement(Database.java:1517) at org.pentaho.di.core.database.Database.execStatement(Database.java:1465) at org.pentaho.di.ui.core.database.dialog.SQLEditor.exec(SQLEditor.java:398) at org.pentaho.di.ui.core.database.dialog.SQLEditor.access$200(SQLEditor.java:81) at org.pentaho.di.ui.core.database.dialog.SQLEditor$7.handleEvent(SQLEditor.java:242) at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source) at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source) at org.pentaho.di.ui.trans.steps.tableoutput.TableOutputDialog.open(TableOutputDialog.java:884) at org.pentaho.di.ui.spoon.delegates.SpoonStepsDelegate.editStep(SpoonStepsDelegate.java:124) at org.pentaho.di.ui.spoon.Spoon.editStep(Spoon.java:8697) at org.pentaho.di.ui.spoon.trans.TransGraph.editStep(TransGraph.java:3027) at org.pentaho.di.ui.spoon.trans.TransGraph.mouseDoubleClick(TransGraph.java:744) at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source) at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source) at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source) at org.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:1310) at org.pentaho.di.ui.spoon.Spoon.waitForDispose(Spoon.java:7908) at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:9179) at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:648) 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) at org.pentaho.commons.launcher.Launcher.main(Launcher.java:92) Caused by: java.sql.SQLSyntaxErrorException: [Vertica][VJDBC](4856) ERROR: Syntax error at or near "MODIFY" at com.vertica.util.ServerErrorData.buildException(Unknown Source) at com.vertica.dataengine.VDataEngine.prepareImpl(Unknown Source) at com.vertica.dataengine.VDataEngine.prepare(Unknown Source) at com.vertica.dataengine.VDataEngine.prepare(Unknown Source) at com.vertica.jdbc.common.SStatement.executeNoParams(Unknown Source) at com.vertica.jdbc.common.SStatement.execute(Unknown Source) at org.pentaho.di.core.database.Database.execStatement(Database.java:1491) ... 27 more Caused by: com.vertica.support.exceptions.SyntaxErrorException: [Vertica][VJDBC](4856) ERROR: Syntax error at or near "MODIFY" ... 34 more
    via by Emanuel Teixeira,
    • java.sql.SQLSyntaxErrorException: [Vertica][VJDBC](4213) ROLLBACK: Object "requests_rej" already exists at com.vertica.util.ServerErrorData.buildException(Unknown Source) at com.vertica.dataengine.VResultSet.fetchChunk(Unknown Source) at com.vertica.dataengine.VResultSet.initialize(Unknown Source) at com.vertica.dataengine.VQueryExecutor.readExecuteResponse(Unknown Source) at com.vertica.dataengine.VQueryExecutor.handleExecuteResponse(Unknown Source) at com.vertica.dataengine.VQueryExecutor.execute(Unknown Source) at com.vertica.jdbc.common.SPreparedStatement.executeWithParams(Unknown Source) at com.vertica.jdbc.common.SPreparedStatement.executeUpdate(Unknown Source) at com.vertica.solutions.kafka.scheduler.MicroBatch.execute(MicroBatch.java:193) at com.vertica.solutions.kafka.scheduler.LaneWorker.run(LaneWorker.java:69) at java.lang.Thread.run(Thread.java:745) Caused by: com.vertica.support.exceptions.SyntaxErrorException: [Vertica][VJDBC](4213) ROLLBACK: Object "requests_rej" already exists ... 11 more

    Users with the same issue

    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,