org.pentaho.di.core.exception.KettleStepException: Error in step, asking everyone to stop because of: Error looking up row in database General error

Pentaho BI Platform Tracking | Yash Sri Gupta | 3 years ago
  1. 0

    Hi Team, I am a new user of pentaho kettle. I am trying to use TABLE OUTPUT and INSERT/UPDATE step in my transformation. The data base is Oracle. I am not able to insert or update record to database. Please help with possible reasons and solutions for such issues. I am getting below error: 2014/03/31 13:18:36 - General - Logging plugin type found with ID: CheckpointLogTable 2014/03/31 13:18:43 - General - Starting agile-bi 2014/03/31 13:18:43 - Spoon - Asking for repository 2014/03/31 13:18:47 - class org.pentaho.agilebi.platform.JettyServer - WebServer.Log.CreateListener localhost:10000 2014/03/31 13:22:40 - Spoon - Transformation opened. 2014/03/31 13:22:40 - Spoon - Launching transformation [insert update]... 2014/03/31 13:22:40 - Spoon - Started the transformation execution. 2014/03/31 13:22:41 - insert update - Dispatching started for transformation [insert update] 2014/03/31 13:22:48 - Table input.0 - Finished reading query, closing connection. 2014/03/31 13:22:48 - Insert / Update.0 - ERROR (version 5.0.4, build 1 from 2014-02-17_08-03-10 by buildguy) : Unexpected error 2014/03/31 13:22:48 - Insert / Update.0 - ERROR (version 5.0.4, build 1 from 2014-02-17_08-03-10 by buildguy) : org.pentaho.di.core.exception.KettleStepException: 2014/03/31 13:22:48 - Insert / Update.0 - Error in step, asking everyone to stop because of: 2014/03/31 13:22:48 - Insert / Update.0 - 2014/03/31 13:22:48 - Insert / Update.0 - Error looking up row in database 2014/03/31 13:22:48 - Insert / Update.0 - General error 2014/03/31 13:22:48 - Insert / Update.0 - 2014/03/31 13:22:48 - Insert / Update.0 - 2014/03/31 13:22:48 - Insert / Update.0 - at org.pentaho.di.trans.steps.insertupdate.InsertUpdate.processRow(InsertUpdate.java:318) 2014/03/31 13:22:48 - Insert / Update.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:60) 2014/03/31 13:22:48 - Insert / Update.0 - at java.lang.Thread.run(Unknown Source) 2014/03/31 13:22:48 - Insert / Update.0 - Caused by: org.pentaho.di.core.exception.KettleDatabaseException: 2014/03/31 13:22:48 - Insert / Update.0 - Error looking up row in database 2014/03/31 13:22:48 - Insert / Update.0 - General error 2014/03/31 13:22:48 - Insert / Update.0 - 2014/03/31 13:22:48 - Insert / Update.0 - at org.pentaho.di.core.database.Database.getLookup(Database.java:2657) 2014/03/31 13:22:48 - Insert / Update.0 - at org.pentaho.di.core.database.Database.getLookup(Database.java:2632) 2014/03/31 13:22:48 - Insert / Update.0 - at org.pentaho.di.trans.steps.insertupdate.InsertUpdate.lookupValues(InsertUpdate.java:91) 2014/03/31 13:22:48 - Insert / Update.0 - at org.pentaho.di.trans.steps.insertupdate.InsertUpdate.processRow(InsertUpdate.java:301) 2014/03/31 13:22:48 - Insert / Update.0 - ... 2 more 2014/03/31 13:22:48 - Insert / Update.0 - Caused by: java.sql.SQLException: General error 2014/03/31 13:22:48 - Insert / Update.0 - at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source) 2014/03/31 13:22:48 - Insert / Update.0 - at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source) 2014/03/31 13:22:48 - Insert / Update.0 - at sun.jdbc.odbc.JdbcOdbc.SQLExecute(Unknown Source) 2014/03/31 13:22:48 - Insert / Update.0 - at sun.jdbc.odbc.JdbcOdbcPreparedStatement.execute(Unknown Source) 2014/03/31 13:22:48 - Insert / Update.0 - at sun.jdbc.odbc.JdbcOdbcPreparedStatement.executeQuery(Unknown Source) 2014/03/31 13:22:48 - Insert / Update.0 - at org.pentaho.di.core.database.Database.getLookup(Database.java:2639) 2014/03/31 13:22:48 - Insert / Update.0 - ... 5 more 2014/03/31 13:22:48 - Table input.0 - Finished processing (I=10, O=0, R=0, W=10, U=0, E=0) 2014/03/31 13:22:49 - Insert / Update.0 - Finished processing (I=0, O=0, R=1, W=0, U=0, E=1) 2014/03/31 13:22:49 - insert update - ERROR (version 5.0.4, build 1 from 2014-02-17_08-03-10 by buildguy) : Errors detected! 2014/03/31 13:22:49 - Spoon - The transformation has finished!! 2014/03/31 13:22:49 - insert update - ERROR (version 5.0.4, build 1 from 2014-02-17_08-03-10 by buildguy) : Errors detected! 2014/03/31 13:22:49 - insert update - ERROR (version 5.0.4, build 1 from 2014-02-17_08-03-10 by buildguy) : Errors detected! 2014/03/31 13:22:49 - insert update - insert update 2014/03/31 13:22:49 - insert update - insert update

    Pentaho BI Platform Tracking | 3 years ago | Yash Sri Gupta
    org.pentaho.di.core.exception.KettleStepException: Error in step, asking everyone to stop because of: Error looking up row in database General error
  2. 0

    Hi Team, I am a new user of pentaho kettle. I am trying to use TABLE OUTPUT and INSERT/UPDATE step in my transformation. The data base is Oracle. I am not able to insert or update record to database. Please help with possible reasons and solutions for such issues. I am getting below error: 2014/03/31 13:18:36 - General - Logging plugin type found with ID: CheckpointLogTable 2014/03/31 13:18:43 - General - Starting agile-bi 2014/03/31 13:18:43 - Spoon - Asking for repository 2014/03/31 13:18:47 - class org.pentaho.agilebi.platform.JettyServer - WebServer.Log.CreateListener localhost:10000 2014/03/31 13:22:40 - Spoon - Transformation opened. 2014/03/31 13:22:40 - Spoon - Launching transformation [insert update]... 2014/03/31 13:22:40 - Spoon - Started the transformation execution. 2014/03/31 13:22:41 - insert update - Dispatching started for transformation [insert update] 2014/03/31 13:22:48 - Table input.0 - Finished reading query, closing connection. 2014/03/31 13:22:48 - Insert / Update.0 - ERROR (version 5.0.4, build 1 from 2014-02-17_08-03-10 by buildguy) : Unexpected error 2014/03/31 13:22:48 - Insert / Update.0 - ERROR (version 5.0.4, build 1 from 2014-02-17_08-03-10 by buildguy) : org.pentaho.di.core.exception.KettleStepException: 2014/03/31 13:22:48 - Insert / Update.0 - Error in step, asking everyone to stop because of: 2014/03/31 13:22:48 - Insert / Update.0 - 2014/03/31 13:22:48 - Insert / Update.0 - Error looking up row in database 2014/03/31 13:22:48 - Insert / Update.0 - General error 2014/03/31 13:22:48 - Insert / Update.0 - 2014/03/31 13:22:48 - Insert / Update.0 - 2014/03/31 13:22:48 - Insert / Update.0 - at org.pentaho.di.trans.steps.insertupdate.InsertUpdate.processRow(InsertUpdate.java:318) 2014/03/31 13:22:48 - Insert / Update.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:60) 2014/03/31 13:22:48 - Insert / Update.0 - at java.lang.Thread.run(Unknown Source) 2014/03/31 13:22:48 - Insert / Update.0 - Caused by: org.pentaho.di.core.exception.KettleDatabaseException: 2014/03/31 13:22:48 - Insert / Update.0 - Error looking up row in database 2014/03/31 13:22:48 - Insert / Update.0 - General error 2014/03/31 13:22:48 - Insert / Update.0 - 2014/03/31 13:22:48 - Insert / Update.0 - at org.pentaho.di.core.database.Database.getLookup(Database.java:2657) 2014/03/31 13:22:48 - Insert / Update.0 - at org.pentaho.di.core.database.Database.getLookup(Database.java:2632) 2014/03/31 13:22:48 - Insert / Update.0 - at org.pentaho.di.trans.steps.insertupdate.InsertUpdate.lookupValues(InsertUpdate.java:91) 2014/03/31 13:22:48 - Insert / Update.0 - at org.pentaho.di.trans.steps.insertupdate.InsertUpdate.processRow(InsertUpdate.java:301) 2014/03/31 13:22:48 - Insert / Update.0 - ... 2 more 2014/03/31 13:22:48 - Insert / Update.0 - Caused by: java.sql.SQLException: General error 2014/03/31 13:22:48 - Insert / Update.0 - at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source) 2014/03/31 13:22:48 - Insert / Update.0 - at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source) 2014/03/31 13:22:48 - Insert / Update.0 - at sun.jdbc.odbc.JdbcOdbc.SQLExecute(Unknown Source) 2014/03/31 13:22:48 - Insert / Update.0 - at sun.jdbc.odbc.JdbcOdbcPreparedStatement.execute(Unknown Source) 2014/03/31 13:22:48 - Insert / Update.0 - at sun.jdbc.odbc.JdbcOdbcPreparedStatement.executeQuery(Unknown Source) 2014/03/31 13:22:48 - Insert / Update.0 - at org.pentaho.di.core.database.Database.getLookup(Database.java:2639) 2014/03/31 13:22:48 - Insert / Update.0 - ... 5 more 2014/03/31 13:22:48 - Table input.0 - Finished processing (I=10, O=0, R=0, W=10, U=0, E=0) 2014/03/31 13:22:49 - Insert / Update.0 - Finished processing (I=0, O=0, R=1, W=0, U=0, E=1) 2014/03/31 13:22:49 - insert update - ERROR (version 5.0.4, build 1 from 2014-02-17_08-03-10 by buildguy) : Errors detected! 2014/03/31 13:22:49 - Spoon - The transformation has finished!! 2014/03/31 13:22:49 - insert update - ERROR (version 5.0.4, build 1 from 2014-02-17_08-03-10 by buildguy) : Errors detected! 2014/03/31 13:22:49 - insert update - ERROR (version 5.0.4, build 1 from 2014-02-17_08-03-10 by buildguy) : Errors detected! 2014/03/31 13:22:49 - insert update - insert update 2014/03/31 13:22:49 - insert update - insert update

    Pentaho BI Platform Tracking | 3 years ago | Yash Sri Gupta
    org.pentaho.di.core.exception.KettleStepException: Error in step, asking everyone to stop because of: Error looking up row in database General error
  3. 0

    SQL Exception!

    Oracle Community | 1 decade ago | 843841
    java.sql.SQLException: General error
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Error when executing interface

    Oracle Community | 8 years ago | 694754
    java.sql.SQLException: [Microsoft][ODBC Excel Driver] The Microsoft Jet database engine could not find the object 'Income_Code'. Make sure the object exists and that you spell its name and the path name correctly.
  6. 0

    ODI error Handling

    Oracle Community | 7 years ago | Varun Kaushal
    java.sql.SQLException: [Microsoft][ODBC Excel Driver] The Microsoft Jet database engine could not find the object 'testexcel'. Make sure the object exists and that you spell its name and the path name correctly.

    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

      General error

      at sun.jdbc.odbc.JdbcOdbc.createSQLException()
    2. sun.jdbc.odbc
      JdbcOdbcPreparedStatement.executeQuery
      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.executeQuery(Unknown Source)
      5 frames
    3. org.pentaho.di
      Database.getLookup
      1. org.pentaho.di.core.database.Database.getLookup(Database.java:2639)
      1 frame