org.pentaho.di.core.exception.KettleException: Error inserting row into table [output1] with values: [id1], [test1] Error inserting/updating row [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near ')'.

Pentaho BI Platform Tracking | shams Islam | 3 years ago
  1. 0

    Hi there, I am new to pentaho and is thinking of using pentaho as an ETL tool. I like this tool in many ways but I am stuck while performing a test. I have defined two data base connections in ODBC with SQL server 2008 in pentaho 5.0.1 stable. The first connection is for taking an input of data from a local sql server express instance using sql authentication(Feeding to the table input) and the Second connection is for taking an out after the transformation in a different instance of microsoft sql server installation in the same computer(feeding to table out). Both the connections are tested ok. But It fails while inserting rows into the output table. here is the error code in the log: 2014/02/21 13:55:43 - Spoon - Transformation opened. 2014/02/21 13:55:43 - Spoon - Launching transformation [t2]... 2014/02/21 13:55:43 - Spoon - Started the transformation execution. 2014/02/21 13:55:43 - t2 - Dispatching started for transformation [t2] 2014/02/21 13:55:43 - Table output.0 - Connected to database [output] (commit=3) 2014/02/21 13:55:43 - Table input.0 - Finished reading query, closing connection. 2014/02/21 13:55:43 - Table input.0 - Finished processing (I=6, O=0, R=0, W=6, U=0, E=0) 2014/02/21 13:55:43 - Table output.0 - ERROR (version 5.0.1-stable, build 1 from 2013-11-15_16-08-58 by buildguy) : Because of an error, this step can't continue: 2014/02/21 13:55:43 - Table output.0 - ERROR (version 5.0.1-stable, build 1 from 2013-11-15_16-08-58 by buildguy) : org.pentaho.di.core.exception.KettleException: 2014/02/21 13:55:43 - Table output.0 - Error inserting row into table [output1] with values: [id1], [test1] 2014/02/21 13:55:43 - Table output.0 - 2014/02/21 13:55:43 - Table output.0 - Error inserting/updating row 2014/02/21 13:55:43 - Table output.0 - [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near ')'. 2014/02/21 13:55:43 - Table output.0 - 2014/02/21 13:55:43 - Table output.0 - 2014/02/21 13:55:43 - Table output.0 - at org.pentaho.di.trans.steps.tableoutput.TableOutput.writeToTable(TableOutput.java:445) 2014/02/21 13:55:43 - Table output.0 - at org.pentaho.di.trans.steps.tableoutput.TableOutput.processRow(TableOutput.java:128) 2014/02/21 13:55:43 - Table output.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:60) 2014/02/21 13:55:43 - Table output.0 - at java.lang.Thread.run(Unknown Source) 2014/02/21 13:55:43 - Table output.0 - Caused by: org.pentaho.di.core.exception.KettleDatabaseException: 2014/02/21 13:55:43 - Table output.0 - Error inserting/updating row 2014/02/21 13:55:43 - Table output.0 - [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near ')'. 2014/02/21 13:55:43 - Table output.0 - 2014/02/21 13:55:43 - Table output.0 - at org.pentaho.di.core.database.Database.insertRow(Database.java:1193) 2014/02/21 13:55:43 - Table output.0 - at org.pentaho.di.trans.steps.tableoutput.TableOutput.writeToTable(TableOutput.java:284) 2014/02/21 13:55:43 - Table output.0 - ... 3 more 2014/02/21 13:55:43 - Table output.0 - Caused by: java.sql.SQLException: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near ')'. 2014/02/21 13:55:43 - Table output.0 - at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source) 2014/02/21 13:55:43 - Table output.0 - at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source) 2014/02/21 13:55:43 - Table output.0 - at sun.jdbc.odbc.JdbcOdbc.SQLExecute(Unknown Source) 2014/02/21 13:55:43 - Table output.0 - at sun.jdbc.odbc.JdbcOdbcPreparedStatement.execute(Unknown Source) 2014/02/21 13:55:43 - Table output.0 - at sun.jdbc.odbc.JdbcOdbcPreparedStatement.executeUpdate(Unknown Source) 2014/02/21 13:55:43 - Table output.0 - at org.pentaho.di.core.database.Database.insertRow(Database.java:1153) 2014/02/21 13:55:43 - Table output.0 - ... 4 more 2014/02/21 13:55:43 - Table output.0 - Finished processing (I=0, O=0, R=1, W=0, U=0, E=1) 2014/02/21 13:55:43 - t2 - ERROR (version 5.0.1-stable, build 1 from 2013-11-15_16-08-58 by buildguy) : Errors detected! 2014/02/21 13:55:43 - Spoon - The transformation has finished!! 2014/02/21 13:55:43 - t2 - ERROR (version 5.0.1-stable, build 1 from 2013-11-15_16-08-58 by buildguy) : Errors detected! 2014/02/21 13:55:43 - t2 - ERROR (version 5.0.1-stable, build 1 from 2013-11-15_16-08-58 by buildguy) : Errors detected! 2014/02/21 13:55:43 - t2 - t2 2014/02/21 13:55:43 - t2 - t2 Please help here and pls any one tell what I am doing wrong here? Thanks in advance.

    Pentaho BI Platform Tracking | 3 years ago | shams Islam
    org.pentaho.di.core.exception.KettleException: Error inserting row into table [output1] with values: [id1], [test1] Error inserting/updating row [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near ')'.
  2. 0

    Hi there, I am new to pentaho and is thinking of using pentaho as an ETL tool. I like this tool in many ways but I am stuck while performing a test. I have defined two data base connections in ODBC with SQL server 2008 in pentaho 5.0.1 stable. The first connection is for taking an input of data from a local sql server express instance using sql authentication(Feeding to the table input) and the Second connection is for taking an out after the transformation in a different instance of microsoft sql server installation in the same computer(feeding to table out). Both the connections are tested ok. But It fails while inserting rows into the output table. here is the error code in the log: 2014/02/21 13:55:43 - Spoon - Transformation opened. 2014/02/21 13:55:43 - Spoon - Launching transformation [t2]... 2014/02/21 13:55:43 - Spoon - Started the transformation execution. 2014/02/21 13:55:43 - t2 - Dispatching started for transformation [t2] 2014/02/21 13:55:43 - Table output.0 - Connected to database [output] (commit=3) 2014/02/21 13:55:43 - Table input.0 - Finished reading query, closing connection. 2014/02/21 13:55:43 - Table input.0 - Finished processing (I=6, O=0, R=0, W=6, U=0, E=0) 2014/02/21 13:55:43 - Table output.0 - ERROR (version 5.0.1-stable, build 1 from 2013-11-15_16-08-58 by buildguy) : Because of an error, this step can't continue: 2014/02/21 13:55:43 - Table output.0 - ERROR (version 5.0.1-stable, build 1 from 2013-11-15_16-08-58 by buildguy) : org.pentaho.di.core.exception.KettleException: 2014/02/21 13:55:43 - Table output.0 - Error inserting row into table [output1] with values: [id1], [test1] 2014/02/21 13:55:43 - Table output.0 - 2014/02/21 13:55:43 - Table output.0 - Error inserting/updating row 2014/02/21 13:55:43 - Table output.0 - [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near ')'. 2014/02/21 13:55:43 - Table output.0 - 2014/02/21 13:55:43 - Table output.0 - 2014/02/21 13:55:43 - Table output.0 - at org.pentaho.di.trans.steps.tableoutput.TableOutput.writeToTable(TableOutput.java:445) 2014/02/21 13:55:43 - Table output.0 - at org.pentaho.di.trans.steps.tableoutput.TableOutput.processRow(TableOutput.java:128) 2014/02/21 13:55:43 - Table output.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:60) 2014/02/21 13:55:43 - Table output.0 - at java.lang.Thread.run(Unknown Source) 2014/02/21 13:55:43 - Table output.0 - Caused by: org.pentaho.di.core.exception.KettleDatabaseException: 2014/02/21 13:55:43 - Table output.0 - Error inserting/updating row 2014/02/21 13:55:43 - Table output.0 - [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near ')'. 2014/02/21 13:55:43 - Table output.0 - 2014/02/21 13:55:43 - Table output.0 - at org.pentaho.di.core.database.Database.insertRow(Database.java:1193) 2014/02/21 13:55:43 - Table output.0 - at org.pentaho.di.trans.steps.tableoutput.TableOutput.writeToTable(TableOutput.java:284) 2014/02/21 13:55:43 - Table output.0 - ... 3 more 2014/02/21 13:55:43 - Table output.0 - Caused by: java.sql.SQLException: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near ')'. 2014/02/21 13:55:43 - Table output.0 - at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source) 2014/02/21 13:55:43 - Table output.0 - at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source) 2014/02/21 13:55:43 - Table output.0 - at sun.jdbc.odbc.JdbcOdbc.SQLExecute(Unknown Source) 2014/02/21 13:55:43 - Table output.0 - at sun.jdbc.odbc.JdbcOdbcPreparedStatement.execute(Unknown Source) 2014/02/21 13:55:43 - Table output.0 - at sun.jdbc.odbc.JdbcOdbcPreparedStatement.executeUpdate(Unknown Source) 2014/02/21 13:55:43 - Table output.0 - at org.pentaho.di.core.database.Database.insertRow(Database.java:1153) 2014/02/21 13:55:43 - Table output.0 - ... 4 more 2014/02/21 13:55:43 - Table output.0 - Finished processing (I=0, O=0, R=1, W=0, U=0, E=1) 2014/02/21 13:55:43 - t2 - ERROR (version 5.0.1-stable, build 1 from 2013-11-15_16-08-58 by buildguy) : Errors detected! 2014/02/21 13:55:43 - Spoon - The transformation has finished!! 2014/02/21 13:55:43 - t2 - ERROR (version 5.0.1-stable, build 1 from 2013-11-15_16-08-58 by buildguy) : Errors detected! 2014/02/21 13:55:43 - t2 - ERROR (version 5.0.1-stable, build 1 from 2013-11-15_16-08-58 by buildguy) : Errors detected! 2014/02/21 13:55:43 - t2 - t2 2014/02/21 13:55:43 - t2 - t2 Please help here and pls any one tell what I am doing wrong here? Thanks in advance.

    Pentaho BI Platform Tracking | 3 years ago | shams Islam
    org.pentaho.di.core.exception.KettleException: Error inserting row into table [output1] with values: [id1], [test1] Error inserting/updating row [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near ')'.
  3. 0

    Cannot open database '|'

    Stack Overflow | 5 years ago | Lucia Belardinelli
    java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Cannot open database '|'. It may not be a database that your application recognizes, or the file may be corrupt.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Syntax Error Insert Into statement java

    Stack Overflow | 3 years ago | JUNGE
    java.sql.SQLException: [Microsoft][ODBC-Treiber für Microsoft Access] Syntaxfehler in der INSERT INTO-Anweisung.
  6. 0

    java.sql.SQLException while inserting multiple date

    Stack Overflow | 4 years ago | speeday125
    java.sql.SQLException: [MySQL][ODBC 5.1 Driver][mysqld-5.5.15]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 'From) values(100,1,_binary'2011-09-17',_binary'2011-09-18')' at line 1

    1 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

      [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near ')'.

      at sun.jdbc.odbc.JdbcOdbc.createSQLException()
    2. sun.jdbc.odbc
      JdbcOdbcPreparedStatement.executeUpdate
      1. sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
      2. sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
      3. sun.jdbc.odbc.JdbcOdbc.SQLExecute(Unknown Source)
      4. sun.jdbc.odbc.JdbcOdbcPreparedStatement.execute(Unknown Source)
      5. sun.jdbc.odbc.JdbcOdbcPreparedStatement.executeUpdate(Unknown Source)
      5 frames
    3. org.pentaho.di
      RunThread.run
      1. org.pentaho.di.core.database.Database.insertRow(Database.java:1153)
      2. org.pentaho.di.trans.steps.tableoutput.TableOutput.writeToTable(TableOutput.java:284)
      3. org.pentaho.di.trans.steps.tableoutput.TableOutput.processRow(TableOutput.java:128)
      4. org.pentaho.di.trans.step.RunThread.run(RunThread.java:60)
      4 frames
    4. Java RT
      Thread.run
      1. java.lang.Thread.run(Unknown Source)
      1 frame